Changeset 2027

Timestamp:

03/11/08 11:13:11 (5 years ago)

Author:

leo

Message:

added test codes

Location:

XerialJ/trunk/sqlite-jdbc

Files:

• pom.xml (modified) (1 diff)
• src/test/java/org/sqlite (added)
• src/test/java/org/sqlite/ConnectionTest.java (added)
• src/test/java/org/sqlite/DBMetaDataTest.java (added)
• src/test/java/org/sqlite/PrepStmtTest.java (added)
• src/test/java/org/sqlite/RSMetaDataTest.java (added)
• src/test/java/org/sqlite/StatementTest.java (added)
• src/test/java/org/sqlite/TransactionTest.java (added)
• src/test/java/org/sqlite/UDFTest.java (added)
• src/test/java/org/xerial/db/sql/sqlite/SQLiteJDBCLoaderTest.java (modified) (3 diffs)

XerialJ/trunk/sqlite-jdbc/pom.xml

@@ -14 +14 @@
   <groupId>org.xerial</groupId>
   <artifactId>sqlite-jdbc</artifactId>
-  <version>v042</version>
+  <version>v042.1-SNAPSHOT</version>
   <name>SQLite JDBC</name>
   <description>SQLite JDBC library</description>

XerialJ/trunk/sqlite-jdbc/src/test/java/org/xerial/db/sql/sqlite/SQLiteJDBCLoaderTest.java

@@ -25 +25 @@
 package org.xerial.db.sql.sqlite;
 
+import static org.junit.Assert.assertEquals;
+import static org.junit.Assert.assertTrue;
 import static org.junit.Assert.fail;
 
@@ -36 +38 @@
 import org.junit.Before;
 import org.junit.Test;
+import org.sqlite.Function;
 
 public class SQLiteJDBCLoaderTest
 {
 
+    private Connection connection = null;
+
     @Before
     public void setUp() throws Exception
     {
-
+        connection = null;
+        Class.forName("org.sqlite.JDBC");
+        // create a database connection
+        connection = DriverManager.getConnection("jdbc:sqlite::memory:");
     }
 
     @After
     public void tearDown() throws Exception
-    {}
+    {
+        if (connection != null)
+            connection.close();
+    }
 
     @Test
     public void query() throws ClassNotFoundException
     {
-        // SQLiteJDBCLoader.initialize();
-
-        // load the sqlite-JDBC driver into the current class loader
-        Class.forName("org.sqlite.JDBC");
-
-        Connection connection = null;
         try
         {
-            // create a database connection
-            connection = DriverManager.getConnection("jdbc:sqlite::memory:");
             Statement statement = connection.createStatement();
             statement.setQueryTimeout(30); // set timeout to 30 sec.
@@ -84 +87 @@
             fail(e.getMessage());
         }
-        finally
-        {
-            try
+    }
+
+    @Test
+    public void function() throws SQLException
+    {
+        Function.create(connection, "total", new Function() {
+            @Override
+            protected void xFunc() throws SQLException
             {
-                if (connection != null)
-                    connection.close();
+                int sum = 0;
+                for (int i = 0; i < args(); i++)
+                    sum += value_int(i);
+                result(sum);
             }
-            catch (SQLException e)
-            {
-                // connection close failed.
-                fail(e.getMessage());
-            }
-        }
+        });
+
+        ResultSet rs = connection.createStatement().executeQuery("select total(1, 2, 3, 4, 5)");
+        assertTrue(rs.next());
+        assertEquals(rs.getInt(1), 1 + 2 + 3 + 4 + 5);
     }
+
 }