diff options
Diffstat (limited to 'tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator')
4 files changed, 0 insertions, 537 deletions
diff --git a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/BaseGenerator.java b/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/BaseGenerator.java deleted file mode 100644 index 05d97723a7..0000000000 --- a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/BaseGenerator.java +++ /dev/null @@ -1,36 +0,0 @@ -/* - * 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.tuscany.das.rdb.generator.impl; - -import org.apache.tuscany.das.rdb.Converter; - -public class BaseGenerator { - - protected Converter getConverter(String converter) { - if (converter != null) { - try { - return (Converter) Thread.currentThread().getContextClassLoader().loadClass(converter).newInstance(); - } catch (Exception ex) { - throw new RuntimeException(ex); - } - } - return null; - } - -} diff --git a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/DeleteGenerator.java b/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/DeleteGenerator.java deleted file mode 100644 index ad2a90c841..0000000000 --- a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/DeleteGenerator.java +++ /dev/null @@ -1,91 +0,0 @@ -/* - * 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.tuscany.das.rdb.generator.impl; - -import java.util.Iterator; - -import org.apache.log4j.Logger; -import org.apache.tuscany.das.rdb.config.Table; -import org.apache.tuscany.das.rdb.config.wrapper.MappingWrapper; -import org.apache.tuscany.das.rdb.config.wrapper.TableWrapper; -import org.apache.tuscany.das.rdb.impl.DeleteCommandImpl; -import org.apache.tuscany.das.rdb.impl.ParameterExtendedImpl; -import org.apache.tuscany.das.rdb.impl.SDODataTypeHelper; -import org.apache.tuscany.das.rdb.impl.SDODataTypes; - -public final class DeleteGenerator extends BaseGenerator { - - public static final DeleteGenerator INSTANCE = new DeleteGenerator(); - - private final Logger logger = Logger.getLogger(DeleteGenerator.class); - - private DeleteGenerator() { - super(); - } - - //JIRA-952 - private String getDeleteStatement(MappingWrapper mapping, Table t) { - TableWrapper table = new TableWrapper(t); - - StringBuffer statement = new StringBuffer(); - statement.append("delete from "); - if(mapping.getConfig().isDatabaseSchemaNameSupported()){ - statement.append(t.getSchemaName()+"."+t.getTableName()); - } - else{ - statement.append(t.getTableName()); - } - statement.append(" where "); - - Iterator names = table.getPrimaryKeyNames().iterator(); - Iterator properties = table.getPrimaryKeyProperties().iterator(); - while (names.hasNext() && properties.hasNext()) { - String name = (String) names.next(); - statement.append(name); - statement.append(" = ?"); - if (names.hasNext() && properties.hasNext()) { - statement.append(" and "); - } - } - - if (this.logger.isDebugEnabled()) { - this.logger.debug(statement.toString()); - } - - return statement.toString(); - } - - public DeleteCommandImpl getDeleteCommand(MappingWrapper mapping, Table t) { - TableWrapper tw = new TableWrapper(t); - DeleteCommandImpl deleteCommand = new DeleteCommandImpl(getDeleteStatement(mapping, t)); - - Iterator i = tw.getPrimaryKeyProperties().iterator(); - for (int idx = 1; i.hasNext(); idx++) { - String property = (String) i.next(); - ParameterExtendedImpl p = new ParameterExtendedImpl(); - p.setName(property); - p.setColumnType(SDODataTypeHelper.columnTypeForSDOType(SDODataTypes.OBJECT)); - p.setConverter(getConverter(tw.getConverter(property))); - p.setIndex(idx); - deleteCommand.addParameter(p); - } - return deleteCommand; - } - -} diff --git a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/InsertGenerator.java b/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/InsertGenerator.java deleted file mode 100644 index d174629ad9..0000000000 --- a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/InsertGenerator.java +++ /dev/null @@ -1,182 +0,0 @@ -/* - * 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.tuscany.das.rdb.generator.impl; - -import java.util.ArrayList; -import java.util.HashSet; -import java.util.Iterator; -import java.util.List; - -import org.apache.log4j.Logger; -import org.apache.tuscany.das.rdb.config.Column; -import org.apache.tuscany.das.rdb.config.Relationship; -import org.apache.tuscany.das.rdb.config.Table; -import org.apache.tuscany.das.rdb.config.wrapper.MappingWrapper; -import org.apache.tuscany.das.rdb.config.wrapper.RelationshipWrapper; -import org.apache.tuscany.das.rdb.config.wrapper.TableWrapper; -import org.apache.tuscany.das.rdb.impl.InsertCommandImpl; -import org.apache.tuscany.das.rdb.impl.ParameterExtendedImpl; -import org.apache.tuscany.das.rdb.impl.SDODataTypeHelper; -import org.apache.tuscany.das.rdb.util.CollectionsUtil; - -import commonj.sdo.DataObject; -import commonj.sdo.Property; - -public final class InsertGenerator extends BaseGenerator { - - public static final InsertGenerator INSTANCE = new InsertGenerator(); - - private final Logger logger = Logger.getLogger(InsertGenerator.class); - - private InsertGenerator() { - super(); - } - - public InsertCommandImpl getInsertCommand(MappingWrapper config, DataObject changedObject, Table t) { - List parameters = new ArrayList(); - TableWrapper table = new TableWrapper(t); - StringBuffer statement = new StringBuffer("insert into "); - //JIRA-952 - if(config.getConfig().isDatabaseSchemaNameSupported()){ - statement.append(t.getSchemaName()+"."+t.getTableName()); - } - else{ - statement.append(t.getTableName()); - } - HashSet changedProperties = getAttributeProperties(changedObject, config, table); - Iterator i; - if ( changedProperties.isEmpty() ) { - i = changedObject.getType().getProperties().iterator(); - } else { - i = changedProperties.iterator(); - } - - List attributes = new ArrayList(); - List generatedKeys = new ArrayList(); - while (i.hasNext()) { - Property attr = (Property) i.next(); - if ( attr.getType().isDataType()) { - if (table.isGeneratedColumnProperty(attr.getName())) { - generatedKeys.add(attr.getName()); - } else { - attributes.add(attr.getName()); - parameters.add(changedObject.getType().getProperty(attr.getName())); - } - } - } - - statement.append("("); - Iterator attrs = attributes.iterator(); - while (attrs.hasNext()) { - String name = (String) attrs.next(); - statement.append(""); - Column c = config.getColumnByPropertyName(t, name); - statement.append(c == null ? name : c.getColumnName()); - if (attrs.hasNext()) { - statement.append(", "); - } else { - statement.append(")"); - } - } - - statement.append(" values ("); - for (int idx = 1; idx <= attributes.size(); idx++) { - statement.append('?'); - if (idx < attributes.size()) { - statement.append(", "); - } else { - statement.append(")"); - } - } - - InsertCommandImpl cmd = new InsertCommandImpl(statement.toString(), - (String[]) generatedKeys.toArray(new String[0])); - Iterator params = parameters.iterator(); - for (int idx = 1; params.hasNext(); idx++) { - Property property = (Property) params.next(); - ParameterExtendedImpl p = new ParameterExtendedImpl(); - p.setName(property.getName()); - p.setType(property.getType()); - p.setColumnType(SDODataTypeHelper.columnTypeForSDOType(property.getType())); - p.setConverter(getConverter(table.getConverter(property.getName()))); - p.setIndex(idx); - cmd.addParameter(p); - - } - if (this.logger.isDebugEnabled()) { - this.logger.debug(statement.toString()); - } - - return cmd; - - } - - private HashSet getAttributeProperties(DataObject obj, MappingWrapper config, TableWrapper tw) { - HashSet fields = new HashSet(); - Iterator i = obj.getType().getProperties().iterator(); - while (i.hasNext()) { - Property p = (Property) i.next(); - if (p.getType().isDataType()) { - if (obj.isSet(p)) { - if (fields.add(p) == false) { - throw new RuntimeException("Foreign key properties should not be set when the corrsponding relationship has changed"); - } - } - } else { - if (obj.isSet(p)) { - Relationship relationship = config.getRelationshipByReference(p); - if ((p.getOpposite() != null && p.getOpposite().isMany()) - || (hasState(tw, relationship, obj))) { - RelationshipWrapper r = new RelationshipWrapper(relationship); - Iterator keys = r.getForeignKeys().iterator(); - while (keys.hasNext()) { - String key = (String) keys.next(); - String keyProperty = config.getColumnPropertyName(tw.getTableName(), key); - Property keyProp = obj.getType().getProperty(keyProperty); - if ( keyProp == null ) - throw new RuntimeException("Invalid foreign key column: " + key); - if (fields.add(keyProp) == false) { - throw new RuntimeException("Foreign key properties should not be set when the corresponding relationship has changed"); - } - } - } - - } - } - } - - return fields; - - } - - private boolean hasState(TableWrapper tw, Relationship rel, DataObject changedObject) { - - if (!rel.isMany()) { - - RelationshipWrapper rw = new RelationshipWrapper(rel); - if ((rel.getForeignKeyTable().equals(tw.getTableName())) - && (CollectionsUtil.disjoint(tw.getPrimaryKeyProperties(), rw.getForeignKeys()))) { - return true; - } - } - - return false; - } - -} diff --git a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/UpdateGenerator.java b/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/UpdateGenerator.java deleted file mode 100644 index 9d2a405dc6..0000000000 --- a/tags/java/das/1.0-incubating-beta2/rdb/src/main/java/org/apache/tuscany/das/rdb/generator/impl/UpdateGenerator.java +++ /dev/null @@ -1,228 +0,0 @@ -/* - * 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.tuscany.das.rdb.generator.impl; - -import java.util.ArrayList; -import java.util.HashSet; -import java.util.Iterator; -import java.util.List; - -import org.apache.log4j.Logger; -import org.apache.tuscany.das.rdb.config.Column; -import org.apache.tuscany.das.rdb.config.Table; -import org.apache.tuscany.das.rdb.config.wrapper.MappingWrapper; -import org.apache.tuscany.das.rdb.config.wrapper.RelationshipWrapper; -import org.apache.tuscany.das.rdb.config.wrapper.TableWrapper; -import org.apache.tuscany.das.rdb.impl.CollisionParameter; -import org.apache.tuscany.das.rdb.impl.ManagedParameterImpl; -import org.apache.tuscany.das.rdb.impl.OptimisticWriteCommandImpl; -import org.apache.tuscany.das.rdb.impl.ParameterExtendedImpl; -import org.apache.tuscany.das.rdb.impl.SDODataTypeHelper; -import org.apache.tuscany.das.rdb.impl.UpdateCommandImpl; - -import commonj.sdo.ChangeSummary; -import commonj.sdo.DataObject; -import commonj.sdo.Property; -import commonj.sdo.Type; -import commonj.sdo.ChangeSummary.Setting; - -public final class UpdateGenerator extends BaseGenerator { - - public static final UpdateGenerator INSTANCE = new UpdateGenerator(); - - private final Logger logger = Logger.getLogger(UpdateGenerator.class); - - private UpdateGenerator() { - super(); - } - - public UpdateCommandImpl getUpdateCommand(MappingWrapper mapping, DataObject changedObject, Table table) { - List parameters = new ArrayList(); - Type type = changedObject.getType(); - TableWrapper tableWrapper = new TableWrapper(table); - StringBuffer statement = new StringBuffer("update "); - if(mapping.getConfig().isDatabaseSchemaNameSupported()){ - statement.append(table.getSchemaName()+"."+table.getTableName()); - } - else{ - statement.append(table.getTableName()); - } - statement.append(" set "); - - ChangeSummary summary = changedObject.getDataGraph().getChangeSummary(); - HashSet changedFields = getChangedFields(mapping, summary, changedObject, tableWrapper); - Iterator i = changedFields.iterator(); - - int idx = 1; - while (i.hasNext()) { - Property property = (Property) i.next(); - Column c = tableWrapper.getColumnByPropertyName(property.getName()); - - if ((c == null) || !c.isCollision() || !c.isPrimaryKey()) { - String columnName = c == null ? property.getName() : c.getColumnName(); - appendFieldSet(statement, idx > 1, columnName); - parameters.add(createParameter(tableWrapper, property, idx++)); - } - } - - Column c = tableWrapper.getManagedColumn(); - if (c != null) { - appendFieldSet(statement, idx > 1, c.getColumnName()); - String propertyName = c.getPropertyName() == null ? c.getColumnName() : c.getPropertyName(); - parameters.add(createManagedParameter(tableWrapper, - changedObject.getInstanceProperty(propertyName), idx++)); - } - - statement.append(" where "); - - Iterator pkColumnNames = tableWrapper.getPrimaryKeyNames().iterator(); - Iterator pkPropertyNames = tableWrapper.getPrimaryKeyProperties().iterator(); - while (pkColumnNames.hasNext() && pkPropertyNames.hasNext()) { - String columnName = (String) pkColumnNames.next(); - String propertyName = (String) pkPropertyNames.next(); - statement.append(columnName); - statement.append(" = ?"); - if (pkColumnNames.hasNext() && pkPropertyNames.hasNext()) { - statement.append(" and "); - } - parameters.add(createParameter(tableWrapper, type.getProperty(propertyName), idx++)); - } - - if (tableWrapper.getCollisionColumn() == null) { - Iterator iter = changedFields.iterator(); - while (iter.hasNext()) { - statement.append(" and "); - Property changedProperty = (Property) iter.next(); - Column column = tableWrapper.getColumnByPropertyName(changedProperty.getName()); - statement.append(column == null ? changedProperty.getName() : column.getColumnName()); - - Object value; - Setting setting = summary.getOldValue(changedObject, changedProperty); - // Setting is null if this is a relationship change - if (setting == null) { - value = changedObject.get(changedProperty); - } else { - value = setting.getValue(); - } - - if (value == null) { - statement.append(" is null"); - } else { - ParameterExtendedImpl param = createCollisionParameter(tableWrapper, changedProperty, idx++); - statement.append(" = ?"); - param.setValue(value); - parameters.add(param); - } - - - } - - } else { - statement.append(" and "); - statement.append(tableWrapper.getCollisionColumn().getColumnName()); - statement.append(" = ?"); - parameters.add(createParameter(tableWrapper, - type.getProperty(tableWrapper.getCollisionColumnPropertyName()), idx++)); - } - - UpdateCommandImpl updateCommand = new OptimisticWriteCommandImpl(statement.toString()); - - Iterator params = parameters.iterator(); - while (params.hasNext()) { - updateCommand.addParameter((ParameterExtendedImpl) params.next()); - } - - if (this.logger.isDebugEnabled()) { - this.logger.debug(statement.toString()); - } - - return updateCommand; - } - - - - private void appendFieldSet(StringBuffer statement, boolean appendComma, String columnName) { - if (appendComma) { - statement.append(", "); - } - statement.append(columnName); - statement.append(" = ?"); - } - - - - private HashSet getChangedFields(MappingWrapper config, ChangeSummary summary, DataObject obj, TableWrapper tw) { - HashSet changes = new HashSet(); - - Iterator i = summary.getOldValues(obj).iterator(); - while (i.hasNext()) { - ChangeSummary.Setting setting = (ChangeSummary.Setting) i.next(); - - if (setting.getProperty().getType().isDataType()) { - if ( changes.add(setting.getProperty()) == false ) { - throw new RuntimeException("Foreign key properties should not be set when the corresponding relationship has changed"); - } - } else { - Property ref = setting.getProperty(); - if (!ref.isMany()) { - RelationshipWrapper r = new RelationshipWrapper(config.getRelationshipByReference(ref)); - - Iterator keys = r.getForeignKeys().iterator(); - while (keys.hasNext()) { - String key = (String) keys.next(); - String keyProperty = config.getColumnPropertyName(tw.getTableName(), key); - Property keyProp = obj.getType().getProperty(keyProperty); - if ( keyProp == null ) - throw new RuntimeException("Invalid foreign key column: " + key); - if (changes.add(keyProp) == false) { - throw new RuntimeException("Foreign key properties should not be set when the corresponding relationship has changed"); - } - } - } - - } - } - return changes; - } - - private ParameterExtendedImpl fillExtendedParameter(ParameterExtendedImpl param, TableWrapper table, Property property, int idx) { - param.setName(property.getName()); - param.setType(property.getType()); - param.setConverter(getConverter(table.getConverter(property.getName()))); - if (idx != -1) { - param.setIndex(idx); - } - param.setColumnType(SDODataTypeHelper.columnTypeForSDOType(property.getType())); - return param; - } - private ParameterExtendedImpl createCollisionParameter(TableWrapper tableWrapper, Property property, int i) { - ParameterExtendedImpl param = new CollisionParameter(); - return fillExtendedParameter(param, tableWrapper, property, i); - } - - private ParameterExtendedImpl createManagedParameter(TableWrapper table, Property property, int idx) { - ParameterExtendedImpl param = new ManagedParameterImpl(); - return fillExtendedParameter(param, table, property, idx); - } - - private ParameterExtendedImpl createParameter(TableWrapper table, Property property, int idx) { - ParameterExtendedImpl param = new ParameterExtendedImpl(); - return fillExtendedParameter(param, table, property, idx); - } -} |