Index (MySQLw 1.9 API)

A B C D E F G H I J K L M N O P Q R S T U V W Y
All Classes and Interfaces|All Packages|Serialized Form

A

add(int, QueryConditions.ConditionKeyword, QueryCondition) - Method in class com.ptsmods.mysqlw.query.QueryConditions: Adds a new QueryCondition at a specific index with a specific keyword.
add(int, E) - Method in class com.ptsmods.mysqlw.collection.DbList
add(QueryConditions.ConditionKeyword, QueryCondition) - Method in class com.ptsmods.mysqlw.query.QueryConditions: Adds a QueryCondition with a specific keyword to the end.
add(E) - Method in class com.ptsmods.mysqlw.collection.DbList
add(E) - Method in class com.ptsmods.mysqlw.collection.DbSet
add(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryFunction: Creates a basic new QueryFunction that adds two columns or variables together.
addAll(int, Collection<? extends E>) - Method in class com.ptsmods.mysqlw.collection.DbList
addAll(Collection<? extends E>) - Method in class com.ptsmods.mysqlw.collection.DbList
addAll(Collection<? extends E>) - Method in class com.ptsmods.mysqlw.collection.DbSet
addAllAsync(int, Collection<? extends E>) - Method in class com.ptsmods.mysqlw.collection.DbList
addAllAsync(Collection<? extends E>) - Method in class com.ptsmods.mysqlw.collection.DbList
addAllAsync(Collection<? extends E>) - Method in class com.ptsmods.mysqlw.collection.DbSet
addAsync(int, E) - Method in class com.ptsmods.mysqlw.collection.DbList
addAsync(E) - Method in class com.ptsmods.mysqlw.collection.DbList
addAsync(E) - Method in class com.ptsmods.mysqlw.collection.DbSet
addCheck(QueryCondition) - Method in class com.ptsmods.mysqlw.table.TablePreset: Adds a new check constraint insertions and updates must comply with to be valid.
addColumn(String, String, ColumnStructure<?>, String) - Method in class com.ptsmods.mysqlw.Database: Adds a new column to the given table.
addColumnAsync(String, String, ColumnStructure<?>, String) - Method in class com.ptsmods.mysqlw.Database: Adds a new column to the given table asynchronously.
addForeignKey(ForeignKey) - Method in class com.ptsmods.mysqlw.table.TablePreset: Add a foreign key to this preset.
addForeignKey(ForeignKey.Builder) - Method in class com.ptsmods.mysqlw.table.TablePreset: Add a foreign key to this preset.
addIndex(TableIndex) - Method in class com.ptsmods.mysqlw.table.TablePreset: Adds a TableIndex to this preset.
AFTER_DELETE - Enum constant in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent
AFTER_INSERT - Enum constant in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent
AFTER_UPDATE - Enum constant in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent
alias(String) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Sets the alias of the table to select from used when selecting.
Mostly only useful in combination with SelectBuilder.join(Join)
alias(String) - Method in class com.ptsmods.mysqlw.query.Join.Builder
and(int, QueryCondition) - Method in class com.ptsmods.mysqlw.query.QueryConditions: Adds a QueryCondition with the AND keyword at a specific index.
and(QueryCondition) - Method in class com.ptsmods.mysqlw.query.QueryConditions: Adds a QueryCondition with the AND keyword to the end.
AND - Enum constant in enum class com.ptsmods.mysqlw.query.QueryConditions.ConditionKeyword: Implies that both the previous QueryConditions and the next one must be true to return a row.
apply(T) - Method in class com.ptsmods.mysqlw.table.configurable.DynamicConfigurable.DefaultedDynamicConfigurable
apply(T[]) - Method in class com.ptsmods.mysqlw.table.configurable.DynamicNConfigurable.DefaultedDynamicNConfigurable
apply(T1, T2) - Method in class com.ptsmods.mysqlw.table.configurable.Dynamic2Configurable.DefaultedDynamic2Configurable
applyDefault() - Method in interface com.ptsmods.mysqlw.table.configurable.Defaultable: Configures this configurable with the set default value if one is set.
applyDefault() - Method in class com.ptsmods.mysqlw.table.configurable.Dynamic2Configurable.DefaultedDynamic2Configurable
applyDefault() - Method in class com.ptsmods.mysqlw.table.configurable.DynamicConfigurable.DefaultedDynamicConfigurable
applyDefault() - Method in interface com.ptsmods.mysqlw.table.configurable.DynamicNConfigurable
applyDefault() - Method in class com.ptsmods.mysqlw.table.configurable.DynamicNConfigurable.DefaultedDynamicNConfigurable
ASC - Enum constant in enum class com.ptsmods.mysqlw.query.QueryOrder.OrderDirection: Ascending order (e.g.
AsyncSQLException - Exception Class in com.ptsmods.mysqlw
AsyncSQLException(Throwable, Exception) - Constructor for exception class com.ptsmods.mysqlw.AsyncSQLException

B

BEFORE_DELETE - Enum constant in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent
BEFORE_INSERT - Enum constant in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent
BEFORE_UPDATE - Enum constant in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent
begin() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
begin() - Static method in class com.ptsmods.mysqlw.procedure.stmt.misc.BeginStmt
BeginStmt - Class in com.ptsmods.mysqlw.procedure.stmt.misc
BIGINT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Big integer type (long)
SIGNED: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
UNSIGNED: 0 to 18,446,744,073,709,551,615
BINARY - Enum constant in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Marks any String type as a binary string.
BINARY - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Same as ColumnType.CHAR except Strings are stored as binary byte strings rather than character strings.
BLOB - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Binary Large OBject
Max size:65,635 bytes
Used for storing various types of files, s.a.
block() - Static method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
block(Statement...) - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.StatementBlock
block(Iterable<Statement>) - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.StatementBlock
BlockBuilder - Class in com.ptsmods.mysqlw.procedure
BlockLikeStatement - Interface in com.ptsmods.mysqlw.procedure.stmt.block: Statements implementing this interface output multi-statement blocks.
bool(String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
BOOLEAN - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Boolean type (tinyint)
Basically the same as a ColumnType.TINYINT, but with a length of 1.
Gets treated as a boolean by MySQL and the MySQL connector.
build() - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder
build() - Method in class com.ptsmods.mysqlw.query.Join.Builder
build() - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
build(Database.RDBMS) - Method in class com.ptsmods.mysqlw.table.TablePreset: Builds the type strings of all columns and maps them to their name.
buildBlock() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
builder() - Static method in class com.ptsmods.mysqlw.procedure.BlockBuilder
builder() - Static method in class com.ptsmods.mysqlw.query.GroupBy
builder() - Static method in class com.ptsmods.mysqlw.query.Join
builder() - Static method in class com.ptsmods.mysqlw.table.ForeignKey
builder(Database.RDBMS) - Static method in class com.ptsmods.mysqlw.procedure.BlockBuilder
buildQuery() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
buildQuery() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Builds a SELECT query from this builder.
buildQuery(Database.RDBMS) - Method in class com.ptsmods.mysqlw.table.TablePreset: Builds the query to create a table representing this preset.
buildQuery(StringBuilder) - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
buildReplaceQuery() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
buildReplaceUpdateQuery() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
buildString() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
buildTypeString(Database.RDBMS) - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Builds the type string for the given database type.
by(String) - Static method in class com.ptsmods.mysqlw.query.QueryOrder: Order by a column in an ascending direction.
by(String, QueryOrder.OrderDirection) - Static method in class com.ptsmods.mysqlw.query.QueryOrder: Order by a column in the given direction.

C

call(String, Object...) - Method in class com.ptsmods.mysqlw.Database: Calls a procedure with the given parameters.
callAsync(String, Object...) - Method in class com.ptsmods.mysqlw.Database: Asynchronously calls a procedure with the given parameters.
canEqual(Object) - Method in class com.ptsmods.mysqlw.Pair
canEqual(Object) - Method in class com.ptsmods.mysqlw.query.Join
CASCADE - Enum constant in enum class com.ptsmods.mysqlw.table.ForeignKey.Action
case_(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.conditional.CaseBlock
case_(String, Consumer<CaseBlock>) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
CaseBlock - Class in com.ptsmods.mysqlw.procedure.stmt.conditional
CHAR - Static variable in class com.ptsmods.mysqlw.table.ColumnType: String with fixed length
Length must be at most 255.
charAt(int) - Method in class com.ptsmods.mysqlw.query.QueryFunction
checkNotNull(T, Object) - Static method in class com.ptsmods.mysqlw.Database
clear() - Method in class com.ptsmods.mysqlw.collection.DbList
clear() - Method in class com.ptsmods.mysqlw.collection.DbMap
clear() - Method in class com.ptsmods.mysqlw.collection.DbSet
clearAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
clearAsync() - Method in class com.ptsmods.mysqlw.collection.DbMap
clearAsync() - Method in class com.ptsmods.mysqlw.collection.DbSet
clearColumns() - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder
clearUsing() - Method in class com.ptsmods.mysqlw.query.Join.Builder
clone() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
clone() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
clone() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
clone() - Method in class com.ptsmods.mysqlw.table.TableIndex
clone() - Method in class com.ptsmods.mysqlw.table.TableIndexType
clone() - Method in class com.ptsmods.mysqlw.table.TablePreset
close(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.cursor.CloseCursorStmt
closeCursor(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
CloseCursorStmt - Class in com.ptsmods.mysqlw.procedure.stmt.cursor
ClosingStatement - Interface in com.ptsmods.mysqlw.procedure.stmt.block: Utility class denoting a statement closes a block of statements.
column(String) - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
column(String) - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder
ColumnAttributes - Enum Class in com.ptsmods.mysqlw.table: Certain attributes the type of a column may have.
ColumnDefault - Class in com.ptsmods.mysqlw.table: The default value of a column.
columns(Collection<? extends String>) - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder
ColumnStructure<C> - Class in com.ptsmods.mysqlw.table: A structure used to describe a column.
Used when making new tables.
Acquire a ColumnStructure via ColumnType.struct() on any of the types in that class.
ColumnType<S> - Class in com.ptsmods.mysqlw.table
com.ptsmods.mysqlw - package com.ptsmods.mysqlw
com.ptsmods.mysqlw.collection - package com.ptsmods.mysqlw.collection
com.ptsmods.mysqlw.procedure - package com.ptsmods.mysqlw.procedure
com.ptsmods.mysqlw.procedure.stmt - package com.ptsmods.mysqlw.procedure.stmt
com.ptsmods.mysqlw.procedure.stmt.block - package com.ptsmods.mysqlw.procedure.stmt.block
com.ptsmods.mysqlw.procedure.stmt.conditional - package com.ptsmods.mysqlw.procedure.stmt.conditional
com.ptsmods.mysqlw.procedure.stmt.cursor - package com.ptsmods.mysqlw.procedure.stmt.cursor
com.ptsmods.mysqlw.procedure.stmt.loop - package com.ptsmods.mysqlw.procedure.stmt.loop
com.ptsmods.mysqlw.procedure.stmt.misc - package com.ptsmods.mysqlw.procedure.stmt.misc
com.ptsmods.mysqlw.procedure.stmt.query - package com.ptsmods.mysqlw.procedure.stmt.query
com.ptsmods.mysqlw.procedure.stmt.vars - package com.ptsmods.mysqlw.procedure.stmt.vars
com.ptsmods.mysqlw.query - package com.ptsmods.mysqlw.query
com.ptsmods.mysqlw.query.builder - package com.ptsmods.mysqlw.query.builder
com.ptsmods.mysqlw.table - package com.ptsmods.mysqlw.table
com.ptsmods.mysqlw.table.configurable - package com.ptsmods.mysqlw.table.configurable
condition(QueryCondition) - Method in class com.ptsmods.mysqlw.query.Join.Builder
condition(String) - Static method in class com.ptsmods.mysqlw.procedure.ConditionValue
CONDITION - Enum constant in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
ConditionValue - Class in com.ptsmods.mysqlw.procedure
ConditionValue.Type - Enum Class in com.ptsmods.mysqlw.procedure
configure(Function<C, String>) - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Run and return the value of the supplier of the selected ColumnType.

This must be called if the ColumnType of this structure has no default values set for its supplier.
(This is the case for e.g.
connect(File) - Static method in class com.ptsmods.mysqlw.Database: Makes a new connection to an SQLite database or creates it if it does not yet exist.
connect(String, int, String, String, String) - Static method in class com.ptsmods.mysqlw.Database: Makes a connection to a MySQL database.
connect(Connection) - Static method in class com.ptsmods.mysqlw.Database: Wraps an SQL connection in a Database.
contains(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
contains(Object) - Method in class com.ptsmods.mysqlw.collection.DbSet
contains(Object) - Method in class com.ptsmods.mysqlw.query.SelectResults
containsAll(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbList
containsAll(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbSet
containsAllAsync(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbList
containsAllAsync(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbSet
containsAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
containsAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbSet
containsKey(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
containsKey(Object) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
containsKeyAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
containsValue(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
containsValueAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
CONTINUE - Enum constant in enum class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt.HandlerAction
count(String) - Static method in class com.ptsmods.mysqlw.query.QueryFunction: Creates a basic new QueryFunction that counts rows.
count(String, String) - Method in class com.ptsmods.mysqlw.Database: Counts columns in a table.
count(String, String, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Counts columns in a table.
countAsync(String, String) - Method in class com.ptsmods.mysqlw.Database: Counts columns in a table asynchronously.
countAsync(String, String, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Counts columns in a table asynchronously.
create() - Static method in class com.ptsmods.mysqlw.query.QueryConditions
create(Database) - Method in class com.ptsmods.mysqlw.table.TablePreset: Builds a query and executes it on the given database.
create(Database, SelectBuilder) - Static method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Create a new SelectBuilder selecting data from another select query on the given Database.
create(Database, String) - Static method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Create a new SelectBuilder selecting data from the given table on the given Database.
create(Database, String, String...) - Static method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
create(Database, String, List<String>) - Static method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
create(SelectBuilder) - Static method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Create a new SelectBuilder for use in BlockBuilders.
create(QueryCondition) - Static method in class com.ptsmods.mysqlw.query.QueryConditions
create(String) - Static method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Create a new SelectBuilder for use in BlockBuilders.
create(String) - Static method in class com.ptsmods.mysqlw.table.TablePreset: Create a new TablePreset with the given name.
create(String, String...) - Static method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
create(String, List<String>) - Static method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
createAsync(Database) - Method in class com.ptsmods.mysqlw.table.TablePreset: Builds a query and executes it on the given database asynchronously.
createConnection(String) - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
createConnection(String, String, String) - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
createIndex(String, TableIndex) - Method in class com.ptsmods.mysqlw.Database: Create a new index on an existing column in an existing table.
createIndexAsync(String, TableIndex) - Method in class com.ptsmods.mysqlw.Database: Create a new index on an existing column in an existing table asynchronously.
createProcedure(String, ProcedureParameter[], BlockBuilder) - Method in class com.ptsmods.mysqlw.Database: Creates a new procedure with the given statements.
createProcedureAsync(String, ProcedureParameter[], BlockBuilder) - Method in class com.ptsmods.mysqlw.Database: Asynchronously creates a new procedure with the given statements.
createStatement() - Method in class com.ptsmods.mysqlw.Database: Creates a new statement.
createStructure() - Method in class com.ptsmods.mysqlw.table.ColumnType: Deprecated.
Use the shorthand ColumnType.struct() instead.
createTable(TablePreset) - Method in class com.ptsmods.mysqlw.Database: Creates a table from a preset.
createTableAsync(TablePreset) - Method in class com.ptsmods.mysqlw.Database: Creates a table from a preset asynchronously.
createTrigger(String, String, TriggeringEvent, BlockBuilder) - Method in class com.ptsmods.mysqlw.Database: Creates a new trigger with the given statements.
createTriggerAsync(String, String, TriggeringEvent, BlockBuilder) - Method in class com.ptsmods.mysqlw.Database: Asynchronously creates a new trigger with the given statements.
CROSS - Enum constant in enum class com.ptsmods.mysqlw.query.JoinType
CURRENT_TIMESTAMP - Static variable in class com.ptsmods.mysqlw.table.ColumnDefault: Whenever a new row is made, the value of this column is set to the current TIMESTAMP.

D

Database - Class in com.ptsmods.mysqlw
Database.RDBMS - Enum Class in com.ptsmods.mysqlw
DATE - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Date type
A date that supports a value anywhere between 1000-01-01 and 9999-12-31.
Format of its String representation is yyyy-mm-dd.
DATETIME - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Datetime type
A combination of ColumnType.DATE and ColumnType.TIME.
DbCF - Class in com.ptsmods.mysqlw.collection: Database Collection Functions
Functions used to convert instances of various classes to and from Strings.
DbCF() - Constructor for class com.ptsmods.mysqlw.collection.DbCF
DbCollection - Interface in com.ptsmods.mysqlw.collection: An interface implemented by DbList, DbSet and DbMap which always pass themselves as an instance of this interface when converting their key/value or element type to/from a String.
DbList<E> - Class in com.ptsmods.mysqlw.collection
dbListFromStringFunc(Class<E>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
dbListFromStringFunc(BiFunction<E, DbCollection, String>, BiFunction<String, DbCollection, E>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
dbListToStringFunc() - Static method in class com.ptsmods.mysqlw.collection.DbCF
DbMap<K,V> - Class in com.ptsmods.mysqlw.collection
DbMap.DbMapEntry<K,V> - Class in com.ptsmods.mysqlw.collection
dbMapFromStringFunc(Class<K>, Class<V>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
dbMapFromStringFunc(BiFunction<K, DbCollection, String>, BiFunction<V, DbCollection, String>, BiFunction<String, DbCollection, K>, BiFunction<String, DbCollection, V>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
dbMapToStringFunc() - Static method in class com.ptsmods.mysqlw.collection.DbCF
DbSet<E> - Class in com.ptsmods.mysqlw.collection
dbSetFromStringFunc(Class<E>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
dbSetFromStringFunc(BiFunction<E, DbCollection, String>, BiFunction<String, DbCollection, E>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
dbSetToStringFunc() - Static method in class com.ptsmods.mysqlw.collection.DbCF
DECIMAL - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Big decimal type (BigDecimal)
Fixed point
Accurate up to 30 decimal places and up to 65 digits.
By default, accurate up to 0 decimals and 10 digits.
Allowed values: -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38
declare(Database.RDBMS, String[], ColumnStructure<?>) - Static method in class com.ptsmods.mysqlw.procedure.stmt.vars.DeclareStmt
declare(Database.RDBMS, String, ColumnStructure<?>) - Static method in class com.ptsmods.mysqlw.procedure.stmt.vars.DeclareStmt
declare(String[], ColumnStructure<?>) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
declare(String, ColumnStructure<?>) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
declareCondition(String, ConditionValue) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
declareCondition(String, ConditionValue) - Static method in class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareConditionStmt
DeclareConditionStmt - Class in com.ptsmods.mysqlw.procedure.stmt.misc
declareCursor(String, SelectBuilder) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
declareCursor(String, SelectBuilder) - Static method in class com.ptsmods.mysqlw.procedure.stmt.cursor.DeclareCursorStmt
DeclareCursorStmt - Class in com.ptsmods.mysqlw.procedure.stmt.cursor
declareHandler(DeclareHandlerStmt.HandlerAction, ConditionValue, Statement) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
declareHandler(DeclareHandlerStmt.HandlerAction, ConditionValue, Statement) - Static method in class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt
DeclareHandlerStmt - Class in com.ptsmods.mysqlw.procedure.stmt.misc
DeclareHandlerStmt.HandlerAction - Enum Class in com.ptsmods.mysqlw.procedure.stmt.misc
DeclareStmt - Class in com.ptsmods.mysqlw.procedure.stmt.vars
DeclaringStmt - Interface in com.ptsmods.mysqlw.procedure.stmt: Utility class to denote a statement is a declaring statement, because all declaring statements must be at the top of the block.
def(Statement) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.CaseBlock
def(Object) - Static method in class com.ptsmods.mysqlw.table.ColumnDefault: Create a default value for a column.
Defaultable<T,S> - Interface in com.ptsmods.mysqlw.table.configurable: Represents a configurable that may have a default value.
delete(String, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Deletes rows matching the given condition or all when no condition given.
delete(String, QueryCondition, int) - Method in class com.ptsmods.mysqlw.Database: Deletes rows matching the given condition or all when no condition given.
deleteAsync(String, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Deletes rows matching the given condition or all when no condition given asynchronously.
deleteAsync(String, QueryCondition, int) - Method in class com.ptsmods.mysqlw.Database: Deletes rows matching the given condition or all when no condition given asynchronously.
delimiter(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.DelimiterStmt
DelimiterStmt - Class in com.ptsmods.mysqlw.procedure.stmt
DESC - Enum constant in enum class com.ptsmods.mysqlw.query.QueryOrder.OrderDirection: Descending order (e.g 4 -> 3 -> 2 -> 1)
divide(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryFunction: Creates a basic new QueryFunction that divides two columns or variables.
doLog() - Method in class com.ptsmods.mysqlw.Database
DOUBLE - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Regular decimal type (double)
Accurate up to around 16 decimal places.
Allowed values: -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38
drop(String) - Method in class com.ptsmods.mysqlw.Database: Drops (completely removes from existence) a table from this database.
dropAsync(String) - Method in class com.ptsmods.mysqlw.Database: Drops (completely removes from existence) a table from this database asynchronously.
dropColumn(String, String) - Method in class com.ptsmods.mysqlw.Database: Drops a column.
dropColumnAsync(String, String) - Method in class com.ptsmods.mysqlw.Database: Drops a column asynchronously
Dynamic2Configurable<T1,T2> - Interface in com.ptsmods.mysqlw.table.configurable: A function that requires a parameter to be configured.
Dynamic2Configurable.DefaultedDynamic2Configurable<T1,T2> - Class in com.ptsmods.mysqlw.table.configurable
DynamicConfigurable<T> - Interface in com.ptsmods.mysqlw.table.configurable: A function that requires a parameter to be configured.
DynamicConfigurable.DefaultedDynamicConfigurable<T> - Class in com.ptsmods.mysqlw.table.configurable
DynamicNConfigurable<T> - Interface in com.ptsmods.mysqlw.table.configurable: A function that requires an amount of parameters to be configured.
DynamicNConfigurable.DefaultedDynamicNConfigurable<T> - Class in com.ptsmods.mysqlw.table.configurable

E

else_() - Static method in class com.ptsmods.mysqlw.procedure.stmt.conditional.ElseStmt
else_(BlockBuilder) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
else_(Statement) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
elseIf(QueryCondition) - Static method in class com.ptsmods.mysqlw.procedure.stmt.conditional.ElseIfStmt
elseIf(QueryCondition, BlockBuilder) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
elseIf(QueryCondition, Statement) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
ElseIfStmt - Class in com.ptsmods.mysqlw.procedure.stmt.conditional
ElseStmt - Class in com.ptsmods.mysqlw.procedure.stmt.conditional
empty() - Static method in class com.ptsmods.mysqlw.Pair
empty() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
empty() - Static method in class com.ptsmods.mysqlw.procedure.EmptyStmt
EmptyStmt - Class in com.ptsmods.mysqlw.procedure
end() - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
end(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
end(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.EndStmt: End a trigger/procedure
endCase() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
endCase() - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.EndStmt: End a case-block
endIf() - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.EndStmt: End an if-block
endLoop() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
endLoop() - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.EndStmt: End a loop-block
EndStmt - Class in com.ptsmods.mysqlw.procedure.stmt.block: Statement ending a block of statements.
endWhile() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
endWhile() - Static method in class com.ptsmods.mysqlw.procedure.stmt.block.EndStmt: End a while-block
engrave(String) - Static method in class com.ptsmods.mysqlw.Database
enquote(String) - Static method in class com.ptsmods.mysqlw.Database: Puts the given String in quotes and escapes any quotes in it to avoid SQL injection.
entrySet() - Method in class com.ptsmods.mysqlw.collection.DbMap
entrySet() - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
entrySetAsync() - Method in class com.ptsmods.mysqlw.collection.DbMap
ENUM - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Enum type
Can only hold the values given when the table was created (can be altered), the index corresponding with a value or the error value (empty string or 0).
Can hold up to 65,635 different values.
equals(Object) - Method in class com.ptsmods.mysqlw.Pair
equals(Object) - Method in class com.ptsmods.mysqlw.query.Join
equals(Object) - Method in class com.ptsmods.mysqlw.query.SelectResults
equals(String, Object) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
escapeQuotes(String) - Static method in class com.ptsmods.mysqlw.Database: Replaces all single quotes in the string with two single quotes to have MySQL read it as a single quote rather than a string end.
escapeQuotes(String[]) - Static method in class com.ptsmods.mysqlw.Database: The same as Database.escapeQuotes(String) but does it for a whole array of Strings.
execute() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
execute() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Executes the built query and parses it into an instance of SelectResults.
execute(String) - Method in class com.ptsmods.mysqlw.Database: Executes a query and returns a boolean value which can mean anything.
executeAsync() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
executeAsync() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Asynchronously executes the built query and parses it into an instance of SelectResults.
executeAsync(String) - Method in class com.ptsmods.mysqlw.Database: Executes a query and returns a boolean value which can mean anything asynchronously.
executeCount() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Counts the rows this select builder will select.
executeCountAsync() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Counts the rows this select builder will select asynchronously.
executeCountMultiple(Class<T>) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Counts the rows this select builder will select.
executeCountMultipleAsync(Class<T>) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Counts the rows this select builder will select asynchronously.
executeCountRaw() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
executeCountRawAsync() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
executeQuery(String) - Method in class com.ptsmods.mysqlw.Database: Executes a query and returns a ResultSet.
executeQueryAsync(String) - Method in class com.ptsmods.mysqlw.Database: Executes a query and returns a ResultSet asynchronously.
executeRaw() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Executes the built query and returns the raw ResultSet.
executeRawAsync() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: SelectBuilder.executeRaw() but asynchronous.
executeReplace() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
executeReplaceAsync() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
executeReplaceUpdate() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
executeReplaceUpdateAsync() - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
executeUpdate(String) - Method in class com.ptsmods.mysqlw.Database: Executes a query and returns an integer value which often denotes the amount of rows affected.
executeUpdateAsync(String) - Method in class com.ptsmods.mysqlw.Database: Executes a query and returns an integer value which often denotes the amount of rows affected asynchronously.
EXIT - Enum constant in enum class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt.HandlerAction

F

fetch(String, String...) - Static method in class com.ptsmods.mysqlw.procedure.stmt.cursor.FetchCursorStmt
fetchCursor(String, String...) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
FetchCursorStmt - Class in com.ptsmods.mysqlw.procedure.stmt.cursor
FLOAT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Small decimal type (float)
Accurate up to around 7 decimal places.
Allowed values: -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38
foreignKey(String, String, String) - Static method in class com.ptsmods.mysqlw.table.ForeignKey: Create a new foreign key without an onDelete or onUpdate action.
ForeignKey - Class in com.ptsmods.mysqlw.table: An indication that every row in a table references to a row in another table (child/parent rows)
ForeignKey.Action - Enum Class in com.ptsmods.mysqlw.table
ForeignKey.Builder - Class in com.ptsmods.mysqlw.table
formatConnectionUrl(String) - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
fromByteFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
fromDoubleFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
fromFloatFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
fromIntFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
fromLongFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
fromShortFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
FULLTEXT - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndex.Type: Allows you to match pieces of text against the value of this column.
FULLTEXT - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndexType.Type: Allows you to match pieces of text against the value of this column.
func(QueryFunction) - Static method in class com.ptsmods.mysqlw.query.QueryCondition

G

GEOMETRY - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Geometry type
Can store a geometry of any type.
GEOMETRYCOLLECTION - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Geometrycollection type
A collection of geometry objects of any type
This type is not supported by SQLite
get(int) - Method in class com.ptsmods.mysqlw.collection.DbList
get(int) - Method in class com.ptsmods.mysqlw.query.SelectResults
get(Class<T>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
get(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
get(Object) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
get(String, Class<T>) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow: Returns a type registered using Database.registerTypeConverter(Class, Function, Function).
getAlias() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getAlias() - Method in class com.ptsmods.mysqlw.query.Join
getAsString(CharSequence) - Static method in class com.ptsmods.mysqlw.Database: Gets a CharSequence as a String, in case of a QueryFunction this returns its function, in case of an asterisk this returns an asterisk, in all other cases this returns the given CharSequence but surrounded by graves.
getAsString(Object) - Static method in class com.ptsmods.mysqlw.Database: Converts an Object to a String to be used in queries.
getAsync(int) - Method in class com.ptsmods.mysqlw.collection.DbList
getAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
getAttributes() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getBlob(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getBoolean(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getByte(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getByteArray(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getCause() - Method in exception class com.ptsmods.mysqlw.AsyncSQLException: Deprecated.
getChecks() - Method in class com.ptsmods.mysqlw.table.TablePreset
getColumn() - Method in class com.ptsmods.mysqlw.query.QueryOrder
getColumn() - Method in class com.ptsmods.mysqlw.table.ForeignKey
getColumn() - Method in class com.ptsmods.mysqlw.table.TableIndex
getColumn() - Method in class com.ptsmods.mysqlw.table.TableIndexType
getColumns() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getColumns() - Method in class com.ptsmods.mysqlw.query.GroupBy
getColumns() - Method in class com.ptsmods.mysqlw.query.SelectResults
getColumns() - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getColumns() - Method in class com.ptsmods.mysqlw.table.TablePreset
getComment() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getCondition() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getCondition() - Method in class com.ptsmods.mysqlw.query.Join
getCondition() - Method in class com.ptsmods.mysqlw.query.SelectResults
getConnection() - Method in class com.ptsmods.mysqlw.Database: Returns the connection to the dataserver.
getConnectionProperties() - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
getCreateQuery(String) - Method in class com.ptsmods.mysqlw.Database
getCreateQueryAsync(String) - Method in class com.ptsmods.mysqlw.Database
getDatabase(Connection) - Static method in class com.ptsmods.mysqlw.Database: Gets the Database that wraps this connection.
getDatabase(ResultSet) - Static method in class com.ptsmods.mysqlw.Database
getDate(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getDb() - Method in interface com.ptsmods.mysqlw.collection.DbCollection
getDb() - Method in class com.ptsmods.mysqlw.collection.DbList
getDb() - Method in class com.ptsmods.mysqlw.collection.DbMap
getDb() - Method in class com.ptsmods.mysqlw.collection.DbSet
getDb() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getDb() - Method in class com.ptsmods.mysqlw.query.SelectResults
getDef() - Method in class com.ptsmods.mysqlw.table.ColumnDefault
getDefaultExecutor(String) - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
getDefString() - Method in class com.ptsmods.mysqlw.table.ColumnDefault
getDefValue() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getDirection() - Method in class com.ptsmods.mysqlw.query.QueryOrder
getDouble(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getDownloadUrl(String) - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
getElementFromString() - Method in class com.ptsmods.mysqlw.collection.DbList
getElementFromString() - Method in class com.ptsmods.mysqlw.collection.DbSet
getElementToString() - Method in class com.ptsmods.mysqlw.collection.DbList
getElementToString() - Method in class com.ptsmods.mysqlw.collection.DbSet
getErrorCode() - Method in exception class com.ptsmods.mysqlw.SilentSQLException
getErrorHandler() - Method in class com.ptsmods.mysqlw.Database
getException() - Method in exception class com.ptsmods.mysqlw.AsyncSQLException
getExecutor() - Method in class com.ptsmods.mysqlw.collection.DbList
getExecutor() - Method in class com.ptsmods.mysqlw.collection.DbMap
getExecutor() - Method in class com.ptsmods.mysqlw.collection.DbSet
getExecutor() - Method in class com.ptsmods.mysqlw.Database
getExtra() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getFloat(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getForeignKeys() - Method in class com.ptsmods.mysqlw.table.TablePreset
getFrom(Class<T>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
getFromString(String, Class<T>) - Static method in class com.ptsmods.mysqlw.Database: Converts a String
getFunction() - Method in class com.ptsmods.mysqlw.query.QueryFunction
getGroupBy() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getHaving() - Method in class com.ptsmods.mysqlw.query.GroupBy
getIndices() - Method in class com.ptsmods.mysqlw.table.TablePreset
getInitialLoadClass() - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
getInt(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getJoins() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getKey() - Method in class com.ptsmods.mysqlw.collection.DbMap.DbMapEntry
getKeyFromString() - Method in class com.ptsmods.mysqlw.collection.DbMap
getKeyToString() - Method in class com.ptsmods.mysqlw.collection.DbMap
getLeft() - Method in class com.ptsmods.mysqlw.Pair
getLimit() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getLimit() - Method in class com.ptsmods.mysqlw.query.QueryLimit
getLimit() - Method in class com.ptsmods.mysqlw.query.SelectResults
getList(Database, String, Class<E>) - Static method in class com.ptsmods.mysqlw.collection.DbList: Parses a String representation of a DbList into a DbList.
getList(Database, String, BiFunction<E, DbCollection, String>, BiFunction<String, DbCollection, E>) - Static method in class com.ptsmods.mysqlw.collection.DbList: Parses a String representation of a DbList into a DbList.
getLog() - Method in class com.ptsmods.mysqlw.Database
getLong(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getMap(Database, String, BiFunction<K, DbCollection, String>, BiFunction<V, DbCollection, String>, BiFunction<String, DbCollection, K>, BiFunction<String, DbCollection, V>) - Static method in class com.ptsmods.mysqlw.collection.DbMap: Gets a map from cache or creates a new one.
getMap(Database, String, Class<K>, Class<V>) - Static method in class com.ptsmods.mysqlw.collection.DbMap: Gets a map from cache or creates a new one.
getMetadataUrl() - Method in enum class com.ptsmods.mysqlw.Database.RDBMS
getName() - Method in interface com.ptsmods.mysqlw.collection.DbCollection
getName() - Method in class com.ptsmods.mysqlw.collection.DbList
getName() - Method in class com.ptsmods.mysqlw.collection.DbMap
getName() - Method in class com.ptsmods.mysqlw.collection.DbSet
getName() - Method in class com.ptsmods.mysqlw.Database: Attempts to get the name of the database currently in use.
getName() - Method in class com.ptsmods.mysqlw.table.ColumnType
getName() - Method in class com.ptsmods.mysqlw.table.TableIndex
getName() - Method in class com.ptsmods.mysqlw.table.TableIndexType
getName() - Method in class com.ptsmods.mysqlw.table.TablePreset
getNumber(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getOffset() - Method in class com.ptsmods.mysqlw.query.QueryLimit
getOnDelete() - Method in class com.ptsmods.mysqlw.table.ForeignKey
getOnUpdate() - Method in class com.ptsmods.mysqlw.table.ForeignKey
getOrder() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getOrder() - Method in class com.ptsmods.mysqlw.query.SelectResults
getParent() - Method in exception class com.ptsmods.mysqlw.SilentSQLException
getReferenceColumn() - Method in class com.ptsmods.mysqlw.table.ForeignKey
getReferenceTable() - Method in class com.ptsmods.mysqlw.table.ForeignKey
getRight() - Method in class com.ptsmods.mysqlw.Pair
getRows() - Method in class com.ptsmods.mysqlw.query.SelectResults
getSelectionTarget() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getSet(Database, String, Class<E>) - Static method in class com.ptsmods.mysqlw.collection.DbSet: Gets a set from cache or creates a new one.
getSet(Database, String, BiFunction<E, DbCollection, String>, BiFunction<String, DbCollection, E>) - Static method in class com.ptsmods.mysqlw.collection.DbSet: Gets a set from cache or creates a new one.
getShort(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getSQLState() - Method in exception class com.ptsmods.mysqlw.SilentSQLException
getStackTrace() - Method in exception class com.ptsmods.mysqlw.AsyncSQLException
getStatements() - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
getString(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getSupplier() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Deprecated.
Suppliers are now type-specific, please use ColumnStructure.getTypeSpecificSupplier() instead.
getSupplier() - Method in class com.ptsmods.mysqlw.table.ColumnType: Deprecated.
getTable() - Method in interface com.ptsmods.mysqlw.collection.DbCollection
getTable() - Method in class com.ptsmods.mysqlw.collection.DbList
getTable() - Method in class com.ptsmods.mysqlw.collection.DbMap
getTable() - Method in class com.ptsmods.mysqlw.collection.DbSet
getTable() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Deprecated.
Has been renamed to account for different usages. Use SelectBuilder.getSelectionTarget() instead.
getTable() - Method in class com.ptsmods.mysqlw.query.Join
getTable() - Method in class com.ptsmods.mysqlw.query.SelectResults
getTarget() - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
getTime(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getTimestamp(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getTo(Class<T>) - Static method in class com.ptsmods.mysqlw.collection.DbCF
getType() - Method in class com.ptsmods.mysqlw.Database
getType() - Method in class com.ptsmods.mysqlw.procedure.ConditionValue
getType() - Method in class com.ptsmods.mysqlw.query.Join
getType() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getType() - Method in class com.ptsmods.mysqlw.table.TableIndex
getType() - Method in class com.ptsmods.mysqlw.table.TableIndexType
getTypeSpecificSupplier() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getTypeSpecificSupplier() - Method in class com.ptsmods.mysqlw.table.ColumnType
getTypeString() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
getUsing() - Method in class com.ptsmods.mysqlw.query.Join
getUUID(String) - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
getValue() - Method in class com.ptsmods.mysqlw.collection.DbMap.DbMapEntry
getValueFromString() - Method in class com.ptsmods.mysqlw.collection.DbMap
getValueToString() - Method in class com.ptsmods.mysqlw.collection.DbMap
greater(String, Object) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
greaterEqual(String, Object) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
groupBy(GroupBy) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Groups this query by the given group by.
groupBy(GroupBy.Builder) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Groups this query by the given group by.
groupBy(String...) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Groups this query by the specified columns, especially useful in combination with aggregate functions.
GroupBy - Class in com.ptsmods.mysqlw.query
GroupBy.Builder - Class in com.ptsmods.mysqlw.query

H

hasDefault() - Method in interface com.ptsmods.mysqlw.table.configurable.Defaultable
hasDefault() - Method in class com.ptsmods.mysqlw.table.configurable.Dynamic2Configurable.DefaultedDynamic2Configurable
hasDefault() - Method in class com.ptsmods.mysqlw.table.configurable.DynamicConfigurable.DefaultedDynamicConfigurable
hasDefault() - Method in class com.ptsmods.mysqlw.table.configurable.DynamicNConfigurable.DefaultedDynamicNConfigurable
hasDefault() - Method in interface com.ptsmods.mysqlw.table.configurable.DynamicNConfigurable
hashCode() - Method in class com.ptsmods.mysqlw.Pair
hashCode() - Method in class com.ptsmods.mysqlw.query.Join
hashCode() - Method in class com.ptsmods.mysqlw.query.SelectResults
having(QueryCondition) - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder

I

if_(QueryCondition) - Static method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfStmt
if_(QueryCondition, BlockBuilder) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
if_(QueryCondition, Statement) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
ifBlock(Consumer<IfBlock>) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
IfBlock - Class in com.ptsmods.mysqlw.procedure.stmt.conditional
IfStmt - Class in com.ptsmods.mysqlw.procedure.stmt.conditional
in() - Method in class com.ptsmods.mysqlw.procedure.ProcedureParameter
in(String, Object[]) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
index(String, TableIndex.Type) - Static method in class com.ptsmods.mysqlw.table.TableIndex
index(String, TableIndexType.Type) - Static method in class com.ptsmods.mysqlw.table.TableIndexType
index(String, String, TableIndex.Type) - Static method in class com.ptsmods.mysqlw.table.TableIndex
index(String, String, TableIndexType.Type) - Static method in class com.ptsmods.mysqlw.table.TableIndexType
INDEX - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndex.Type: Used to speed up queries.
INDEX - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndexType.Type: Used to speed up queries.
indexOf(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
indexOfAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
INNER - Enum constant in enum class com.ptsmods.mysqlw.query.JoinType
insert(InsertBuilder) - Static method in class com.ptsmods.mysqlw.procedure.stmt.query.InsertStmt
insert(Iterable<Object[]>) - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
insert(Object...) - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
insert(Object[]...) - Method in class com.ptsmods.mysqlw.query.builder.InsertBuilder
insert(String, String[], Object[]) - Method in class com.ptsmods.mysqlw.Database: Inserts new data into the table.
insert(String, String[], List<Object[]>) - Method in class com.ptsmods.mysqlw.Database: Inserts new data into the table.
insert(String, String, Object) - Method in class com.ptsmods.mysqlw.Database: Inserts new data into the table.
insertAsync(String, String[], Object[]) - Method in class com.ptsmods.mysqlw.Database: Inserts new data into the table asynchronously.
insertAsync(String, String[], List<Object[]>) - Method in class com.ptsmods.mysqlw.Database: Inserts new data into the table asynchronously.
insertAsync(String, String, Object) - Method in class com.ptsmods.mysqlw.Database: Inserts new data into the table asynchronously.
insertBuilder(String, String...) - Method in class com.ptsmods.mysqlw.Database: Creates a new InsertBuilder to build insert queries with.
InsertBuilder - Class in com.ptsmods.mysqlw.query.builder
insertIgnore(String, String[], Object[], String) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or inserts the given key into the keyColumn (which already has that value so it basically ignores it) when a row with the given key already exists.
insertIgnore(String, String, Object) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or edits old data when a row with the given value for the given column already exists.
insertIgnoreAsync(String, String[], Object[], String) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or inserts the given key into the keyColumn (which already has that value so it basically ignores it) when a row with the given key already exists asynchronously.
insertIgnoreAsync(String, String, Object) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or edits old data when a row with the given value for the given column already exists asynchronously.
InsertStmt - Class in com.ptsmods.mysqlw.procedure.stmt.query
insertUpdate(String, String[], Object[], Map<String, Object>, String) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or edits old data when a row with the given key already exists.
insertUpdate(String, String, Object, Object) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or edits old data when a row with the given value for the given column already exists.
insertUpdateAsync(String, String[], Object[], Map<String, Object>, String) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or edits old data when a row with the given key already exists asynchronously.
insertUpdateAsync(String, String, Object, Object) - Method in class com.ptsmods.mysqlw.Database: Inserts new data or edits old data when a row with the given value for the given column already exists asynchronously.
INT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Integer type (int)
SIGNED: -2,147,483,648 to 2,147,483,647
UNSIGNED: 0 to 4,294,967,295
into(String) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Sets the table or variable to store the selected data into.
isAutoIncrement() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
isEmpty() - Method in class com.ptsmods.mysqlw.collection.DbList
isEmpty() - Method in class com.ptsmods.mysqlw.collection.DbMap
isEmpty() - Method in class com.ptsmods.mysqlw.collection.DbSet
isEmptyAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
isEmptyAsync() - Method in class com.ptsmods.mysqlw.collection.DbMap
isEmptyAsync() - Method in class com.ptsmods.mysqlw.collection.DbSet
isNatural() - Method in class com.ptsmods.mysqlw.query.Join
isNullAllowed() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
isPrimary() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
isRollup() - Method in class com.ptsmods.mysqlw.query.GroupBy
isUnique() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
iterate(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
iterate(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.loop.IterateStmt
IterateStmt - Class in com.ptsmods.mysqlw.procedure.stmt.loop
iterator() - Method in class com.ptsmods.mysqlw.collection.DbList
iterator() - Method in class com.ptsmods.mysqlw.collection.DbSet
iteratorAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
iteratorAsync() - Method in class com.ptsmods.mysqlw.collection.DbSet

J

join(Join) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Add a new prebuilt join.
join(Join.Builder) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Add a new join formed with a builder.
join(JoinType, String, QueryCondition) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Add a new join.
join(String, QueryCondition) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Add a new INNER join.
Join - Class in com.ptsmods.mysqlw.query
Join.Builder - Class in com.ptsmods.mysqlw.query
JoinType - Enum Class in com.ptsmods.mysqlw.query
JSON - Static variable in class com.ptsmods.mysqlw.table.ColumnType: JSON type
Just a string, but it's supposed to resemble JSON data, and you can do cool tricks when selecting using JSON_CONTAINS.

K

keySet() - Method in class com.ptsmods.mysqlw.collection.DbMap
keySetAsync() - Method in class com.ptsmods.mysqlw.collection.DbMap

L

lastIndexOf(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
lastIndexOfAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
leave(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
leave(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.loop.LeaveStmt
LeaveStmt - Class in com.ptsmods.mysqlw.procedure.stmt.loop
LEFT - Enum constant in enum class com.ptsmods.mysqlw.query.JoinType
length() - Method in class com.ptsmods.mysqlw.query.QueryFunction
less(String, Object) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
lessEqual(String, Object) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
like(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
limit(int) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Set the maximum amount of rows that should be returned.
Convenience method for SelectBuilder.limit(QueryLimit) and QueryLimit.limit(int).
limit(int) - Static method in class com.ptsmods.mysqlw.query.QueryLimit
limit(int, int) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Set the maximum amount of rows that should be returned.
Convenience method for SelectBuilder.limit(QueryLimit) and QueryLimit.limit(int, int).
limit(int, int) - Static method in class com.ptsmods.mysqlw.query.QueryLimit
limit(QueryLimit) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Set the maximum amount of rows that should be returned.
LINESTRING - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Linestring type
A curve with linear interpolation between points.
listIterator() - Method in class com.ptsmods.mysqlw.collection.DbList
listIterator(int) - Method in class com.ptsmods.mysqlw.collection.DbList
listIteratorAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
listIteratorAsync(int) - Method in class com.ptsmods.mysqlw.collection.DbList
loadConnector(Database.RDBMS, String, File, boolean) - Static method in class com.ptsmods.mysqlw.Database: Downloads the latest version of the connector for the given type and attempts to add it to the classpath.
It is not recommended you rely on this, but if, for example, you offer your users a choice whether to use MySQL or SQLite and you do not want to make your jar file huge, there is always this option.
logOrThrow(String, SQLException) - Method in class com.ptsmods.mysqlw.Database
LONGBLOB - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Long Binary Large OBject
Max size: 4,294,967,295 bytes
Used for storing various types of files, s.a.
LONGTEXT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Long text type
Can store up to 4,294,967,295 characters.
loop(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
loop(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.loop.LoopStmt
LoopStmt - Class in com.ptsmods.mysqlw.procedure.stmt.loop

M

match(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
MEDIUMBLOB - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Medium Binary Large OBject
Max size: 16,777,215 bytes
Used for storing various types of files, s.a.
MEDIUMINT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Medium integer type (no Java equivalent, 24-bit integer)
SIGNED: -8,388,608 to 8,388,607
UNSIGNED: 0 to 16,777,215
MEDIUMTEXT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Medium text type
Can store up to 16,777,215 characters.
modifyColumn(String, String, ColumnStructure<?>) - Method in class com.ptsmods.mysqlw.Database: Modifies a column's definition.
modifyColumnAsync(String, String, ColumnStructure<?>) - Method in class com.ptsmods.mysqlw.Database: Modifies a column's definition asynchronously.
MULTILINESTRING - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Multilinestring type
A collection of linestrings
multiply(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryFunction: Creates a basic new QueryFunction that multiplies two columns or variables.
MULTIPOINT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Multipoint type
A collection of points
This type is not supported by SQLite
MULTIPOLYGON - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Multipolygon type
A collection of polygons
This type is not supported by SQLite
MySQL - Enum constant in enum class com.ptsmods.mysqlw.Database.RDBMS

N

natural(boolean) - Method in class com.ptsmods.mysqlw.query.Join.Builder
NO_ACTION - Enum constant in enum class com.ptsmods.mysqlw.table.ForeignKey.Action
NOT_FOUND - Enum constant in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
notEquals(String, Object) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
notFound() - Static method in class com.ptsmods.mysqlw.procedure.ConditionValue
notIn(String, Object[]) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
NULL - Static variable in class com.ptsmods.mysqlw.table.ColumnDefault: Sets the default value of a column to be null, this is the default behaviour.

O

onDelete(ForeignKey.Action) - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
onUpdate(ForeignKey.Action) - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
open(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.cursor.OpenCursorStmt
openCursor(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
OpenCursorStmt - Class in com.ptsmods.mysqlw.procedure.stmt.cursor
OpeningStatement - Interface in com.ptsmods.mysqlw.procedure.stmt.block: Utility class denoting that a statement opens a block of statements.
or(int, QueryCondition) - Method in class com.ptsmods.mysqlw.query.QueryConditions: Adds a QueryCondition with the OR keyword at a specific index.
or(QueryCondition) - Method in class com.ptsmods.mysqlw.query.QueryConditions: Adds a QueryCondition with the OR keyword to the end.
OR - Enum constant in enum class com.ptsmods.mysqlw.query.QueryConditions.ConditionKeyword: Implies that either the previous QueryConditions or the next one must be true to return a row.
order(QueryOrder) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Sets the order in which the data should be returned.
order(String) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Sets the order in which the data should be returned.
Convenient shorthand for SelectBuilder.order(QueryOrder) and QueryOrder.by(String).
order(String, QueryOrder.OrderDirection) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Sets the order in which the data should be returned.
Convenient shorthand for SelectBuilder.order(QueryOrder) and QueryOrder.by(String, QueryOrder.OrderDirection).
out() - Method in class com.ptsmods.mysqlw.procedure.ProcedureParameter

P

Pair<L,R> - Class in com.ptsmods.mysqlw
Pair(L, R) - Constructor for class com.ptsmods.mysqlw.Pair
parameter(String, ColumnStructure<?>) - Static method in class com.ptsmods.mysqlw.procedure.ProcedureParameter
parse(Database, String, ResultSet, QueryCondition, QueryOrder, QueryLimit) - Static method in class com.ptsmods.mysqlw.query.SelectResults: Parse a ResultSet into a SelectResults object.
parse(ResultSet) - Static method in class com.ptsmods.mysqlw.query.SelectResults: Parse a ResultSet into a SelectResults object.
parseString(Database, String, BiFunction<E, DbCollection, String>, BiFunction<String, DbCollection, E>) - Static method in class com.ptsmods.mysqlw.collection.DbSet: Parses a String representation of a DbSet into a DbSet.
parseString(Database, String, BiFunction<E, DbCollection, String>, BiFunction<String, DbCollection, E>) - Static method in class com.ptsmods.mysqlw.collection.DbList: Parses a String representation of a DbList into a DbList.
parseString(Database, String, BiFunction<K, DbCollection, String>, BiFunction<V, DbCollection, String>, BiFunction<String, DbCollection, K>, BiFunction<String, DbCollection, V>) - Static method in class com.ptsmods.mysqlw.collection.DbMap: Parses a String representation of a DbMap into a DbMap.
POINT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Point type
Holds a coordinate with an X and Y value (and more dimensions of you choose to).
POLYGON - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Polygon type
You know what a polygon is, right?
If not, it's basically any 2D shape with straight lines.
prepareStatement(String) - Method in class com.ptsmods.mysqlw.Database: Prepares a new statement.
ProcedureParameter - Class in com.ptsmods.mysqlw.procedure
put(K, V) - Method in class com.ptsmods.mysqlw.collection.DbMap
putAll(Map<? extends K, ? extends V>) - Method in class com.ptsmods.mysqlw.collection.DbMap
putAll(Map<String, ColumnStructure<?>>) - Method in class com.ptsmods.mysqlw.table.TablePreset: Puts all columns with their names into this TablePreset.
putAllAsync(Map<? extends K, ? extends V>) - Method in class com.ptsmods.mysqlw.collection.DbMap
putAsync(K, V) - Method in class com.ptsmods.mysqlw.collection.DbMap
putColumn(String, ColumnStructure<?>) - Method in class com.ptsmods.mysqlw.table.TablePreset: Puts a new column into this TablePreset.

Q

QueryCondition - Class in com.ptsmods.mysqlw.query: A condition a query must meet to affect or return rows.
QueryCondition() - Constructor for class com.ptsmods.mysqlw.query.QueryCondition
QueryConditions - Class in com.ptsmods.mysqlw.query: A collection of QueryConditions which a query must meet to affect or return rows.
QueryConditions.ConditionKeyword - Enum Class in com.ptsmods.mysqlw.query
QueryFunction - Class in com.ptsmods.mysqlw.query: To make sure that functions don't get enquoted when putting them in a query, wrap them in this class.
QueryFunction(String) - Constructor for class com.ptsmods.mysqlw.query.QueryFunction: Creates a new QueryFunction.
QueryLimit - Class in com.ptsmods.mysqlw.query: Indicates a limit of the amount of rows you wish to have returned.
QueryOrder - Class in com.ptsmods.mysqlw.query: The order in which to return results.
QueryOrder.OrderDirection - Enum Class in com.ptsmods.mysqlw.query

R

raw(String) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
raw(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.RawStmt
rawClosing(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.RawStmt
rawClosingOpening(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.RawStmt
rawOpening(String) - Static method in class com.ptsmods.mysqlw.procedure.stmt.RawStmt
RawStmt - Class in com.ptsmods.mysqlw.procedure.stmt
readOnly() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Makes this ColumnStructure immutable so it cannot be edited.
Used when describing a table.
readQuotedString(String) - Static method in class com.ptsmods.mysqlw.Database: Reads a String starting with a single quote until the next quote.
REAL - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Synonym for ColumnType.DOUBLE unless the SQL option REAL_AS_FLOAT is set in which case it's a synonym for ColumnType.FLOAT.
referenceColumn(String) - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
referenceTable(String) - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
registerConverters(Class<T>, BiFunction<T, DbCollection, String>, BiFunction<String, DbCollection, T>) - Static method in class com.ptsmods.mysqlw.collection.DbCF: Used to register a bifunction to convert Objects of type T to Strings and a bifunction to convert Strings to Objects of type T.
registerTypeConverter(Class<T>, Function<T, String>, Function<String, T>) - Static method in class com.ptsmods.mysqlw.Database: Register a type converterTo used to determine how to convert an object of the given Class to a String which can be used in MySQL queries.
remove(int) - Method in class com.ptsmods.mysqlw.collection.DbList
remove(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
remove(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
remove(Object) - Method in class com.ptsmods.mysqlw.collection.DbSet
removeAll(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbList
removeAll(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbSet
removeAllAsync(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbList
removeAllAsync(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbSet
removeAsync(int) - Method in class com.ptsmods.mysqlw.collection.DbList
removeAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbList
removeAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbMap
removeAsync(Object) - Method in class com.ptsmods.mysqlw.collection.DbSet
removeCheck(QueryCondition) - Method in class com.ptsmods.mysqlw.table.TablePreset: Removes a check constraint
removeColumn(String) - Method in class com.ptsmods.mysqlw.table.TablePreset: Removes a column by its name.
removeForeignKey(ForeignKey) - Method in class com.ptsmods.mysqlw.table.TablePreset: Remove a foreign key from this preset.
removeIndex(TableIndex) - Method in class com.ptsmods.mysqlw.table.TablePreset: Removes an index.
removeJoin(Join) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder
repeat(QueryCondition, BlockBuilder) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
repeat(QueryCondition, BlockBuilder) - Static method in class com.ptsmods.mysqlw.procedure.stmt.loop.RepeatBlock
repeat(QueryCondition, Statement) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
repeat(QueryCondition, Statement) - Static method in class com.ptsmods.mysqlw.procedure.stmt.loop.RepeatBlock
RepeatBlock - Class in com.ptsmods.mysqlw.procedure.stmt.loop
replace(String, String[], Object[]) - Method in class com.ptsmods.mysqlw.Database: Replaces data in a table when a row with the same value for the primary key column as the value given already exists.
replace(String, String[], List<Object[]>) - Method in class com.ptsmods.mysqlw.Database: Replaces data in a table when a row with the same value for the primary key column as the value given already exists.
replace(String, String, Object) - Method in class com.ptsmods.mysqlw.Database: Replaces data in a table when a row with the same value for the primary key column as the value given already exists.
replaceAsync(String, String[], Object[]) - Method in class com.ptsmods.mysqlw.Database: Replaces data in a table when a row with the same value for the primary key column as the value given already exists asynchronously.
replaceAsync(String, String[], List<Object[]>) - Method in class com.ptsmods.mysqlw.Database: Replaces data in a table when a row with the same value for the primary key column as the value given already exists asynchronously.
replaceAsync(String, String, Object) - Method in class com.ptsmods.mysqlw.Database: Replaces data in a table when a row with the same value for the primary key column as the value given already exists asynchronously.
RESTRICT - Enum constant in enum class com.ptsmods.mysqlw.table.ForeignKey.Action
retainAll(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbList
retainAll(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbSet
retainAllAsync(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbList
retainAllAsync(Collection<?>) - Method in class com.ptsmods.mysqlw.collection.DbSet
RIGHT - Enum constant in enum class com.ptsmods.mysqlw.query.JoinType
rollup(boolean) - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder
runAsync(Runnable) - Method in class com.ptsmods.mysqlw.collection.DbList
runAsync(Runnable) - Method in class com.ptsmods.mysqlw.collection.DbMap
runAsync(Runnable) - Method in class com.ptsmods.mysqlw.collection.DbSet
runAsync(Runnable) - Method in class com.ptsmods.mysqlw.Database: Runs the given runnable on the set executor using CompletableFutures.
runAsync(Supplier<T>) - Method in class com.ptsmods.mysqlw.collection.DbList
runAsync(Supplier<T>) - Method in class com.ptsmods.mysqlw.collection.DbMap
runAsync(Supplier<T>) - Method in class com.ptsmods.mysqlw.collection.DbSet
runAsync(Supplier<T>) - Method in class com.ptsmods.mysqlw.Database: Runs the given supplier on the set executor using CompletableFutures.

S

satiateSupplier(Function<C, String>) - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Deprecated.
Has been renamed. Use ColumnStructure.configure(Function) instead.
select(SelectBuilder) - Static method in class com.ptsmods.mysqlw.procedure.stmt.query.SelectStmt
select(CharSequence) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Select a column or QueryFunction.
select(CharSequence...) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Select columns or QueryFunctions or any combination.
select(CharSequence, String) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Select a column or QueryFunction with a specific name.
select(Iterable<? extends CharSequence>) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Select columns or QueryFunctions or any combination.
select(String, CharSequence) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output.
select(String, CharSequence[]) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output.
select(String, CharSequence[], QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output.
select(String, CharSequence[], QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output.
select(String, CharSequence, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output.
select(String, CharSequence, QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output.
selectAsync(String, CharSequence) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output asynchronously.
selectAsync(String, CharSequence[]) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output asynchronously.
selectAsync(String, CharSequence[], QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output asynchronously.
selectAsync(String, CharSequence[], QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output asynchronously.
selectAsync(String, CharSequence, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output asynchronously.
selectAsync(String, CharSequence, QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns parsed output asynchronously.
selectBuilder(SelectBuilder) - Method in class com.ptsmods.mysqlw.Database: Creates a new SelectBuilder to use for selecting data.
selectBuilder(String) - Method in class com.ptsmods.mysqlw.Database: Creates a new SelectBuilder to use for selecting data.
SelectBuilder - Class in com.ptsmods.mysqlw.query.builder
selectRaw(String, CharSequence) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output.
selectRaw(String, CharSequence[]) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output.
selectRaw(String, CharSequence[], QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output.
selectRaw(String, CharSequence[], QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output.
selectRaw(String, CharSequence, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output.
selectRaw(String, CharSequence, QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output.
selectRawAsync(String, CharSequence) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output asynchronously.
selectRawAsync(String, CharSequence[]) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output asynchronously.
selectRawAsync(String, CharSequence[], QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output asynchronously.
selectRawAsync(String, CharSequence[], QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output asynchronously.
selectRawAsync(String, CharSequence, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output asynchronously.
selectRawAsync(String, CharSequence, QueryCondition, QueryOrder, QueryLimit) - Method in class com.ptsmods.mysqlw.Database: Runs a select query and returns the raw output asynchronously.
SelectResults - Class in com.ptsmods.mysqlw.query: Returned when you use any of the select methods in Database.
SelectResults.SelectResultRow - Class in com.ptsmods.mysqlw.query: A row in SelectResults
SelectStmt - Class in com.ptsmods.mysqlw.procedure.stmt.query
selectVariable(String) - Method in class com.ptsmods.mysqlw.Database: Selects a single variable stored in the RDBMS.
selectVariableAsync(String) - Method in class com.ptsmods.mysqlw.Database: Asynchronously selects a single variable stored in the RDBMS.
set(int, E) - Method in class com.ptsmods.mysqlw.collection.DbList
set(String, SelectBuilder) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
set(String, SelectBuilder) - Static method in class com.ptsmods.mysqlw.procedure.stmt.vars.SetStmt
set(String, Object) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
set(String, Object) - Static method in class com.ptsmods.mysqlw.procedure.stmt.vars.SetStmt
SET - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Set type
Same as enum, but can only hold up to 64 different values, does not have an error type (so it can hold empty strings) and cannot hold indexes corresponding with a value.
So it can only hold the values given when initialised.
SET_NULL - Enum constant in enum class com.ptsmods.mysqlw.table.ForeignKey.Action
setAsync(int, E) - Method in class com.ptsmods.mysqlw.collection.DbList
setAttributes(ColumnAttributes) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setAutoIncrement() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Sets auto increment to true.
setAutoIncrement(boolean) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setComment(String) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setDefault(ColumnDefault) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setErrorHandler(Consumer<Throwable>) - Method in class com.ptsmods.mysqlw.Database: Sets the error handler used whenever an asynchronous call throws an error.
setExecutor(Executor) - Method in class com.ptsmods.mysqlw.collection.DbList
setExecutor(Executor) - Method in class com.ptsmods.mysqlw.collection.DbMap
setExecutor(Executor) - Method in class com.ptsmods.mysqlw.collection.DbSet
setExecutor(Executor) - Method in class com.ptsmods.mysqlw.Database: Sets the Executor used to run tasks asynchronously.
setExtra(String) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setLogging(boolean) - Method in class com.ptsmods.mysqlw.Database: Sets whether exceptions should be logged or thrown.
When this is set to false, all SQLExceptions will be thrown wrapped in a SilentSQLException.
setName(String) - Method in class com.ptsmods.mysqlw.table.TablePreset: Changes the name of this TablePreset.
setNatural(boolean) - Method in class com.ptsmods.mysqlw.query.Join
setNonNull() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Sets null allowed to false.
setNullable() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Sets null allowed to true.
setNullAllowed(boolean) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setPrimary() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Sets primary to true.
setPrimary(boolean) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
SetStmt - Class in com.ptsmods.mysqlw.procedure.stmt.vars
setType(JoinType) - Method in class com.ptsmods.mysqlw.query.Join
setTypeString(String) - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Basically what configuring does, except you put in raw data.
Don't forget to include the type in here too.
Example: VARCHAR(255)
setUnique() - Method in class com.ptsmods.mysqlw.table.ColumnStructure: Sets unique to true.
setUnique(boolean) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
setValue(V) - Method in class com.ptsmods.mysqlw.collection.DbMap.DbMapEntry
SilentSQLException - Exception Class in com.ptsmods.mysqlw: An Exception class to wrap SQLExceptions to be thrown silently.
SilentSQLException(SQLException) - Constructor for exception class com.ptsmods.mysqlw.SilentSQLException
SimpleConfigurable - Interface in com.ptsmods.mysqlw.table.configurable
singletonMap(K, V) - Static method in class com.ptsmods.mysqlw.Database
size() - Method in class com.ptsmods.mysqlw.collection.DbList
size() - Method in class com.ptsmods.mysqlw.collection.DbMap
size() - Method in class com.ptsmods.mysqlw.collection.DbSet
size() - Method in class com.ptsmods.mysqlw.query.SelectResults
sizeAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
sizeAsync() - Method in class com.ptsmods.mysqlw.collection.DbMap
sizeAsync() - Method in class com.ptsmods.mysqlw.collection.DbSet
SMALLINT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Small integer type (short)
SIGNED: -32,768 to 32,767
UNSIGNED: 0 to 65,535
SPATIAL - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndex.Type: Indices for GEOMETRY objects.
SPATIAL - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndexType.Type: Indexes for GEOMETRY objects.
SQL_ERROR - Enum constant in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
SQL_EXCEPTION - Enum constant in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
SQL_STATE - Enum constant in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
SQL_WARNING - Enum constant in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
sqlError(int) - Static method in class com.ptsmods.mysqlw.procedure.ConditionValue
sqlException() - Static method in class com.ptsmods.mysqlw.procedure.ConditionValue
SQLite - Enum constant in enum class com.ptsmods.mysqlw.Database.RDBMS
sqlState(String) - Static method in class com.ptsmods.mysqlw.procedure.ConditionValue
sqlWarning() - Static method in class com.ptsmods.mysqlw.procedure.ConditionValue
Statement - Class in com.ptsmods.mysqlw.procedure.stmt
Statement() - Constructor for class com.ptsmods.mysqlw.procedure.stmt.Statement
StatementBlock - Class in com.ptsmods.mysqlw.procedure.stmt.block
stmt(int, Statement) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
stmt(Statement) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
stmts(Statement...) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
stmts(Iterable<Statement>) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
strFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
struct() - Method in class com.ptsmods.mysqlw.table.ColumnType
subList(int, int) - Method in class com.ptsmods.mysqlw.collection.DbList
subListAsync(int, int) - Method in class com.ptsmods.mysqlw.collection.DbList
subSequence(int, int) - Method in class com.ptsmods.mysqlw.query.QueryFunction
subtract(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryFunction: Creates a basic new QueryFunction that subtracts two columns or variables from each other.

T

table(String) - Method in class com.ptsmods.mysqlw.query.Join.Builder
tableExists(String) - Method in class com.ptsmods.mysqlw.Database: Checks if a table exists.
tableExistsAsync(String) - Method in class com.ptsmods.mysqlw.Database: Checks if a table exists asynchronously.
TableIndex - Class in com.ptsmods.mysqlw.table: Table indices, used to speed up queries.
TableIndex.Type - Enum Class in com.ptsmods.mysqlw.table
TableIndexType - Class in com.ptsmods.mysqlw.table: Table indices, used to speed up queries.
TableIndexType.Type - Enum Class in com.ptsmods.mysqlw.table
TablePreset - Class in com.ptsmods.mysqlw.table
TEXT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Text type
Can store up to 65,535 characters.
TIME - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Time type
Holds just a time in the format hh:mm:ss.
Supported range is -838:59:59 to 838:59:59.
TIMESTAMP - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Timestamp type
Stored as an integer of seconds since epoch.
Contains a date and time.
Supported range is 1970-01-01 00:00:01 UTC to 2038-01-09 03:14:07 UTC.
TINYBLOB - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Tiny Binary Large OBject
Max size: 255 bytes
Used for storing various types of files, s.a.
TINYINT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Tiny integer type (byte)
SIGNED: -128 to 127
UNSIGNED: 0 to 255
TINYTEXT - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Tiny text type
Can store up to 255 characters.
toArray() - Method in class com.ptsmods.mysqlw.collection.DbList
toArray() - Method in class com.ptsmods.mysqlw.collection.DbSet
toArray(T[]) - Method in class com.ptsmods.mysqlw.collection.DbList
toArray(T[]) - Method in class com.ptsmods.mysqlw.collection.DbSet
toArrayAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
toArrayAsync() - Method in class com.ptsmods.mysqlw.collection.DbSet
toArrayAsync(T[]) - Method in class com.ptsmods.mysqlw.collection.DbList
toArrayAsync(T[]) - Method in class com.ptsmods.mysqlw.collection.DbSet
toArrayList() - Method in class com.ptsmods.mysqlw.collection.DbList
toArrayListAsync() - Method in class com.ptsmods.mysqlw.collection.DbList
toBuilder() - Method in class com.ptsmods.mysqlw.procedure.stmt.block.StatementBlock
toByteFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
toDoubleFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
toFloatFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
toHashSet() - Method in class com.ptsmods.mysqlw.collection.DbSet
toHashSetAsync() - Method in class com.ptsmods.mysqlw.collection.DbSet
toIntFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
toLongFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
toShortFunc - Static variable in class com.ptsmods.mysqlw.collection.DbCF
toString() - Method in class com.ptsmods.mysqlw.collection.DbList
toString() - Method in class com.ptsmods.mysqlw.collection.DbMap
toString() - Method in class com.ptsmods.mysqlw.collection.DbSet
toString() - Method in class com.ptsmods.mysqlw.Database
toString() - Method in class com.ptsmods.mysqlw.Pair
toString() - Method in class com.ptsmods.mysqlw.procedure.ConditionValue
toString() - Method in class com.ptsmods.mysqlw.procedure.EmptyStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.ProcedureParameter
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.block.EndStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.block.StatementBlock
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.CaseBlock
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.ElseIfStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.ElseStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.cursor.CloseCursorStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.cursor.DeclareCursorStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.cursor.FetchCursorStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.cursor.OpenCursorStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.DelimiterStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.loop.IterateStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.loop.LeaveStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.loop.LoopStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.loop.RepeatBlock
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.loop.WhileStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.misc.BeginStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareConditionStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.query.InsertStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.query.SelectStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.RawStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.Statement
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.vars.DeclareStmt
toString() - Method in class com.ptsmods.mysqlw.procedure.stmt.vars.SetStmt
toString() - Method in class com.ptsmods.mysqlw.query.GroupBy.Builder
toString() - Method in class com.ptsmods.mysqlw.query.GroupBy
toString() - Method in class com.ptsmods.mysqlw.query.Join.Builder
toString() - Method in class com.ptsmods.mysqlw.query.Join
toString() - Method in class com.ptsmods.mysqlw.query.QueryCondition
toString() - Method in class com.ptsmods.mysqlw.query.QueryConditions
toString() - Method in class com.ptsmods.mysqlw.query.QueryFunction
toString() - Method in class com.ptsmods.mysqlw.query.QueryLimit
toString() - Method in class com.ptsmods.mysqlw.query.QueryOrder
toString() - Method in class com.ptsmods.mysqlw.query.SelectResults.SelectResultRow
toString() - Method in class com.ptsmods.mysqlw.query.SelectResults
toString() - Method in enum class com.ptsmods.mysqlw.table.ColumnAttributes
toString() - Method in class com.ptsmods.mysqlw.table.ColumnStructure
toString() - Method in class com.ptsmods.mysqlw.table.ForeignKey.Builder
toString() - Method in class com.ptsmods.mysqlw.table.ForeignKey
toString() - Method in class com.ptsmods.mysqlw.table.TableIndex
toString() - Method in class com.ptsmods.mysqlw.table.TableIndexType
toString(boolean) - Method in class com.ptsmods.mysqlw.table.TableIndex
toString(int) - Method in class com.ptsmods.mysqlw.procedure.EmptyStmt
toString(int) - Method in interface com.ptsmods.mysqlw.procedure.stmt.block.BlockLikeStatement
toString(int) - Method in class com.ptsmods.mysqlw.procedure.stmt.block.StatementBlock
toString(int) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.CaseBlock
toString(int) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.IfBlock
toString(int) - Method in class com.ptsmods.mysqlw.procedure.stmt.loop.RepeatBlock
toString(int) - Method in class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt
toString(Database.RDBMS) - Method in class com.ptsmods.mysqlw.query.GroupBy
toString(Database.RDBMS) - Method in class com.ptsmods.mysqlw.table.ColumnStructure
toString(Object) - Method in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type
toString(String, String) - Method in enum class com.ptsmods.mysqlw.table.TableIndexType.Type
toString(String, String, boolean) - Method in enum class com.ptsmods.mysqlw.table.TableIndex.Type
TriggeringEvent - Enum Class in com.ptsmods.mysqlw.procedure
truncate(String) - Method in class com.ptsmods.mysqlw.Database: Truncates (clears) a table.
truncateAsync(String) - Method in class com.ptsmods.mysqlw.Database: Truncates (clears) a table asynchronously.
type(JoinType) - Method in class com.ptsmods.mysqlw.query.Join.Builder
types - Static variable in class com.ptsmods.mysqlw.table.ColumnType

U

UNDO - Enum constant in enum class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt.HandlerAction
UNIQUE - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndex.Type: Each row must have a unique value for this column.
UNIQUE - Enum constant in enum class com.ptsmods.mysqlw.table.TableIndexType.Type: Each row must have a unique value for this column.
UNKNOWN - Enum constant in enum class com.ptsmods.mysqlw.Database.RDBMS
UNSIGED_ZEROFILL - Enum constant in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Deprecated.
This was a typo, but the value has always been correct. Please use ColumnAttributes.UNSIGNED_ZEROFILL instead.
UNSIGNED - Enum constant in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Store any number type as unsigned.
UNSIGNED_ZEROFILL - Enum constant in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Same as ColumnAttributes.UNSIGNED but also fills the number with zeros to fit the length.
update(String, String, Object, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Updates data in a table.
update(String, Map<String, Object>, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Updates data in a table.
UPDATE_CURRENT_TIMESTAMP - Enum constant in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Store the current TIMESTAMP in this column whenever the row gets updated.
updateAsync(String, String, Object, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Updates data in a table asynchronously.
updateAsync(String, Map<String, Object>, QueryCondition) - Method in class com.ptsmods.mysqlw.Database: Updates data in a table asynchronously.
using(String) - Method in class com.ptsmods.mysqlw.query.Join.Builder
using(Collection<? extends String>) - Method in class com.ptsmods.mysqlw.query.Join.Builder
UUID - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Char text type with fixed length of 36 characters, used to store UUIDs.

V

valueOf(String) - Static method in enum class com.ptsmods.mysqlw.Database.RDBMS: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt.HandlerAction: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.query.JoinType: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.query.QueryConditions.ConditionKeyword: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.query.QueryOrder.OrderDirection: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.table.ForeignKey.Action: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.table.TableIndex.Type: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class com.ptsmods.mysqlw.table.TableIndexType.Type: Returns the enum constant of this class with the specified name.
values() - Method in class com.ptsmods.mysqlw.collection.DbMap
values() - Static method in enum class com.ptsmods.mysqlw.Database.RDBMS: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.procedure.ConditionValue.Type: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.procedure.stmt.misc.DeclareHandlerStmt.HandlerAction: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.procedure.TriggeringEvent: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.query.JoinType: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.query.QueryConditions.ConditionKeyword: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.query.QueryOrder.OrderDirection: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.table.ColumnAttributes: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.table.ForeignKey.Action: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.table.TableIndex.Type: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class com.ptsmods.mysqlw.table.TableIndexType.Type: Returns an array containing the constants of this enum class, in the order they are declared.
valuesAsync() - Method in class com.ptsmods.mysqlw.collection.DbMap
VARBINARY - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Same as ColumnType.VARCHAR except Strings are stored as binary byte strings rather than character strings.
VARCHAR - Static variable in class com.ptsmods.mysqlw.table.ColumnType: String with varying length
Max length must be at most 65535 when using MySQL.
varEquals(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
varGreater(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
varGreaterEqual(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
varLess(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
varLessEqual(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition
varNotEquals(String, String) - Static method in class com.ptsmods.mysqlw.query.QueryCondition

W

when(Object, Statement) - Method in class com.ptsmods.mysqlw.procedure.stmt.conditional.CaseBlock
where(QueryCondition) - Method in class com.ptsmods.mysqlw.query.builder.SelectBuilder: Sets the condition that rows must comply with to be selected.
while_(QueryCondition) - Method in class com.ptsmods.mysqlw.procedure.BlockBuilder
while_(QueryCondition) - Static method in class com.ptsmods.mysqlw.procedure.stmt.loop.WhileStmt
WhileStmt - Class in com.ptsmods.mysqlw.procedure.stmt.loop
withDefault(Pair<T1, T2>) - Method in interface com.ptsmods.mysqlw.table.configurable.Dynamic2Configurable
withDefault(T) - Method in interface com.ptsmods.mysqlw.table.configurable.Defaultable
withDefault(T) - Method in interface com.ptsmods.mysqlw.table.configurable.DynamicConfigurable
withDefault(T...) - Method in interface com.ptsmods.mysqlw.table.configurable.DynamicNConfigurable

Y

YEAR - Static variable in class com.ptsmods.mysqlw.table.ColumnType: Year type
A year stored with either four (default) or two digits.
YEAR(2) is deprecated and no longer supported, so this library does not support it either.

A B C D E F G H I J K L M N O P Q R S T U V W Y
All Classes and Interfaces|All Packages|Serialized Form