java.lang.Object
- org.fluentjdbc.DbContextSelectBuilder

All Implemented Interfaces:: DatabaseQueryable<DbContextSelectBuilder>, DbContextListableSelect<DbContextSelectBuilder>

public class DbContextSelectBuilder
extends Object
implements DbContextListableSelect<DbContextSelectBuilder>

Generate SELECT statements by collecting WHERE expressions and parameters.Example:

 DbContextTable table = context.table("database_test_table");
 try (DbContextConnection ignored = context.startConnection(dataSource)) {
      List<Person> result = table
          .where("firstName", firstName)
          .whereExpression("lastName like ?", "joh%")
          .whereIn("status", statuses)
          .orderBy("lastName")
          .list(row -> new Person(row));
 }

See Also:: DatabaseTableQueryBuilder

Constructor Summary

Constructors
Constructor Description

DbContextSelectBuilder(DbContextTable dbContextTable)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`int`	`executeDelete()`	Executes `DELETE FROM tableName WHERE ....`
`void`	`forEach(DatabaseResult.RowConsumer consumer)`	Executes the `SELECT * FROM ...` statement and calls back to `DatabaseResult.RowConsumer` for each returned row
`int`	`getCount()`	Executes `SELECT count(*) FROM ...` on the query and returns the result
`<T> List<T>`	`list(DatabaseResult.RowMapper<T> mapper)`	Execute the query and map each return value over the `DatabaseResult.RowMapper` function to return a list.
`DbContextSelectBuilder`	`orderBy(String orderByClause)`	Adds `ORDER BY ...` clause to the `SELECT` statement
`DbContextSelectBuilder`	`query()`	Returns this.
`<T> Optional<T>`	`singleObject(DatabaseResult.RowMapper<T> mapper)`	If the query returns no rows, returns `Optional.empty()`, if exactly one row is returned, maps it and return it, if more than one is returned, throws `IllegalStateException`
`Optional<String>`	`singleString(String fieldName)`	Returns a string from the specified column name
`DbContextSelectBuilder`	`skipAndLimit(int offset, int rowCount)`	Adds `OFFSET ...`
`<T> Stream<T>`	`stream(DatabaseResult.RowMapper<T> mapper)`	Execute the query and map each return value over the `DatabaseResult.RowMapper` function to return a stream.
`DbContextSelectBuilder`	`unordered()`	If you haven't called `orderBy(java.lang.String)`, the results of `list(org.fluentjdbc.DatabaseResult.RowMapper<T>)` will be unpredictable.
`DbContextUpdateBuilder`	`update()`	Creates a `DbContextUpdateBuilder` object to fluently generate a `UPDATE ...` statement
`DbContextSelectBuilder`	`whereExpressionWithParameterList(String expression, Collection<?> parameters)`	Adds the expression to the WHERE-clause and all the values to the parameter list.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.fluentjdbc.DatabaseQueryable
where, whereAll, whereExpression, whereExpression, whereIn, whereOptional

Methods inherited from interface org.fluentjdbc.DbContextListableSelect
limit, listLongs, listStrings, singleInputStream, singleInstant, singleLong, singleReader

- Constructor Detail
  - DbContextSelectBuilder
```
public DbContextSelectBuilder(DbContextTable dbContextTable)
```
- Method Detail
  - query
```
public DbContextSelectBuilder query()
```
    Returns this. Needed to make DbContextSelectBuilder interchangeable with DbContextTable
    
    Specified by:
    
    query in interface DatabaseQueryable<DbContextSelectBuilder>
  - whereExpressionWithParameterList
```
public DbContextSelectBuilder whereExpressionWithParameterList(String expression,
                                                               Collection<?> parameters)
```
    Adds the expression to the WHERE-clause and all the values to the parameter list. E.g. whereExpressionWithParameterList("created_at between ? and ?", List.of(earliestDate, latestDate))
    
    Specified by:
    
    whereExpressionWithParameterList in interface DatabaseQueryable<DbContextSelectBuilder>
  - orderBy
