diff options
Diffstat (limited to 'plugins/org.eclipse.osee.framework.core.datastore/src/org/eclipse/osee/framework/core/datastore/schema/sql/PostgreSqlManager.java')
-rw-r--r-- | plugins/org.eclipse.osee.framework.core.datastore/src/org/eclipse/osee/framework/core/datastore/schema/sql/PostgreSqlManager.java | 402 |
1 files changed, 201 insertions, 201 deletions
diff --git a/plugins/org.eclipse.osee.framework.core.datastore/src/org/eclipse/osee/framework/core/datastore/schema/sql/PostgreSqlManager.java b/plugins/org.eclipse.osee.framework.core.datastore/src/org/eclipse/osee/framework/core/datastore/schema/sql/PostgreSqlManager.java index 9036b5cd7c2..cd78abf526b 100644 --- a/plugins/org.eclipse.osee.framework.core.datastore/src/org/eclipse/osee/framework/core/datastore/schema/sql/PostgreSqlManager.java +++ b/plugins/org.eclipse.osee.framework.core.datastore/src/org/eclipse/osee/framework/core/datastore/schema/sql/PostgreSqlManager.java @@ -1,201 +1,201 @@ -/*******************************************************************************
- * Copyright (c) 2004, 2007 Boeing.
- * 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:
- * Boeing - initial API and implementation
- *******************************************************************************/
-package org.eclipse.osee.framework.core.datastore.schema.sql;
-
-import java.util.ArrayList;
-import java.util.List;
-import java.util.Map;
-import java.util.Set;
-import java.util.logging.Level;
-import org.apache.commons.lang.StringUtils;
-import org.eclipse.osee.framework.core.datastore.internal.Activator;
-import org.eclipse.osee.framework.core.datastore.schema.data.AppliesToClause;
-import org.eclipse.osee.framework.core.datastore.schema.data.ColumnMetadata;
-import org.eclipse.osee.framework.core.datastore.schema.data.ConstraintElement;
-import org.eclipse.osee.framework.core.datastore.schema.data.ForeignKey;
-import org.eclipse.osee.framework.core.datastore.schema.data.IndexElement;
-import org.eclipse.osee.framework.core.datastore.schema.data.ReferenceClause;
-import org.eclipse.osee.framework.core.datastore.schema.data.TableElement;
-import org.eclipse.osee.framework.core.datastore.schema.data.ReferenceClause.OnDeleteEnum;
-import org.eclipse.osee.framework.core.datastore.schema.data.ReferenceClause.OnUpdateEnum;
-import org.eclipse.osee.framework.core.datastore.schema.data.TableElement.ColumnFields;
-import org.eclipse.osee.framework.core.exception.OseeDataStoreException;
-import org.eclipse.osee.framework.database.core.ConnectionHandler;
-import org.eclipse.osee.framework.database.core.OseeConnection;
-import org.eclipse.osee.framework.logging.OseeLog;
-
-/**
- * @author Andrew M. Finkbeiner
- */
-public class PostgreSqlManager extends SqlManagerImpl {
- /**
- * @param sqlDataType
- */
- public PostgreSqlManager(SqlDataType sqlDataType) {
- super(sqlDataType);
- }
-
- private String handleColumnCreationSection(OseeConnection connection, Map<String, ColumnMetadata> columns) {
- List<String> lines = new ArrayList<String>();
- Set<String> keys = columns.keySet();
- for (String key : keys) {
- Map<ColumnFields, String> column = columns.get(key).getColumnFields();
- lines.add(columnDataToSQL(column));
- }
- String toExecute = org.eclipse.osee.framework.jdk.core.util.Collections.toString(lines, ",\n");
- return toExecute;
- }
-
- public void createTable(OseeConnection connection, TableElement tableDef) throws OseeDataStoreException {
- String toExecute = "CREATE TABLE " + tableDef.getFullyQualifiedTableName() + " ( \n";
- toExecute += handleColumnCreationSection(connection, tableDef.getColumns());
- toExecute += handleConstraintCreationSection(tableDef.getConstraints(), tableDef.getFullyQualifiedTableName());
- toExecute +=
- handleConstraintCreationSection(tableDef.getForeignKeyConstraints(), tableDef.getFullyQualifiedTableName());
- toExecute += " \n)\n";
- OseeLog.log(Activator.class, Level.FINE,
- "Creating Table: [ " + tableDef.getFullyQualifiedTableName() + "]");
- ConnectionHandler.runPreparedUpdate(connection, toExecute);
- }
-
- @Override
- public void dropTable(TableElement tableDef) throws OseeDataStoreException {
- String toExecute = "DROP TABLE " + formatQuotedString(tableDef.getFullyQualifiedTableName(), "\\.") + " CASCADE";
- OseeLog.log(Activator.class, Level.FINE,
- "Dropping Table: [ " + tableDef.getFullyQualifiedTableName() + "]");
- ConnectionHandler.runPreparedUpdate(toExecute);
- }
-
- @Override
- protected String formatQuotedString(String value, String splitAt) {
- String[] array = value.split(splitAt);
- for (int index = 0; index < array.length; index++) {
- array[index] = array[index];
- }
- return StringUtils.join(array, splitAt.replaceAll("\\\\", ""));
- }
-
- public void dropIndex(OseeConnection connection, TableElement tableDef) throws OseeDataStoreException {
- List<IndexElement> tableIndices = tableDef.getIndexData();
- String tableName = tableDef.getFullyQualifiedTableName();
- for (IndexElement iData : tableIndices) {
- if (iData.ignoreMySql()) {
- continue;
- }
- OseeLog.log(Activator.class, Level.FINE, String.format("Dropping Index: [%s] FROM [%s]\n",
- iData.getId(), tableName));
- if (iData.getId().equals("PRIMARY")) {
- ConnectionHandler.runPreparedUpdate(connection,
- "ALTER TABLE " + tableDef.getFullyQualifiedTableName() + " DROP PRIMARY KEY");
- } else {
- ConnectionHandler.runPreparedUpdate(connection,
- "ALTER TABLE " + tableDef.getFullyQualifiedTableName() + " DROP INDEX " + iData.getId());
- }
- }
- }
-
- @Override
- public String constraintDataToSQL(ConstraintElement constraint, String tableID) {
- StringBuilder toReturn = new StringBuilder();
- String id = formatQuotedString(constraint.getId(), "\\.");
- String type = constraint.getConstraintType().toString();
- String appliesTo = formatQuotedString(constraint.getCommaSeparatedColumnsList(), ",");
-
- if (id != null && !id.equals("") && appliesTo != null && !appliesTo.equals("")) {
- toReturn.append("CONSTRAINT " + id + " " + type + " (" + appliesTo + ")");
-
- if (constraint instanceof ForeignKey) {
- ForeignKey fk = (ForeignKey) constraint;
- List<ReferenceClause> refs = fk.getReferences();
-
- for (ReferenceClause ref : refs) {
- String refTable = formatQuotedString(ref.getFullyQualifiedTableName(), "\\.");
- String refColumns = formatQuotedString(ref.getCommaSeparatedColumnsList(), ",");
-
- String onUpdate = "";
- if (!ref.getOnUpdateAction().equals(OnUpdateEnum.UNSPECIFIED)) {
- onUpdate = "ON UPDATE " + ref.getOnUpdateAction().toString();
- }
-
- String onDelete = "";
- if (!ref.getOnDeleteAction().equals(OnDeleteEnum.UNSPECIFIED)) {
- onDelete = "ON DELETE " + ref.getOnDeleteAction().toString();
- }
-
- if (refTable != null && refColumns != null && !refTable.equals("") && !refColumns.equals("")) {
- toReturn.append(" REFERENCES " + refTable + " (" + refColumns + ")");
- if (!onUpdate.equals("")) {
- toReturn.append(" " + onUpdate);
- }
-
- if (!onDelete.equals("")) {
- toReturn.append(" " + onDelete);
- }
-
- if (constraint.isDeferrable()) {
- toReturn.append(" DEFERRABLE");
- }
- }
-
- else {
- OseeLog.log(Activator.class, Level.WARNING,
- "Skipping CONSTRAINT at Table: " + tableID + "\n\t " + fk.toString());
- }
-
- }
- }
- } else {
- OseeLog.log(Activator.class, Level.WARNING,
- "Skipping CONSTRAINT at Table: " + tableID + "\n\t " + constraint.toString());
- }
- return toReturn.toString();
- }
-
- public void createIndex(OseeConnection connection, TableElement tableDef) throws OseeDataStoreException {
- List<IndexElement> tableIndices = tableDef.getIndexData();
- String indexId = null;
- StringBuilder appliesTo = new StringBuilder();
- String tableName = formatQuotedString(tableDef.getFullyQualifiedTableName(), "\\.");
- for (IndexElement iData : tableIndices) {
- if (iData.ignoreMySql()) {
- continue;
- }
- indexId = iData.getId();
- appliesTo.delete(0, appliesTo.length());
-
- List<AppliesToClause> appliesToList = iData.getAppliesToList();
- for (int index = 0; index < appliesToList.size(); index++) {
- AppliesToClause record = appliesToList.get(index);
- appliesTo.append(record.getColumnName());
-
- // switch (record.getOrderType()) {
- // case Ascending:
- // appliesTo.append(" ASC");
- // break;
- // case Descending:
- // appliesTo.append(" DESC");
- // break;
- // default:
- // break;
- // }
- if (index + 1 < appliesToList.size()) {
- appliesTo.append(", ");
- }
- }
- String toExecute =
- String.format(CREATE_STRING + " " + iData.getIndexType() + " INDEX %s ON %s (%s)", indexId, tableName,
- appliesTo);
- OseeLog.log(Activator.class, Level.FINE, toExecute);
- ConnectionHandler.runPreparedUpdate(connection, toExecute);
- }
- }
-
-}
+/******************************************************************************* + * Copyright (c) 2004, 2007 Boeing. + * 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: + * Boeing - initial API and implementation + *******************************************************************************/ +package org.eclipse.osee.framework.core.datastore.schema.sql; + +import java.util.ArrayList; +import java.util.List; +import java.util.Map; +import java.util.Set; +import java.util.logging.Level; +import org.apache.commons.lang.StringUtils; +import org.eclipse.osee.framework.core.datastore.internal.Activator; +import org.eclipse.osee.framework.core.datastore.schema.data.AppliesToClause; +import org.eclipse.osee.framework.core.datastore.schema.data.ColumnMetadata; +import org.eclipse.osee.framework.core.datastore.schema.data.ConstraintElement; +import org.eclipse.osee.framework.core.datastore.schema.data.ForeignKey; +import org.eclipse.osee.framework.core.datastore.schema.data.IndexElement; +import org.eclipse.osee.framework.core.datastore.schema.data.ReferenceClause; +import org.eclipse.osee.framework.core.datastore.schema.data.TableElement; +import org.eclipse.osee.framework.core.datastore.schema.data.ReferenceClause.OnDeleteEnum; +import org.eclipse.osee.framework.core.datastore.schema.data.ReferenceClause.OnUpdateEnum; +import org.eclipse.osee.framework.core.datastore.schema.data.TableElement.ColumnFields; +import org.eclipse.osee.framework.core.exception.OseeDataStoreException; +import org.eclipse.osee.framework.database.core.ConnectionHandler; +import org.eclipse.osee.framework.database.core.OseeConnection; +import org.eclipse.osee.framework.logging.OseeLog; + +/** + * @author Andrew M. Finkbeiner + */ +public class PostgreSqlManager extends SqlManagerImpl { + /** + * @param sqlDataType + */ + public PostgreSqlManager(SqlDataType sqlDataType) { + super(sqlDataType); + } + + private String handleColumnCreationSection(OseeConnection connection, Map<String, ColumnMetadata> columns) { + List<String> lines = new ArrayList<String>(); + Set<String> keys = columns.keySet(); + for (String key : keys) { + Map<ColumnFields, String> column = columns.get(key).getColumnFields(); + lines.add(columnDataToSQL(column)); + } + String toExecute = org.eclipse.osee.framework.jdk.core.util.Collections.toString(lines, ",\n"); + return toExecute; + } + + public void createTable(OseeConnection connection, TableElement tableDef) throws OseeDataStoreException { + String toExecute = "CREATE TABLE " + tableDef.getFullyQualifiedTableName() + " ( \n"; + toExecute += handleColumnCreationSection(connection, tableDef.getColumns()); + toExecute += handleConstraintCreationSection(tableDef.getConstraints(), tableDef.getFullyQualifiedTableName()); + toExecute += + handleConstraintCreationSection(tableDef.getForeignKeyConstraints(), tableDef.getFullyQualifiedTableName()); + toExecute += " \n)\n"; + OseeLog.log(Activator.class, Level.FINE, + "Creating Table: [ " + tableDef.getFullyQualifiedTableName() + "]"); + ConnectionHandler.runPreparedUpdate(connection, toExecute); + } + + @Override + public void dropTable(TableElement tableDef) throws OseeDataStoreException { + String toExecute = "DROP TABLE " + formatQuotedString(tableDef.getFullyQualifiedTableName(), "\\.") + " CASCADE"; + OseeLog.log(Activator.class, Level.FINE, + "Dropping Table: [ " + tableDef.getFullyQualifiedTableName() + "]"); + ConnectionHandler.runPreparedUpdate(toExecute); + } + + @Override + protected String formatQuotedString(String value, String splitAt) { + String[] array = value.split(splitAt); + for (int index = 0; index < array.length; index++) { + array[index] = array[index]; + } + return StringUtils.join(array, splitAt.replaceAll("\\\\", "")); + } + + public void dropIndex(OseeConnection connection, TableElement tableDef) throws OseeDataStoreException { + List<IndexElement> tableIndices = tableDef.getIndexData(); + String tableName = tableDef.getFullyQualifiedTableName(); + for (IndexElement iData : tableIndices) { + if (iData.ignoreMySql()) { + continue; + } + OseeLog.log(Activator.class, Level.FINE, String.format("Dropping Index: [%s] FROM [%s]\n", + iData.getId(), tableName)); + if (iData.getId().equals("PRIMARY")) { + ConnectionHandler.runPreparedUpdate(connection, + "ALTER TABLE " + tableDef.getFullyQualifiedTableName() + " DROP PRIMARY KEY"); + } else { + ConnectionHandler.runPreparedUpdate(connection, + "ALTER TABLE " + tableDef.getFullyQualifiedTableName() + " DROP INDEX " + iData.getId()); + } + } + } + + @Override + public String constraintDataToSQL(ConstraintElement constraint, String tableID) { + StringBuilder toReturn = new StringBuilder(); + String id = formatQuotedString(constraint.getId(), "\\."); + String type = constraint.getConstraintType().toString(); + String appliesTo = formatQuotedString(constraint.getCommaSeparatedColumnsList(), ","); + + if (id != null && !id.equals("") && appliesTo != null && !appliesTo.equals("")) { + toReturn.append("CONSTRAINT " + id + " " + type + " (" + appliesTo + ")"); + + if (constraint instanceof ForeignKey) { + ForeignKey fk = (ForeignKey) constraint; + List<ReferenceClause> refs = fk.getReferences(); + + for (ReferenceClause ref : refs) { + String refTable = formatQuotedString(ref.getFullyQualifiedTableName(), "\\."); + String refColumns = formatQuotedString(ref.getCommaSeparatedColumnsList(), ","); + + String onUpdate = ""; + if (!ref.getOnUpdateAction().equals(OnUpdateEnum.UNSPECIFIED)) { + onUpdate = "ON UPDATE " + ref.getOnUpdateAction().toString(); + } + + String onDelete = ""; + if (!ref.getOnDeleteAction().equals(OnDeleteEnum.UNSPECIFIED)) { + onDelete = "ON DELETE " + ref.getOnDeleteAction().toString(); + } + + if (refTable != null && refColumns != null && !refTable.equals("") && !refColumns.equals("")) { + toReturn.append(" REFERENCES " + refTable + " (" + refColumns + ")"); + if (!onUpdate.equals("")) { + toReturn.append(" " + onUpdate); + } + + if (!onDelete.equals("")) { + toReturn.append(" " + onDelete); + } + + if (constraint.isDeferrable()) { + toReturn.append(" DEFERRABLE"); + } + } + + else { + OseeLog.log(Activator.class, Level.WARNING, + "Skipping CONSTRAINT at Table: " + tableID + "\n\t " + fk.toString()); + } + + } + } + } else { + OseeLog.log(Activator.class, Level.WARNING, + "Skipping CONSTRAINT at Table: " + tableID + "\n\t " + constraint.toString()); + } + return toReturn.toString(); + } + + public void createIndex(OseeConnection connection, TableElement tableDef) throws OseeDataStoreException { + List<IndexElement> tableIndices = tableDef.getIndexData(); + String indexId = null; + StringBuilder appliesTo = new StringBuilder(); + String tableName = formatQuotedString(tableDef.getFullyQualifiedTableName(), "\\."); + for (IndexElement iData : tableIndices) { + if (iData.ignoreMySql()) { + continue; + } + indexId = iData.getId(); + appliesTo.delete(0, appliesTo.length()); + + List<AppliesToClause> appliesToList = iData.getAppliesToList(); + for (int index = 0; index < appliesToList.size(); index++) { + AppliesToClause record = appliesToList.get(index); + appliesTo.append(record.getColumnName()); + + // switch (record.getOrderType()) { + // case Ascending: + // appliesTo.append(" ASC"); + // break; + // case Descending: + // appliesTo.append(" DESC"); + // break; + // default: + // break; + // } + if (index + 1 < appliesToList.size()) { + appliesTo.append(", "); + } + } + String toExecute = + String.format(CREATE_STRING + " " + iData.getIndexType() + " INDEX %s ON %s (%s)", indexId, tableName, + appliesTo); + OseeLog.log(Activator.class, Level.FINE, toExecute); + ConnectionHandler.runPreparedUpdate(connection, toExecute); + } + } + +} |