Package org.hibernate.sql

Examples of org.hibernate.sql.Update


    }
  }

  protected String generateLockString() {
    SessionFactoryImplementor factory = lockable.getFactory();
    Update update = new Update( factory.getDialect() );
    update.setTableName( lockable.getRootTableName() );
    update.setPrimaryKeyColumnNames( lockable.getRootTableIdentifierColumnNames() );
    update.setVersionColumnName( lockable.getVersionColumnName() );
    update.addColumn( lockable.getVersionColumnName() );
    if ( factory.getSettings().isCommentsEnabled() ) {
      update.setComment( lockMode + " lock " + lockable.getEntityName() );
    }
    return update.toStatementString();
  }
View Full Code Here


  /**
   * Generate the SQL UPDATE that updates all the foreign keys to null
   */
  protected String generateDeleteString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames, "null" )
        .setPrimaryKeyColumnNames( keyColumnNames );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames, "null" );
   
    if ( hasWhere ) update.setWhere( sqlWhereString );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "delete one-to-many " + getRole() );
    }
   
    return update.toStatementString();
  }
View Full Code Here

  /**
   * Generate the SQL UPDATE that updates a foreign key to a value
   */
  protected String generateInsertRowString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames );
   
    //identifier collections not supported for 1-to-many
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "create one-to-many row " + getRole() );
    }
   
    return update.setPrimaryKeyColumnNames( elementColumnNames )
        .toStatementString();
  }
View Full Code Here

   * Generate the SQL UPDATE that updates a particular row's foreign
   * key to null
   */
  protected String generateDeleteRowString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames, "null" );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames, "null" );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "delete one-to-many row " + getRole() );
    }
   
    //use a combination of foreign key columns and pk columns, since
    //the ordering of removal and addition is not guaranteed when
    //a child moves from one parent to another
    String[] rowSelectColumnNames = ArrayHelper.join(keyColumnNames, elementColumnNames);
    return update.setPrimaryKeyColumnNames( rowSelectColumnNames )
        .toStatementString();
  }
View Full Code Here

  /**
   * Generate the SQL UPDATE that updates a row
   */
  protected String generateUpdateRowString() {
   
    Update update = new Update( getDialect() )
      .setTableName( qualifiedTableName );
   
    //if ( !elementIsFormula ) {
      update.addColumns( elementColumnNames, elementColumnIsSettable );
    //}
   
    if ( hasIdentifier ) {
      update.setPrimaryKeyColumnNames( new String[]{ identifierColumnName } );
    }
    else if ( hasIndex && !indexContainsFormula ) {
      update.setPrimaryKeyColumnNames( ArrayHelper.join( keyColumnNames, indexColumnNames ) );
    }
    else {
      update.setPrimaryKeyColumnNames( ArrayHelper.join( keyColumnNames, elementColumnNames, elementColumnIsInPrimaryKey ) );
    }
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "update collection row " + getRole() );
    }
   
    return update.toStatementString();
  }
View Full Code Here

   * Generate the SQL UPDATE that updates all the foreign keys to null
   */
  @Override
    protected String generateDeleteString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames, "null" )
        .addPrimaryKeyColumns( keyColumnNames );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames, "null" );
   
    if ( hasWhere ) update.setWhere( sqlWhereString );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "delete one-to-many " + getRole() );
    }
   
    return update.toStatementString();
  }
View Full Code Here

   * Generate the SQL UPDATE that updates a foreign key to a value
   */
  @Override
    protected String generateInsertRowString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames );
   
    //identifier collections not supported for 1-to-many
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "create one-to-many row " + getRole() );
    }
   
    return update.addPrimaryKeyColumns( elementColumnNames, elementColumnWriters )
        .toStatementString();
  }
View Full Code Here

  /**
   * Generate the SQL UPDATE that inserts a collection index
   */
  @Override
    protected String generateUpdateRowString() {
    Update update = new Update( getDialect() ).setTableName( qualifiedTableName );
    update.addPrimaryKeyColumns( elementColumnNames, elementColumnIsSettable, elementColumnWriters );
    if ( hasIdentifier ) {
      update.addPrimaryKeyColumns( new String[]{ identifierColumnName } );
    }
    if ( hasIndex && !indexContainsFormula ) {
      update.addColumns( indexColumnNames );
    }
   
    return update.toStatementString();
  }
View Full Code Here

   * key to null
   */
  @Override
    protected String generateDeleteRowString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames, "null" );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames, "null" );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "delete one-to-many row " + getRole() );
    }
   
    //use a combination of foreign key columns and pk columns, since
    //the ordering of removal and addition is not guaranteed when
    //a child moves from one parent to another
    String[] rowSelectColumnNames = ArrayHelper.join( keyColumnNames, elementColumnNames );
    return update.addPrimaryKeyColumns( rowSelectColumnNames )
        .toStatementString();
  }
View Full Code Here

  /**
   * Generate the SQL UPDATE that updates all the foreign keys to null
   */
  protected String generateDeleteString() {
   
    Update update = new Update( getDialect() )
        .setTableName( qualifiedTableName )
        .addColumns( keyColumnNames, "null" )
        .addPrimaryKeyColumns( keyColumnNames );
   
    if ( hasIndex && !indexContainsFormula ) update.addColumns( indexColumnNames, "null" );
   
    if ( hasWhere ) update.setWhere( sqlWhereString );
   
    if ( getFactory().getSettings().isCommentsEnabled() ) {
      update.setComment( "delete one-to-many " + getRole() );
    }
   
    return update.toStatementString();
  }
View Full Code Here

TOP

Related Classes of org.hibernate.sql.Update

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.