private Document createDocFromChange(Change change, DeployExecution deployExecution, Date insertTimestamp) { Date currentTimestamp = getCurrentTimestamp(); return new Document() .append("ARTFTYPE", change instanceof ChangeIncremental ? "I" : "R") .append("DBSCHEMA", change.getSchema()) .append("ACTIVE", change.isActive() ? 1 : 0) .append("CHANGETYPE", change.getChangeType().getName()) .append("CONTENTHASH", change.getContentHash()) .append(changeNameColumn, change.getChangeName()) .append("OBJECTNAME", change.getObjectName()) .append(rollbackContentColumn, change.getRollbackContent()) .append(deployUserIdColumn, deployUserId) .append(timeInsertedColumn, ObjectUtils.firstNonNull(insertTimestamp, currentTimestamp)) .append(timeUpdatedColumn, currentTimestamp) .append(insertDeployExecutionIdColumn, deployExecution.getId()) .append(updateDeployExecutionIdColumn, deployExecution.getId()); }
private Document createDocFromChange(Change change, DeployExecution deployExecution, Date insertTimestamp) { Date currentTimestamp = getCurrentTimestamp(); return new Document() .append("ARTFTYPE", change instanceof ChangeIncremental ? "I" : "R") .append("DBSCHEMA", change.getSchema()) .append("ACTIVE", change.isActive() ? 1 : 0) .append("CHANGETYPE", change.getChangeType().getName()) .append("CONTENTHASH", change.getContentHash()) .append(changeNameColumn, change.getChangeName()) .append("OBJECTNAME", change.getObjectName()) .append(rollbackContentColumn, change.getRollbackContent()) .append(deployUserIdColumn, deployUserId) .append(timeInsertedColumn, ObjectUtils.firstNonNull(insertTimestamp, currentTimestamp)) .append(timeUpdatedColumn, currentTimestamp) .append(insertDeployExecutionIdColumn, deployExecution.getId()) .append(updateDeployExecutionIdColumn, deployExecution.getId()); }
private int updateInternal(Connection conn, Change artifact, DeployExecution deployExecution) { return sqlExecutor.getJdbcTemplate().update( conn, "UPDATE " + env.getPlatform().getSchemaPrefix(artifact.getPhysicalSchema(env)) + dbChangeTable + " SET " + "ARTFTYPE = ?, " + "DBSCHEMA = ?, " + "ACTIVE = ?, " + "CHANGETYPE = ?, " + "CONTENTHASH = ?, " + rollbackContentColumn + " = ?, " + deployUserIdColumn + " = ?, " + timeUpdatedColumn + " = ?, " + updateDeployExecutionIdColumn + " = ? " + "WHERE " + changeNameColumn + " = ? AND OBJECTNAME = ?" , artifact instanceof ChangeIncremental ? "I" : "R" , artifact.getSchema() , artifact.isActive() ? 1 : 0 , artifact.getChangeType().getName() , artifact.getContentHash() , artifact.getRollbackContent() , deployUserId , getCurrentTimestamp() , deployExecution.getId() , artifact.getChangeName() , artifact.getObjectName() ); }
private int updateInternal(Connection conn, Change artifact, DeployExecution deployExecution) { return sqlExecutor.getJdbcTemplate().update( conn, "UPDATE " + env.getPlatform().getSchemaPrefix(artifact.getPhysicalSchema(env)) + dbChangeTable + " SET " + "ARTFTYPE = ?, " + "DBSCHEMA = ?, " + "ACTIVE = ?, " + "CHANGETYPE = ?, " + "CONTENTHASH = ?, " + rollbackContentColumn + " = ?, " + deployUserIdColumn + " = ?, " + timeUpdatedColumn + " = ?, " + updateDeployExecutionIdColumn + " = ? " + "WHERE " + changeNameColumn + " = ? AND OBJECTNAME = ?" , artifact instanceof ChangeIncremental ? "I" : "R" , artifact.getSchema() , artifact.isActive() ? 1 : 0 , artifact.getChangeType().getName() , artifact.getContentHash() , artifact.getRollbackContent() , deployUserId , getCurrentTimestamp() , deployExecution.getId() , artifact.getChangeName() , artifact.getObjectName() ); }
private void insertNewChangeInternal(Connection conn, Change change, DeployExecution deployExecution) { JdbcHelper jdbcTemplate = sqlExecutor.getJdbcTemplate(); Timestamp currentTimestamp = getCurrentTimestamp(); jdbcTemplate.update( conn, "INSERT INTO " + env.getPlatform().getSchemaPrefix(change.getPhysicalSchema(env)) + dbChangeTable + " (ARTFTYPE, DBSCHEMA, ACTIVE, CHANGETYPE, CONTENTHASH, " + changeNameColumn + ", OBJECTNAME, " + rollbackContentColumn + ", " + deployUserIdColumn + ", " + timeInsertedColumn + ", " + timeUpdatedColumn + ", " + insertDeployExecutionIdColumn + ", " + updateDeployExecutionIdColumn + ") " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" , change instanceof ChangeIncremental ? "I" : "R" , change.getSchema() , change.isActive() ? 1 : 0 , change.getChangeType().getName() , change.getContentHash() , change.getChangeName() , change.getObjectName() , change.getRollbackContent() , deployUserId , currentTimestamp , currentTimestamp , deployExecution.getId() , deployExecution.getId() ); }
private void insertNewChangeInternal(Connection conn, Change change, DeployExecution deployExecution) { JdbcHelper jdbcTemplate = sqlExecutor.getJdbcTemplate(); Timestamp currentTimestamp = getCurrentTimestamp(); jdbcTemplate.update( conn, "INSERT INTO " + env.getPlatform().getSchemaPrefix(change.getPhysicalSchema(env)) + dbChangeTable + " (ARTFTYPE, DBSCHEMA, ACTIVE, CHANGETYPE, CONTENTHASH, " + changeNameColumn + ", OBJECTNAME, " + rollbackContentColumn + ", " + deployUserIdColumn + ", " + timeInsertedColumn + ", " + timeUpdatedColumn + ", " + insertDeployExecutionIdColumn + ", " + updateDeployExecutionIdColumn + ") " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" , change instanceof ChangeIncremental ? "I" : "R" , change.getSchema() , change.isActive() ? 1 : 0 , change.getChangeType().getName() , change.getContentHash() , change.getChangeName() , change.getObjectName() , change.getRollbackContent() , deployUserId , currentTimestamp , currentTimestamp , deployExecution.getId() , deployExecution.getId() ); }