2.1. Main window

This chapter presents the main interface of Mergeant. The main screen, after the connection to the DBMS has been successfully established, looks like what is shown in the figure below with the following parts most important:

• a toolbar located by default just below the menubar provides some shortcuts to the functions present in the menus: DBMS connection management and relations displaying.

• a vertical icon bar on the left with the icons to switch pages: tables, sequences (if supported by the database provider), queries.

• on the right of that vertical icon bar is where the pages selected on the left appear:

  • the tables anv views page shows all the tables and views contained in the database; the possible actions on the tables are: create a table (not yet implemented), destroy (drop) a table, view and edit the properties of a table (partially implemented) and view and edit the contents of a table.

  • the sequences page lists all the sequences; the possible actions on sequences only range from creating a new one (not yet implemented) to destroying one.

  • the queries page lists the queries that have been defined by the user and, for each query, all the forms or tabular views that can be applied to the query (the result of a query is displayed either in a table or in a form from which it can be edited).

  • the forms page lists all the defined forms through which queries will be used to manage data.

  • the sql page is a console where the user can submit any SQL command.

Here is a screenshot of the main screen: