private SQLAction renderTrigger(NameConverters nameConverters, DDLTable table, DDLField field) { StringBuilder back = new StringBuilder(); back.append("CREATE TRIGGER ").append(withSchema(nameConverters.getTriggerNameConverter().autoIncrementName(table.getName(), field.getName())) + '\n'); back.append("BEFORE INSERT\n").append(" ON ").append(withSchema(table.getName())).append(" FOR EACH ROW\n"); back.append("BEGIN\n"); back.append(" SELECT ").append(withSchema(nameConverters.getSequenceNameConverter().getName(shorten(table.getName()), shorten(field.getName()))) + ".NEXTVAL"); back.append(" INTO :NEW.").append(processID(field.getName())).append(" FROM DUAL;\nEND;"); return SQLAction.of(back); }
private SQLAction renderTrigger(NameConverters nameConverters, DDLTable table, DDLField field) { StringBuilder back = new StringBuilder(); back.append("CREATE TRIGGER ").append(withSchema(nameConverters.getTriggerNameConverter().autoIncrementName(table.getName(), field.getName())) + '\n'); back.append("BEFORE INSERT\n").append(" ON ").append(withSchema(table.getName())).append(" FOR EACH ROW\n"); back.append("BEGIN\n"); back.append(" SELECT ").append(withSchema(nameConverters.getSequenceNameConverter().getName(shorten(table.getName()), shorten(field.getName()))) + ".NEXTVAL"); back.append(" INTO :NEW.").append(processID(field.getName())).append(" FROM DUAL;\nEND;"); return SQLAction.of(back); }
/** * Renders SQL statement(s) to drop the trigger which corresponds to the * specified field, or <code>null</code> if none. * * @param nameConverters * @param table The table containing the field for which a trigger * may need to be rendered. * @param field The field for which the trigger should be rendered, * if any. @return A database-specific DDL statement to drop a trigger for * the field in question, or <code>null</code>. */ protected SQLAction _renderDropTriggerForField(NameConverters nameConverters, DDLTable table, DDLField field) { final String trigger = _getTriggerNameForField(nameConverters.getTriggerNameConverter(), table, field); if (trigger != null) { return SQLAction.of("DROP TRIGGER " + processID(trigger)); } return null; }
/** * Renders SQL statement(s) to drop the trigger which corresponds to the * specified field, or <code>null</code> if none. * * @param nameConverters * @param table The table containing the field for which a trigger * may need to be rendered. * @param field The field for which the trigger should be rendered, * if any. @return A database-specific DDL statement to drop a trigger for * the field in question, or <code>null</code>. */ protected SQLAction _renderDropTriggerForField(NameConverters nameConverters, DDLTable table, DDLField field) { final String trigger = _getTriggerNameForField(nameConverters.getTriggerNameConverter(), table, field); if (trigger != null) { return SQLAction.of("DROP TRIGGER " + processID(trigger)); } return null; }
/** * Renders SQL statement(s) to drop the function which corresponds to the * specified field, if applicable, or <code>null</code> otherwise. * * @param nameConverters * @param table The table containing the field for which a function * may need to be rendered. * @param field The field for which the function should be rendered, * if any. * @return A database-specific DDL statement to drop a function for * the field in question, or <code>null</code>. */ protected SQLAction _renderDropFunctionForField(NameConverters nameConverters, DDLTable table, DDLField field) { final String functionName = _getFunctionNameForField(nameConverters.getTriggerNameConverter(), table, field); if (functionName != null) { return SQLAction.of("DROP FUNCTION " + processID(functionName)); } return null; }
/** * Renders SQL statement(s) to drop the function which corresponds to the * specified field, if applicable, or <code>null</code> otherwise. * * @param nameConverters * @param table The table containing the field for which a function * may need to be rendered. * @param field The field for which the function should be rendered, * if any. * @return A database-specific DDL statement to drop a function for * the field in question, or <code>null</code>. */ protected SQLAction _renderDropFunctionForField(NameConverters nameConverters, DDLTable table, DDLField field) { final String functionName = _getFunctionNameForField(nameConverters.getTriggerNameConverter(), table, field); if (functionName != null) { return SQLAction.of("DROP FUNCTION " + processID(functionName)); } return null; }
public CachingNameConverters(NameConverters nameConverters) { Objects.requireNonNull(nameConverters, "nameConverters can't be null"); this.tableNameConverter = new CachingTableNameConverter(nameConverters.getTableNameConverter()); this.fieldNameConverter = nameConverters.getFieldNameConverter(); this.sequenceNameConverter = nameConverters.getSequenceNameConverter(); this.triggerNameConverter = nameConverters.getTriggerNameConverter(); this.indexNameConverter = nameConverters.getIndexNameConverter(); this.uniqueNameConverter = nameConverters.getUniqueNameConverter(); }
public CachingNameConverters(NameConverters nameConverters) { Objects.requireNonNull(nameConverters, "nameConverters can't be null"); this.tableNameConverter = new CachingTableNameConverter(nameConverters.getTableNameConverter()); this.fieldNameConverter = nameConverters.getFieldNameConverter(); this.sequenceNameConverter = nameConverters.getSequenceNameConverter(); this.triggerNameConverter = nameConverters.getTriggerNameConverter(); this.indexNameConverter = nameConverters.getIndexNameConverter(); this.uniqueNameConverter = nameConverters.getUniqueNameConverter(); }
private SQLAction renderDropTrigger(NameConverters nameConverters, DDLTable table, DDLField field) { return SQLAction.of("DROP TRIGGER " + withSchema(nameConverters.getTriggerNameConverter().autoIncrementName(table.getName(), field.getName()))); }
private SQLAction renderDropTrigger(NameConverters nameConverters, DDLTable table, DDLField field) { return SQLAction.of("DROP TRIGGER " + withSchema(nameConverters.getTriggerNameConverter().autoIncrementName(table.getName(), field.getName()))); }