Package tilda.db.stores

Interface DBType

All Known Subinterfaces:

CodeGenSql

All Known Implementing Classes:

BigQuery, CommonStoreImpl, MSSQL, PostgreSQL, Sql, Sql, Sql

public interface DBType

Field Summary

Fields

Modifier and Type	Field	Description
static DBType[]	_DBTypes
static DBType	BigQuery
static DBType	Postgres
static DBType	SQLServer

Method Summary

Modifier and Type	Method	Description
void	age(Connection Con, java.lang.StringBuilder Str, Type_DatetimePrimitive ColStart, Type_DatetimePrimitive ColEnd, DurationUtil.IntervalEnum Type, int Count, java.lang.String Operator)
boolean	alterTableAddColumn(Connection Con, Column Col, java.lang.String DefaultValue, java.lang.String temporaryDefaultValue)
boolean	alterTableAddFK(Connection Con, ForeignKey FK)
boolean	alterTableAddIndex(Connection Con, Index IX)
java.lang.String	alterTableAddIndexDDL(Index IX)
boolean	alterTableAlterColumnComment(Connection Con, Column Col)
boolean	alterTableAlterColumnDefault(Connection Con, Column Col)
boolean	alterTableAlterColumnMulti(Connection Con, java.util.List<ColMetaColPair> BatchTypeCols, java.util.List<ColMetaColPair> BatchSizeCols, ZoneInfo_Data defaultZI)
boolean	alterTableAlterColumnNull(Connection Con, Column Col, java.lang.String DefaultValue)
boolean	alterTableAlterColumnNumericSize(Connection connection, ColumnMeta colMeta, Column col)
boolean	alterTableAlterColumnStringSize(Connection Con, ColumnMeta ColMeta, Column Col)
boolean	alterTableAlterColumnType(Connection Con, ColumnMeta ColMeta, Column Col, ZoneInfo_Data defaultZI)
boolean	alterTableComment(Connection Con, Object Obj)
boolean	alterTableDropColumn(Connection Con, Object Obj, java.lang.String ColumnName)
boolean	alterTableDropFK(Connection Con, Object Obj, FKMeta FK)
boolean	alterTableDropIndex(Connection Con, Object Obj, IndexMeta IX)
boolean	alterTableIndexAddCluster(Connection Con, Index IX)
boolean	alterTableIndexDropCluster(Connection Con, IndexMeta IX)
boolean	alterTableRenameIndex(Connection Con, Object Obj, java.lang.String OldName, java.lang.String NewName)
boolean	alterTableReplaceTablePK(Connection Con, Object Obj, PKMeta oldPK)
void	cancel(Connection con)
boolean	createKeysEntry(Connection Con, Object Obj)
boolean	createSchema(Connection Con, Schema S)
boolean	createTable(Connection Con, Object Obj)
boolean	createView(Connection Con, View V)
boolean	dropView(Connection con, ViewMeta v, boolean cascade)
boolean	dropView(Connection Con, View V)
boolean	fullIdentifierOnUpdate()
java.lang.String	getAclRolesScript(Connection Con, java.util.List<Schema> TildaList)
java.lang.String	getAggregateStr(AggregateType AT)
java.lang.String	getBackendConnectionId(Connection con)
char	getColumnQuotingEndChar()
char	getColumnQuotingStartChar()
void	getColumnType(java.lang.StringBuilder Str, ColumnType T, java.lang.Integer S, ColumnMode M, boolean Collection, java.lang.Integer Precision, java.lang.Integer Scale)
java.lang.String	getColumnType(Column C)
java.lang.String	getColumnType(Column C, ColumnType AggregateType)
java.lang.String	getColumnTypeRaw(ColumnType Type, int Size, boolean isArray)
java.lang.String	getColumnTypeRaw(Column C, boolean MultiOverride)
java.lang.String[]	getConnectionCancelStates()
java.lang.String[]	getConnectionLockMsgs()
java.lang.String[]	getConnectionNoDataStates()
java.time.LocalDate	getCurrentDate(Connection con)
java.lang.String	getCurrentDateStr()
java.time.ZonedDateTime	getCurrentDateTime(Connection con)
java.lang.String	getCurrentDateTimeStr()
java.time.ZonedDateTime	getCurrentTimestamp(Connection con)
java.lang.String	getCurrentTimestampStr()
DBStringType	getDBStringType(int Size)
void	getFullColumnVar(java.lang.StringBuilder Str, java.lang.String SchemaName, java.lang.String TableName, java.lang.String ColumnName)
java.lang.String	getFullColumnVar(Column C)
java.lang.String	getFullColumnVar(Column C, int i)
void	getFullTableVar(java.lang.StringBuilder Str, java.lang.String SchemaName, java.lang.String TableName)
java.lang.String	getFullTableVar(Object O)
java.lang.String	getFullTableVar(Object O, int i)
java.lang.String	getHelperFunctionsScript(Connection Con, boolean start)
java.lang.String	getJsonParametrizedQueryPlaceHolder()
int	getMaxColumnNameSize()
int	getMaxTableNameSize()
java.lang.String	getName()
java.lang.String	getSelectLimitClause(int Start, int Size)
java.lang.String	getShortColumnVar(java.lang.String name)
java.lang.String	getShortColumnVar(Column C)
CodeGenSql	getSQlCodeGen()
StringStringPair	getTypeMapping(int type, java.lang.String name, int size, java.lang.String typeName)
boolean	isCaseSentitiveSchemaTableViewNames()
boolean	isSuperUser(Connection Con)
boolean	moveTableView(Connection con, Base base, java.lang.String oldSchemaName)
boolean	needsSavepoint()
boolean	renameTableColumn(Connection con, Column col, java.lang.String oldName)
boolean	renameTableView(Connection con, Base base, java.lang.String oldName)
boolean	reorgTable(Connection con, java.lang.String schemaName, java.lang.String tableName, java.lang.String clusterIndexName, boolean verbose, boolean full)
java.lang.String	rewriteExpressionColumnQuoting(java.lang.String expr)
void	setArray(Connection Con, java.sql.PreparedStatement PS, int i, ColumnType Type, java.util.List<java.sql.Array> allocatedArrays, java.util.Collection<?> val)
void	setOrderByWithNullsOrdering(Connection Con, java.lang.StringBuilder Str, ColumnDefinition Col, boolean Asc, boolean NullsLast)
boolean	supportsArrays()
boolean	supportsFilterClause()
boolean	supportsFirstLastAggregates()
boolean	supportsForeignKeys()
boolean	supportsIndices()
boolean	supportsPrimaryKeys()
boolean	supportsReorg()
boolean	supportsSelectLimit()
boolean	supportsSelectOffset()
boolean	supportsSuperMetaDataQueries()
void	truncateTable(Connection C, java.lang.String schemaName, java.lang.String tableName, boolean cascade)
void	within(Connection Con, java.lang.StringBuilder Str, Type_DatetimePrimitive Col, Type_DatetimePrimitive ColStart, long DurationCount, DurationUtil.IntervalEnum DurationType)

Field Detail

SQLServer

static final DBType SQLServer

Postgres

static final DBType Postgres

BigQuery

static final DBType BigQuery

_DBTypes

static final DBType[] _DBTypes

Method Detail

getName

java.lang.String getName()

needsSavepoint

boolean needsSavepoint()

supportsArrays

boolean supportsArrays()

supportsSelectLimit

boolean supportsSelectLimit()

supportsSelectOffset

boolean supportsSelectOffset()

supportsFilterClause

boolean supportsFilterClause()

supportsFirstLastAggregates

boolean supportsFirstLastAggregates()

supportsPrimaryKeys

boolean supportsPrimaryKeys()

supportsForeignKeys

boolean supportsForeignKeys()

supportsIndices

boolean supportsIndices()

supportsSuperMetaDataQueries

boolean supportsSuperMetaDataQueries()

getSelectLimitClause

java.lang.String getSelectLimitClause(int Start,
                                      int Size)

getMaxColumnNameSize

int getMaxColumnNameSize()

getMaxTableNameSize

int getMaxTableNameSize()

getColumnQuotingStartChar

char getColumnQuotingStartChar()

getColumnQuotingEndChar

char getColumnQuotingEndChar()

getConnectionNoDataStates

java.lang.String[] getConnectionNoDataStates()

getConnectionLockMsgs

java.lang.String[] getConnectionLockMsgs()

getConnectionCancelStates

java.lang.String[] getConnectionCancelStates()

getCurrentTimestampStr

java.lang.String getCurrentTimestampStr()

Returns:

The string denoting the current timestamp with timezone statement, e.g., "statement_timestamp()" for Postgres, or "CURRENT_TIMESTAMP" for bigquery.

getCurrentDateTimeStr

java.lang.String getCurrentDateTimeStr()

Returns:

The string denoting the current timestamp without timezone statement, "statement_timestamp()::timestamp" for Postgres, or "CURRENT_DATETIME" for bigquery.

getCurrentDateStr

java.lang.String getCurrentDateStr()

isCaseSentitiveSchemaTableViewNames

boolean isCaseSentitiveSchemaTableViewNames()

getSQlCodeGen

