KDb/TODOs: Difference between revisions

From KDE Community Wiki
< KDb
No edit summary
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.


==Marketing==
==Marketing==

Revision as of 12:58, 29 February 2012

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

The Goal: Making Predicate 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

Marketing

Ideas: