AnyLogic
Expand
Search
Font size
Package com.anylogic.engine.database

Class DatabaseSQLBuilderBasic

@AnyLogicInternalAPI
public class DatabaseSQLBuilderBasic
extends Object
This class is internal and shouldn't be called by user.
it may be removed/renamed in future.
Author:
AnyLogic North America, LLC https://anylogic.com

Nested Class Summary

Modifier and TypeClassDescription
static enum DatabaseSQLBuilderBasic.PrettyFormatting 
static class DatabaseSQLBuilderBasic.QueryBuilder 
static enum DatabaseSQLBuilderBasic.ValuesAre 
static enum DatabaseSQLBuilderBasic.Where 

Field Summary

Modifier and TypeFieldDescription
static final StringSQL_ADD 
static final StringSQL_ALTER 
static final StringSQL_AND 
static final StringSQL_AS 
static final StringSQL_BEFORE 
static final StringSQL_CASCADE 
static final StringSQL_CAST 
static final StringSQL_CHECK 
static final StringSQL_CLOSE_PARENTHESIS 
static final StringSQL_COLUMN 
static final StringSQL_COMMA 
static final StringSQL_CONSTRAINT 
static final StringSQL_COUNT 
static final StringSQL_CREATE 
static final StringSQL_DEFAULT 
static final StringSQL_DELETE 
static final StringSQL_DELETE_FROM 
static final StringSQL_DISTINCT 
static final StringSQL_DOT 
static final StringSQL_DOUBLE_QUOTE 
static final StringSQL_DROP 
static final StringSQL_EQUALLY 
static final StringSQL_EXISTS 
static final StringSQL_FALSE 
static final StringSQL_FOREIGN_KEY 
static final StringSQL_FROM 
static final StringSQL_GREATER 
static final StringSQL_GROUP_BY 
static final StringSQL_HAVING 
static final StringSQL_IF 
static final StringSQL_IN 
static final StringSQL_INDEX 
static final StringSQL_INNER 
static final StringSQL_INSERT_INTO 
static final StringSQL_IS 
static final StringSQL_IS_NULL 
static final StringSQL_JOIN 
static final StringSQL_LEFT 
static final StringSQL_LIKE 
static final StringSQL_LIMIT 
static final StringSQL_MAX 
static final StringSQL_MODIFY 
static final StringSQL_NOT 
static final StringSQL_NULL 
static final StringSQL_ON 
static final StringSQL_OPEN_PARENTHESIS 
static final StringSQL_ORDER_BY 
static final StringSQL_PRIMARY_KEY 
static final StringSQL_REFERENCES 
static final StringSQL_RENAME_TO 
static final StringSQL_SELECT 
static final StringSQL_SET 
static final StringSQL_SINGLE_QUOTE 
static final StringSQL_TABLE 
static final StringSQL_TRUE 
static final StringSQL_UNDERLINE 
static final StringSQL_UNIQUE 
static final StringSQL_UNIQUE_AUTOINC_COLUMN_TYPE 
static final StringSQL_UPDATE 
static final StringSQL_VALUES 
static final StringSQL_VIEW 
static final StringSQL_WHERE 
static final StringSQL_WHITESPACE 

Method Summary

Modifier and TypeMethodDescription
static StringBuilderappendValue(StringBuilder sb, String value)
'{value}' | NULL
static StringbuildDeleteFromTable(String tableName, String[]... where)
DELETE FROM {tableName} WHERE [{where[i][0]} = '{where[i][1]}' AND ...]
static StringbuildSelectFrom(String[] whatToSelect, String tableName, String[]... where)
SELECT {whatToSelect} FROM {tableName} WHERE [{where[i][0]} = '{where[i][1]}' AND ...]
static StringinsertInto(String tableName, String[] columnNames, DatabaseSQLBuilderBasic.ValuesAre howToInsertValues, String... values)
INSERT INTO {TABLE_NAME} VALUES ('{value[i]}', ...)
static StringprepareInsertInto(String tableName, String... fields) 
static StringprepareUpdateSet(String tableName, String unicFieldName, DatabaseSQLBuilderBasic.Where where, String... fields) 

Methods inherited from class java.lang.Object

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

Field Details

SQL_WHITESPACE

public static final String SQL_WHITESPACE
See Also:
Constant Field Values

SQL_TRUE

public static final String SQL_TRUE
See Also:
Constant Field Values

SQL_FALSE

public static final String SQL_FALSE
See Also:
Constant Field Values

SQL_AND

public static final String SQL_AND
See Also:
Constant Field Values

SQL_NOT

public static final String SQL_NOT
See Also:
Constant Field Values

SQL_NULL

public static final String SQL_NULL
See Also:
Constant Field Values

SQL_ON

public static final String SQL_ON
See Also:
Constant Field Values

SQL_IS

public static final String SQL_IS
See Also:
Constant Field Values

SQL_IN

public static final String SQL_IN
See Also:
Constant Field Values

SQL_DEFAULT

public static final String SQL_DEFAULT
See Also:
Constant Field Values

SQL_UNIQUE

public static final String SQL_UNIQUE
See Also:
Constant Field Values

SQL_OPEN_PARENTHESIS

public static final String SQL_OPEN_PARENTHESIS
See Also:
Constant Field Values

SQL_CLOSE_PARENTHESIS

public static final String SQL_CLOSE_PARENTHESIS
See Also:
Constant Field Values

SQL_EQUALLY

public static final String SQL_EQUALLY
See Also:
Constant Field Values

SQL_CONSTRAINT

public static final String SQL_CONSTRAINT
See Also:
Constant Field Values

SQL_INDEX

public static final String SQL_INDEX
See Also:
Constant Field Values

SQL_IF

public static final String SQL_IF
See Also:
Constant Field Values

SQL_EXISTS

public static final String SQL_EXISTS
See Also:
Constant Field Values

SQL_COUNT

public static final String SQL_COUNT
See Also:
Constant Field Values

SQL_FROM

public static final String SQL_FROM
See Also:
Constant Field Values

SQL_WHERE

public static final String SQL_WHERE
See Also:
Constant Field Values

SQL_GROUP_BY

public static final String SQL_GROUP_BY
See Also:
Constant Field Values

SQL_ORDER_BY

public static final String SQL_ORDER_BY
See Also:
Constant Field Values

SQL_TABLE

public static final String SQL_TABLE
See Also:
Constant Field Values

SQL_COLUMN

public static final String SQL_COLUMN
See Also:
Constant Field Values

SQL_ALTER

public static final String SQL_ALTER
See Also:
Constant Field Values

SQL_SELECT

public static final String SQL_SELECT
See Also:
Constant Field Values

SQL_DISTINCT

public static final String SQL_DISTINCT
See Also:
Constant Field Values

SQL_UPDATE

public static final String SQL_UPDATE
See Also:
Constant Field Values

SQL_ADD

public static final String SQL_ADD
See Also:
Constant Field Values

SQL_DROP

public static final String SQL_DROP
See Also:
Constant Field Values

SQL_RENAME_TO

public static final String SQL_RENAME_TO
See Also:
Constant Field Values

SQL_MODIFY

public static final String SQL_MODIFY
See Also:
Constant Field Values

SQL_SET

public static final String SQL_SET
See Also:
Constant Field Values

SQL_CREATE

public static final String SQL_CREATE
See Also:
Constant Field Values

SQL_BEFORE

public static final String SQL_BEFORE
See Also:
Constant Field Values

SQL_UNDERLINE

public static final String SQL_UNDERLINE
See Also:
Constant Field Values

SQL_MAX

public static final String SQL_MAX
See Also:
Constant Field Values

SQL_LIKE

public static final String SQL_LIKE
See Also:
Constant Field Values

SQL_CHECK

