added a second test for prepared statements

3 files changed, 45 insertions, 1 deletions

diff --git a/tests/psql/GNUmakefile b/tests/psql/GNUmakefile
index 754895f..8ba71a0 100644
--- a/tests/psql/GNUmakefile
+++ b/tests/psql/GNUmakefile
@@ -11,7 +11,8 @@ LIBS_DIR = \
 	-lpqxx -lpq
 
 CPP_BINS = \
-	test1$(EXE)
+	test1$(EXE) \
+	test2$(EXE)
 
 OBJS =
 
diff --git a/tests/psql/README b/tests/psql/README
index 51987a7..b0af0d1 100644
--- a/tests/psql/README
+++ b/tests/psql/README
@@ -1 +1,2 @@
 test1	- using the newest libpqxx
+test2	- using libpqxx and prepared statements
diff --git a/tests/psql/test2.cpp b/tests/psql/test2.cpp
new file mode 100644
index 0000000..5d4e06f
--- /dev/null
+++ b/tests/psql/test2.cpp
@@ -0,0 +1,42 @@
+#include <iostream>
+#include <sstream>
+#include <stdio.h>
+
+#include "pqxx"
+
+using namespace pqxx;
+using namespace PGSTD;
+using namespace std;
+
+int main( ) {
+	connection c( "dbname=test" );
+
+	//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( ) );
+	}
+
+	result r( t.exec( "select * from test" ) );
+	cout << "a\tb" << endl;
+	for( result::size_type i = 0; i < r.size( ); i++ ) {
+		cout << r[i]["a"] << "\t" << r[i]["b"] << endl;
+	}
+
+	t.exec( "drop table test" );
+
+	t.commit( );
+
+	return 0;
+}