Uses of Class
com.gengoai.sql.SQLContext

Packages that use SQLContext

Package	Description
com.gengoai.sql
com.gengoai.sql.object
com.gengoai.sql.statement

Uses of SQLContext in com.gengoai.sql

Methods in com.gengoai.sql that return SQLContext

Modifier and Type	Method	Description
static SQLContext	SQLContext.create(@NonNull Connection connection, @NonNull SQLDialect dialect)	Creates an SQLContext from the given JDBC Connection and will generate SQL using the given SQLDialect**.

Constructors in com.gengoai.sql with parameters of type SQLContext

Constructor	Description
SQLProber(SQLContext context)

Uses of SQLContext in com.gengoai.sql.object

Methods in com.gengoai.sql.object with parameters of type SQLContext

Modifier and Type	Method	Description
int	Table.batchInsert(@NonNull SQLContext context, @NonNull Stream<Map<String,?>> values)	Batch insert int.
int	Table.batchUpsert(@NonNull SQLContext context, @NonNull List<String> indexedColumns, @NonNull Stream<Map<String,?>> values)	Batch upsert int.
long	Table.count(@NonNull SQLContext context)	Performs a select count(0) from this table.
boolean	SQLObject.create(@NonNull SQLContext context)
boolean	SQLObject.createIfNotExists(@NonNull SQLContext context)
int	Table.delete(@NonNull SQLContext context, @NonNull SQLElement where)	Deletes all rows matching the given where criteria
int	Table.deleteAll(@NonNull SQLContext context)	Deletes all rows from the table
boolean	SQLObject.drop(@NonNull SQLContext context)
boolean	SQLObject.dropIfExists(@NonNull SQLContext context)
boolean	Table.dropIndex(@NonNull SQLContext context, String name)	Drop index boolean.
boolean	Table.dropIndexIfExists(@NonNull SQLContext context, String name)	Drop index if exists boolean.
boolean	Table.exists(@NonNull SQLContext context)	Checks if this table exists in the database using the given SQLContext
int	Table.insert(@NonNull SQLContext context, @NonNull Map<String,Object> values)	Insert int.
int	Table.update(@NonNull SQLContext context, @NonNull UpdateType updateType, @NonNull Map<String,SQLElement> setParameters, @NonNull SQLElement where)
int	Table.update(@NonNull SQLContext context, @NonNull Map<String,SQLElement> setParameters, @NonNull SQLElement where)
boolean	Table.upsert(@NonNull SQLContext context, String indexedColumn, @NonNull Map<String,Object> values)	Perform an upsert on the table using the given context, list of columns to base the upsert on, and values to upserted.
boolean	Table.upsert(@NonNull SQLContext context, List<String> indexedColumns, @NonNull Map<String,Object> values)	Perform an upsert on the table using the given context, list of columns to base the upsert on, and values to upserted.

Uses of SQLContext in com.gengoai.sql.statement

Methods in com.gengoai.sql.statement with parameters of type SQLContext