CodeGenSql getSQlCodeGen()

createSchema

boolean createSchema(Connection Con,
                     Schema S)
              throws java.lang.Exception

Throws:

java.lang.Exception

createTable

boolean createTable(Connection Con,
                    Object Obj)
             throws java.lang.Exception

Throws:

java.lang.Exception

alterTableComment

boolean alterTableComment(Connection Con,
                          Object Obj)
                   throws java.lang.Exception

Throws:

java.lang.Exception

createKeysEntry

boolean createKeysEntry(Connection Con,
                        Object Obj)
                 throws java.lang.Exception

Throws:

java.lang.Exception

dropView

boolean dropView(Connection Con,
                 View V)
          throws java.lang.Exception

Throws:

java.lang.Exception

dropView

boolean dropView(Connection con,
                 ViewMeta v,
                 boolean cascade)
          throws java.lang.Exception

Throws:

java.lang.Exception

createView

boolean createView(Connection Con,
                   View V)
            throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAddColumn

boolean alterTableAddColumn(Connection Con,
                            Column Col,
                            java.lang.String DefaultValue,
                            java.lang.String temporaryDefaultValue)
                     throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnDefault

boolean alterTableAlterColumnDefault(Connection Con,
                                     Column Col)
                              throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnNumericSize

boolean alterTableAlterColumnNumericSize(Connection connection,
                                         ColumnMeta colMeta,
                                         Column col)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

alterTableDropColumn

boolean alterTableDropColumn(Connection Con,
                             Object Obj,
                             java.lang.String ColumnName)
                      throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnNull

boolean alterTableAlterColumnNull(Connection Con,
                                  Column Col,
                                  java.lang.String DefaultValue)
                           throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnComment

boolean alterTableAlterColumnComment(Connection Con,
                                     Column Col)
                              throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnType

boolean alterTableAlterColumnType(Connection Con,
                                  ColumnMeta ColMeta,
                                  Column Col,
                                  ZoneInfo_Data defaultZI)
                           throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnMulti

boolean alterTableAlterColumnMulti(Connection Con,
                                   java.util.List<ColMetaColPair> BatchTypeCols,
                                   java.util.List<ColMetaColPair> BatchSizeCols,
                                   ZoneInfo_Data defaultZI)
                            throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAlterColumnStringSize

boolean alterTableAlterColumnStringSize(Connection Con,
                                        ColumnMeta ColMeta,
                                        Column Col)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

alterTableReplaceTablePK

boolean alterTableReplaceTablePK(Connection Con,
                                 Object Obj,
                                 PKMeta oldPK)
                          throws java.lang.Exception

Throws:

java.lang.Exception

alterTableDropFK

boolean alterTableDropFK(Connection Con,
                         Object Obj,
                         FKMeta FK)
                  throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAddFK

boolean alterTableAddFK(Connection Con,
                        ForeignKey FK)
                 throws java.lang.Exception

Throws:

java.lang.Exception

alterTableDropIndex

boolean alterTableDropIndex(Connection Con,
                            Object Obj,
                            IndexMeta IX)
                     throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAddIndexDDL

java.lang.String alterTableAddIndexDDL(Index IX)
                                throws java.lang.Exception

Throws:

java.lang.Exception

alterTableAddIndex

boolean alterTableAddIndex(Connection Con,
                           Index IX)
                    throws java.lang.Exception

Throws:

java.lang.Exception

alterTableIndexDropCluster

boolean alterTableIndexDropCluster(Connection Con,
                                   IndexMeta IX)
                            throws java.lang.Exception

Throws:

java.lang.Exception

alterTableIndexAddCluster

boolean alterTableIndexAddCluster(Connection Con,
                                  Index IX)
                           throws java.lang.Exception

Throws:

java.lang.Exception

alterTableRenameIndex

boolean alterTableRenameIndex(Connection Con,
                              Object Obj,
                              java.lang.String OldName,
                              java.lang.String NewName)
                       throws java.lang.Exception

Throws:

java.lang.Exception

getHelperFunctionsScript

java.lang.String getHelperFunctionsScript(Connection Con,
                                          boolean start)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

getAclRolesScript

java.lang.String getAclRolesScript(Connection Con,
                                   java.util.List<Schema> TildaList)
                            throws java.lang.Exception

Throws:

java.lang.Exception

isSuperUser

boolean isSuperUser(Connection Con)
             throws java.lang.Exception

Throws:

java.lang.Exception

truncateTable

void truncateTable(Connection C,
                   java.lang.String schemaName,
                   java.lang.String tableName,
                   boolean cascade)
            throws java.lang.Exception

Throws:

java.lang.Exception

