freepascal.compiler/fcl/db

This is the Database directory of the Free Component Library.

At the moment, there is a read/write implementation of TDataset.
The blob support is not tested yet.

Compiling the units:

Just run 'make all' and all should go fine, provided
1) The mysql unit is in the compiler path (the makefile will try to compile
it in the packages mysql subdirectory)
2) the mysqlclient library is in /usr/lib (if you want to compile the mtest
program)
if these conditions are not satisfied, you should edit the makefile
and add -Fl/path/to/libmysqlclient to NEEDOPTS as well as
the -Fu/path/to/mysql/unit option.

Compiling the examples:

If the units compile fine, then the examples can be compiled by doing
'make examples'. see also the above remarks.

there are 2 descendents of TDataset to demonstrate/test the
TDataset implementation.

TddgDataset :

Implemented in ddg_ds and ddg_rec. The dataset as
implemented in the Delphi 4 Developers Guide.
To test it, do a
createds filename
testds filename
tested filename
the first creates a flat file, filled with 100 records;
the second tests the navigation methods of TDataset on this file.
the third tests the editing methods of TDataset (Append,Insert
and edit)

TMySQLdataset :
Implemented in mysqldb. You need the mysql units for this.
This is a temporary implementation based on the code from
Rangel Gustavo Reale ([email protected])
it will be used as a base for the DBdataset scalable dataset
implementation.
To test it, do a
mtest db user pwd SQL
this will run the query SQL on the database db with user
'user' and password 'pwd', and dump the result. Take care
that you don't specify blob fields.
To test it on the table created by the mkdb shell script
that comes with the Free Pascal mysql unit, I did a
mtest test michael pwd 'select * from FPdev'

I haven't implemented/tested blob fields yet.

Enjoy !

Michael.