public SelectFragment setExtraSelectList(CaseFragment caseFragment, String fragmentAlias) { setExtraSelectList( caseFragment.setReturnColumnName(fragmentAlias, suffix).toFragmentString() ); return this; }
public DisjunctionFragment addCondition(ConditionFragment fragment) { addCondition( fragment.toFragmentString() ); return this; }
@Override public String[] getIndexColumnAliases(String suffix) { if ( hasIndex ) { return new Alias( suffix ).toAliasStrings( indexColumnAliases ); } else { return null; } }
public CaseFragment setReturnColumnName(String returnColumnName, String suffix) { return setReturnColumnName( new Alias(suffix).toAliasString(returnColumnName) ); }
/** * Adds another join fragment to this one. * * @param ojf The other join fragment */ public void addFragment(JoinFragment ojf) { if ( ojf.hasThetaJoins() ) { hasThetaJoins = true; } addJoins( ojf.toFromFragmentString(), ojf.toWhereFragmentString() ); }
private void addJoin(String tableName, String alias, String concreteAlias, String[] fkColumns, String[] pkColumns, JoinType joinType, String on) { if ( !useThetaStyleInnerJoins || joinType != JoinType.INNER_JOIN ) { JoinFragment jf = dialect.createOuterJoinFragment(); jf.addJoin( tableName, alias, fkColumns, pkColumns, joinType, on ); addFragment( jf ); } else { addCrossJoin( tableName, alias ); addCondition( concreteAlias, fkColumns, pkColumns ); addCondition( on ); } }
@Override public String getIdentifierColumnAlias(String suffix) { if ( hasIdentifier ) { return new Alias( suffix ).toAliasString( identifierColumnAlias ); } else { return null; } }
protected SelectFragment generateSelectFragment(String alias, String columnSuffix) { return new SelectFragment() .setSuffix( columnSuffix ) .addColumns( alias, keyColumnNames, keyColumnAliases ); }
public Update addColumns(String[] columnNames) { for ( String columnName : columnNames ) { addColumn( columnName ); } return this; }
public SimpleSelect addCondition(String[] lhs, String condition) { for ( String lh : lhs ) { if ( lh != null ) { addCondition( lh, condition ); } } return this; }
public Insert addColumns(String[] columnNames) { for ( int i=0; i<columnNames.length; i++ ) { addColumn( columnNames[i] ); } return this; }
public SelectFragment addFormulas(String tableAlias, String[] formulas, String[] formulaAliases) { for ( int i=0; i<formulas.length; i++ ) { if ( formulas[i]!=null ) { addFormula( tableAlias, formulas[i], formulaAliases[i] ); } } return this; }
protected void appendIdentifierColumns(SelectFragment frag, String alias) { if ( hasIdentifier ) { frag.addColumn( alias, identifierColumnName, identifierColumnAlias ); } }
/** * Map case support to the Oracle DECODE function. Oracle did not * add support for CASE until 9i. * <p/> * {@inheritDoc} */ @Override public CaseFragment createCaseFragment() { return new DecodeCaseFragment(); }
public String[] toUnquotedAliasStrings(String[] sqlIdentifiers) { String[] aliases = new String[ sqlIdentifiers.length ]; for ( int i=0; i<sqlIdentifiers.length; i++ ) { aliases[i] = toUnquotedAliasString(sqlIdentifiers[i]); } return aliases; }
public Delete addPrimaryKeyColumns(String[] columnNames, boolean[] includeColumns, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { if( includeColumns[i] ) { addPrimaryKeyColumn( columnNames[i], valueExpressions[i] ); } } return this; }
public Update addColumns(String[] columnNames, String valueExpression) { for ( String columnName : columnNames ) { addColumn( columnName, valueExpression ); } return this; }
public SimpleSelect addCondition(String[] lhs, String op, String[] rhs) { for ( int i = 0; i < lhs.length; i++ ) { addCondition( lhs[i], op, rhs[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; }
public Delete addPrimaryKeyColumns(String[] columnNames, String[] valueExpressions) { for ( int i=0; i<columnNames.length; i++ ) { addPrimaryKeyColumn( columnNames[i], valueExpressions[i] ); } return this; }