kexi
KexiDB::SQLiteConnection Class Reference
#include <sqliteconnection.h>
Inheritance diagram for KexiDB::SQLiteConnection:

Detailed Description
sqlite-specific connection
Definition at line 37 of file sqliteconnection.h.
Public Member Functions | |
virtual | ~SQLiteConnection () |
virtual Cursor * | prepareQuery (const QString &statement, uint cursor_options=0) |
virtual Cursor * | prepareQuery (QuerySchema &query, uint cursor_options=0) |
virtual PreparedStatement::Ptr | prepareStatement (PreparedStatement::StatementType type, FieldList &fields) |
virtual bool | isReadOnly () const |
Protected Member Functions | |
SQLiteConnection (Driver *driver, ConnectionData &conn_data) | |
virtual bool | drv_connect () |
virtual bool | drv_disconnect () |
virtual bool | drv_getDatabasesList (QStringList &list) |
virtual bool | drv_getTablesList (QStringList &list) |
virtual bool | drv_containsTable (const QString &tableName) |
virtual bool | drv_createDatabase (const QString &dbName=QString::null) |
virtual bool | drv_useDatabase (const QString &dbName=QString::null, bool *cancelled=0, MessageHandler *msgHandler=0) |
virtual bool | drv_closeDatabase () |
virtual bool | drv_dropDatabase (const QString &dbName=QString::null) |
virtual bool | drv_executeSQL (const QString &statement) |
virtual Q_ULLONG | drv_lastInsertRowID () |
virtual int | serverResult () |
virtual QString | serverResultName () |
virtual QString | serverErrorMsg () |
virtual void | drv_clearServerResult () |
Protected Attributes | |
SQLiteConnectionInternal * | d |
Friends | |
class | SQLiteDriver |
class | SQLiteCursor |
Constructor & Destructor Documentation
SQLiteConnection::SQLiteConnection | ( | Driver * | driver, | |
ConnectionData & | conn_data | |||
) | [protected] |
Used by driver
Definition at line 85 of file sqliteconnection.cpp.
Member Function Documentation
void SQLiteConnection::drv_clearServerResult | ( | ) | [protected, virtual] |
Clears number of last server operation's result stored as a single integer. Formally, this integer should be set to value that means "NO ERRORS" or "OK". This method is called by clearError(). For reimplementation. By default does nothing.
- See also:
- serverErrorMsg()
Reimplemented from KexiDB::Object.
Definition at line 318 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_closeDatabase | ( | ) | [protected, virtual] |
For reimplemenation: closes previously opened database using connection.
Implements KexiDB::Connection.
Definition at line 232 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_connect | ( | ) | [protected, virtual] |
For reimplemenation: connects to database
- Returns:
- true on success.
Implements KexiDB::Connection.
Definition at line 101 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_containsTable | ( | const QString & | tableName | ) | [protected, virtual] |
LOW LEVEL METHOD. For reimplemenation: returns true if table with name tableName exists in the database.
- Returns:
- false if it does not exist or error occured. The lookup is case insensitive.
Implements KexiDB::Connection.
Definition at line 120 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_createDatabase | ( | const QString & | dbName = QString::null |
) | [protected, virtual] |
Creates new database using connection. Note: Do not pass dbName arg because for file-based engine (that has one database per connection) it is defined during connection.
Implements KexiDB::Connection.
Definition at line 148 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_disconnect | ( | ) | [protected, virtual] |
For reimplemenation: disconnects database
- Returns:
- true on success.
Implements KexiDB::Connection.
Definition at line 107 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_dropDatabase | ( | const QString & | dbName = QString::null |
) | [protected, virtual] |
Drops database from the server using connection. After drop, database shouldn't be accessible anymore, so database file is just removed. See note from drv_useDatabase().
Implements KexiDB::Connection.
Definition at line 254 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_executeSQL | ( | const QString & | statement | ) | [protected, virtual] |
Executes query statement, but without returning resulting rows (used mostly for functional queries). Only use this method if you really need.
Implements KexiDB::Connection.
Definition at line 276 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_getDatabasesList | ( | QStringList & | list | ) | [protected, virtual] |
For reimplemenation: loads list of databases' names available for this connection and adds these names to list. If your server is not able to offer such a list, consider reimplementing drv_databaseExists() instead. The method should return true only if there was no error on getting database names list from the server. Default implementation puts empty list into list and returns true.
Reimplemented from KexiDB::Connection.
Definition at line 113 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_getTablesList | ( | QStringList & | list | ) | [protected, virtual] |
LOW LEVEL METHOD. For reimplemenation: loads low-level list of table names available for this connection. The names are in lower case. The method should return true only if there was no error on getting database names list from the server.
Implements KexiDB::Connection.
Definition at line 127 of file sqliteconnection.cpp.
Q_ULLONG SQLiteConnection::drv_lastInsertRowID | ( | ) | [protected, virtual] |
- Returns:
- unique identifier of last inserted row. Typically this is just primary key value. This identifier could be reused when we want to reference just inserted row. Note for driver developers: contact js (at) iidea.pl if your engine do not offers this information.
Implements KexiDB::Connection.
Definition at line 297 of file sqliteconnection.cpp.
bool SQLiteConnection::drv_useDatabase | ( | const QString & | dbName = QString::null , |
|
bool * | cancelled = 0 , |
|||
MessageHandler * | msgHandler = 0 | |||
) | [protected, virtual] |
Opens existing database using connection. Do not pass dbName arg because for file-based engine (that has one database per connection) it is defined during connection. If you pass it, database file name will be changed.
Implements KexiDB::Connection.
Definition at line 160 of file sqliteconnection.cpp.
bool SQLiteConnection::isReadOnly | ( | ) | const [virtual] |
Reimplemented to provide real read-only flag of the connection
Reimplemented from KexiDB::Connection.
Definition at line 343 of file sqliteconnection.cpp.
Cursor * SQLiteConnection::prepareQuery | ( | const QString & | statement, | |
uint | cursor_options = 0 | |||
) | [virtual] |
This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Statement is build from data provided by table schema, it is like "select * from table_name".
Implements KexiDB::Connection.
Definition at line 266 of file sqliteconnection.cpp.
QString SQLiteConnection::serverErrorMsg | ( | ) | [protected, virtual] |
KexiDB library offers detailed error numbers using errorNum() and detailed error i18n'd messages using errorMsg() - these informations are not engine-dependent (almost). Use this in your application to give users more information on what's up.
This method returns (non-i18n'd !) engine-specific error message, if there was any error during last server-side operation, otherwise null string. Reimplement this for your driver
- default implementation just returns null string.
- See also:
- serverErrorMsg()
Reimplemented from KexiDB::Object.
Definition at line 330 of file sqliteconnection.cpp.
int SQLiteConnection::serverResult | ( | ) | [protected, virtual] |
- Returns:
- engine-specific last server-side operation result number. Use this in your application to give users more information on what's up.
- See also:
- serverErrorMsg(), drv_clearServerResult()
Reimplemented from KexiDB::Object.
Definition at line 302 of file sqliteconnection.cpp.
QString SQLiteConnection::serverResultName | ( | ) | [protected, virtual] |
- Returns:
- engine-specific last server-side operation result name, (name for serverResult()). Use this in your application to give users more information on what's up.
- See also:
- serverErrorMsg(), drv_clearServerResult()
Reimplemented from KexiDB::Object.
Definition at line 307 of file sqliteconnection.cpp.
Member Data Documentation
SQLiteConnectionInternal* KexiDB::SQLiteConnection::d [protected] |
for future extensions
Reimplemented from KexiDB::Connection.
Definition at line 99 of file sqliteconnection.h.
The documentation for this class was generated from the following files: