Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/org.eclipse.net4j.db.tests/src/org/eclipse/net4j/db/tests/AbstractDBTest.java')
-rw-r--r--plugins/org.eclipse.net4j.db.tests/src/org/eclipse/net4j/db/tests/AbstractDBTest.java256
1 files changed, 128 insertions, 128 deletions
diff --git a/plugins/org.eclipse.net4j.db.tests/src/org/eclipse/net4j/db/tests/AbstractDBTest.java b/plugins/org.eclipse.net4j.db.tests/src/org/eclipse/net4j/db/tests/AbstractDBTest.java
index 731f8f4fa0..a82558074d 100644
--- a/plugins/org.eclipse.net4j.db.tests/src/org/eclipse/net4j/db/tests/AbstractDBTest.java
+++ b/plugins/org.eclipse.net4j.db.tests/src/org/eclipse/net4j/db/tests/AbstractDBTest.java
@@ -1,128 +1,128 @@
-/*
- * Copyright (c) 2004 - 2012 Eike Stepper (Berlin, Germany) and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Eike Stepper - initial API and implementation
- */
-package org.eclipse.net4j.db.tests;
-
-import org.eclipse.net4j.db.DBType;
-import org.eclipse.net4j.db.DBUtil;
-import org.eclipse.net4j.db.IDBAdapter;
-import org.eclipse.net4j.db.IDBConnectionProvider;
-import org.eclipse.net4j.db.ddl.IDBField;
-import org.eclipse.net4j.db.ddl.IDBIndex;
-import org.eclipse.net4j.db.ddl.IDBSchema;
-import org.eclipse.net4j.db.ddl.IDBTable;
-import org.eclipse.net4j.util.tests.AbstractOMTest;
-
-import javax.sql.DataSource;
-
-import java.sql.Connection;
-import java.util.Set;
-
-/**
- * @author Eike Stepper
- */
-public abstract class AbstractDBTest<DATA_SOURCE extends DataSource> extends AbstractOMTest
-{
- protected IDBAdapter dbAdapter;
-
- protected IDBConnectionProvider dbConnectionProvider;
-
- @SuppressWarnings("unchecked")
- @Override
- protected void doSetUp() throws Exception
- {
- dbAdapter = createDBAdapter();
- DATA_SOURCE dataSource = (DATA_SOURCE)dbAdapter.createJDBCDataSource();
- configureDataSource(dataSource);
- dbConnectionProvider = DBUtil.createConnectionProvider(dataSource);
- }
-
- @Override
- protected void doTearDown() throws Exception
- {
- }
-
- protected abstract IDBAdapter createDBAdapter();
-
- protected abstract void configureDataSource(DATA_SOURCE dataSource);
-
- protected Connection getConnection()
- {
- return dbConnectionProvider.getConnection();
- }
-
- public void testDBTypes() throws Exception
- {
- IDBSchema schema = DBUtil.createSchema("testDBTypes"); //$NON-NLS-1$
- DBType[] dbTypes = DBType.values();
-
- int count = 0;
- int i = 0;
- for (DBType dbType : dbTypes)
- {
- IDBTable table = schema.addTable("table_" + i); //$NON-NLS-1$
- table.addField("field", dbType); //$NON-NLS-1$
- ++count;
-
- if (dbAdapter.isTypeIndexable(dbType))
- {
- IDBTable idx_table = schema.addTable("idx_table" + i); //$NON-NLS-1$
- IDBField idx_field = idx_table.addField("field", dbType); //$NON-NLS-1$
- idx_table.addIndex(IDBIndex.Type.NON_UNIQUE, idx_field);
- ++count;
-
- IDBTable uni_table = schema.addTable("uni_table" + i); //$NON-NLS-1$
- IDBField uni_field = uni_table.addField("field", dbType); //$NON-NLS-1$
- uni_table.addIndex(IDBIndex.Type.UNIQUE, uni_field);
- ++count;
-
- IDBTable pk_table = schema.addTable("pk_table" + i); //$NON-NLS-1$
- IDBField pk_field = pk_table.addField("field", dbType); //$NON-NLS-1$
- pk_table.addIndex(IDBIndex.Type.PRIMARY_KEY, pk_field);
- ++count;
- }
-
- ++i;
- }
-
- Set<IDBTable> tables = schema.create(dbAdapter, dbConnectionProvider);
- assertEquals(count, tables.size());
- }
-
- // public void testEscapeStrings() throws Exception
- // {
- // IDBSchema schema = DBUtil.createSchema("testEscapeStrings"); //$NON-NLS-1$
- // IDBTable table = schema.addTable("testtable"); //$NON-NLS-1$
- // IDBField field = table.addField("strval", DBType.VARCHAR, 255); //$NON-NLS-1$
- // schema.create(dbAdapter, dbConnectionProvider);
- //
- // insertString(field, "My name is 'nobody', not body"); //$NON-NLS-1$
- // insertString(field, "a = 'hello'"); //$NON-NLS-1$
- // insertString(field, "'hello' == a"); //$NON-NLS-1$
- // insertString(field, "'hello'"); //$NON-NLS-1$
- // }
- //
- // private void insertString(IDBField field, String val)
- // {
- // Connection connection = getConnection();
- // IDBTable table = field.getTable();
- //
- // try
- // {
- // DBUtil.insertRow(connection, dbAdapter, table, val);
- // Object[] result = DBUtil.select(connection, (String)null, field);
- // assertEquals(val, result[0]);
- // }
- // finally
- // {
- // DBUtil.update(connection, "DELETE FROM " + table); //$NON-NLS-1$
- // }
- // }
-}
+/*
+ * Copyright (c) 2004 - 2012 Eike Stepper (Berlin, Germany) and others.
+ * All rights reserved. This program and the accompanying materials
+ * are made available under the terms of the Eclipse Public License v1.0
+ * which accompanies this distribution, and is available at
+ * http://www.eclipse.org/legal/epl-v10.html
+ *
+ * Contributors:
+ * Eike Stepper - initial API and implementation
+ */
+package org.eclipse.net4j.db.tests;
+
+import org.eclipse.net4j.db.DBType;
+import org.eclipse.net4j.db.DBUtil;
+import org.eclipse.net4j.db.IDBAdapter;
+import org.eclipse.net4j.db.IDBConnectionProvider;
+import org.eclipse.net4j.db.ddl.IDBField;
+import org.eclipse.net4j.db.ddl.IDBIndex;
+import org.eclipse.net4j.db.ddl.IDBSchema;
+import org.eclipse.net4j.db.ddl.IDBTable;
+import org.eclipse.net4j.util.tests.AbstractOMTest;
+
+import javax.sql.DataSource;
+
+import java.sql.Connection;
+import java.util.Set;
+
+/**
+ * @author Eike Stepper
+ */
+public abstract class AbstractDBTest<DATA_SOURCE extends DataSource> extends AbstractOMTest
+{
+ protected IDBAdapter dbAdapter;
+
+ protected IDBConnectionProvider dbConnectionProvider;
+
+ @SuppressWarnings("unchecked")
+ @Override
+ protected void doSetUp() throws Exception
+ {
+ dbAdapter = createDBAdapter();
+ DATA_SOURCE dataSource = (DATA_SOURCE)dbAdapter.createJDBCDataSource();
+ configureDataSource(dataSource);
+ dbConnectionProvider = DBUtil.createConnectionProvider(dataSource);
+ }
+
+ @Override
+ protected void doTearDown() throws Exception
+ {
+ }
+
+ protected abstract IDBAdapter createDBAdapter();
+
+ protected abstract void configureDataSource(DATA_SOURCE dataSource);
+
+ protected Connection getConnection()
+ {
+ return dbConnectionProvider.getConnection();
+ }
+
+ public void testDBTypes() throws Exception
+ {
+ IDBSchema schema = DBUtil.createSchema("testDBTypes"); //$NON-NLS-1$
+ DBType[] dbTypes = DBType.values();
+
+ int count = 0;
+ int i = 0;
+ for (DBType dbType : dbTypes)
+ {
+ IDBTable table = schema.addTable("table_" + i); //$NON-NLS-1$
+ table.addField("field", dbType); //$NON-NLS-1$
+ ++count;
+
+ if (dbAdapter.isTypeIndexable(dbType))
+ {
+ IDBTable idx_table = schema.addTable("idx_table" + i); //$NON-NLS-1$
+ IDBField idx_field = idx_table.addField("field", dbType); //$NON-NLS-1$
+ idx_table.addIndex(IDBIndex.Type.NON_UNIQUE, idx_field);
+ ++count;
+
+ IDBTable uni_table = schema.addTable("uni_table" + i); //$NON-NLS-1$
+ IDBField uni_field = uni_table.addField("field", dbType); //$NON-NLS-1$
+ uni_table.addIndex(IDBIndex.Type.UNIQUE, uni_field);
+ ++count;
+
+ IDBTable pk_table = schema.addTable("pk_table" + i); //$NON-NLS-1$
+ IDBField pk_field = pk_table.addField("field", dbType); //$NON-NLS-1$
+ pk_table.addIndex(IDBIndex.Type.PRIMARY_KEY, pk_field);
+ ++count;
+ }
+
+ ++i;
+ }
+
+ Set<IDBTable> tables = schema.create(dbAdapter, dbConnectionProvider);
+ assertEquals(count, tables.size());
+ }
+
+ // public void testEscapeStrings() throws Exception
+ // {
+ // IDBSchema schema = DBUtil.createSchema("testEscapeStrings"); //$NON-NLS-1$
+ // IDBTable table = schema.addTable("testtable"); //$NON-NLS-1$
+ // IDBField field = table.addField("strval", DBType.VARCHAR, 255); //$NON-NLS-1$
+ // schema.create(dbAdapter, dbConnectionProvider);
+ //
+ // insertString(field, "My name is 'nobody', not body"); //$NON-NLS-1$
+ // insertString(field, "a = 'hello'"); //$NON-NLS-1$
+ // insertString(field, "'hello' == a"); //$NON-NLS-1$
+ // insertString(field, "'hello'"); //$NON-NLS-1$
+ // }
+ //
+ // private void insertString(IDBField field, String val)
+ // {
+ // Connection connection = getConnection();
+ // IDBTable table = field.getTable();
+ //
+ // try
+ // {
+ // DBUtil.insertRow(connection, dbAdapter, table, val);
+ // Object[] result = DBUtil.select(connection, (String)null, field);
+ // assertEquals(val, result[0]);
+ // }
+ // finally
+ // {
+ // DBUtil.update(connection, "DELETE FROM " + table); //$NON-NLS-1$
+ // }
+ // }
+}

Back to the top