private String generateSaveQuery(boolean ignoreGenerators) { final StringBuilder builder = new StringBuilder("INSERT INTO "); builder.append(classMapper.getTableMap().getTableNameWithSchema()); builder.append(" ("); builder.append( columnToCommaSepareted( getColumnNames(classMapper , "", classMapper.getAllColumnJavaNames()), ignoreGenerators )); builder.append(") VALUES ("); builder.append( questionCommaSepareted( classMapper, getColumnNames(classMapper , "", classMapper.getAllColumnJavaNames()), ignoreGenerators )); builder.append(")"); final String query = builder.toString(); logger.info("generateSaveQuery", "Generated INSERT query (with generators? " + !ignoreGenerators + ") for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query ); return query; }
private String generateBaseSelectClause() { return columnToCommaSepareted( getColumnNames(classMapper , ICrudConstants.ROW_NAME_PREFIX_PLACEHOLDER, classMapper.getAllColumnJavaNames()), true ); }
private String generateDeleteQuery() { final StringBuilder builder = new StringBuilder("DELETE FROM "); builder.append(classMapper.getTableMap().getTableNameWithSchema()); if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) { builder.append(" WHERE "); builder.append( columnToWhereClause( getColumnNames(classMapper, "", classMapper.getPrimaryKeyColumnJavaNames()) )); } final String query = builder.toString(); logger.info("generateDeleteQuery", "Generated DELETE query for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query ); return query; }
private String generateLoadQuery() { final StringBuilder builder = new StringBuilder("SELECT * FROM "); builder.append(classMapper.getTableMap().getTableNameWithSchema()); if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) { builder.append(" WHERE "); builder.append( columnToWhereClause( getColumnNames(classMapper, "", classMapper.getPrimaryKeyColumnJavaNames()) )); } final String query = builder.toString(); logger.info("generateLoadQuery", "Generated SELECT query for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query ); return query; }
private String generateUpdateQuery() { final StringBuilder builder = new StringBuilder("UPDATE "); builder.append(classMapper.getTableMap().getTableNameWithSchema()); builder.append(" SET "); if ( classMapper.getNotPrimaryKeyColumnJavaNames().length>0 ) { builder.append( columnToSetClause( getColumnNames(classMapper, "", classMapper.getNotPrimaryKeyColumnJavaNames()) )); } if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) { builder.append(" WHERE "); builder.append( columnToWhereClause( getColumnNames(classMapper, "", classMapper.getPrimaryKeyColumnJavaNames()) )); } final String query = builder.toString(); logger.info("generateUpdateQuery", "Generated UPDATE query for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query ); return query; }
private String generateBeanVersionQuery() { String query = ""; final ITableMap<T> tableMap = classMapper.getTableMap(); if (tableMap.isVersionable()) { final StringBuilder builder = new StringBuilder("SELECT count(*) FROM "); builder.append(classMapper.getTableMap().getTableNameWithSchema()); if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) { builder.append(" WHERE "); final String[] pk = classMapper.getPrimaryKeyColumnJavaNames(); final String[] pkAndVersion = new String[ pk.length + 1 ]; for (int i=0 ; i<(pk.length); i++) { pkAndVersion[i] = pk[i]; } pkAndVersion[pkAndVersion.length-1] = tableMap.getVersionJavaFieldName() ; builder.append( columnToWhereClause( getColumnNames(classMapper, "", pkAndVersion ) )); } builder.append( tableMap.getVersionLoadLockMode().getLockMode() ); query = builder.toString(); } logger.info("generateBeanVersionQuery", "Generated query to load the version of a record for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query ); return query; }