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

[Quallenauge]

https://bugs.kde.org/show_bug.cgi?id=127321


Quallenauge <Hamsi2k at freenet.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |Hamsi2k at freenet.de




--- 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.