Modifier and Type	Method	Description
default <T> int	UpdateStatement.batch(@NonNull SQLContext context, @NonNull Collection<? extends T> items, @NonNull CheckedBiConsumer<T,NamedPreparedStatement> statementFiller)	Performs a batch update over a Collection of items filling the NamedPreparedStatement using the given CheckedBiConsumer.
default <T> int	UpdateStatement.batch(@NonNull SQLContext context, @NonNull Collection<? extends T> items, @NonNull CheckedBiConsumer<T,NamedPreparedStatement> statementFiller, int batchSize)	Performs a batch update over a Collection of items filling the NamedPreparedStatement using the given CheckedBiConsumer.
default int	UpdateStatement.batch(@NonNull SQLContext context, @NonNull Collection<Map<String,?>> items)	Performs a batch update over a Collection of Maps whose keys are column names and values of the column.
default int	UpdateStatement.batch(@NonNull SQLContext context, @NonNull Collection<Map<String,?>> items, int batchSize)	Performs a batch update over a Collection of Maps whose keys are column names and values of the column.
default <T> int	UpdateStatement.batch(@NonNull SQLContext context, @NonNull Stream<? extends T> items, @NonNull CheckedBiConsumer<T,NamedPreparedStatement> statementFiller)	Performs a batch update over a Stream of items filling the NamedPreparedStatement using the given CheckedBiConsumer.
default <T> int	UpdateStatement.batch(@NonNull SQLContext context, @NonNull Stream<? extends T> items, @NonNull CheckedBiConsumer<T,NamedPreparedStatement> statementFiller, int batchSize)	Performs a batch update over a Stream of items filling the NamedPreparedStatement using the given CheckedBiConsumer.
boolean	QueryStatement.exists(@NonNull SQLContext context)	Runs the query returning true if there is at least on result.
ResultSet	QueryStatement.query(@NonNull SQLContext context)	Runs the query on the given context returning a ResultSet
<T> Stream<T>	QueryStatement.query(@NonNull SQLContext context, @NonNull ResultSetMapper<? extends T> resultSetMapper)	Performs the query specified in this statement using the given SQLContext returning the results as a ResultSetIterator using the given ResultSetMapper to map ResultSet to objects
<T> Stream<T>	QueryStatement.query(@NonNull SQLContext context, @NonNull List<?> values, @NonNull ResultSetMapper<? extends T> resultSetMapper)	Performs the query specified in this statement using the given SQLContext filling in indexed value placeholders using the given List of values and returning the results as a ResultSetIterator* using the given ResultSetMapper to map ResultSet to objects
<T> Stream<T>	QueryStatement.query(@NonNull SQLContext context, @NonNull Map<String,?> values, @NonNull ResultSetMapper<? extends T> resultSetMapper)	Performs the query specified in this statement using the given SQLContext filling in named value placeholders using the given Map of values and returning the results as a ResultSetIterator using the given ResultSetMapper to map ResultSet to objects
<T> Stream<T>	Select.queryParallel(@NonNull SQLContext context, @NonNull ResultSetMapper<? extends T> mapper, @NonNull String partitionColumn)	Performs this Select query using the given SQLContext using the given ResultSetMapper to map ResultSet to objects.
<T> Stream<T>	Select.queryParallel(@NonNull SQLContext context, @NonNull ResultSetMapper<? extends T> mapper, @NonNull String partitionColumn, int numPartitions)	Performs this Select query using the given SQLContext using the given ResultSetMapper to map ResultSet to objects.
<T> Stream<T>	Select.queryParallel(@NonNull SQLContext context, @NonNull List<?> values, @NonNull ResultSetMapper<? extends T> mapper, @NonNull String partitionColumn, int numPartitions)	Performs this Select query using the given SQLContext filling in indexed value placeholders using the given Map of values and returning the results as a ResultSetIterator using the given ResultSetMapper* to map ResultSet to objects.
<T> Stream<T>	Select.queryParallel(@NonNull SQLContext context, @NonNull List<Object> values, @NonNull ResultSetMapper<? extends T> mapper, @NonNull String partitionColumn)	Performs this Select query using the given SQLContext filling in indexed value placeholders using the given Map of values and returning the results as a ResultSetIterator using the given ResultSetMapper to map ResultSet to objects.
<T> Stream<T>	Select.queryParallel(@NonNull SQLContext context, @NonNull Map<String,?> values, @NonNull ResultSetMapper<? extends T> mapper, @NonNull String partitionColumn)	Performs this Select query using the given SQLContext filling in named value placeholders using the given Map of values and returning the results as a ResultSetIterator using the given ResultSetMapper* to map ResultSet to objects.
<T> Stream<T>	Select.queryParallel(@NonNull SQLContext context, @NonNull Map<String,?> values, @NonNull ResultSetMapper<? extends T> mapper, @NonNull String partitionColumn, int numPartitions)	Performs this Select query using the given SQLContext filling in named value placeholders using the given Map of values and returning the results as a ResultSetIterator using the given ResultSetMapper to map ResultSet to objects.
<T> T	QueryStatement.queryScalar(@NonNull SQLContext context, @NonNull Class<T> tClass)	Performs this query on the given SQLContext which expects a single value for a single column to return.
Double	QueryStatement.queryScalarDouble(@NonNull SQLContext context)	Performs this query on the given SQLContext which expects a single value for a single column to return.
Long	QueryStatement.queryScalarLong(@NonNull SQLContext context)	Performs this query on the given SQLContext which expects a single value for a single column to return.
String	QueryStatement.queryScalarString(@NonNull SQLContext context)	Performs this query on the given SQLContext which expects a single value for a single column to return.
default int	UpdateStatement.update(@NonNull SQLContext context)	Performs the update using the given SQLContext
default int	UpdateStatement.update(@NonNull SQLContext context, @NonNull List<Object> values)	Performs the update using the given SQLContext filling in indexed value placeholders using the given List of values.
default int	UpdateStatement.update(@NonNull SQLContext context, @NonNull Map<String,Object> values)	Performs the update using the given SQLContext filling in named value placeholders using the given Map of values.
default <T> int	UpdateStatement.update(@NonNull SQLContext context, T value, @NonNull CheckedBiConsumer<? super T,NamedPreparedStatement> statementFiller)	Performs the update s using the given SQLContext filling in value placeholders using the given value and the consumer to for filling the statement.