db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From m...@apache.org
Subject svn commit: r331927 - /db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/SqlBuilderTest.java
Date Wed, 09 Nov 2005 00:00:02 GMT
Author: mvdb
Date: Tue Nov  8 15:59:58 2005
New Revision: 331927

URL: http://svn.apache.org/viewcvs?rev=331927&view=rev
Log:
Add test for updateSql. Far from complete, but a start..

Added:
    db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/SqlBuilderTest.java

Added: db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/SqlBuilderTest.java
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/SqlBuilderTest.java?rev=331927&view=auto
==============================================================================
--- db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/SqlBuilderTest.java (added)
+++ db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/SqlBuilderTest.java Tue Nov  8
15:59:58 2005
@@ -0,0 +1,71 @@
+package org.apache.ddlutils.platform;
+
+/*
+ * Copyright 1999-2005 The Apache Software Foundation.
+ * 
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+import java.util.HashMap;
+import java.util.Map;
+
+import org.apache.ddlutils.PlatformInfo;
+import org.apache.ddlutils.TestPlatformBase;
+import org.apache.ddlutils.model.Database;
+
+/**
+ * Test the SqlBuilder (abstract) class.
+ * 
+ * @author <a href="mailto:martin@mvdb.net">Martin van den Bemt</a>
+ * @version $Revision: $
+ */
+public class SqlBuilderTest extends TestPlatformBase {
+
+    String xml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+
+                 "<database name='ddlutils'>\n"+
+                 "  <table name='TestTable'>\n"+
+                 "    <column name='id' autoIncrement='true' type='INTEGER' primaryKey='true'/>\n"+
+                 "    <column name='name' type='VARCHAR' size='15'/>\n"+
+                 "  </table>\n"+
+                 "</database>";
+
+    public void setUp()
+    {
+    }
+
+    /**
+     * Test the updateSql method
+     */
+    public void testUpdateSql()
+    {
+        SqlBuilder sqlBuilder = new SqlBuilderImpl(new PlatformInfo());
+        Database database = parseDatabaseFromString(xml);
+        Map map = new HashMap();
+        map.put("name", "ddlutils");
+        map.put("id", new Integer(0));
+        String sql = sqlBuilder.getUpdateSql(database.getTable(0), map, false);
+        assertEquals("UPDATE \"TestTable\" SET \"name\" = 'ddlutils' WHERE \"id\" = '0'",
sql);
+    }
+
+
+    protected String getDatabaseName() {
+        return null;
+    }
+
+    public class SqlBuilderImpl extends SqlBuilder {
+
+        public SqlBuilderImpl(PlatformInfo info) {
+            super(info);
+        }
+    }
+}



Mime
View raw message