public static final String SQL_CHECK
See Also:
Constant Field Values

SQL_PRIMARY_KEY

public static final String SQL_PRIMARY_KEY
See Also:
Constant Field Values

SQL_FOREIGN_KEY

public static final String SQL_FOREIGN_KEY
See Also:
Constant Field Values

SQL_REFERENCES

public static final String SQL_REFERENCES
See Also:
Constant Field Values

SQL_JOIN

public static final String SQL_JOIN
See Also:
Constant Field Values

SQL_LEFT

public static final String SQL_LEFT
See Also:
Constant Field Values

SQL_INNER

public static final String SQL_INNER
See Also:
Constant Field Values

SQL_COMMA

public static final String SQL_COMMA
See Also:
Constant Field Values

SQL_DOT

public static final String SQL_DOT
See Also:
Constant Field Values

SQL_CASCADE

public static final String SQL_CASCADE
See Also:
Constant Field Values

SQL_DELETE

public static final String SQL_DELETE
See Also:
Constant Field Values

SQL_INSERT_INTO

public static final String SQL_INSERT_INTO
See Also:
Constant Field Values

SQL_VALUES

public static final String SQL_VALUES
See Also:
Constant Field Values

SQL_CAST

public static final String SQL_CAST
See Also:
Constant Field Values

SQL_AS

public static final String SQL_AS
See Also:
Constant Field Values

SQL_VIEW

public static final String SQL_VIEW
See Also:
Constant Field Values

SQL_UNIQUE_AUTOINC_COLUMN_TYPE

public static final String SQL_UNIQUE_AUTOINC_COLUMN_TYPE
See Also:
Constant Field Values

SQL_HAVING

public static final String SQL_HAVING
See Also:
Constant Field Values

SQL_GREATER

public static final String SQL_GREATER
See Also:
Constant Field Values

SQL_SINGLE_QUOTE

public static final String SQL_SINGLE_QUOTE
See Also:
Constant Field Values

SQL_DOUBLE_QUOTE

public static final String SQL_DOUBLE_QUOTE
See Also:
Constant Field Values

SQL_LIMIT

public static final String SQL_LIMIT
See Also:
Constant Field Values

SQL_IS_NULL

public static final String SQL_IS_NULL
See Also:
Constant Field Values

SQL_DELETE_FROM

public static final String SQL_DELETE_FROM
See Also:
Constant Field Values

Method Details

prepareInsertInto

@AnyLogicInternalAPI
public static String prepareInsertInto(String tableName,
 String... fields)

insertInto

public static String insertInto(String tableName,
 String[] columnNames,
 DatabaseSQLBuilderBasic.ValuesAre howToInsertValues,
 String... values)
INSERT INTO {TABLE_NAME} VALUES ('{value[i]}', ...)
Parameters:
tableName -
values -
Returns:

prepareUpdateSet

@AnyLogicInternalAPI
public static String prepareUpdateSet(String tableName,
 String unicFieldName,
 DatabaseSQLBuilderBasic.Where where,
 String... fields)

buildSelectFrom

public static String buildSelectFrom(String[] whatToSelect,
 String tableName,
 String[]... where)
SELECT {whatToSelect} FROM {tableName} WHERE [{where[i][0]} = '{where[i][1]}' AND ...]
Parameters:
whatToSelect - array of columns or null
tableName -
where -
Returns:

buildDeleteFromTable

@SafeVarargs
public static String buildDeleteFromTable(String tableName,
 String[]... where)
DELETE FROM {tableName} WHERE [{where[i][0]} = '{where[i][1]}' AND ...]
Parameters:
tableName -
columnName -
value -
Returns:

appendValue

public static StringBuilder appendValue(StringBuilder sb,
 String value)
'{value}' | NULL
Parameters:
value -
Returns:
We use cookies to give you the best online experience, including personalized content, advertising, and web analytics. You can reject cookies by changing your browser settings. To learn more about the cookies we use, see our Cookie Policy.