1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
Mergeant, 1999,2002 (c) Vivien Malerba <malerba@linuxave.net>
___________________________________________________________
**** WARNING ****
*
* This program is still considered as beta software, and thus it might
* corrupt your data. So do not use this software for production
* purposes. See the BUGS and TODO files for more information.
*
*******************
Mergeant is a program which helps administer a DBMS database using the gnome-db
framework (see http://www.gnome.org/gnome-db/ for more information about
gnome-db). Basically, it memorizes all the structure of the database, and some
queries, and does the SQL queries instead of the user (not having to type all
over again those SQL commands, although it is still possible to do so).
The program requires the Gnome libraries, gnome-db and Gtk to be installed
correctly. You will also need a working DBMS installation (with some DB you can
access with Mergeant).
Mergeant is distributed under the terms of the GNU General Public License V2.0
(read the COPYING file provided with this package).
**** DISCLAIMER ****
Mergeant comes with NO WARRANTY AT ALL!!! Take a look at
the COPYING file for more info. Basically, if it breaks something
(for example your beloved DB), or whatever you are not happy with,
IT'S NOT MY FAULT!
**** Gnome-db, libgda, CORBA, Bonobo, OAF, GConf, ... ****
All these are new technologies, some are already part of the
GNOME installation, and some are for future versions of GNOME.
This means that before Mergeant can work, you need to install all these
libraries/programs.
**** Compiling and Installing is (relatively) easy ****
Before trying to compile or use Mergeant, make sure you have a fully
configured and working gnome-db (and libgda) installation.
Configuring Mergeant is a simple matter or runing the "configure" script. The
option --with-gnome-db=/path/to/gnome-db can be used if the script cannot
find where gnome-db is installed (see configure --help for more information
on all the options)
Bonobo usage:
From version 0.5.3, Mergeant uses bonobo, and from version 0.5.5 its use
is mandatory.
So to configure and build Mergeant, do something like:
./configure
AND
make
make install <-- probably as ROOT depending of $prefix
**** Bonobo, gnome-db and Mergeant ****
Mergeant uses Bonobo to display and allow the user to modify some
information which are heavily dependant on the DBMS accessed (like users
list, users access control, etc). Some DBMS do not yet implement those
possibilities, so you may get some errors from Mergeant. If you wnat to help,
have a look at the gnome-db homepage (http://www.gnome.org/gnome-db/).
**** Using the program ****
- Calling the program with the --help argument will give you all the possible
options. You can call Mergeant with an optionnal XML file (to avoid having to
open it with the file/open menu...)
- If you want the additional information given to the program (links, queries)
to be saved, you must either open an existing file (XML format) or ask to
SAVE AS the current session, BEFORE YOU DISCONNECT from the backend
(otherwise all the informations of the previous session will be lost).
- The program will automatically store your last connection parameters and load
them back the next time you launch it (except for your password).
- The first time you connect to a DBMS, Mergeant will have to fetch all the
information needed, and this will take some time. If you save your work, the
next time you connect to the same DBMS (and open the file in which you saved
your work), you will be asked if you want to update these informations.
If nothing has changed since, you can say NO and start to work.
**** Example ****
This a PostgreSQL example. If you are using another DBMS, feel free to
port it to your DBMS. However, DO NOT use the sales.xml file since it contains
some data types and functions specific to Postgres. Rather create a new one
from Mergeant.
There is one example under the directory examples. To use it, proceed as:
- create a db to hold that example (named computers for example):
> createdb sales
- create the structure and insert some data:
> psql sales
> \i sales.sql
- if you did not install in the default (/usr/local) directory (you gave a --prefix=DIR argument to
the configure script) then you will have to modify the 2nd line of the sales.xml file to
reflect the prefix you have chosen. Then launch Mergeant with the sales.xml file:
> gasql sales.xml
- if you have not already set up the gnome-db data sources, do it now by
either running 'gnomedb-mgr' or selecting the 'Settings->Database manager'
menu. From there you can manage all the connections Mergeant will possibly
use. For this example, create one (by clicking on the 'Add' button):
* GDA Name: Sales
* Provider: the postgres one which is proposed
* DSN: DATABASE=sales;HOST=localhost
* Description: Postgres Example for Mergeant
* Username: guest
* Config: let it empty
- if your username is not "guest", click on the "Preferences" button, and
replace "guest" with your username.
- start enjoying...
Do not hesitate to mail me some comments (bugs, features you would like to
see,...)
|
