/** * Generate the SQL INSERT that creates a new row */ @Override protected String generateInsertRowString() { final Insert insert = new Insert( getDialect() ) .setTableName( qualifiedTableName ) .addColumns( keyColumnNames ); if ( hasIdentifier ) { insert.addColumn( identifierColumnName ); } if ( hasIndex /*&& !indexIsFormula*/ ) { insert.addColumns( indexColumnNames, indexColumnIsSettable ); } if ( getFactory().getSessionFactoryOptions().isCommentsEnabled() ) { insert.setComment( "insert collection row " + getRole() ); } //if ( !elementIsFormula ) { insert.addColumns( elementColumnNames, elementColumnIsSettable, elementColumnWriters ); //} return insert.toStatementString(); }
Insert insert = new Insert( getFactory().getDialect() ) .setTableName( getTableName( j ) ); insert.addColumns( getPropertyColumnNames( i ), propertyColumnInsertable[i], values ); insert.addColumns( getPropertyColumnNames( i ), propertyColumnInsertable[i], insert.addIdentityColumn( getKeyColumns( 0 )[0] ); insert.addColumns( getKeyColumns( j ) ); insert.setComment( "insert " + getEntityName() ); if ( includeProperty[i] && isPropertyOfTable( i, j ) ) { insert.addColumns( getPropertyColumnNames( i ), propertyColumnInsertable[i], String result = insert.toStatementString();
insert.setTableName( getTableName( 0 ) ); insert.addColumns( getPropertyColumnNames( i ), propertyColumnInsertable[i], insert.addColumns( getPropertyColumnNames( i ), propertyColumnInsertable[i], insert.addColumns( getPropertyColumnNames( i ), propertyColumnInsertable[i], propertyColumnWriters[i] ); insert.setComment( "insert " + getEntityName() ); return insert.toStatementString();
public Insert addColumns(String[] columnNames, boolean[] insertable, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { if ( insertable[i] ) { addColumn( columnNames[i], valueExpressions[i] ); } } return this; }
public Insert addColumns(String[] columnNames, boolean[] insertable) { for ( int i=0; i<columnNames.length; i++ ) { if ( insertable[i] ) { addColumn( columnNames[i] ); } } return this; }
/** * Used to generate an insery statement against the root table in the * case of identifier generation strategies where the insert statement * executions actually generates the identifier value. * * @param includeProperty indices of the properties to include in the * insert statement. * @return The insert SQL statement string */ protected String generateIdentityInsertString(boolean[] includeProperty) { Insert insert = identityDelegate.prepareIdentifierGeneratingInsert(); insert.setTableName( getTableName( 0 ) ); // add normal properties for ( int i = 0; i < entityMetamodel.getPropertySpan(); i++ ) { if ( includeProperty[i] && isPropertyOfTable( i, 0 ) ) { // this property belongs on the table and is to be inserted insert.addColumns( getPropertyColumnNames(i), propertyColumnInsertable[i], propertyColumnWriters[i] ); } } // add the discriminator addDiscriminatorToInsert( insert ); // delegate already handles PK columns if ( getFactory().getSettings().isCommentsEnabled() ) { insert.setComment( "insert " + getEntityName() ); } return insert.toStatementString(); }
/** * Generate the SQL INSERT that creates a new row */ protected String generateInsertRowString() { Insert insert = new Insert( null ) .setTableName( qualifiedTableName ) .addColumns( keyColumnNames ); if ( hasIdentifier) insert.addColumn( identifierColumnName ); if ( hasIndex /*&& !indexIsFormula*/ ) { insert.addColumns( indexColumnNames, indexColumnIsSettable ); } if ( getFactory().getSettings().isCommentsEnabled() ) { insert.setComment( "insert collection row " + getRole() ); } //if ( !elementIsFormula ) { insert.addColumns( elementColumnNames, elementColumnIsSettable ); //} return insert.toStatementString(); }
Insert insert = new Insert( getFactory().getDialect() ) .setTableName( getTableName( j ) ); if ( includeProperty[i] && isPropertyOfTable( i, j ) ) { insert.addColumns( getPropertyColumnNames(i), propertyColumnInsertable[i], propertyColumnWriters[i] ); insert.addIdentityColumn( getKeyColumns( 0 )[0] ); insert.addColumns( getKeyColumns( j ) ); insert.setComment( "insert " + getEntityName() ); String result = insert.toStatementString();
public Insert addColumns(String[] columnNames) { for ( int i=0; i<columnNames.length; i++ ) { addColumn( columnNames[i] ); } return this; }
/** * Used to generate an insery statement against the root table in the * case of identifier generation strategies where the insert statement * executions actually generates the identifier value. * * @param includeProperty indices of the properties to include in the * insert statement. * @return The insert SQL statement string */ protected String generateIdentityInsertString(boolean[] includeProperty) { Insert insert = identityDelegate.prepareIdentifierGeneratingInsert(); insert.setTableName( getTableName( 0 ) ); // add normal properties for ( int i = 0; i < entityMetamodel.getPropertySpan(); i++ ) { if ( includeProperty[i] && isPropertyOfTable( i, 0 ) ) { // this property belongs on the table and is to be inserted insert.addColumns( getPropertyColumnNames(i), propertyColumnInsertable[i], propertyColumnWriters[i] ); } } // add the discriminator addDiscriminatorToInsert( insert ); // delegate already handles PK columns if ( getFactory().getSettings().isCommentsEnabled() ) { insert.setComment( "insert " + getEntityName() ); } return insert.toStatementString(); }
/** * Generate the SQL INSERT that creates a new row */ protected String generateInsertRowString() { Insert insert = new Insert( getDialect() ) .setTableName( qualifiedTableName ) .addColumns( keyColumnNames ); if ( hasIdentifier) insert.addColumn( identifierColumnName ); if ( hasIndex /*&& !indexIsFormula*/ ) { insert.addColumns( indexColumnNames, indexColumnIsSettable ); } if ( getFactory().getSettings().isCommentsEnabled() ) { insert.setComment( "insert collection row " + getRole() ); } //if ( !elementIsFormula ) { insert.addColumns( elementColumnNames, elementColumnIsSettable ); //} return insert.toStatementString(); }
Insert insert = new Insert( getFactory().getDialect() ) .setTableName( getTableName( j ) ); if ( includeProperty[i] && isPropertyOfTable( i, j ) ) { insert.addColumns( getPropertyColumnNames(i), propertyColumnInsertable[i] ); insert.addIdentityColumn( getKeyColumns( 0 )[0] ); insert.addColumns( getKeyColumns( j ) ); insert.setComment( "insert " + getEntityName() ); String result = insert.toStatementString();
public Insert addColumn(String columnName) { return addColumn(columnName, "?"); }
/** * Generate the SQL INSERT that creates a new row */ @Override protected String generateInsertRowString() { Insert insert = new Insert( getDialect() ) .setTableName( qualifiedTableName ) .addColumns( keyColumnNames ); if ( hasIdentifier) insert.addColumn( identifierColumnName ); if ( hasIndex /*&& !indexIsFormula*/ ) { insert.addColumns( indexColumnNames, indexColumnIsSettable ); } if ( getFactory().getSettings().isCommentsEnabled() ) { insert.setComment( "insert collection row " + getRole() ); } //if ( !elementIsFormula ) { insert.addColumns( elementColumnNames, elementColumnIsSettable, elementColumnWriters ); //} return insert.toStatementString(); }
Insert insert = new Insert( getFactory().getDialect() ) .setTableName( getTableName( j ) ); if ( includeProperty[i] && isPropertyOfTable( i, j ) ) { insert.addColumns( getPropertyColumnNames(i), propertyColumnInsertable[i], propertyColumnWriters[i] ); insert.addIdentityColumn( getKeyColumns( 0 )[0] ); insert.addColumns( getKeyColumns( j ) ); insert.setComment( "insert " + getEntityName() ); String result = insert.toStatementString();
protected void addDiscriminatorToInsert(Insert insert) { if ( discriminatorInsertable ) { insert.addColumn( getDiscriminatorColumnName(), discriminatorSQLValue ); } }
/** * Generate the SQL INSERT that creates a new row */ @Override protected String generateInsertRowString() { Insert insert = new Insert( getDialect() ) .setTableName( qualifiedTableName ) .addColumns( keyColumnNames ); if ( hasIdentifier) insert.addColumn( identifierColumnName ); if ( hasIndex /*&& !indexIsFormula*/ ) { insert.addColumns( indexColumnNames, indexColumnIsSettable ); } if ( getFactory().getSettings().isCommentsEnabled() ) { insert.setComment( "insert collection row " + getRole() ); } //if ( !elementIsFormula ) { insert.addColumns( elementColumnNames, elementColumnIsSettable, elementColumnWriters ); //} return insert.toStatementString(); }
Insert insert = new Insert( getFactory().getDialect() ) .setTableName( getTableName( j ) ); insert.addIdentityColumn( getKeyColumns( 0 )[0] ); insert.addColumns( getKeyColumns( j ) ); insert.setComment( "insert " + getEntityName() ); String result = insert.toStatementString();
@Override protected void addDiscriminatorToInsert(Insert insert) { if ( explicitDiscriminatorColumnName != null ) { insert.addColumn( explicitDiscriminatorColumnName, getDiscriminatorSQLValue() ); } }
public Insert addColumn(String columnName, Object value, LiteralType type) throws Exception { return addColumn( columnName, type.objectToSQLString(value, dialect) ); }