made an example with templated prepared statements (libpqxx, brilliant!)

1 files changed, 5 insertions, 9 deletions

diff --git a/tests/psql/test2.cpp b/tests/psql/test2.cpp
index 5d4e06f..852f257 100644
--- a/tests/psql/test2.cpp
+++ b/tests/psql/test2.cpp
@@ -13,19 +13,15 @@ int main( ) {
 
 	//c.trace( stdout );
 
-	cout << "Conntected to database." << endl
-	     << "Backend protocol version: " << c.server_version( ) << endl
-	     << "Protocol version: " << c.protocol_version( ) << endl
-	     << "Server PID: " << c.backendpid( ) << endl
-	     << "Prepared Statements: " << c.supports( c.cap_prepared_statements ) << endl; 
-
 	work t( c, "test transaction" );
 
 	t.exec( "create table test( a integer, b integer)" );
 	for( unsigned int i = 0; i < 1000; i++ ) {
-		ostringstream sql;
-		sql << "insert into test values( '" << i << "', '" << i << "' )";
-		t.exec( sql.str( ) );
+		c.prepare( "insertTestStmt",
+			"insert into test(a,b) values($1,$2)" )
+			 ( "integer", prepare::treat_direct )
+			 ( "integer", prepare::treat_direct );
+		t.prepared( "insertTestStmt" )(i)(i).exec( );
 	}
 
 	result r( t.exec( "select * from test" ) );