You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by aa...@apache.org on 2009/02/04 11:44:09 UTC
svn commit: r740685 -
/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/trans/InsertBatchQueryBuilderTest.java
Author: aadamchik
Date: Wed Feb 4 10:44:08 2009
New Revision: 740685
URL: http://svn.apache.org/viewvc?rev=740685&view=rev
Log:
CAY-289 Implement Quoting of identifiers
forgot to add a unit test
Added:
cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/trans/InsertBatchQueryBuilderTest.java
Added: cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/trans/InsertBatchQueryBuilderTest.java
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/trans/InsertBatchQueryBuilderTest.java?rev=740685&view=auto
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/trans/InsertBatchQueryBuilderTest.java (added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/trans/InsertBatchQueryBuilderTest.java Wed Feb 4 10:44:08 2009
@@ -0,0 +1,96 @@
+/*****************************************************************
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you 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.
+ ****************************************************************/
+package org.apache.cayenne.access.trans;
+
+import java.util.Collections;
+import java.util.List;
+
+import org.apache.cayenne.dba.DbAdapter;
+import org.apache.cayenne.dba.JdbcAdapter;
+import org.apache.cayenne.map.DbEntity;
+import org.apache.cayenne.query.InsertBatchQuery;
+import org.apache.cayenne.testdo.locking.SimpleLockingTestEntity;
+import org.apache.cayenne.unit.LockingCase;
+
+public class InsertBatchQueryBuilderTest extends LockingCase {
+
+ public void testConstructor() throws Exception {
+ DbAdapter adapter = new JdbcAdapter();
+
+ DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(adapter);
+
+ assertSame(adapter, builder.getAdapter());
+ }
+
+ public void testCreateSqlString() throws Exception {
+ DbEntity entity = getDomain().getEntityResolver().lookupObjEntity(
+ SimpleLockingTestEntity.class).getDbEntity();
+
+ List idAttributes = Collections.singletonList(entity
+ .getAttribute("LOCKING_TEST_ID"));
+
+ InsertBatchQuery deleteQuery = new InsertBatchQuery(entity, 1);
+ InsertBatchQueryBuilder builder = new InsertBatchQueryBuilder(new JdbcAdapter());
+ String generatedSql = builder.createSqlString(deleteQuery);
+ assertNotNull(generatedSql);
+ assertEquals("INSERT INTO "
+ + entity.getName()
+ + " (DESCRIPTION, LOCKING_TEST_ID, NAME) VALUES (?, ?, ?)", generatedSql);
+ }
+
+ public void testCreateSqlStringWithIdentifiersQuote() throws Exception {
+ DbEntity entity = getDomain().getEntityResolver().lookupObjEntity(
+ SimpleLockingTestEntity.class).getDbEntity();
+ try {
+
+ entity.getDataMap().setQuotingSQLIdentifiers(true);
+ List idAttributes = Collections.singletonList(entity
+ .getAttribute("LOCKING_TEST_ID"));
+
+ InsertBatchQuery deleteQuery = new InsertBatchQuery(entity, 1);
+ InsertBatchQueryBuilder builder = new InsertBatchQueryBuilder(
+ new JdbcAdapter());
+ String generatedSql = builder.createSqlString(deleteQuery);
+ JdbcAdapter adapter = (JdbcAdapter) getAccessStackAdapter().getAdapter();
+ String charStart = adapter.getIdentifiersStartQuote();
+ String charEnd = adapter.getIdentifiersEndQuote();
+ assertNotNull(generatedSql);
+ assertEquals("INSERT INTO "
+ + charStart
+ + entity.getName()
+ + charEnd
+ + " ("
+ + charStart
+ + "DESCRIPTION"
+ + charEnd
+ + ", "
+ + charStart
+ + "LOCKING_TEST_ID"
+ + charEnd
+ + ", "
+ + charStart
+ + "NAME"
+ + charEnd
+ + ") VALUES (?, ?, ?)", generatedSql);
+ }
+ finally {
+ entity.getDataMap().setQuotingSQLIdentifiers(false);
+ }
+ }
+}