org.jooq.util.sqlite
Class SQLiteFactory

java.lang.Object
  org.jooq.impl.Factory
      org.jooq.util.sqlite.SQLiteFactory

All Implemented Interfaces:

Serializable, Configuration, FactoryOperations

public class SQLiteFactory
extends Factory

A SQLDialect.SQLITE specific factory

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

SQLiteFactory(Connection connection)
Create a factory with connection

SQLiteFactory(Connection connection, SchemaMapping mapping)
Deprecated. - 2.0.5 - Use SQLiteFactory(Connection, Settings) instead

SQLiteFactory(Connection connection, Settings settings)
Create a factory with connection and a settings configured

Method Summary

static Field<Long>

rowid() Retrieve the SQLite-specific _rowid_ pseudo-field.

Methods inherited from class org.jooq.impl.Factory

abs, abs, acos, acos, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, attach, attach, avg, avgDistinct, batch, batch, batch, bind, bindContext, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, concat, concat, condition, condition, connectByIsCycle, connectByIsLeaf, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, currval, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, deleteQuery, denseRank, e, escape, escape, execute, execute, executeDelete, executeDelete, executeDeleteOne, executeDeleteOne, executeInsert, executeUpdate, executeUpdate, executeUpdateOne, executeUpdateOne, exists, exp, exp, extract, extract, falseCondition, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchLazy, fetchLazy, fetchMany, fetchMany, fetchOne, fetchOne, fetchOne, fetchOne, field, field, field, field, field, field, field, field, field, firstValue, floor, floor, function, function, getConnection, getData, getData, getDataType, getDialect, getSchemaMapping, getSettings, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, insertInto, insertInto, insertInto, insertInto, insertQuery, lag, lag, lag, lag, lastID, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, literal, literal, literal, ln, ln, loadInto, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, median, mergeInto, min, minDistinct, minute, minute, month, month, newRecord, newRecord, newRecord, nextval, notExists, ntile, nullif, nullif, nullif, nullif, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, param, param, param, param, percentRank, pi, position, position, position, position, power, power, power, power, prior, query, query, rad, rad, rand, rank, render, renderContext, renderInlined, renderNamedParams, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, rollup, round, round, round, round, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, second, second, select, select, selectCount, selectDistinct, selectDistinct, selectFrom, selectOne, selectQuery, selectQuery, selectZero, setConnection, setData, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, tan, tan, tanh, tanh, timestampDiff, timestampDiff, timestampDiff, timestampDiff, toString, trim, trim, trueCondition, truncate, two, unnest, unnest, unnest, unnest, update, updateQuery, upper, upper, use, use, val, val, val, val, vals, value, value, value, value, varPop, varSamp, year, year, zero

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLiteFactory

@Deprecated
public SQLiteFactory(Connection connection,
                                SchemaMapping mapping)

Deprecated. - 2.0.5 - Use SQLiteFactory(Connection, Settings) instead

Create a factory with connection and a schema mapping configured

Parameters:

connection - The connection to use with objects created from this factory

mapping - The schema mapping to use with objects created from this factory

SQLiteFactory

public SQLiteFactory(Connection connection,
                     Settings settings)

Create a factory with connection and a settings configured

Parameters:

connection - The connection to use with objects created from this factory

settings - The runtime settings to apply to objects created from this factory

SQLiteFactory

public SQLiteFactory(Connection connection)

Create a factory with connection

Parameters:

connection - The connection to use with objects created from this factory

Method Detail

rowid

public static Field<Long> rowid()

Retrieve the SQLite-specific _rowid_ pseudo-field. _rowid_ was chosen over rowid as it is less likely to be used as an actual table column in client code.

See Also:

http://www.sqlite.org/lang_createtable.html#rowid