private String generateDelete(String tableName, String[] columnNames, String idSubselect, String comment) { final Delete delete = new Delete() .setTableName( tableName ) .setWhere( "(" + String.join( ", ", columnNames ) + ") IN (" + idSubselect + ")" ); if ( factory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( comment ); } return delete.toStatementString(); }
public Delete addPrimaryKeyColumns(String[] columnNames) { for ( String columnName : columnNames ) { addPrimaryKeyColumn( columnName, "?" ); } return this; }
public Delete setPrimaryKeyColumnNames(String[] columnNames) { this.primaryKeyColumns.clear(); addPrimaryKeyColumns(columnNames); return this; }
/** * Generate the SQL that deletes a row by id (and version) */ protected String generateDeleteString(int j) { Delete delete = new Delete() .setTableName( getTableName( j ) ) .setPrimaryKeyColumnNames( getKeyColumns( j ) ); if ( j == 0 ) { delete.setVersionColumnName( getVersionColumnName() ); } if ( getFactory().getSettings().isCommentsEnabled() ) { delete.setComment( "delete " + getEntityName() ); } return delete.toStatementString(); }
idSubselect, "bulk delete - m2m join table cleanup" ).toStatementString() ); deletes.add( generateDelete( tableNames[i], columnNames[i], idSubselect, "bulk delete" ).toStatementString() );
String[] deleteStrings = new String[span]; for ( int j = span - 1; j >= 0; j-- ) { Delete delete = new Delete() .setTableName( getTableName( j ) ) .setPrimaryKeyColumnNames( getKeyColumns( j ) );
private String generateDelete( String tableName, String[] columnNames, String idSubselect, String comment) { final Delete delete = new Delete().setTableName( tableName ).setWhere( "(" + String.join( ", ", (CharSequence[]) columnNames ) + ") in (" + idSubselect + ")" ); if ( factory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( comment ); } return delete.toStatementString(); }
public Delete addPrimaryKeyColumns(String[] columnNames, boolean[] includeColumns, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { if( includeColumns[i] ) { addPrimaryKeyColumn( columnNames[i], valueExpressions[i] ); } } return this; }
public Delete setPrimaryKeyColumnNames(String[] columnNames) { this.primaryKeyColumns.clear(); addPrimaryKeyColumns(columnNames); return this; }
/** * Generate the SQL DELETE that deletes all rows */ @Override protected String generateDeleteString() { final Delete delete = new Delete() .setTableName( qualifiedTableName ) .addPrimaryKeyColumns( keyColumnNames ); if ( hasWhere ) { delete.setWhere( sqlWhereString ); } if ( getFactory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( "delete collection " + getRole() ); } return delete.toStatementString(); }
public Delete addPrimaryKeyColumns(String[] columnNames, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { addPrimaryKeyColumn( columnNames[i], valueExpressions[i] ); } return this; }
public Delete setPrimaryKeyColumnNames(String[] columnNames) { this.primaryKeyColumns.clear(); addPrimaryKeyColumns(columnNames); return this; }
protected Delete generateDelete( String tableName, String[] columnNames, String idSubselect, String comment) { final Delete delete = new Delete() .setTableName( tableName ) .setWhere(idSubselect); if ( factory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( comment ); } return delete; } }
public Delete addPrimaryKeyColumns(String[] columnNames) { for ( int i=0; i<columnNames.length; i++ ) { addPrimaryKeyColumn( columnNames[i], "?" ); } return this; }
public Delete setPrimaryKeyColumnNames(String[] columnNames) { this.primaryKeyColumns.clear(); addPrimaryKeyColumns(columnNames); return this; }
protected Delete generateDelete( String tableName, String[] columnNames, String idSubselect, String comment) { final Delete delete = new Delete().setTableName( tableName ).setWhere( "(" + String.join( ", ", (CharSequence[]) columnNames ) + ") in (" + idSubselect + ")" ); if ( factory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( comment ); } return delete; } }
public Delete addPrimaryKeyColumns(String[] columnNames, boolean[] includeColumns, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { if( includeColumns[i] ) addPrimaryKeyColumn( columnNames[i], valueExpressions[i] ); } return this; }
/** * Generate the SQL DELETE that deletes a particular row */ @Override protected String generateDeleteRowString() { final Delete delete = new Delete().setTableName( qualifiedTableName ); if ( hasIdentifier ) { delete.addPrimaryKeyColumns( new String[] {identifierColumnName} ); } else if ( hasIndex && !indexContainsFormula ) { delete.addPrimaryKeyColumns( ArrayHelper.join( keyColumnNames, indexColumnNames ) ); } else { delete.addPrimaryKeyColumns( keyColumnNames ); delete.addPrimaryKeyColumns( elementColumnNames, elementColumnIsInPrimaryKey, elementColumnWriters ); } if ( getFactory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( "delete collection row " + getRole() ); } return delete.toStatementString(); }
public Delete addPrimaryKeyColumns(String[] columnNames, boolean[] includeColumns, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { if( includeColumns[i] ) addPrimaryKeyColumn( columnNames[i], valueExpressions[i] ); } return this; }
/** * Generate the SQL that deletes a row by id (and version) */ protected String generateDeleteString(int j) { final Delete delete = new Delete() .setTableName( getTableName( j ) ) .addPrimaryKeyColumns( getKeyColumns( j ) ); if ( j == 0 ) { delete.setVersionColumnName( getVersionColumnName() ); } if ( getFactory().getSessionFactoryOptions().isCommentsEnabled() ) { delete.setComment( "delete " + getEntityName() ); } return delete.toStatementString(); }