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:[EMAIL PROTECTED]">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);
+ }
+ }
+}
