Package org.hibernate.sql

Examples of org.hibernate.sql.Delete

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
    for ( int i = tableNames.length - 1; i >= 0; i-- ) {
      // TODO : an optimization here would be to consider cascade deletes and not gen those delete statements;
      //      the difficulty is the ordering of the tables here vs the cascade attributes on the persisters ->
      //          the table info gotten here should really be self-contained (i.e., a class representation
      //          defining all the needed attributes), then we could then get an array of those
      final Delete delete = new Delete()
          .setTableName( tableNames[i] )
          .setWhere( "(" + StringHelper.join( ", ", columnNames[i] ) + ") IN (" + idSubselect + ")" );
      if ( getFactory().getSettings().isCommentsEnabled() ) {
        delete.setComment( "bulk delete" );
      }

      deletes[i] = delete.toStatementString();
    }
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
    for ( int i = tableNames.length - 1; i >= 0; i-- ) {
      // TODO : an optimization here would be to consider cascade deletes and not gen those delete statements;
      //      the difficulty is the ordering of the tables here vs the cascade attributes on the persisters ->
      //          the table info gotten here should really be self-contained (i.e., a class representation
      //          defining all the needed attributes), then we could then get an array of those
      final Delete delete = new Delete()
          .setTableName( tableNames[i] )
          .setWhere( "(" + StringHelper.join( ", ", columnNames[i] ) + ") IN (" + idSubselect + ")" );
      if ( getFactory().getSettings().isCommentsEnabled() ) {
        delete.setComment( "bulk delete" );
      }

      deletes[i] = delete.toStatementString();
    }
  }
View Full Code Here
2555
2556
2557
2558
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
  /**
   * Generate the SQL that deletes a row by id (and version)
   */
  protected String generateDeleteString(int j) {
    Delete delete = new Delete()
        .setTableName( getTableName( j ) )
        .addPrimaryKeyColumns( getKeyColumns( j ) );
    if ( j == 0 ) {
      delete.setVersionColumnName( getVersionColumnName() );
    }
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      delete.setComment( "delete " + getEntityName() );
    }
    return delete.toStatementString();
  }
View Full Code Here
3347
3348
3349
3350
3351
3352
3353
3354
3355
3356
3357
3358
3359
3360
3361
3362
3363
3364
3365
3366
3367
3368
3369
3370
3371
3372
3373
3374
3375
3376
3377
3378
3379
3380
  private String[] generateSQLDeletStrings(Object[] loadedState) {
    int span = getTableSpan();
    String[] deleteStrings = new String[span];
    for ( int j = span - 1; j >= 0; j-- ) {
      Delete delete = new Delete()
          .setTableName( getTableName( j ) )
          .addPrimaryKeyColumns( getKeyColumns( j ) );
      if ( getFactory().getSettings().isCommentsEnabled() ) {
        delete.setComment( "delete " + getEntityName() + " [" + j + "]" );
      }

      boolean[] versionability = getPropertyVersionability();
      Type[] types = getPropertyTypes();
      for ( int i = 0; i < entityMetamodel.getPropertySpan(); i++ ) {
        if ( isPropertyOfTable( i, j ) && versionability[i] ) {
          // this property belongs to the table and it is not specifically
          // excluded from optimistic locking by optimistic-lock="false"
          String[] propertyColumnNames = getPropertyColumnNames( i );
          boolean[] propertyNullness = types[i].toColumnNullness( loadedState[i], getFactory() );
          for ( int k = 0; k < propertyNullness.length; k++ ) {
            if ( propertyNullness[k] ) {
              delete.addWhereFragment( propertyColumnNames[k] + " = ?" );
            }
            else {
              delete.addWhereFragment( propertyColumnNames[k] + " is null" );
            }
          }
        }
      }
      deleteStrings[j] = delete.toStatementString();
    }
    return deleteStrings;
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
   * Generate the SQL DELETE that deletes all rows
   */
  @Override
    protected String generateDeleteString() {
   
    Delete delete = new Delete()
        .setTableName( qualifiedTableName )
        .addPrimaryKeyColumns( keyColumnNames );
   
    if ( hasWhere ) delete.setWhere( sqlWhereString );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      delete.setComment( "delete collection " + getRole() );
    }
   
    return delete.toStatementString();
  }
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
   * Generate the SQL DELETE that deletes a particular row
   */
  @Override
    protected String generateDeleteRowString() {
   
    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().getSettings().isCommentsEnabled() ) {
      delete.setComment( "delete collection row " + getRole() );
    }
   
    return delete.toStatementString();
  }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
   * Generate the SQL DELETE that deletes all rows
   */
  @Override
    protected String generateDeleteString() {
   
    Delete delete = new Delete()
        .setTableName( qualifiedTableName )
        .addPrimaryKeyColumns( keyColumnNames );
   
    if ( hasWhere ) delete.setWhere( sqlWhereString );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      delete.setComment( "delete collection " + getRole() );
    }
   
    return delete.toStatementString();
  }
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
   * Generate the SQL DELETE that deletes a particular row
   */
  @Override
    protected String generateDeleteRowString() {
   
    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().getSettings().isCommentsEnabled() ) {
      delete.setComment( "delete collection row " + getRole() );
    }
   
    return delete.toStatementString();
  }
