Changes between Version 37 and Version 38 of Packages/SQLite

Timestamp:

07/02/12 05:58:54 (12 years ago)

Author:

C Rempel

Comment:

/* Testing Ideas */

Packages/SQLite

@@ -99 +99 @@
 =  Testing Ideas  =
 
-Originally I thought it would be necessary to define a src/os_rtems.c because of issues with shared memory support, and thus would need to use the network filesystem, but as that is no longer an issue, I would suggest using one of the network-demos with a filesystem as a code-base to copy and the [http://www.sqlite.org/quickstart.html SQLite quickstart] guide as guideline for the database demo.
+# Link the SQLite library using a Makefile.
+# Use [http://www.sqlite.org/cintro.html An Introduction To The SQLite C/C++ Interface] as a guideline for the test.
+So the idea would be to:
+# Open the database
+# Prepare the SQL statement for processing
+# "Step" through the results, in this case, an insert (or make table?) would be awesome!
+# Some simple column statement
+# Finalize (delete) the prepared statement
+# Close the connection.
+So, a test would look like:
+ /* SQL Test */
+/* Database initialization */
+ printk("Opening the Database\n");
+ sqlite3_open(filename, &ppDb, flags, &zVfs);
+ 
+ printk("Preparing the SQL Statement\n");
+ sqlite3_prepare_v2(&db, &zSql, nByte, &ppStmt, &pzTail);
+
+ printk("Stepping through the Results\n");
+ sqlite3_step(&ppStmt);
+
+ printk("Counting the number of columns...");
+ nCols = sqlite3_column_count(&ppStmt);
+ printk("and the number of columns is %d\n", nCols);
+
+ printk("Deleting the SQL Statement\n");
+ sqlite3_finalize(&ppStmt);
+ 
+ printk("Closing the Database");
+ sqlite3_close(&ppDb);
 =  Next Steps  =