KDb/TODOs: Difference between revisions

From KDE Community Wiki
< KDb
(Created page with '==Making Predicate work with databases creates elsewhere without importing them== Introduction: KexiDB depends on kexi__* objects even when accessing native database features. Hi...')
 
No edit summary
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Making Predicate work with databases creates elsewhere without importing them==
==Making KDb work with databases creates elsewhere without importing them==
Introduction: KexiDB depends on kexi__* objects even when accessing native database features. Historically this was caused by limitations of SQLite and having simple support for multiple databases. The problem is however that there are existing databases and users expect to be able to use them with Kexi, and possible extend them with Kexi-specific features.
Introduction: KDb depends on kexi__* objects even when accessing native database features. Historically this was caused by limitations of SQLite and having simple support for multiple databases. The problem is however that there are existing databases and users expect to be able to use them with Kexi, and possible extend them with Kexi-specific features.


The Goal: Making Predicate work without importing
The Goal: Making KDb work without importing


Ideas:
Ideas:
Line 13: Line 13:
*add to Connection: virtual bool drv_viewNames(QStringList& tablenames) = 0;
*add to Connection: virtual bool drv_viewNames(QStringList& tablenames) = 0;
**map it to SELECT queries in Kexi
**map it to SELECT queries in Kexi
==SQLite Driver==
*Add better scrolling to the cursor, see: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor for advice.
==Junior Jobs==
===Fix Krazy warnings===
Fix [http://ebn.kde.org/krazy/reports/playground/libs/kdb/index.html Krazy checker's warnings]. Especially:
*add d-pointers - [dpointer] warning
*move inline code from headers to .cpp - [inline] warning
*fix typos
For other types of warnings ask the maintainer first - there are false positives!
===Add unit tests===
See [[../Tests/]].
==DONE==
===User data storage===
--> [[/User data/]] - Add support for user data storage

Latest revision as of 18:50, 6 April 2023

Making KDb work with databases creates elsewhere without importing them

Introduction: KDb depends on kexi__* objects even when accessing native database features. Historically this was caused by limitations of SQLite and having simple support for multiple databases. The problem is however that there are existing databases and users expect to be able to use them with Kexi, and possible extend them with Kexi-specific features.

The Goal: Making KDb work without importing

Ideas:

  • add to Connection: virtual bool drv_tableNames(QStringList& tablenames) = 0; (from KexiMigrate)
    • this iterates through the database schema
  • add to Connection: virtual bool drv_readTableSchema(QString& tableName, KexiDB::TableSchema& tableSchema) = 0; (from KexiMigrate)
    • this reads the native table schema and creates TableSchema object

Optional:

  • add to Connection: virtual bool drv_viewNames(QStringList& tablenames) = 0;
    • map it to SELECT queries in Kexi

SQLite Driver

Junior Jobs

Fix Krazy warnings

Fix Krazy checker's warnings. Especially:

  • add d-pointers - [dpointer] warning
  • move inline code from headers to .cpp - [inline] warning
  • fix typos

For other types of warnings ask the maintainer first - there are false positives!

Add unit tests

See Tests.

DONE

User data storage

--> User data - Add support for user data storage