|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
Announcements
Chapters
Services
Feature Zones
|
Note: This is an unedited contribution. If this article is inappropriate,
needs attention or copies someone else's work without reference then please
Report This Article
IntroductionRecently I was looking for a solution for embedded SQL/Database library, so I won't have to redistribute DAO/Jet/SQL Server Express/ODBC or some other database driver... I ran into SQLite3, which is a protable library, written completely in C, I immediatly downloaded SQLite3 (http://www.sqlite.org), and wanted to immediately start using it. Wait a moment, no OOP??? (Object oriented programming, c++...) As I mentioned before, the library is completely written in C, I found out immediately that I needed to create some classes to wrap the library, SQLite is a database engine that you can download, add to your project, and run! There's absolutly zero-configuration needed! Using the codeThere are basically two classes: Database and Table, under the namespace SQLite. Later update: Another class TablePtr to wrap a pointer to Table class. Both classes use The use is very simple, everything is documented inside the code. The classes expect sqlite3 in folder .\SQLite\, you can change it in the source code for wherever you want. When a function is specified as 'Safe' it means that even if it is a null object (e.g. Table * pTbl=0) the show will go on... In the Database class there are the following methods: int Open( LPCTSTR void Close() - Closes the database... bool IsOpen() - Is a database open? (Safe function) sqlite3 * GetPtr() - Returns the handle to the sqlite3 database. int GetLastError() - Returns last error... void CleanError() - Clean last error... Table QuerySQL( LPCTSTR TablePtr QuerySQL2( LPCTSTR int ExecuteSQL( LPCTSTR bool IsSQLComplete() - Checks if an SQL statement is complete (by the sqlite3 ideas and specs...) int GetLastChangesCount() - Returns the count of changes made by the last SQL statement. int ReadBlob( LPCTSTR strSQL, BYTE ** pData, int * iLenBlob ) - Read a BLOB value into pData, the length of the blob goes into iLenBlob. Expects only 1 record, 1 column! int WriteBlob( LPCTSTR strSQL, BYTE * pData, int iLenBlob ) - Write a BLOB value using an INSERT or UPDATE sql statement.sqlite_int64 GetLastInsertRowID() - Get the Row-ID of the last row inserted using INSERT. See SQLite doumentation for more info. Functions Open(), GetLastError() & ExecuteSQL() return an In the Table class, there are the following methods: int GetColCount() - Returns number of columns. Safe function int GetRowCount() - Returns number of rows. Safe function int GetCurRow() - Returns the current selected row. Safe function LPCTSTR GetColName( int bool GoFirst() - Naviagtes to first record, returning false if no records exists. Safe function (returns false if Table is null) bool GoLast() / GoNext() / GoPrev() - Naviagtes through the records... bool GoRow() - Naviagtes to a specific record. Safe function (returns false if Table is null or out of bounds) LPCTSTR GetValue(LPCTSTR LPCTSTR GetValue(int LPCTSTR operator [] (LPCTSTR LPCTSTR operator [] (int void JoinTable(Table & In the TablePtr class: Table * m_pTable - Public member which points to a Table class. Table * Detach() - Detaches the class from the Table, and returns the Table that were just detached... void Attach( Table * pTable) - Frees the current Table, and attaches the pTable. operator () - Now you do not have to use TablePtr::m_pTable, you can just use TablePtr(). operator bool() - Now you do not have to check if m_pTable is valid. Just "if (TablePtr) {...}". Points of InterestYou may have noticed that you can only get values as strings... That is because sqlite3 does not restrict ant field to its data type... so you can put a float instead of a string or an integer, or a string instead of an integer for example... But sqlite3 try to convert to the 'preferred' datatype when it is possible. So you can always expect a string, then if you know that it should be an integer, use _ttoi() to convert, or _tstof() to convert to float... CommentsIf you have any comments, requests, bugs... Feel free to contact me, and I will update as soon as I can. Updates20/08/2007 - I have just added a basic interface for BLOB readings and writing, 25/08/2007 - I have added the TablePtr class to wrap a pointer to the Table class. Suggested by Douglas R. Keesler, thanks! 01/10/2007 - I have made some modifications to make the code more safe. Also implemented JoinTable() for joining to table classes, and an () operator for the TablePtr. Also the GetLastInsertRowID() is implemented now. 20/11/2007 - Added the simple GetCurRow() to the Table class... Also added the documentation about GoRow() 23/12/2007 - Added the bool operator for TablePtr, so you can "if (TablePtr) {...}" to check if the m_pTable member is valid.
|
||||||||||||||||||||||