[Bug 127321] allow use of other database backends such as postgres and mysql

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 127321] allow use of other database backends such as postgres and mysql

Bugzilla from Hamsi2k@freenet.de
https://bugs.kde.org/show_bug.cgi?id=127321


Quallenauge <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #7 from Quallenauge <Hamsi2k freenet de>  2009-07-17 08:59:08 ---
I have basically implemented a generic database access for Digikam to use a QT
supported database.

The background idea is to use xml file which stores the database specific
queries. This makes it easy to modify existing statements, without compiling
the project.

* An xml file, where the database settings (for the QSQLDatabase handler) are
stored and also the specific statements.

* A class which parses this xml file and stores the structure at the
databaseparameters class.

* Database class has now a method getDBAction(QString &dbAction) where the
specific DBAction with its statements can be retrieved and is used for the
database schema creation. This works already.

* A new query/execSQL method which accepts a QMap to execute queries with named
placeholders.

I have done this for the mysql database as "reference" implementation.

Quite difficult for me is now the setup dialog which should do the following:
- Provide Standard Setting with SQLLite file selection.
- Provide Expert Settings where all database connection parameters can be
adjusted.

Can somebody help me with that?!

Next steps:
DB locking - only one Digikam-App should access the DB.

Cheers :)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel