/sqlite3cc : revision 14

To get this branch, use:

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

Viewing changes to test/test-main.cc

- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec

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 basic_statement binding via stream operator

// test command binding via stream operator

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

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

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

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

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

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

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

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";

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