List of colName() Examples

Examples of colName()

org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

                {
                    colName = DBNames.QNAME_TABLE_VALUE_COLUMN_NAME;
                }
                // Last table column might be null because of left joins
                builder.getWhere().reset(
                    b.isNull( c.colName( TABLE_NAME_PREFIX + lastTableIndex, colName ) ) );
            }
        }
    }


    private static class AssociationNullWhereClauseProcessor

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

                ColumnsFactory c = vendor.getColumnsFactory();
                BooleanFactory b = vendor.getBooleanFactory();


                // Last table column might be null because of left joins
                builder.getWhere().reset(
                    b.isNull( c.colName( TABLE_NAME_PREFIX + lastTableIndex,
                                         DBNames.QNAME_TABLE_VALUE_COLUMN_NAME ) ) );
            }
        }
    }

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()


            // @formatter:off
            return q.simpleQueryBuilder()
                .select( SQLs.ENTITY_PK_COLUMN_NAME, SQLs.ENTITY_OPTIMISTIC_LOCK_COLUMN_NAME, SQLs.ENTITY_STATE_COLUMN_NAME )
                .from( t.tableName( this.schemaName, SQLs.TABLE_NAME ) )
                .where( b.eq( c.colName( SQLs.ENTITY_IDENTITY_COLUMN_NAME ), l.param() ) )
                .createExpression();
            // @formatter:on
        }


        protected SQLStatement createInsertEntityStatement( SQLVendor vendor )

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

                    m.setClause( SQLs.ENTITY_STATE_COLUMN_NAME, m.updateSourceByExp( l.param() ) ),
                    m.setClause( SQLs.ENTITY_LAST_MODIFIED_COLUMN_NAME, m.updateSourceByExp( l.param() ) )
                    );
            builder
                .getWhereBuilder()
                    .reset( b.eq( c.colName( SQLs.ENTITY_PK_COLUMN_NAME ), l.param() ) )
                    .and( b.eq( c.colName( SQLs.ENTITY_OPTIMISTIC_LOCK_COLUMN_NAME ), l.param() ) );
            return builder.createExpression();
            // @formatter:on
        }

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

                    m.setClause( SQLs.ENTITY_LAST_MODIFIED_COLUMN_NAME, m.updateSourceByExp( l.param() ) )
                    );
            builder
                .getWhereBuilder()
                    .reset( b.eq( c.colName( SQLs.ENTITY_PK_COLUMN_NAME ), l.param() ) )
                    .and( b.eq( c.colName( SQLs.ENTITY_OPTIMISTIC_LOCK_COLUMN_NAME ), l.param() ) );
            return builder.createExpression();
            // @formatter:on
        }


        protected SQLStatement createRemoveEntityStatement( SQLVendor vendor )

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()


            // @formatter:off
            DeleteBySearchBuilder builder = m.deleteBySearch()
                .setTargetTable( m.createTargetTable( t.tableName( this.schemaName, SQLs.TABLE_NAME ) ) );
            builder.getWhere()
                .reset( b.eq( c.colName( SQLs.ENTITY_PK_COLUMN_NAME ), l.param() ) );
            return builder.createExpression();
            // @formatter:on
        }


        protected SQLDataType getPKType()

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

        QueryFactory q = vendor.getQueryFactory();
        TableReferenceFactory t = vendor.getTableReferenceFactory();
        LiteralFactory l = vendor.getLiteralFactory();
        ColumnsFactory c = vendor.getColumnsFactory();


        ColumnReference mainColumn = c.colName( TABLE_NAME_PREFIX + "0", DBNames.ENTITY_TABLE_IDENTITY_COLUMN_NAME );
        if( countOnly )
        {
            mainColumn = c.colExp( l.func( SQLFunctions.COUNT, mainColumn ) );
        }

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

        BooleanFactory b = vendor.getBooleanFactory();
        LiteralFactory l = vendor.getLiteralFactory();
        ColumnsFactory c = vendor.getColumnsFactory();


        List<Integer> typeIDs = this.getEntityTypeIDs( resultType );
        InBuilder in = b.inBuilder( c.colName( TABLE_NAME_PREFIX + TYPE_TABLE_SUFFIX,
                                               DBNames.ENTITY_TYPES_TABLE_PK_COLUMN_NAME ) );
        for( Integer i : typeIDs )
        {
            in.addValues( l.n( i ) );
        }

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

                LiteralFactory l = vendor.getLiteralFactory();
                ColumnsFactory c = vendor.getColumnsFactory();


                builder.getWhere().reset(
                    vendor.getBooleanFactory().regexp(
                        c.colName( TABLE_NAME_PREFIX + lastTableIndex,
                                   DBNames.QNAME_TABLE_VALUE_COLUMN_NAME ),
                        l.param() ) );


                Object value = predicate.value();
                if( value instanceof Variable )

View Full Code Here

Examples of org.sql.generation.api.grammar.factories.ColumnsFactory.colName()

                BooleanFactory b = vendor.getBooleanFactory();


                builder.getWhere().reset(
                    getOperator( predicate ).getExpression(
                        b,
                        c.colName( TABLE_NAME_PREFIX + lastTableIndex,
                                   DBNames.ENTITY_TABLE_IDENTITY_COLUMN_NAME ),
                        l.param() ) );


                Object value = predicate.value();
                // TODO Is it really certain that this value is always instance of

View Full Code Here

0 1 2 3 4

TOP

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.