@Override public String getFullQuotedName() { return dialect.openQuote() + subQueryAlias + dialect.closeQuote() + '.' + getQuotedName(); } }
@Override public String getQuotedName() { return dialect.openQuote() + alias + dialect.closeQuote(); }
@Override public ArraySubQuery getArraySubQuery(Column arrayColumn, String subQueryAlias) { return new ArraySubQueryPostgreSQL(arrayColumn, subQueryAlias); }
public String getForeignKeyConstraintName(String tableName, String foreignColumnName, String foreignTableName) { return makeName(tableName + '_', foreignColumnName + '_' + foreignTableName, "_FK", getMaxNameSize()); }
public static JDBCInfo jdbcInfo(String string, int jdbcType, String jdbcBaseTypeString, int jdbcBaseType) { return new JDBCInfo(string, jdbcType, jdbcBaseTypeString, jdbcBaseType); }
@Override public String getArrayIlikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable) { return getArrayOpSql(arrayColumn, refName, positive, dataHierTable, "ILIKE"); }
/** * Returns the SQL to soft-delete several rows. The array of ids and the time are free parameters. * * @return the SQL statement */ public String getSoftDeleteSql() { return dialect.getSoftDeleteSql(); }
/** * Returns the SQL to clean (hard-delete) soft-deleted rows. The max and beforeTime are free parameters. * * @return the SQL statement */ public String getSoftDeleteCleanupSql() { return dialect.getSoftDeleteCleanupSql(); }
public Timestamp[] getTimestampFromCalendar(Serializable[] value) { if (value == null) { return null; } Timestamp[] ts = new Timestamp[value.length]; for (int i = 0; i < value.length; i++) { ts[i] = getTimestampFromCalendar((Calendar) value[i]); } return ts; }
/** * The dialect need an extra SQL statement to populate a user read acl cache before running the query. * * @since 5.5 */ public boolean needsPrepareUserReadAcls() { return supportsReadAcl(); }
public Calendar[] getCalendarFromTimestamp(Timestamp[] value) { if (value == null) { return null; } Calendar[] cal = new GregorianCalendar[value.length]; for (int i = 0; i < value.length; i++) { cal[i] = getCalendarFromTimestamp(value[i]); } return cal; }
@Override public String getDateCast() { if (majorVersion <= 9) { // SQL Server 2005 doesn't have a DATE type. At all. Sigh. // Style 112 is YYYYMMDD return "CONVERT(DATETIME, CONVERT(VARCHAR, %s, 112), 112)"; } return super.getDateCast(); }
public int getMaximumArgsForIn() { return dialect.getMaximumArgsForIn(); }
@Override public String getQuotedSuffixedName(String suffix) { return dialect.openQuote() + alias + suffix + dialect.closeQuote(); }
public String getTableName(String name) { return makeName(name, getMaxNameSize()); }
public static JDBCInfo jdbcInfo(String string, int jdbcType) { return new JDBCInfo(string, jdbcType); }
@Override public String getArrayLikeSql(Column arrayColumn, String refName, boolean positive, Table dataHierTable) { return getArrayOpSql(arrayColumn, refName, positive, dataHierTable, "LIKE"); }
public String getTable(Dialect dialect) { if (tableAlias == null) { return table; } else { return table + " " + dialect.openQuote() + tableAlias + dialect.closeQuote(); } }
@Override public String getQuotedName() { return dialect.openQuote() + name + dialect.closeQuote(); }
@Override public String getQuotedSuffixedName(String suffix) { return dialect.openQuote() + name + suffix + dialect.closeQuote(); }