protected final String queryTableName(Query query, TableNameConverter converter) { final String queryTable = query.getTable(); final String tableName = queryTable != null ? queryTable : converter.getName(query.getTableType()); final StringBuilder queryTableName = new StringBuilder().append(withSchema(tableName)); if (query.getAlias(query.getTableType()) != null) { queryTableName.append(" ").append(query.getAlias(query.getTableType())); } return queryTableName.toString(); }
protected final String queryTableName(Query query, TableNameConverter converter) { final String queryTable = query.getTable(); final String tableName = queryTable != null ? queryTable : converter.getName(query.getTableType()); final StringBuilder queryTableName = new StringBuilder().append(withSchema(tableName)); if (query.getAlias(query.getTableType()) != null) { queryTableName.append(" ").append(query.getAlias(query.getTableType())); } return queryTableName.toString(); }
private String withAlias(Query query, String field, final TableNameConverter converter) { final StringBuilder withAlias = new StringBuilder(); if (query.getAlias(query.getTableType()) != null) { withAlias.append(query.getAlias(query.getTableType())).append("."); } else if (!query.getJoins().isEmpty()) { String queryTable = query.getTable(); String tableName = queryTable != null ? queryTable : converter.getName(query.getTableType()); withAlias.append(processID(tableName)).append("."); } return withAlias.append(processID(field)).toString(); }
private String withAlias(Query query, String field, final TableNameConverter converter) { final StringBuilder withAlias = new StringBuilder(); if (query.getAlias(query.getTableType()) != null) { withAlias.append(query.getAlias(query.getTableType())).append("."); } else if (!query.getJoins().isEmpty()) { String queryTable = query.getTable(); String tableName = queryTable != null ? queryTable : converter.getName(query.getTableType()); withAlias.append(processID(tableName)).append("."); } return withAlias.append(processID(field)).toString(); }
tableName = converter.getName(query.getTableType());
@Override protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) { StringBuilder sql = new StringBuilder(); String tableName = query.getTable(); if (tableName == null) { tableName = converter.getName(query.getTableType()); } switch (query.getType()) { case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT "); } int limit = query.getLimit(); if (limit >= 0) { if (query.getOffset() > 0) { limit += query.getOffset(); } sql.append("TOP ").append(limit).append(' '); } if (count) { sql.append("COUNT(*)"); } else { sql.append(querySelectFields(query, converter)); } sql.append(" FROM ").append(queryTableName(query, converter)); break; } return sql.toString(); }
tableName = converter.getName(query.getTableType());
@Override protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) { StringBuilder sql = new StringBuilder(); String tableName = query.getTable(); if (tableName == null) { tableName = converter.getName(query.getTableType()); } switch (query.getType()) { case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT "); } int limit = query.getLimit(); if (limit >= 0) { if (query.getOffset() > 0) { limit += query.getOffset(); } sql.append("TOP ").append(limit).append(' '); } if (count) { sql.append("COUNT(*)"); } else { sql.append(querySelectFields(query, converter)); } sql.append(" FROM ").append(queryTableName(query, converter)); break; } return sql.toString(); }