```
public DbContextSelectBuilder orderBy(String orderByClause)
```
    Adds ORDER BY ... clause to the SELECT statement
    
    Specified by:
    
    orderBy in interface DbContextListableSelect<DbContextSelectBuilder>
  - unordered
```
@CheckReturnValue
public DbContextSelectBuilder unordered()
```
    If you haven't called orderBy(java.lang.String), the results of list(org.fluentjdbc.DatabaseResult.RowMapper<T>) will be unpredictable. Call unordered() if you are okay with this.
  - skipAndLimit
```
public DbContextSelectBuilder skipAndLimit(int offset,
                                           int rowCount)
```
    Adds OFFSET ... ROWS FETCH ... ROWS ONLY clause to the SELECT statement. FETCH FIRST was introduced in SQL:2008 and is supported by Postgresql 8.4, Oracle 12c, IBM DB2, HSQLDB, H2, and SQL Server 2012.
    
    Specified by:
    
    skipAndLimit in interface DbContextListableSelect<DbContextSelectBuilder>
  - executeDelete
```
public int executeDelete()
```
    Executes DELETE FROM tableName WHERE ....
  - stream
```
public <T> Stream<T> stream(DatabaseResult.RowMapper<T> mapper)
```
    Execute the query and map each return value over the DatabaseResult.RowMapper function to return a stream. Example:
    table.where("status", status).stream(row -> row.getInstant("created_at"))
    Specified by:
    
    stream in interface DbContextListableSelect<DbContextSelectBuilder>
  - list
```
public <T> List<T> list(DatabaseResult.RowMapper<T> mapper)
```
    Execute the query and map each return value over the DatabaseResult.RowMapper function to return a list. Example:
    List<Instant> creationTimes = table.where("status", status).list(row -> row.getInstant("created_at"))
    Specified by:
    
    list in interface DbContextListableSelect<DbContextSelectBuilder>
  - getCount
```
public int getCount()
```
    Executes SELECT count(*) FROM ... on the query and returns the result
    
    Specified by:
    
    getCount in interface DbContextListableSelect<DbContextSelectBuilder>
  - singleObject
```
@Nonnull
public <T> Optional<T> singleObject(DatabaseResult.RowMapper<T> mapper)
```
    If the query returns no rows, returns Optional.empty(), if exactly one row is returned, maps it and return it, if more than one is returned, throws `IllegalStateException`
    
    Specified by:
    
    singleObject in interface DbContextListableSelect<DbContextSelectBuilder>
    
    Parameters:
    
    mapper - Function object to map a single returned row to a object
    
    Returns:
    
    the mapped row if one row is returned, Optional.empty otherwise
    
    Throws:
    
    IllegalStateException - if more than one row was matched the the query
  - singleString
```
@Nonnull
public Optional<String> singleString(String fieldName)
```
    Returns a string from the specified column name
    
    Specified by:
    
    singleString in interface DbContextListableSelect<DbContextSelectBuilder>
    
    Returns:
    
    the mapped row if one row is returned, Optional.empty otherwise
    
    Throws:
    
    IllegalStateException - if more than one row was matched the the query
  - forEach
```
public void forEach(DatabaseResult.RowConsumer consumer)
```
    Executes the SELECT * FROM ... statement and calls back to DatabaseResult.RowConsumer for each returned row
    
    Specified by:
    
    forEach in interface DbContextListableSelect<DbContextSelectBuilder>
  - update
```
@CheckReturnValue
public DbContextUpdateBuilder update()
```
    Creates a DbContextUpdateBuilder object to fluently generate a UPDATE ... statement

Class DbContextSelectBuilder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface org.fluentjdbc.DatabaseQueryable

Methods inherited from interface org.fluentjdbc.DbContextListableSelect

Constructor Detail

DbContextSelectBuilder

Method Detail

query

whereExpressionWithParameterList

orderBy

unordered

skipAndLimit

executeDelete

stream

list

getCount

singleObject

singleString

forEach

update