pgpool2.git / summary / log / commit / refs

commit    2fd41c50743ffa0cb32cc8ebdad056508bcf33e3
Author:   Yoshiyuki Asaba <y-asaba at pgfoundry.org>
Date:     Tue Nov 06 07:09:25 2007 +0000

    Add INSERT statement test.


 Makefile.am                 |  2 +-
 test/jdbc/InsertTest.java   | 34 ++++++++++++++++++++++++++++++++++
 test/jdbc/RunTest.java      |  3 +++
 test/jdbc/expected/insert   |  1 +
 test/jdbc/pgpool.properties |  2 +-
 test/jdbc/prepare.sql       |  4 ++++
 6 files changed, 44 insertions(+), 2 deletions(-)

diff --git a/Makefile.am b/Makefile.am
index 16f01fe4a..39170f43e 100644
--- a/Makefile.am
+++ b/Makefile.am
@@ -61,7 +61,7 @@ EXTRA_DIST = pgpool.8.in sql/system_db.sql sample/pgpool.pam doc/pgpool-ja.html
 		test/jdbc/*.java test/jdbc/pgpool.properties test/jdbc/prepare.sql test/jdbc/run.sh \
 		test/jdbc/expected/autocommit test/jdbc/expected/batch \
 		test/jdbc/expected/column test/jdbc/expected/lock test/jdbc/expected/select \
-		test/jdbc/expected/update \
+		test/jdbc/expected/update test/jdbc/expected/insert \
 		redhat/pgpool.init redhat/pgpool.sysconfig
 
 SUBDIRS = parser pcp
diff --git a/test/jdbc/InsertTest.java b/test/jdbc/InsertTest.java
new file mode 100644
index 000000000..62dd35658
--- /dev/null
+++ b/test/jdbc/InsertTest.java
@@ -0,0 +1,34 @@
+import java.sql.*;
+
+public class InsertTest extends PgpoolTest {
+    public void do_test() throws SQLException {
+	int N = 100;
+
+	try {
+	    ResultSet rs;
+	    PreparedStatement pstmt = null;
+	    Statement stmt = null;
+
+	    for (int i = 0; i < N; i++) {
+		connection.setAutoCommit(false);
+		pstmt = connection.prepareStatement("INSERT INTO ins VALUES (?)");
+		pstmt.setInt(1, i);
+		pstmt.executeUpdate();
+		pstmt.close();
+		connection.commit();
+	    }
+	    connection.setAutoCommit(true);
+	    stmt = connection.createStatement();
+	    rs = stmt.executeQuery("SELECT count(a) FROM ins" );
+	    rs.next();
+	    logwriter.println(rs.getInt(1));
+	}
+	finally {
+	    connection.close();
+	}
+    }
+
+    public String getTestName() {
+	return "insert";
+    }
+}
diff --git a/test/jdbc/RunTest.java b/test/jdbc/RunTest.java
index 018f1b7a0..77698a645 100644
--- a/test/jdbc/RunTest.java
+++ b/test/jdbc/RunTest.java
@@ -71,6 +71,9 @@ public class RunTest {
 	if (testcase.equals("update"))
 	    return new UpdateTest();
 
+	if (testcase.equals("insert"))
+	    return new InsertTest();
+
 	/* unknown test case */
 	return null;
     }
diff --git a/test/jdbc/expected/insert b/test/jdbc/expected/insert
new file mode 100644
index 000000000..29d6383b5
--- /dev/null
+++ b/test/jdbc/expected/insert
@@ -0,0 +1 @@
+100
diff --git a/test/jdbc/pgpool.properties b/test/jdbc/pgpool.properties
index a55e06433..5ceb6a181 100644
--- a/test/jdbc/pgpool.properties
+++ b/test/jdbc/pgpool.properties
@@ -4,4 +4,4 @@ pgpooltest.user=pgpool
 pgpooltest.password=
 pgpooltest.dbname=pgpooltest
 pgpooltest.options=
-pgpooltest.tests=autocommit batch column lock select update
+pgpooltest.tests=autocommit batch column lock select update insert
diff --git a/test/jdbc/prepare.sql b/test/jdbc/prepare.sql
index 336515f61..c5a474be7 100644
--- a/test/jdbc/prepare.sql
+++ b/test/jdbc/prepare.sql
@@ -48,3 +48,7 @@ DROP TABLE up;
 CREATE TABLE up (a int);
 INSERT INTO up VALUES (1);
 INSERT INTO up VALUES (2);
+
+-- insert
+DROP TABLE ins;
+CREATE TABLE ins (a int);


[parent: 6ac7bb2c8898]