Help On Line MySQL Connectus 0.4.0

 

 

Index   

>>MenuFile

>>MenuOptions

>>MenuHelp

>>Plug-in

>>Query | Modification window

>>Table window

>> Tree

>> Log window

 

 Menu File

Log in

Here you have to insert your user name and password to log in .

If you didn’t previously choose a password let it blank and press OK button.

If your user name or password are incorrect ,or you don’t have the necessary 

privileges  to access the selected DB, a message window will appear.

Log out

By clicking here you can  log out the current connection.

This command doesn't invalidate cache, and this feature is usefull

if you use a remote connection: you can do a remote query ,

disconnect from the Internet and then re-lunch the query and get

the same results. In local connection if you need to invalidate cache

go to Menu Help->About and click Invalidate Cache button and then

(it's a good idea but not necessary) press Run GC (Garbage Collector).

New query

Choosing this voice will appear a window in which you can insert a query

text and execute it.

New updein

Updein is a shorthand  for Update/Insert/Delete . In this window you can

write and execute your modifications.

Open query

Here you can open a file in which there is the text of a query. The file should be

with ".qry" extension but you can always load a ".txt" , an extentionless file

or however a file where a text is present.

Open updein

Like Open query but for insert/delete/update with ".mod" extension.

Open tables

Open a table with ".dat" extension. If file is corrupted an error message

will be shown.

Import into existing table

Open a file .txt in which table data are present and ask you what

table to populate in the current connection.

Create & Import  

Open a file .txt in which table data are present and ask you what

table to create & populate in the current connection. Remember that

all the 2 txt files are needed to build the table.

Load and Execute Connection Script

This feauture allows you to load and execute a script file in a single step.

A well formed script file is as down here:

HOST->ip or hostname

USER->username

PASSWORD->password

DBNAME->dbname

If you try loading a bad formed script this will be rejected and no connection made.

You may not to write the dbname , the program will show you that you didn't insert it but the

connection will be regularly enabled.

Example of a well formed script for local connection:

HOST->localhost

USER->root

PASSWORD->firestorm

DBNAME->store

Remenber you can't change the order in which fields are written, so password can't

came before host et cetera.

Change database

Pressing this button a dialog window will be shown asking you the name of the

DB you want to connect. If you're not logged in an error message will be

shown.

Show databases

Show databases present in the system accordingly to the access privileges of the user.

If the user is not logged in, a error window will be thrown .

Show relations

Show relations present in the db accordingly to the access privileges of the user.

If the user is not logged in, a error window will be thrown .

Exit

Exit the program and save current settings if AutoConfig is enabled.

 Plug-in

Here you can choose the desired plug-in to load.

If you want to add a plug-in simply put it in plug-in directory

in mysqlconnectus installation directory.

 

 Menu Options

SubMenu LookAndFeel!

Windows Style

Selecting this option the program will be set in a ms windows fashion. If this theme

is not present on your sdk , the program won’t change its appearance.

Motif Style

This will set the program in a Motif fashion. If this theme

is not present on your sdk , the program won’t change its appearance.

SubMenu Java Styles

This are a collections of styles available in every Java sdk provided Swing framework (1.4 or above).

Ruby/Emerald/Aqua/Charcoal/Contrast themes

A set of amazing themes with which you can custom your program.

Auto Configuration

This feature allows you to choose if you want that the program would remember or not

your preferences selected in the running instance of the program.

Preferences are : running theme , and last selected script file.

For instance imagine you open the program then load a script and change theme

to Motif style : if autoconfig is enabled on the next start of the program Motif style

will be applied and the connection script will be automatically loaded.

This feature is based on config.txt file in \bin .

If config.txt is corrupted or an invalid fields is written or is absent an error message will be displayed ,

default parameters will be applied and when you choose exit to quit the program  config.txt

will be fixed up.

 Menu Help

Help On Line

This html page will appear.

About

About the program author contact and system info.

Here you can choose to run garbage collector ,

invalidate cache ,see the current and old log file and read

the GPL  license agreement .

    Log window

In this window you can read a summary of the current operations,error and warnings.

Cancel

With this button you can delete the current shown messages.

 

 Query | Modification window

 

In this window you can insert your query | modification text.

By clicking right button you'll be prompted to a menu

in which you can choose to print ,cut,copy or paste the

selected text. If you choose print and there is no

selected text all the doc will be printed. The cut,paste,copy

features are at OS level and not internal so you can cut and paste

between other applications.

D&D is enabled:  try dragging an underlined text from a query | mod. window

and dropping it in another query | mod. window

 

Actions Menu

Well form

This button will reorder your query text . ( Available since ver. 0.2 )

The caret is changed red -->>  blue color indicating that the query has been reordered

at least once.

WARNING : This is only an alfa version feauture so,if you found any unrecognised word

or in general an error , put one or more spaces between the uncorrect words then 

press "Well form"  button again. Now correctness of recognition is granted  only for query

and modifications and partial for tables,views,triggers,assertions,procedures,functions

absent for PSM and transactions.

Execute

Pushing this button the query will be executed and the results shown.

If no DB has been previously selected an error window will appear.

If any other SQL error is present in your query this will been shown by a

 message  window that will inform you of your error. When a query

is execute the results are cached. So if you lunch again the same query

the cached results will be shown (you can see on the shell if the

last loaded results were from db or cache and the time to get results ).

 If you make a changing to your db with Mod window, no matter ,

the cache will be automatically invalidated.

If you do a modification to the db with an external program be care to

invalidate cache with about window before executing a query.

Save

A file choosing window will appear and there you can save your query.

Cancel

Cancel the text and caret color is set to red indicating that the text is not reordered .

 

 

 Table window

Print

By pressing this button you can print your table.

As you push this button a dialog window will appear asking you about

the columns spacing size. If you choose to close the window 90 dots will

be applied . If you don't have a printer an error message will be shown.  

Save

Here you can save your table in a .dat file.

Export to TXT

Here you can export table contents into a txt file. Please be care to

save with txt extension , differently import feature won't work.

When you save , 2 files txt are created.

1) "filename.txt"

2) "filename@metadata.txt"

The first contains real data. The second contains metadata like fields format.

If you want to  use import (Menu File) feature you only need the first file.

 If you want to  use create & import  (Menu File) feature you  need

both the files.

Two files are saved and not one to ensure compatibility with a MySQL

command (SEE ImportTable.java for more detail).

Export to DB

Here you can export the table to db in two ways:

1) Populate existing table: transfer data from the shown table to a table

in the db in the current connection.

2)Create and populate table: create a table in the currently connected  db

and populate it with current shown data. This is usefull if you exchange .dat

file and want to create and populate a table in your db.

 

 Tree

By double clicking on folders you can directly connect to your DBs.

By double clicking on relations a "SELECT * FROM relation" query

will be performed and the results shown.

D&D is enabled : try dragging a db and dropping it in a query window.

 

  For more information look at \MySQLConnectus\Docs\Index.htm