/sqlite3cc : revision 12

To get this branch, use:

bzr branch
http://bzr.ed.am/sqlite3cc

Viewing changes to test/test-main.cc

- moved null_t, exec_t and set_index_t to detail namespace so only their extern instantiations are in the main namespace
- added immediate transation

added added

removed removed

sqlite::command c7( db, "INSERT INTO pets VALUES( :foo, :bar )" );

c7.bind( ":foo", "foocat" ); c7.bind( ":bar", 22 ); c7.exec();

// test command binding via stream operator

// test basic_statement binding via stream operator

sqlite::command c4( db, "INSERT INTO pets VALUES( ?, ? )" );

c4 << "tessa" << 16 << sqlite::exec;

sqlite::command( db, "INSERT INTO pets VALUES( ?, ? )" ) <<

"tessa" << 16 << sqlite::exec;

sqlite::command c4( db, "INSERT INTO pets VALUES( ?, ? )" );

c4 << sqlite::null << sqlite::null << sqlite::set_index( 1 ) <<

"tamara" << sqlite::exec;

assert( c4.changes() == 1 );

// test query binding via stream operator

sqlite::query( db, "SELECT * FROM pets WHERE name = ? OR age = ?" )

<< "foo" << 16;

sqlite::query( db, "SELECT * FROM pets WHERE name = ? OR name = ? OR "

"name = ? OR name = ?" ) << "foo" << sqlite::null << sqlite::null

<< sqlite::set_index( 1 ) << "bar" << "baz";

sqlite::null << sqlite::null <<

sqlite::set_index( 1 ) << "tamara" << sqlite::exec;

// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -