Examples of UpdateStatement


Examples of liquibase.statement.core.UpdateStatement

      localHost = NetUtil.getLocalHost();
    } catch (Exception e) {
      throw new UnexpectedLiquibaseException(e);
    }

    UpdateStatement updateStatement = new UpdateStatement(liquibaseSchema,
            database.getDatabaseChangeLogLockTableName());
    updateStatement.addNewColumnValue("LOCKED", true);
    updateStatement.addNewColumnValue("LOCKGRANTED", new Timestamp(new java.util.Date().getTime()));
    updateStatement.addNewColumnValue("LOCKEDBY", localHost.getHostName()
            + " (" + localHost.getHostAddress() + ")");
    String whereClause = database.escapeColumnName(liquibaseSchema,
            database.getDatabaseChangeLogTableName(), "ID")
            + " = 1 AND ";

    if (database instanceof CUBRIDDatabase) {
      whereClause = whereClause
              + "( "
              + database.escapeColumnName(liquibaseSchema,
                      database.getDatabaseChangeLogTableName(),
                      "LOCKED")
              + " = "
              + TypeConverterFactory.getInstance().findTypeConverter(database).getBooleanType()
                      .getFalseBooleanValue()
              + " OR "
              + database.escapeColumnName(liquibaseSchema,
                      database.getDatabaseChangeLogTableName(),
                      "LOCKED") + " = '0')";
    } else {
      whereClause = whereClause
              + database.escapeColumnName(liquibaseSchema,
                      database.getDatabaseChangeLogTableName(),
                      "LOCKED")
              + " = "
              + TypeConverterFactory.getInstance().findTypeConverter(database).getBooleanType()
                      .getFalseBooleanValue();
    }
    updateStatement.setWhereClause(whereClause);

    return SqlGeneratorFactory.getInstance().generateSql(updateStatement, database);

  }
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.UpdateStatement

      }
      return result;
   }

  public UpdateStatement getUpdateStatement() {
    UpdateStatement result = getSchema().getSQLFactory().newUpdateStatement();
    result.setTable(this);
    TableReference ref = result.getTableReference();
    boolean hasPrimaryKey = false;
    for (Iterator iter = getColumns();  iter.hasNext()) {
      Column column = (Column) iter.next();
      if (column.isPrimaryKeyPart()) {
        hasPrimaryKey = true;
      } else {
        result.addSet(column);
      }
    }
    if (hasPrimaryKey) {
      result.getWhere().addColumnSetQuery(getPrimaryKey(), ref);
    } else {
      throw new IllegalStateException("Cannot create a default update statement without a primary key.");
    }
    return result;
  }
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.UpdateStatement

  /** <p>Basic test for creating an <code>UPDATE</code> statement.</p>
   */
  public void testBasicUpdate() {
    Table table = getPrimaryKeyTable();
    UpdateStatement updateStatement = table.getUpdateStatement();
    SQLGenerator generator = sqlFactory.newSQLGenerator();
    generator.setLineTerminator("\n");
    String s = generator.getQuery(updateStatement);
    assertEquals("UPDATE MySchema.MyTable SET MyName=?, MyDate=? WHERE MyIndex=?", s);
  }
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.UpdateStatement

   
    /** <p>Basic test for creating an <code>UPDATE</code> statement.</p>
     */
    public void testBasicUpdate() {
        Table table = getPrimaryKeyTable();
        UpdateStatement updateStatement = table.getUpdateStatement();
        SQLGenerator generator = getSQLGenerator();
        generator.setLineTerminator("\n");
        String s = generator.getQuery(updateStatement);
        assertEquals("UPDATE MySchema.MyTable SET MyName=?, MyDate=? WHERE MyIndex=?", s);
    }
View Full Code Here

Examples of org.apache.ws.jaxme.sqls.UpdateStatement

      }
      return result;
   }

  public UpdateStatement getUpdateStatement() {
    UpdateStatement result = getSchema().getSQLFactory().newUpdateStatement();
    result.setTable(this);
    TableReference ref = result.getTableReference();
    boolean hasPrimaryKey = false;
    for (Iterator iter = getColumns();  iter.hasNext()) {
      Column column = (Column) iter.next();
      if (column.isPrimaryKeyPart()) {
        hasPrimaryKey = true;
      } else {
        result.addSet(column);
      }
    }
    if (hasPrimaryKey) {
      result.getWhere().addColumnSetQuery(getPrimaryKey(), ref);
    } else {
      throw new IllegalStateException("Cannot create a default update statement without a primary key.");
    }
    return result;
  }
View Full Code Here

Examples of org.g4studio.core.orm.xibatis.sqlmap.engine.mapping.statement.UpdateStatement

        statementParser.parseGeneralStatement(node, new InsertStatement());
      }
    });
    parser.addNodelet("/sqlMap/update", new Nodelet() {
      public void process(Node node) throws Exception {
        statementParser.parseGeneralStatement(node, new UpdateStatement());
      }
    });
    parser.addNodelet("/sqlMap/delete", new Nodelet() {
      public void process(Node node) throws Exception {
        statementParser.parseGeneralStatement(node, new DeleteStatement());
View Full Code Here

Examples of org.hibernate.hql.ast.tree.UpdateStatement

    }

  }

  protected void postProcessUpdate(AST update) throws SemanticException {
    UpdateStatement updateStatement = ( UpdateStatement ) update;

    postProcessDML( updateStatement );
  }
View Full Code Here

Examples of org.hibernate.hql.ast.tree.UpdateStatement

    return intoClause;
  }

  protected void prepareVersioned(AST updateNode, AST versioned) throws SemanticException {
    UpdateStatement updateStatement = ( UpdateStatement ) updateNode;
    FromClause fromClause = updateStatement.getFromClause();
    if ( versioned != null ) {
      // Make sure that the persister is versioned
      Queryable persister = fromClause.getFromElement().getQueryable();
      if ( !persister.isVersioned() ) {
        throw new SemanticException( "increment option specified for update of non-versioned entity" );
      }

      VersionType versionType = persister.getVersionType();
      if ( versionType instanceof UserVersionType ) {
        throw new SemanticException( "user-defined version types not supported for increment option" );
      }

      AST eq = getASTFactory().create( HqlSqlTokenTypes.EQ, "=" );
      AST versionPropertyNode = generateVersionPropertyNode( persister );

      eq.setFirstChild( versionPropertyNode );

      AST versionIncrementNode = null;
      if ( Date.class.isAssignableFrom( versionType.getReturnedClass() ) ) {
        versionIncrementNode = getASTFactory().create( HqlSqlTokenTypes.PARAM, "?" );
        ParameterSpecification paramSpec = new VersionTypeSeedParameterSpecification( versionType );
        ( ( ParameterNode ) versionIncrementNode ).setHqlParameterSpecification( paramSpec );
        parameters.add( 0, paramSpec );
      }
      else {
        // Not possible to simply re-use the versionPropertyNode here as it causes
        // OOM errors due to circularity :(
        versionIncrementNode = getASTFactory().create( HqlSqlTokenTypes.PLUS, "+" );
        versionIncrementNode.setFirstChild( generateVersionPropertyNode( persister ) );
        versionIncrementNode.addChild( getASTFactory().create( HqlSqlTokenTypes.IDENT, "1" ) );
      }

      eq.addChild( versionIncrementNode );

      evaluateAssignment( eq, persister, 0 );

      AST setClause = updateStatement.getSetClause();
      AST currentFirstSetElement = setClause.getFirstChild();
      setClause.setFirstChild( eq );
      eq.setNextSibling( currentFirstSetElement );
    }
  }
View Full Code Here

Examples of org.hibernate.hql.ast.tree.UpdateStatement

    if ( !walker.getSessionFactoryHelper().getFactory().getDialect().supportsTemporaryTables() ) {
      throw new HibernateException( "cannot perform multi-table updates using dialect not supporting temp tables" );
    }

    UpdateStatement updateStatement = ( UpdateStatement ) walker.getAST();
    FromElement fromElement = updateStatement.getFromClause().getFromElement();
    String bulkTargetAlias = fromElement.getTableAlias();
    this.persister = fromElement.getQueryable();

    this.idInsertSelect = generateIdInsertSelect( persister, bulkTargetAlias, updateStatement.getWhereClause() );
    log.trace( "Generated ID-INSERT-SELECT SQL (multi-table update) : " +  idInsertSelect );

    String[] tableNames = persister.getConstraintOrderedTableNameClosure();
    String[][] columnNames = persister.getContraintOrderedTableKeyColumnClosure();
View Full Code Here

Examples of org.hibernate.hql.ast.tree.UpdateStatement

    }

  }

  protected void postProcessUpdate(AST update) throws SemanticException {
    UpdateStatement updateStatement = ( UpdateStatement ) update;

    postProcessDML( updateStatement );
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.