Examples of jodd.db.oom.sqlgen.chunks.ColumnsSelectChunk

jodd.db.oom.sqlgen.chunks.ColumnsSelectChunk
Columns select chunk resolves entity column(s) from column references. Should be used for SELECT queries.
Column reference is specified as: {@link TableChunk tableReference}.propertyName where property name is a property of the entity references by table reference. Result is rendered as: tableName.column or alias.column (if table has an alias).
There are some special values for propertyName
- wildcard (*), all table columns will be listed
- id sign (+), all table id columns will be listed
If previous chunk is also a column chunk, comma separator will be added in between.
Note that column alias are appended to the column name (using 'as' construct).
Macro rules:
- $C{tableRef} is rendered as FOO.col1, FOO.col2,...
- $C{tableRef.*} is equal to above, renders all entity columns
- $C{tableRef.+} renders to only identity columns
- $C{tableRef.%} renders all but identity columns
- $C{tableRef.colRef} is rendered as FOO.column
- $C{tableRef.[colRef1,colRef2|...]} is rendered as FOO.column1, FOO.column2,..., support id sign (+)
- $C{entityRef.colRef} renders to FOO$column
- $C{hint.entityRef...} defines a hint
- $C{hint:entityRef...} defines a hint with custom name
- $C{.columName} renders as column name
- $C{hint:.columName} renders as column name and defines its hint

  }


  // ---------------------------------------------------------------- columns


  public DbSqlBuilder column(String reference) {
    return addChunk(new ColumnsSelectChunk(reference));
  }

View Full Code Here

  public DbSqlBuilder column(String reference) {
    return addChunk(new ColumnsSelectChunk(reference));
  }


  public DbSqlBuilder column(String tableRef, String columnRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, columnRef));
  }

View Full Code Here

  public DbSqlBuilder column(String tableRef, String columnRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, columnRef));
  }


  public DbSqlBuilder columnsAll(String tableRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, true));
  }

View Full Code Here

  public DbSqlBuilder columnsAll(String tableRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, true));
  }


  public DbSqlBuilder columnsIds(String tableRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, false));
  }

View Full Code Here

  }


  // ---------------------------------------------------------------- columns


  public DbSqlBuilder column(String reference) {
    return addChunk(new ColumnsSelectChunk(reference));
  }

View Full Code Here

  public DbSqlBuilder column(String reference) {
    return addChunk(new ColumnsSelectChunk(reference));
  }


  public DbSqlBuilder column(String tableRef, String columnRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, columnRef));
  }

View Full Code Here

  public DbSqlBuilder column(String tableRef, String columnRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, columnRef));
  }


  public DbSqlBuilder columnsAll(String tableRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, true));
  }

View Full Code Here

  public DbSqlBuilder columnsAll(String tableRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, true));
  }


  public DbSqlBuilder columnsIds(String tableRef) {
    return addChunk(new ColumnsSelectChunk(tableRef, false));
  }

View Full Code Here

TOP

Related Classes of jodd.db.oom.sqlgen.chunks.ColumnsSelectChunk

jodd.db.oom.ColumnAliasType

jodd.db.oom.DbEntityColumnDescriptor

jodd.db.oom.DbEntityDescriptor

jodd.db.oom.sqlgen.DbSqlBuilder

jodd.db.oom.sqlgen.DbSqlBuilderException

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.