fullIdentifierOnUpdate

boolean fullIdentifierOnUpdate()

getAggregateStr

java.lang.String getAggregateStr(AggregateType AT)

getDBStringType

DBStringType getDBStringType(int Size)

getTypeMapping

StringStringPair getTypeMapping(int type,
                                java.lang.String name,
                                int size,
                                java.lang.String typeName)
                         throws java.lang.Exception

Throws:

java.lang.Exception

getFullTableVar

java.lang.String getFullTableVar(Object O)

getFullTableVar

java.lang.String getFullTableVar(Object O,
                                 int i)

getFullTableVar

void getFullTableVar(java.lang.StringBuilder Str,
                     java.lang.String SchemaName,
                     java.lang.String TableName)

getShortColumnVar

java.lang.String getShortColumnVar(java.lang.String name)

getShortColumnVar

java.lang.String getShortColumnVar(Column C)

rewriteExpressionColumnQuoting

java.lang.String rewriteExpressionColumnQuoting(java.lang.String expr)

getFullColumnVar

java.lang.String getFullColumnVar(Column C)

getFullColumnVar

java.lang.String getFullColumnVar(Column C,
                                  int i)

getFullColumnVar

void getFullColumnVar(java.lang.StringBuilder Str,
                      java.lang.String SchemaName,
                      java.lang.String TableName,
                      java.lang.String ColumnName)

getColumnType

java.lang.String getColumnType(Column C)

getColumnType

java.lang.String getColumnType(Column C,
                               ColumnType AggregateType)

getColumnType

void getColumnType(java.lang.StringBuilder Str,
                   ColumnType T,
                   java.lang.Integer S,
                   ColumnMode M,
                   boolean Collection,
                   java.lang.Integer Precision,
                   java.lang.Integer Scale)

getColumnTypeRaw

java.lang.String getColumnTypeRaw(Column C,
                                  boolean MultiOverride)

getColumnTypeRaw

java.lang.String getColumnTypeRaw(ColumnType Type,
                                  int Size,
                                  boolean isArray)

setArray

void setArray(Connection Con,
              java.sql.PreparedStatement PS,
              int i,
              ColumnType Type,
              java.util.List<java.sql.Array> allocatedArrays,
              java.util.Collection<?> val)
       throws java.lang.Exception

Throws:

java.lang.Exception

getJsonParametrizedQueryPlaceHolder

java.lang.String getJsonParametrizedQueryPlaceHolder()

setOrderByWithNullsOrdering

void setOrderByWithNullsOrdering(Connection Con,
                                 java.lang.StringBuilder Str,
                                 ColumnDefinition Col,
                                 boolean Asc,
                                 boolean NullsLast)

age

void age(Connection Con,
         java.lang.StringBuilder Str,
         Type_DatetimePrimitive ColStart,
         Type_DatetimePrimitive ColEnd,
         DurationUtil.IntervalEnum Type,
         int Count,
         java.lang.String Operator)

within

void within(Connection Con,
            java.lang.StringBuilder Str,
            Type_DatetimePrimitive Col,
            Type_DatetimePrimitive ColStart,
            long DurationCount,
            DurationUtil.IntervalEnum DurationType)

getBackendConnectionId

java.lang.String getBackendConnectionId(Connection con)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

cancel

void cancel(Connection con)
     throws java.sql.SQLException

Throws:

java.sql.SQLException

moveTableView

boolean moveTableView(Connection con,
                      Base base,
                      java.lang.String oldSchemaName)
               throws java.lang.Exception

Throws:

java.lang.Exception

renameTableView

boolean renameTableView(Connection con,
                        Base base,
                        java.lang.String oldName)
                 throws java.lang.Exception

Throws:

java.lang.Exception

renameTableColumn

boolean renameTableColumn(Connection con,
                          Column col,
                          java.lang.String oldName)
                   throws java.lang.Exception

Throws:

java.lang.Exception

getCurrentTimestamp

java.time.ZonedDateTime getCurrentTimestamp(Connection con)
                                     throws java.lang.Exception

Throws:

java.lang.Exception

getCurrentDateTime

java.time.ZonedDateTime getCurrentDateTime(Connection con)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

getCurrentDate

java.time.LocalDate getCurrentDate(Connection con)
                            throws java.lang.Exception

Throws:

java.lang.Exception

supportsReorg

boolean supportsReorg()

reorgTable

boolean reorgTable(Connection con,
                   java.lang.String schemaName,
                   java.lang.String tableName,
                   java.lang.String clusterIndexName,
                   boolean verbose,
                   boolean full)
            throws java.lang.Exception

Throws:

java.lang.Exception