protected void addFilterWhereClause(StringBuilder clause, List<ColumnAndValue> params) { if (staticFilters.length == 0) { return; } for (SQLStaticFilter filter : staticFilters) { if (clause.length() > 0) { clause.append(" AND "); } Column column = filter.getDirectoryColumn(table, getDirectory().useNativeCase()); clause.append(column.getQuotedName()); clause.append(" "); clause.append(filter.getOperator()); clause.append(" ?"); params.add(new ColumnAndValue(column, filter.getValue())); } }
protected String addFilterWhereClause(String whereClause) { if (staticFilters.length == 0) { return whereClause; } if (whereClause != null && whereClause.trim().length() > 0) { whereClause = whereClause + " AND "; } else { whereClause = ""; } for (int i = 0; i < staticFilters.length; i++) { SQLStaticFilter filter = staticFilters[i]; whereClause += filter.getDirectoryColumn(table, getDirectory().useNativeCase()).getQuotedName(); whereClause += " " + filter.getOperator() + " "; whereClause += "? "; if (i < staticFilters.length - 1) { whereClause = whereClause + " AND "; } } return whereClause; }
protected void addFilterValues(PreparedStatement ps, int startIdx) { for (int i = 0; i < staticFilters.length; i++) { SQLStaticFilter filter = staticFilters[i]; setFieldValue(ps, startIdx + i, filter.getDirectoryColumn(table, getDirectory().useNativeCase()), filter.getValue()); } }
table = SQLHelper.addTable(tableName, dialect, useNativeCase()); SchemaManager schemaManager = Framework.getService(SchemaManager.class); schema = schemaManager.getSchema(getSchema()); type = ColumnType.AUTOINC; Column column = SQLHelper.addColumn(table, fieldName, type, useNativeCase()); if (isId) { if (descriptor.isAutoincrementIdField()) {
protected void initialize(Connection connection) { SQLDirectory directory = (SQLDirectory) getSourceDirectory(); Dialect dialect = directory.getDialect(); boolean nativeCase = directory.useNativeCase(); table = SQLHelper.addTable(tableName, dialect, nativeCase); SQLHelper.addColumn(table, sourceColumn, ColumnType.STRING, nativeCase);