Package org.jobrunr.storage.sql.common.db

Class Sql<T>

java.lang.Object

org.jobrunr.storage.sql.common.db.Sql<T>

Direct Known Subclasses:

BackgroundJobServerTable, JobStatsView, JobTable, MetadataTable, RecurringJobTable

public class Sql<T>
extends Object

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	Sql()

Method Summary

Modifier and Type	Method	Description
int	delete(String statement)
Stream<SqlResultSet>	execute(String statement)
static <T> Sql<T>	forType(Class<T> tClass)
void	insert(String statement)
void	insert(T item, String statement)
void	insertAll(List<T> batchCollection, String statement)
Stream<SqlResultSet>	select(String statement)
long	selectCount(String statement)
boolean	selectExists(String statement)
long	selectSum(String column)
void	update(String statement)
void	update(T item, String statement)
void	updateAll(List<T> batchCollection, String statement)
Sql<T>	using(Connection connection, Dialect dialect, String tablePrefix, String tableName)
Sql<T>	with(String name, Enum<?> value)
Sql<T>	with(String name, Object value)
Sql<T>	with(String name, Function<T,Object> function)
Sql<T>	withOrderLimitAndOffset(String order, int limit, long offset)
Sql<T>	withVersion(Function<T,Integer> function)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Sql

protected Sql()

Method Details

forType

public static <T> Sql<T> forType(Class<T> tClass)

using

public Sql<T> using(Connection connection,
 Dialect dialect,
 String tablePrefix,
 String tableName)

with

public Sql<T> with(String name,
 Enum<?> value)

with

public Sql<T> with(String name,
 Object value)

with

public Sql<T> with(String name,
 Function<T,Object> function)

withVersion

public Sql<T> withVersion(Function<T,Integer> function)

withOrderLimitAndOffset

public Sql<T> withOrderLimitAndOffset(String order,
 int limit,
 long offset)

select

public Stream<SqlResultSet> select(String statement)

execute

public Stream<SqlResultSet> execute(String statement)

selectCount

public long selectCount(String statement)
                 throws SQLException

Throws:

SQLException

selectSum

public long selectSum(String column)
               throws SQLException

Throws:

SQLException

selectExists

public boolean selectExists(String statement)
                     throws SQLException

Throws:

SQLException

insert

public void insert(T item,
 String statement)
            throws SQLException

Throws:

SQLException

insert

public void insert(String statement)
            throws SQLException

Throws:

SQLException

update

public void update(String statement)
            throws SQLException

Throws:

SQLException

update

public void update(T item,
 String statement)
            throws SQLException

Throws:

SQLException

delete

public int delete(String statement)
           throws SQLException

Throws:

SQLException

insertAll

public void insertAll(List<T> batchCollection,
 String statement)
               throws SQLException

Throws:

SQLException

updateAll

public void updateAll(List<T> batchCollection,
 String statement)
               throws SQLException

Throws:

SQLException