| 1 |
Local EmployeeDB Example
|
| 2 |
========================
|
| 3 |
|
| 4 |
The purpose of this example is to demonstrate the use of the TIBLocalDB support component.
|
| 5 |
This component is used with a TIBDatabase when the database is accessed using the Firebird
|
| 6 |
Embedded Server. TIBLocalDB takes care of checking the environment and setting up FIREBIRD
|
| 7 |
environment variables and DB parameters. It also supports initialisation of the local
|
| 8 |
database from an archive in gbak format, plus save and restore of the local database.
|
| 9 |
It can also run SQL scripts to upgrade the database schema when a new software version
|
| 10 |
is released.
|
| 11 |
|
| 12 |
Both GUI and Console Examples are provided.
|
| 13 |
|
| 14 |
Before compiling and running the example, the Firebird embedded server must be installed:
|
| 15 |
|
| 16 |
Under Linux:
|
| 17 |
------------
|
| 18 |
|
| 19 |
Debian/Ubuntu/Mint: run "sudo apt-get install libfbembed2.5" to install the server
|
| 20 |
|
| 21 |
Fedora/Red hat/Centos: su -c "yum install firebird-libfbembed"
|
| 22 |
|
| 23 |
Under Windows:
|
| 24 |
--------------
|
| 25 |
|
| 26 |
Download the Firebird Embedded Server from http://www.firebirdsql.org/en/firebird-2-5-5/ and
|
| 27 |
extract the contents of the archive into the example directory i.e. ibx\examples\local-employeedb.
|
| 28 |
You may replace the firebird.conf and firebird.msg files with those in the archive,
|
| 29 |
while not replacing or renaming the readme.txt that comes with the archive.
|
| 30 |
|
| 31 |
Running the application
|
| 32 |
-----------------------
|
| 33 |
|
| 34 |
The example should just compile and run. An archive of the Firebird example employee
|
| 35 |
database is provided with the example. This will be used to create the initial database.
|
| 36 |
It should then be automatically upgraded to "version 2" using the sql scripts provided in the
|
| 37 |
"patches" directory. (see also the file upgrade.conf). Note that the upgrade adds
|
| 38 |
a "photo" to employee number 2.
|
| 39 |
|
| 40 |
Note that you will not be prompted for a username/password. The embedded server
|
| 41 |
uses normal file permissions to control access. Otherwise you can edit the employee
|
| 42 |
database as in the client/server version.
|
| 43 |
|
| 44 |
The local database will be created in:
|
| 45 |
|
| 46 |
Linux: $HOME/.MWA Software/employee.fdb
|
| 47 |
Windows: <User Local Application Data Folder>\MWA Software\employee.fdb
|
| 48 |
|
| 49 |
The File menu provides actions to save the current database to a gbak format archive,
|
| 50 |
restore it again (replacing the current database) or to restore the database to its initial state.
|
| 51 |
|
| 52 |
|
| 53 |
|
| 54 |
|
