Terarea  2
The automation project
Loading...
Searching...
No Matches
src.lib.sql.sql_constants Namespace Reference

Variables

list UNWANTED_ARGUMENTS
 
list RISKY_KEYWORDS
 
list KEYWORD_LOGIC_GATES
 
str DATE_ONLY = '%Y-%m-%d'
 
str DATE_AND_TIME = '%Y-%m-%d %H:%M:%S'
 
str CONNECTION_FAILED = "Connection to the database is non-existant, aborting command."
 
str CURSOR_FAILED = "Cursor to the database is non-existant, aborting command."
 
tuple GET_TABLE_SIZE_ERROR = (-1)
 

Detailed Description

    File in charge of storing information that is required for the sql library, but is constant.

Variable Documentation

◆ CONNECTION_FAILED

str src.lib.sql.sql_constants.CONNECTION_FAILED = "Connection to the database is non-existant, aborting command."

Definition at line 58 of file sql_constants.py.

◆ CURSOR_FAILED

str src.lib.sql.sql_constants.CURSOR_FAILED = "Cursor to the database is non-existant, aborting command."

Definition at line 60 of file sql_constants.py.

◆ DATE_AND_TIME

str src.lib.sql.sql_constants.DATE_AND_TIME = '%Y-%m-%d %H:%M:%S'

Definition at line 55 of file sql_constants.py.

◆ DATE_ONLY

str src.lib.sql.sql_constants.DATE_ONLY = '%Y-%m-%d'

Definition at line 53 of file sql_constants.py.

◆ GET_TABLE_SIZE_ERROR

tuple src.lib.sql.sql_constants.GET_TABLE_SIZE_ERROR = (-1)

Definition at line 63 of file sql_constants.py.

◆ KEYWORD_LOGIC_GATES

list src.lib.sql.sql_constants.KEYWORD_LOGIC_GATES
Initial value:
1= [
2 'and', 'or', 'not', 'xor', 'between', 'in', 'is', 'like', 'regexp', 'rlike', 'null', 'true', 'false', 'exists',
3 'distinct', 'limit', 'having', 'join', 'union', 'current_date', 'current_time', 'current_timestamp', 'utc_date',
4 'utc_time', 'utc_timestamp', 'mod', 'if'
5]

Definition at line 46 of file sql_constants.py.

◆ RISKY_KEYWORDS

list src.lib.sql.sql_constants.RISKY_KEYWORDS

Definition at line 14 of file sql_constants.py.

◆ UNWANTED_ARGUMENTS

list src.lib.sql.sql_constants.UNWANTED_ARGUMENTS
Initial value:
1= [
2 "option_files"
3
4]

Definition at line 8 of file sql_constants.py.