gASQL manual | ||
---|---|---|
<<< Previous | Main interface of gASQL | Next >>> |
Here is a brief description of each of the menus (note that some of them are avaibale only when the connection is opened to a database). The descriptions of the various functionnalities are more in depth in the chapters of this documentation dealing with each functionnality.
'File':
'New workspace', 'Open', 'Close', 'Save', 'Save as': these are the usual menu entries to save the work to a file, and to load that file back to resume working with it.
'Export': this will allow the contents of the database to be exported to a file (and to be restored at another time). This is not yet implemented.
'Print setup': this is the first step towards supporting printing in gASQL...
'Exit': leave the application (if necessary the modified data may be saved); gASQL asks for confirmation before exiting.
'Connection': this menu manages the connection to the DBMS using libgda. The first item ('Preferences') is used to select from the possibly multiple connections pre-configured, enter a username and a password. The other two items are used to open and close the connection (same functionnality as for the corresponding buttons in the toolbar).
'Database':
'Relations scheme': displays a graphical view of all the relations that are defined within the database among the tables' fields, sequences ...
'Integrity check': this is a tool to help check that the data within the tables respect the relations as they are defined in gASQL. This is not yet a complete tool since the relations are not yet enough described (the cardinality among other things).
'System informations': this opens a dialog box in which it is possible to consult what the database engine supports regarding data types, functions, aggregates and general functionnalities such as tables inheritance, sequences, ... An example of such a dialog for a PostgreSQL connection is given in the following figure:
'Refresh memory structure': if the database structure has changed since gASQL was started (which means it has a wrong representation of the database structure), then to have gASQL update its internal representation, this function must be used.
'Settings': the general settings of gASQL are located in this menu:
'Database Manager': this is used to manage all the possible connections gASQL will use. This is the same manager that Gnome-DB uses, and the possible connections are shared. Any connection gASQL will use must be declared using this tool (for some parameters such as the location of the database server, which port, the DBMs type, ...)
'Plugins': this is for the plugins management (for the current session only). Basically the plugins are used to provide a custom user interface for a particular data type. The list of plugins can be refreshed (for example if some plugins have been added), and their usage can be configured.
'Help': this is the traditional online help.
<<< Previous | Home | Next >>> |
Main interface of gASQL | Up | Tables relations |