Constructor and Description |
---|
TBaseType() |
Modifier and Type | Method and Description |
---|---|
static void |
addToCryptFunctions(String functionName,
Integer keyPosition)
In order to replace key argument used in some user defined functions when generate sql text from TCustomSqlStatement.asCanonical()
We use this function to set the functions the need to be process. |
static void |
calculateSqlLinesStats(List<String> directoryPaths,
long timeInMillis)
Calculates statistics for SQL files within a given directory.
|
static void |
clearCryptFunctions() |
static boolean |
compareStringBuilderToFile(StringBuilder actual,
String requiredSourceFileName) |
static boolean |
compareStringsLineByLine(String str1,
String str2) |
static boolean |
comparyStringArray(String[] actualText,
String[] requiredText) |
static void |
dumpLogs(boolean force) |
static void |
dumpLogsToFile(String fileName) |
static String |
dumpLogsToString() |
static List<String> |
getArrayListBetweenTokens(TSourceToken startToken,
TSourceToken endToken,
boolean includeNonSolidToken)
return an array list in text between ( and ), which is start token and end token, like this: ( option1=value1, option2=value2, option3=values )
the result is an array like this:
option1=value1 option2=value2 option3=value3 |
static String |
getLastPartOfQualifiedName(String str) |
static String |
getOption(List<String> optionList,
String optionName)
The input optionList is in format like this:
option1=value1 option2=value2 option3=value3 when optionName is option1, value1 should be returned. |
static List<String> |
getOptionNames(List<String> optionList) |
static String |
getStringInsideLiteral(String literalStr)
Extracts the string content from inside a SQL literal value.
|
static String |
getTextByTokenCode(int tokenCode) |
static String |
getTextWithoutQuoted(String str) |
static boolean |
isSupportLateralColumn(EDbVendor pDbvendor) |
static void |
log(String message,
int type) |
static void |
log(String message,
int type,
long line,
long column) |
static void |
log(String message,
int type,
TParseTreeNode node) |
static void |
log(String message,
int type,
TSourceToken token) |
static int |
logSize() |
static String |
numberOfSpace(int pNum,
char space) |
static String |
readFile(String path,
Charset encoding) |
static String |
readFromTextfile(File file) |
static String |
removeDelimiters(String str,
char leftDelim,
char rightDelim,
boolean doublequote)
Efficiently removes delimiters from SQL identifiers without unnecessary string allocations.
|
static String |
removePrefixOrSuffixQuoteChar(String str) |
static String |
removeQuoteChar(String str) |
static void |
resetTokenChain(TSourceTokenList pSourceTokenList,
int startPos) |
static Integer |
searchCryptFunction(String functionName) |
static boolean |
searchOracleTablePros(String str) |
static String |
stringBlock(int line,
int column) |
static String |
stringBlock(int lineNo,
int columnNo,
int quotedSymbolLength,
String quotedStr) |
static String |
toHex(String arg,
String charset) |
public static final String versionid
public static final String releaseDate
public static final boolean full_edition
public static final String version
public static final String vendorEmail
public static double db_version_num
public static boolean DEBUG
public static boolean DEBUG_PARSE_TABLE
public static boolean ENABLE_ERROR_RECOVER_IN_CREATE_TABLE
public static boolean ENABLE_INTERPRETER
public static boolean ENABLE_RESOLVER
public static boolean DUMP_RESOLVER_LOG_TO_CONSOLE
public static boolean USE_JOINEXPR_INSTEAD_OF_JOIN
public static String sqlflow_stmt_delimiter_str
public static final int tag_token_value_changed_in_on_canonical
public static boolean as_canonical_f_decrypt_replace_password
public static boolean REDSHIFT_ENABLE_BRACKET_NAME
public static final int BOOL_VALUE_FALSE
public static final int BOOL_VALUE_TRUE
public static final int BOOL_VALUE_NOT_SET
public static final int MATCH_COLUMN_RESULT_NOT_MATCH
public static final int MATCH_COLUMN_RESULT_MATCHED
public static final int MATCH_COLUMN_RESULT_MATCHED_COLUMN_PROPERTY
public static final int MATCH_COLUMN_RESULT_MAYBE_MATCH_P1
public static final int MATCH_COLUMN_RESULT_MAYBE_MATCH_P3
public static final int MATCH_COLUMN_RESULT_MAYBE_MATCH_P4
public static final int MATCH_COLUMN_RESULT_MAYBE_MATCH_P5
public static final int MATCH_COLUMN_RESULT_MAYBE_MATCH_P9
public static final int CAN_BE_COLUMN_NOT_VALIDATE_YET
public static final int VALIDATED_CAN_BE_A_COLUMN_NAME
public static final int VALIDATED_CAN_NOT_BE_A_COLUMN_NAME
public static final int MARKED_NOT_A_COLUMN_IN_COLUMN_RESOLVER
public static final int COLUMN_LINKED_TO_COLUMN_ALIAS_IN_OLD_ALGORITHM
public static final int COLUMN_LINKED_TO_TABLE_IN_OLD_ALGORITHM
public static final int NOT_RESOLVED_YET
public static final int RESOLVED_BUT_NOT_FOUND
public static final int RESOLVED_AND_FOUND
public static final int RESOLVED_BUT_AMBIGUOUS
public static final int RESOLVE_DELAY_TO_COLUMN_RESOLVER
public static final int GUESS_COLUMN_STRATEGY_NEAREST
public static final int GUESS_COLUMN_STRATEGY_FARTHEST
public static final int GUESS_COLUMN_STRATEGY_NOT_PICKUP
public static final String[] GUESS_COLUMN_STRATEGY_MSG
public static int GUESS_COLUMN_STRATEGY
public static final int COLUMN_IN_TABEL_FUNCTION_YES
public static final int COLUMN_IN_TABEL_FUNCTION_NO
public static final int COLUMN_IN_TABEL_FUNCTION_NOTSURE
public static final int MSG_WARNING_ERROR_WHEN_TOKENIZE
public static final int MSG_HINT_FIND_ORPHAN_COLUMN
public static final int MSG_ERROR_NO_ROOT_NODE
public static final int MSG_ERROR_AND_KEYWORD_CANT_USED_AS_TABLE_ALIAS
public static final int MSG_ERROR_RESERVED_KEYWORD_CANT_USED_AS_COLUMN_NAME
public static final int MSG_ERROR_FUNCTION_IN_SET_CLAUSE
public static final int MSG_ERROR_DUPLICATED_COLUMN_NAME
public static final int MSG_ERROR_SYNTAX_ERROR
public static final int MSG_ERROR_INSERT_VALUE_COLUMN_NUMBER_NOT_MATCH
public static final int MSG_ERROR_COLUMN_NOT_FOUND
public static final String windowsLinebreak
public static final String windowsLinebreakEscape
public static boolean bigquery_legacysql_compatible
public static final int cmtslashstar
public static final int cmtdoublehyphen
public static final int lexspace
public static final int lexnewline
public static final int fconst
public static final int sconst
public static final int iconst
public static final int ident
public static final int op
public static final int cmpop
public static final int bind_v
public static final int assign_sign
public static final int double_dot
public static final int label_begin
public static final int hive_CharSetName
public static final int label_end
public static final int hive_div
public static final int substitution_v
public static final int filepath_sign
public static final int hive_number
public static final int sqlpluscmd
public static final int atversion
public static final int left_parenthesis_3
public static final int error
public static final int variable
public static final int hive_DecimalLiteral
public static final int hive_StringLiteral
public static final int hive_CharSetLiteral
public static final int hive_ByteLengthLiteral
public static final int hive_BigintLiteral
public static final int hive_SmallintLiteral
public static final int hive_TinyintLiteral
public static final int mslabel
public static final int RW_NATURAL2
public static final int bconst
public static final int equal_start_expr
public static final int leftjoin_op
public static final int logic_and_op
public static final int odbc_esc_prefix
public static final int rightjoin_op
public static final int logic_or_op
public static final int odbc_esc_terminator
public static final int dax_column_token
public static final int with_rollup
public static final int RW_FULL2
public static final int db2label
public static final int xconst
public static final int teradata_unicode_sconst
public static final int scriptoptions
public static final int JSON_GET_TEXT
public static final int ORACLE_OUTER2
public static final int mysqllabel
public static final int JSON_GET_TEXT_AT_PATH
public static final int BTEQCMD
public static final int concatenationop
public static final int rw_not_deferrable
public static final int JSON_GET_OBJECT
public static final int rw_for1
public static final int JSON_GET_OBJECT_AT_PATH
public static final int rw_not1
public static final int rw_for_system_time
public static final int stmt_delimiter
public static final int m_clause
public static final int rw_sybase_at1
public static final int typecast
public static final int rrw_time2_teradata
public static final int rrw_merge2_sqlserver
public static final int k_clause
public static final int rw_sybase_update1
public static final int JSON_LEFT_CONTAIN
public static final int safe_equal
public static final int rrw_date2_teradata
public static final int measure_equal
public static final int slash_dot
public static final int postgresql_arary_operator
public static final int outer_join
public static final int hive_equal
public static final int rrw_timestamp2_teradata
public static final int not_equal
public static final int not_great
public static final int not_less
public static final int great_equal
public static final int less_equal
public static final int exponentiate
public static final int boolean_and
public static final int rowtype_operator
public static final int boolean_or
public static final int JSON_RIGHT_CONTAIN
public static final int square_root
public static final int cube_root
public static final int bitwise_shift_left
public static final int bitwise_shift_right
public static final int rw_locktable
public static final int rw_foreign2
public static final int rw_constraint2
public static final int JSON_EXIST
public static final int HIVE_FUNC_IDENT
public static final int rw_primary2
public static final int JSON_ANY_EXIST
public static final int rw_unique2
public static final int JSON_ALL_EXIST
public static final int IDENT_BEFORE_COLON
public static final int NEXT_PARAM
public static final int POSITIONAL_PARAM
public static final int NAMED_PARAM
public static final int rrw_select
public static final int rrw_insert
public static final int rrw_delete
public static final int rrw_update
public static final int rrw_if
public static final int rrw_for
public static final int rrw_create
public static final int rrw_table
public static final int rrw_index
public static final int rrw_view
public static final int rrw_with
public static final int rrw_start
public static final int rrw_end
public static final int rrw_drop
public static final int rrw_declare
public static final int rrw_case
public static final int rrw_where
public static final int rrw_having
public static final int rrw_and
public static final int rrw_or
public static final int rrw_not
public static final int rrw_when
public static final int rrw_on
public static final int rrw_join
public static final int rrw_set
public static final int rrw_values
public static final int rrw_object
public static final int rrw_record
public static final int rrw_from
public static final int rrw_group
public static final int rrw_sort
public static final int rrw_into
public static final int rrw_order
public static final int rrw_fetch
public static final int rrw_decode
public static final int rrw_over
public static final int rrw_extract
public static final int rrw_distinct
public static final int rrw_all
public static final int rrw_by
public static final int rrw_as
public static final int rrw_union
public static final int rrw_left
public static final int rrw_right
public static final int rrw_inner
public static final int rrw_full
public static final int rrw_outer
public static final int rrw_then
public static final int rrw_else
public static final int rrw_between
public static final int rrw_begin
public static final int rrw_except
public static final int rrw_minus
public static final int rrw_intersect
public static final int rrw_bit
public static final int rrw_tinyint
public static final int rrw_smallint
public static final int rrw_mediumint
public static final int rrw_middleint
public static final int rrw_int
public static final int rrw_integer
public static final int rrw_int1
public static final int rrw_int2
public static final int rrw_int3
public static final int rrw_int4
public static final int rrw_int8
public static final int rrw_bigint
public static final int rrw_float
public static final int rrw_float4
public static final int rrw_float8
public static final int rrw_num
public static final int rrw_numeric
public static final int rrw_number
public static final int rrw_real
public static final int rrw_decimal
public static final int rrw_dec
public static final int rrw_double
public static final int rrw_precision
public static final int rrw_char
public static final int rrw_nchar
public static final int rrw_character
public static final int rrw_varchar
public static final int rrw_varchar2
public static final int rrw_national
public static final int rrw_nvarchar
public static final int rrw_nvarchar2
public static final int rrw_varbinary
public static final int rrw_varying
public static final int rrw_tinytext
public static final int rrw_text
public static final int rrw_mediumtext
public static final int rrw_longtext
public static final int rrw_time
public static final int rrw_date
public static final int rrw_timestamp
public static final int rrw_year
public static final int rrw_local
public static final int rrw_zone
public static final int rrw_long
public static final int rrw_raw
public static final int rrw_blob
public static final int rrw_tinyblob
public static final int rrw_mediumblob
public static final int rrw_longblob
public static final int rrw_clob
public static final int rrw_nclob
public static final int rrw_dbclob
public static final int rrw_bfile
public static final int rrw_large
public static final int rrw_data
public static final int rrw_binary
public static final int rrw_graphic
public static final int rrw_vargraphic
public static final int rrw_datalink
public static final int rrw_enum
public static final int rrw_interval
public static final int rrw_urowid
public static final int rrw_merge
public static final int rrw_commit
public static final int rrw_rollback
public static final int rrw_savepoint
public static final int rrw_revoke
public static final int rrw_grant
public static final int rrw_truncate
public static final int rrw_database
public static final int rrw_alter
public static final int rrw_return
public static final int rrw_add
public static final int rrw_close
public static final int rrw_continue
public static final int rrw_backup
public static final int rrw_break
public static final int rrw_bulk
public static final int rrw_dbcc
public static final int rrw_deallocate
public static final int rrw_deny
public static final int rrw_disable
public static final int rrw_enable
public static final int rrw_exec
public static final int rrw_execute
public static final int rrw_goto
public static final int rrw_kill
public static final int rrw_open
public static final int rrw_save
public static final int rrw_move
public static final int rrw_print
public static final int rrw_raiserror
public static final int rrw_readtext
public static final int rrw_receive
public static final int rrw_reconfigure
public static final int rrw_restore
public static final int rrw_send
public static final int rrw_setuser
public static final int rrw_shutdown
public static final int rrw_sign
public static final int rrw_try
public static final int rrw_updatetext
public static final int rrw_use
public static final int rrw_waitfor
public static final int rrw_while
public static final int rrw_writetext
public static final int rrw_catch
public static final int rrw_go
public static final int rrw_openrowset
public static final int rrw_analyze
public static final int rrw_associate
public static final int rrw_audit
public static final int rrw_call
public static final int rrw_comment
public static final int rrw_disassociate
public static final int rrw_explain
public static final int rrw_flashback
public static final int rrw_lock
public static final int rrw_noaudit
public static final int rrw_purge
public static final int rrw_rename
public static final int rrw_procedure
public static final int rrw_function
public static final int rrw_package
public static final int rrw_allocate
public static final int rrw_connect
public static final int rrw_describe
public static final int rrw_disconnect
public static final int rrw_flush
public static final int rrw_free
public static final int rrw_get
public static final int rrw_include
public static final int rrw_iterate
public static final int rrw_leave
public static final int rrw_loop
public static final int rrw_prepare
public static final int rrw_refresh
public static final int rrw_release
public static final int rrw_repeat
public static final int rrw_resignal
public static final int rrw_signal
public static final int rrw_cache
public static final int rrw_change
public static final int rrw_check
public static final int rrw_checksum
public static final int rrw_do
public static final int rrw_handler
public static final int rrw_load
public static final int rrw_optimize
public static final int rrw_replace
public static final int rrw_repair
public static final int rrw_reset
public static final int rrw_show
public static final int rrw_stop
public static final int rrw_unlock
public static final int rrw_terminate
public static final int rrw_to
public static final int rrw_primary
public static final int rrw_unique
public static final int rrw_constraint
public static final int rrw_foreign
public static final int rrw_revert
public static final int rrw_checkpoint
public static final int rrw_calculate
public static final int rrw_clear
public static final int rrw_drillthrough
public static final int rrw_freeze
public static final int rrw_existing
public static final int rrw_scope
public static final int rrw_is
public static final int rrw_body
public static final int rrw_abort
public static final int rrw_databricks_msck
public static final int rrw_databricks_sync
public static final int rrw_databricks_copy
public static final int rrw_databricks_uncache
public static final int rrw_databricks_desc
public static final int rrw_databricks_list
public static final int rrw_databricks_values_insert
public static final int rrw_databricks_datatype_used_to_cast
public static final int rrw_databricks_convert
public static final int rrw_databricks_fsck
public static final int rrw_databricks_reorg
public static final int rrw_databricks_vacuum
public static final int castoperator
public static final int rrw_informix_unload
public static final int rrw_informix_whenever
public static final int rrw_informix_put
public static final int rrw_informix_output
public static final int rrw_informix_info
public static final int rrw_informix_connect_to
public static final int rrw_rr
public static final int rrw_rs
public static final int rrw_cs
public static final int rrw_ur
public static final int rrw_with_isolation
public static final int rrw_declare_global
public static final int rrw_db2_second
public static final int rrw_db2_label
public static final int rrw_db2_tablespace
public static final int rrw_db2_runstats
public static final int rrw_db2_current
public static final int rrw_jdbc_escape_fn
public static final int rrw_jdbc_escape_end
public static final int rrw_db2_trim_l
public static final int rrw_db2_trim_r
public static final int rrw_db2_trim
public static final int param
public static final int rrw_postgresql_cluster
public static final int rrw_postgresql_copy
public static final int rrw_postgresql_discard
public static final int rrw_postgresql_listen
public static final int rrw_postgresql_notify
public static final int rrw_postgresql_reassign
public static final int rrw_postgresql_reindex
public static final int rrw_postgresql_security
public static final int rrw_postgresql_unlisten
public static final int rrw_cascade
public static final int rrw_restrict
public static final int rrw_perform
public static final int rrw_debug
public static final int rrw_exception
public static final int rrw_notice
public static final int rrw_postgresql_info
public static final int rrw_warning
public static final int rrw_log
public static final int rrw_postgresql_rowtype
public static final int rrw_plpgsql_function_delimiter
public static final int rrw_postgresql_vacuum
public static final int rrw_postgresql_do_update
public static final int rrw_postgresql_POSITION_FUNCTION
public static final int rrw_postgresql_POSITION
public static final int rrw_postgresql_insert_values
public static final int rrw_postgresql_conflict
public static final int rrw_postgresql_nothing
public static final int rrw_postgresql_import
public static final int rrw_postgresql_with_lookahead
public static final int rrw_postgresql_ordinality
public static final int rrw_postgresql_filter
public static final int OP_STAR_EQUAL
public static final int OP_STAR_LESS
public static final int OP_STAR_GREAT
public static final int OP_SQUARE_ROOT
public static final int OP_LESS_LESS
public static final int OP_GREAT_GREAT
public static final int OP_EXCLAMATION_EXCLAMATION
public static final int OP_TILDE_TILDE
public static final int OP_TILDE_STAR
public static final int OP_EXCLAMATION_TILDE
public static final int OP_AT_AT
public static final int OP_POUND_POUND
public static final int OP_AT_GREAT
public static final int OP_LESS_AT
public static final int OP_PUNCTUATION_PUNCTUATION
public static final int OP_PUNCTUATION_LESS
public static final int OP_PUNCTUATION_GREAT
public static final int OP_LESS_CARET
public static final int OP_GREAT_CARET
public static final int OP_QUESTION_POUND
public static final int OP_QUESTION_MINUS
public static final int OP_QUESTION_BAR
public static final int OP_TILDE_EQUAL
public static final int OP_MINUS_GREAT
public static final int OP_POUND_GREAT
public static final int OP_QUESTION_PUNCTUATION
public static final int OP_POUND_MINUS
public static final int OP_AT_QUESTION
public static final int OP_STAR_LESS_GREAT
public static final int OP_STAR_LESS_EQUAL
public static final int OP_STAR_GREAT_EQUAL
public static final int OP_CUBE_ROOT
public static final int OP_TILDE_TILDE_STAR
public static final int OP_EXCLAMATION_TIDLE_TIDLE
public static final int OP_EXCLAMATION_TIDLE_TIDLE_STAR
public static final int OP_EXCLAMATION_TIDLE_STAR
public static final int OP_AT_MINUS_AT
public static final int OP_LESS_MINUS_GREAT
public static final int OP_LESS_LESS_BAR
public static final int OP_BAR_GREAT_GREAT
public static final int OP_PUNCTUATION_LESS_BAR
public static final int OP_BAR_PUNCTUATION_GREAT
public static final int OP_QUESTION_MINUS_BAR
public static final int OP_QUESTION_BAR_BAR
public static final int OP_LESS_LESS_EQUAL
public static final int OP_GREAT_GREAT_EQUAL
public static final int OP_AT_AT_AT
public static final int OP_MINUS_GREAT_GREAT
public static final int OP_POUND_GREAT_GREAT
public static final int OP_MINUS_BAR_MINUS
public static final int OP_JSONB_QUESTION
public static final int rrw_postgresql_json
public static final int rrw_postgresql_jsonb
public static final int OP_TILDE_GREAT_TILDE
public static final int OP_TILDE_LESS_TILDE
public static final int OP_TILDE_GREAT_EQUAL_TILDE
public static final int OP_TILDE_LESS_EQUAL_TILDE
public static final int OP_LESS_LESS_LESS
public static final int OP_GREAT_GREAT_GREAT
public static final int OP_LESS_PERCENT
public static final int OP_GREAT_PERCENT
public static final int rrw_postgresql_recursive
public static final int rrw_postgresql_function_delimiter
public static final int rrw_postgresql_language
public static final int rrw_postgresql_type
public static final int OP_SAFE_EQUAL
public static final int GAUSSDB_CURSOR
public static final int GAUSSDB_DECLARE_SINGLE_STMT
public static final int GAUSSDB_BEGIN_TRANSACTION
public static final int GAUSSDB_PROCEDURE_ORA
public static final int GAUSSDB_FUNCTION_ORA
public static final int GAUSSDB_TO_NUMBER
public static final int GAUSSDB_NULL
public static final int rrw_greenplum_cluster
public static final int rrw_greenplum_copy
public static final int rrw_greenplum_reassign
public static final int rrw_greenplum_reindex
public static final int rrw_greenplum_vacuum
public static final int rrw_greenplum_language
public static final int rrw_greenplum_rowtype
public static final int rrw_greenplum_analyse
public static final int rrw_greenplum_DATE_FUNCTION
public static final int rrw_greenplum_POSITION_FUNCTION
public static final int rrw_greenplum_POSITION
public static final int rrw_greenplum_CURSOR
public static final int rrw_greenplum_exits
public static final int rrw_greenplum_filter
public static final int rrw_greenplum_values_insert
public static final int rrw_greenplum_function_delimiter
public static final int logical_and
public static final int logical_or
public static final int rrw_left_shift
public static final int rrw_right_shift
public static final int rrw_mysql_desc
public static final int rrw_mysql_delimiter
public static final int rrw_rollup
public static final int rrw_mysql_date_function
public static final int rrw_mysql_date_const
public static final int rrw_mysql_time_const
public static final int rrw_mysql_row
public static final int rrw_mysql_each
public static final int rrw_mysql_source
public static final int rrw_mysql_interval_func
public static final int rrw_mysql_true
public static final int rrw_mysql_false
public static final int rrw_mysql_default
public static final int rrw_mysql_d
public static final int rrw_mysql_t
public static final int rrw_mysql_ts
public static final int rrw_mysql_null
public static final int rrw_mysql_current
public static final int rrw_mysql_timestamp_constant
public static final int rrw_mysql_position
public static final int rrw_custom
public static final int rrw_translate
public static final int rrw_keep
public static final int rrw_keep_before_dense_rank
public static final int rrw_dense_rank
public static final int rrw_wrapped
public static final int rrw_level
public static final int rrw_match
public static final int rrw_natural
public static final int rrw_type2
public static final int rrw_type
public static final int rrw_of
public static final int rrw_oid
public static final int rrw_null
public static final int rrw_trigger
public static final int rrw_library
public static final int rrw_value_after_by
public static final int rrw_value_oracle
public static final int rrw_new_oracle
public static final int rrw_chr_oracle
public static final int rrw_errors_oracle
public static final int rrw_log_oracle
public static final int rrw_add_p
public static final int rrw_partition
public static final int rrw_oracle_apply
public static final int rrw_oracle_subpartition
public static final int rrw_oracle_subpartition_tablesample
public static final int rrw_oracle_new_constructor
public static final int rrw_oracle_supplemental
public static final int rrw_oracle_compound
public static final int rrw_oracle_offset
public static final int rrw_oracle_row
public static final int rrw_oracle_rows
public static final int rrw_oracle_offset_row
public static final int rrw_oracle_a_in_aset
public static final int rrw_oracle_set_in_aset
public static final int rrw_oracle_modify
public static final int rrw_oracle_column
public static final int rrw_oracle_column_after_modify
public static final int rrw_oracle_without
public static final int rrw_oracle_count
public static final int rrw_oracle_without_before_count
public static final int rrw_oracle_cursor
public static final int rrw_oracle_collect
public static final int rrw_oracle_synonym
public static final int rrw_oracle_model
public static final int rrw_oracle_model_in_model_clause
public static final int twocolons
public static final int compoundAssignmentOperator
public static final int SEMI_COLON_AFTER_BEGIN
public static final int rrw_starea
public static final int rrw_stasbinary
public static final int rrw_stastext
public static final int rrw_stbuffer
public static final int rrw_stdimension
public static final int rrw_stdisjoint
public static final int rrw_stdistance
public static final int rrw_stendpoint
public static final int rrw_stgeometryn
public static final int rrw_stgeometrytype
public static final int rrw_stintersection
public static final int rrw_stintersects
public static final int rrw_stisclosed
public static final int rrw_stisempty
public static final int rrw_stlength
public static final int rrw_stnumgeometries
public static final int rrw_stnumpoints
public static final int rrw_stpointn
public static final int rrw_stsrid
public static final int rrw_ststartpoint
public static final int rrw_stunion
public static final int rrw_xml_value
public static final int rrw_xml_modify
public static final int rrw_xml_query
public static final int rrw_xml_exist
public static final int rrw_xml_nodes
public static final int rrw_sqlserver_value
public static final int rrw_sqlserver_modify
public static final int rrw_sqlserver_query
public static final int rrw_sqlserver_exist
public static final int rrw_sqlserver_nodes
public static final int rrw_sqlserver_throw
public static final int rrw_system_time
public static final int rrw_xmlnamespaces
public static final int rrw_sqlserver_next
public static final int rrw_sqlserver_row
public static final int rrw_sqlserver_rows
public static final int rrw_sqlserver_offset_fetch
public static final int rrw_sqlserver_odbc_escape
public static final int rrw_sqlserver_exists
public static final int rrw_sqlserver_copy
public static final int rrw_sqlserver_copyinto
public static final int rrw_sqlserver_column
public static final int rrw_sqlserver_drop_column
public static final int rrw_sqlserver_check_with
public static final int rrw_sqlserver_semicolon_module_number
public static final int rrw_sqlserver_trim
public static final int rrw_sqlserver_synonym
public static final int rrw_sqlserver_sequence
public static final int rrw_soql_update_tracking
public static final int rrw_sybase_dump
public static final int rrw_sybase_at
public static final int rrw_sybase_isolation
public static final int rrw_sybase_off
public static final int rrw_sybase_partition
public static final int rrw_sybase_exce_proc_name
public static final int rrw_teradata_using
public static final int rrw_bt
public static final int rrw_teradata_collect
public static final int rrw_teradata_cm
public static final int rrw_ct
public static final int rrw_teradata_del
public static final int rrw_teradata_diagnostic
public static final int rrw_teradata_dump
public static final int rrw_teradata_echo
public static final int rrw_et
public static final int rrw_teradata_give
public static final int rrw_teradata_help
public static final int rrw_teradata_ins
public static final int rrw_logoff
public static final int rrw_teradata_logon
public static final int rrw_teradata_modify
public static final int rrw_teradata_position
public static final int rrw_teradata_restart
public static final int rrw_rewind
public static final int rrw_teradata_sel
public static final int rrw_ss
public static final int rrw_teradata_upd
public static final int rrw_teradata_wait
public static final int rrw_teradata_locking
public static final int rrw_casespecific
public static final int rrw_teradata_cs
public static final int rrw_teradata_add_months
public static final int rrw_teradata_format
public static final int rrw_teradata_title
public static final int rrw_teradata_named
public static final int left_parenthesis_2
public static final int rrw_teradata_start_data_conversion
public static final int rrw_teradata_period
public static final int rrw_teradata_cast
public static final int rrw_teradata_cv
public static final int rrw_teradata_for_loop
public static final int rrw_teradata_last
public static final int rrw_last_function
public static final int rrw_teradata_transaction
public static final int rrw_teradata_end_t
public static final int rrw_teradata_exit
public static final int rrw_teradata_label
public static final int rrw_teradata_pivot
public static final int rrw_teradata_cursor_name
public static final int rrw_teradata_condition_name
public static final int rrw_teradata_case_stmt
public static final int rrw_teradata_with_grant
public static final int rrw_teradata_external
public static final int rrw_teradata_type
public static final int rrw_teradata_sample
public static final int rrw_teradata_validtime
public static final int rrw_teradata_sequenced
public static final int rrw_teradata_nonsequenced
public static final int rrw_hive_desc
public static final int rrw_hive_msck
public static final int rrw_hive_export
public static final int rrw_hive_import
public static final int rrw_hive_recover
public static final int rrw_map
public static final int rrw_formatted
public static final int rrw_extended
public static final int rrw_pretty
public static final int rrw_shared
public static final int rrw_exclusive
public static final int rrw_show_database
public static final int rrw_hive_DATE_FUNCTION
public static final int rrw_hive_rollup
public static final int rrw_hive_cube
public static final int rrw_hive_upsert
public static final int rrw_netezza_groom
public static final int rrw_netezza_copy
public static final int rrw_netezza_generate
public static final int rrw_int_cast
public static final int rrw_integer_cast
public static final int rrw_smallint_cast
public static final int rrw_bigint_cast
public static final int rrw_real_cast
public static final int rrw_float_cast
public static final int rrw_numeric_cast
public static final int rrw_boolean_cast
public static final int rrw_bit_cast
public static final int rrw_char_cast
public static final int rrw_nchar_cast
public static final int rrw_varchar_cast
public static final int rrw_character_cast
public static final int rrw_date_cast
public static final int rrw_time_cast
public static final int rrw_timestamp_cast
public static final int rrw_interval_cast
public static final int rrw_decimal_cast
public static final int rrw_begin_proc
public static final int rrw_end_proc
public static final int rrw_netezza_op_less_less
public static final int rrw_netezza_op_great_great
public static final int hive_DOT
public static final int hive_COLON
public static final int hive_COMMA
public static final int hive_SEMICOLON
public static final int hive_LPAREN
public static final int hive_RPAREN
public static final int hive_LSQUARE
public static final int hive_RSQUARE
public static final int hive_LCURLY
public static final int hive_RCURLY
public static final int hive_LESSTHAN
public static final int hive_GREATERTHAN
public static final int hive_DIVIDE
public static final int hive_PLUS
public static final int hive_MINUS
public static final int hive_STAR
public static final int hive_MOD
public static final int hive_AMPERSAND
public static final int hive_TILDE
public static final int hive_BITWISEOR
public static final int hive_BITWISEXOR
public static final int hive_QUESTION
public static final int hive_DOLLAR
public static final int rrw_redshift_cancel
public static final int rrw_redshift_unload
public static final int rrw_redshift_verbose
public static final int rrw_redshift_struct
public static final int rrw_redshift_array
public static final int rrw_redshift_array_type
public static final int rrw_redshift_vacuum
public static final int rrw_redshift_copy
public static final int rrw_redshift_rowtype
public static final int rrw_redshift_filter
public static final int rrw_redshift_function_delimiter
public static final int rrw_redshift_language
public static final int rrw_hana_unset
public static final int rrw_hana_upsert
public static final int rrw_as_before_of
public static final int rrw_hana_import
public static final int rrw_hana_export
public static final int rrw_hana_of
public static final int rrw_hana_date_const
public static final int rrw_hana_time_const
public static final int rrw_hana_timestamp_const
public static final int rrw_hana_with_structured
public static final int rrw_hana_with_cache
public static final int rrw_hana_with_check
public static final int rrw_hana_recover
public static final int rrw_hana_unload
public static final int rrw_hana_unload2
public static final int rrw_hana_validate
public static final int rrw_hana_header
public static final int rrw_hana_with_mask
public static final int rrw_hana_with_expression
public static final int rrw_hana_with_anonymization
public static final int rrw_hana_with_hint
public static final int rrw_dax_define
public static final int rrw_dax_evaluate
public static final int rrw_dax_product
public static final int rrw_dax_true
public static final int rrw_dax_false
public static final int rrw_dax_calendar
public static final int rrw_dax_second
public static final int rrw_odbc_d
public static final int rrw_odbc_t
public static final int rrw_odbc_ts
public static final int rrw_odbc_oj
public static final int rrw_odbc_fn
public static final int rrw_odbc_escape
public static final int rrw_vertica_activate
public static final int rrw_vertica_deactivate
public static final int rrw_vertica_profile
public static final int rrw_vertica_date_function
public static final int rrw_vertica_greatest
public static final int rrw_vertica_least
public static final int rrw_vertica_copy
public static final int rrw_vertica_export
public static final int rrw_openedge_with_check
public static final int howtoSetValue_none
public static final int howtoSetValue_assign
public static final int howtoSetValue_default
public static final int kind_create
public static final int kind_declare
public static final int kind_define
public static final int kind_create_body
public static final int rrw_couchbase_build
public static final int rrw_couchbase_infer
public static final int rrw_couchbase_upsert
public static final int rrw_snowflake_list
public static final int rrw_snowflake_remove
public static final int rrw_snowflake_undrop
public static final int rrw_snowflake_copy
public static final int rrw_snowflake_desc
public static final int rrw_snowflake_ls
public static final int rrw_snowflake_put
public static final int rrw_snowflake_rm
public static final int rrw_snowflake_unset
public static final int rrw_snowflake_at
public static final int rrw_snowflake_at_before_parenthesis
public static final int rrw_snowflake_pseudo_stmt_sign
public static final int rrw_snowflake_date
public static final int rrw_snowflake_time
public static final int rrw_snowflake_char
public static final int rrw_snowflake_begin_transaction
public static final int rrw_snowflake_language
public static final int rrw_snowflake_plpgsql_function_delimiter
public static final int rrw_snowflake_datetime
public static final int rrw_snowflake_window
public static final int rrw_snowflake_window_as
public static final int rrw_snowflake_pivot
public static final int rrw_snowflake_unpivot
public static final int rrw_snowflake_default
public static final int rrw_snowflake_flatten
public static final int rrw_snowflake_offset
public static final int rrw_snowflake_replace_after_star
public static final int rrw_snowflake_function_delimiter
public static final int rrw_snowflake_parameter_name
public static final int rrw_snowflake_exists
public static final int rrw_snowflake_transaction
public static final int rrw_snowflake_javascript
public static final int rrw_snowflake_top
public static final int rrw_snowflake_limit
public static final int rrw_snowflake_work
public static final int rrw_snowflake_left_join
public static final int rrw_snowflake_right_join
public static final int rrw_bigquery_struct
public static final int rrw_bigquery_struct_constructor
public static final int rrw_bigquery_datatype_used_to_cast
public static final int rrw_bigquery_export
public static final int rrw_bigquery_begin_transaction
public static final int rrw_spark_uncache
public static final int rrw_spark_desc
public static final int rrw_spark_list
public static final int rrw_spark_date_const
public static final int rrw_spark_date_function
public static final int rrw_spark_time_const
public static final int rrw_spark_timestamp_constant
public static final int rrw_spark_msck
public static final int rrw_presto_verbose
public static final int rrw_athena_unload
public static final int rrw_athena_msck
public static final int kind_create_incomplete
EOracleCreateType.octIncomplete
public static final int kind_create_varray
EOracleCreateType.octVarray
public static final int kind_create_nested_table
EOracleCreateType.octNestedTable
public static final int kind_create_type_placeholder
public static final int fireMode_before
public static final int fireMode_after
public static final int fireMode_insteadOf
public static final int fireMode_for
public static final int join_source_fake
public static final int join_source_table
public static final int join_source_join
public static final int vt_values
public static final int vt_query
public static final int vt_default_values
public static final int vt_execute
public static final int vt_values_function
public static final int vt_values_empty
public static final int vt_set_column_value
public static final int vt_values_oracle_record
public static final int vt_values_multi_table
public static final int vt_hive
public static final int vt_hive_query
public static final int vt_table
public static final int declare_varaible_normal
public static final int declare_varaible_cursor
public static final int declare_varaible_table
public static final int declare_statement_variable
public static final int declare_statement_cursor
public static final int declare_statement_conditions
public static final int declare_statement_handlers
public static final int declare_statement_statement
public static final int declare_statement_returnCode
public static final int condition_statement_if
public static final int condition_statement_while
public static final int parameter_mode_default
public static final int parameter_mode_in
public static final int parameter_mode_out
public static final int parameter_mode_inout
public static final int parameter_mode_output
public static final int parameter_mode_readonly
public static final int parameter_mode_aslocator
public static final int parameter_mode_variadic
public static final int function_return_datatype
public static final int function_return_table
public static final int function_return_table_variable
public static final int constraint_level_column
public static final int constraint_level_table
public static final int TOKEN_ALREADY_PROCESSED
public static final int dtNone
EUniqueRowFilterType.urfNone
public static final int dtDistinct
EUniqueRowFilterType.urfDistinct
public static final int dtDistinctOn
EUniqueRowFilterType.urfDistinctOn
public static final int dtAll
EUniqueRowFilterType.urfAll
public static final int dtUnique
EUniqueRowFilterType.urfUnique
public static final int dtDistinctRow
EUniqueRowFilterType.urfDistinctRow
public static final int mstUnknown
public static final int mstLocalVar
public static final int mstLocalVarCursor
public static final int mstSetCmd
public static final int mstXmlMethod
public static final int mstSybaseLocalVar
public static final int tfmFor
public static final int tfmAfter
public static final int tfmInsteadOf
public static final int tfmBefore
public static final int tfmNoCascadeBefore
public static final int tReferencing
public static final int metExecSp
public static final int metExecStringCmd
public static final int metExecStringCmdLinkServer
public static final int metNoExecKeyword
public static final int uftUnknown
public static final int uftScalar
public static final int uftInlineTableValued
public static final int uftMultiStatementTableValued
public static final int srtNone
ESortType
public static final int srtAsc
ESortType
public static final int srtDesc
ESortType
public static final int srnNone
public static final int srnNullsFirst
public static final int srnNullsLast
public static int LEXER_INIT_MAX_MATCHES
public static boolean c_createTableStrictParsing
public static int TABSIZE
public TBaseType()
public static void resetTokenChain(TSourceTokenList pSourceTokenList, int startPos)
public static String getStringInsideLiteral(String literalStr)
literalStr
- The SQL string literal to processpublic static String removeQuoteChar(String str)
public static String getTextWithoutQuoted(String str)
public static String removePrefixOrSuffixQuoteChar(String str)
public static String getLastPartOfQualifiedName(String str)
public static String getTextByTokenCode(int tokenCode)
public static String stringBlock(int line, int column)
public static String stringBlock(int lineNo, int columnNo, int quotedSymbolLength, String quotedStr)
public static void clearCryptFunctions()
public static void addToCryptFunctions(String functionName, Integer keyPosition)
addToCryptFunctions(String, Integer)
with 'f_decrypt' refer to the function name and 2 refer to
the second argument that need to be replaced.
functionName
- keyPosition
- public static Integer searchCryptFunction(String functionName)
public static boolean searchOracleTablePros(String str)
public static boolean isSupportLateralColumn(EDbVendor pDbvendor)
public static boolean comparyStringArray(String[] actualText, String[] requiredText)
public static boolean compareStringBuilderToFile(StringBuilder actual, String requiredSourceFileName)
public static String readFromTextfile(File file)
public static boolean compareStringsLineByLine(String str1, String str2)
public static String readFile(String path, Charset encoding) throws IOException
IOException
public static List<String> getArrayListBetweenTokens(TSourceToken startToken, TSourceToken endToken, boolean includeNonSolidToken)
startToken
- endToken
- includeNonSolidToken
- public static String getOption(List<String> optionList, String optionName)
optionList
- optionName
- public static List<String> getOptionNames(List<String> optionList)
public static String numberOfSpace(int pNum, char space)
public static int logSize()
public static void log(String message, int type, TParseTreeNode node)
public static void log(String message, int type, TSourceToken token)
public static void dumpLogs(boolean force)
public static void dumpLogsToFile(String fileName)
public static String dumpLogsToString()
public static void calculateSqlLinesStats(List<String> directoryPaths, long timeInMillis)
directoryPaths
- A list of paths to directories to scan recursively.timeInMillis
- The time taken to process the files in milliseconds. If 0, speed calculation is skipped.public static String removeDelimiters(String str, char leftDelim, char rightDelim, boolean doublequote)
str
- The input stringleftDelim
- Left delimiter characterrightDelim
- Right delimiter characterdoublequote
- Whether to remove double quotes