View Full Code Here
2127
2128
2129
2130
2131
2132
2133
2134
2135
2136
2137
2138
2139
2140
2141
2142
  /**
   * Generate the SQL that deletes a row by id (and version)
   */
  protected String generateDeleteString(int j) {
    Delete delete = new Delete()
        .setTableName( getTableName( j ) )
        .addPrimaryKeyColumns( getKeyColumns( j ) );
    if ( j == 0 ) {
      delete.setVersionColumnName( getVersionColumnName() );
    }
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      delete.setComment( "delete " + getEntityName() );
    }
    return delete.toStatementString();
  }
View Full Code Here
2901
2902
2903
2904
2905
2906
2907
2908
2909
2910
2911
2912
2913
2914
2915
2916
2917
2918
2919
2920
2921
2922
2923
2924
2925
2926
2927
2928
2929
2930
2931
2932
2933
2934
  private String[] generateSQLDeletStrings(Object[] loadedState) {
    int span = getTableSpan();
    String[] deleteStrings = new String[span];
    for ( int j = span - 1; j >= 0; j-- ) {
      Delete delete = new Delete()
          .setTableName( getTableName( j ) )
          .addPrimaryKeyColumns( getKeyColumns( j ) );
      if ( getFactory().getSettings().isCommentsEnabled() ) {
        delete.setComment( "delete " + getEntityName() + " [" + j + "]" );
      }

      boolean[] versionability = getPropertyVersionability();
      Type[] types = getPropertyTypes();
      for ( int i = 0; i < entityMetamodel.getPropertySpan(); i++ ) {
        if ( isPropertyOfTable( i, j ) && versionability[i] ) {
          // this property belongs to the table and it is not specifically
          // excluded from optimistic locking by optimistic-lock="false"
          String[] propertyColumnNames = getPropertyColumnNames( i );
          boolean[] propertyNullness = types[i].toColumnNullness( loadedState[i], getFactory() );
          for ( int k = 0; k < propertyNullness.length; k++ ) {
            if ( propertyNullness[k] ) {
              delete.addWhereFragment( propertyColumnNames[k] + " = ?" );
            }
            else {
              delete.addWhereFragment( propertyColumnNames[k] + " is null" );
            }
          }
        }
      }
      deleteStrings[j] = delete.toStatementString();
    }
    return deleteStrings;
  }
View Full Code Here
TOP

Related Classes of org.hibernate.sql.Delete

  • org.hibernate.hql.ast.exec.MultiTableDeleteExecutor
  • org.hibernate.hql.internal.ast.exec.DeleteExecutor
  • org.hibernate.hql.internal.ast.exec.MultiTableDeleteExecutor
  • org.hibernate.hql.spi.TableBasedDeleteHandlerImpl
  • org.hibernate.persister.collection.BasicCollectionPersister
  • org.hibernate.persister.entity.AbstractEntityPersister
  • java.util.Iterator
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.