Terarea  2
The automation project
Loading...
Searching...
No Matches
Public Member Functions | Data Fields | Protected Attributes
src.lib.sql.sql_manager.SQL Class Reference
Collaboration diagram for src.lib.sql.sql_manager.SQL:
Collaboration graph

Public Member Functions

 __init__ (self, str url, int port, str username, str password, str db_name, int success=0, int error=84, bool debug=False)
 
None __del__ (self)
 

Data Fields

bool debug = debug
 
int success = success
 
int error = error
 
str url = url
 
int port = port
 
str username = username
 
str password = password
 
str db_name = db_name
 
Disp disp = None
 
SQLManageConnections sql_manage_connections = None
 
SQLTimeManipulation sql_time_manipulation = None
 
SQLQueryBoilerplates sql_query_boilerplates = None
 
SQLTimeManipulation.datetime_to_string datetime_to_string = self.sql_time_manipulation.datetime_to_string
 
SQLTimeManipulation.string_to_datetime string_to_datetime = self.sql_time_manipulation.string_to_datetime
 
SQLQueryBoilerplates.get_table_column_names get_table_column_names = self.sql_query_boilerplates.get_table_column_names
 
SQLQueryBoilerplates.get_table_names get_table_names = self.sql_query_boilerplates.get_table_names
 
SQLQueryBoilerplates.describe_table describe_table = self.sql_query_boilerplates.describe_table
 
SQLQueryBoilerplates.insert_data_into_table insert_data_into_table = self.sql_query_boilerplates.insert_data_into_table
 
SQLQueryBoilerplates.get_data_from_table get_data_from_table = self.sql_query_boilerplates.get_data_from_table
 
SQLQueryBoilerplates.get_table_size get_table_size = self.sql_query_boilerplates.get_table_size
 
SQLQueryBoilerplates.update_data_in_table update_data_in_table = self.sql_query_boilerplates.update_data_in_table
 
SQLQueryBoilerplates.insert_or_update_data_into_table insert_or_update_data_into_table = self.sql_query_boilerplates.insert_or_update_data_into_table
 
SQLQueryBoilerplates.remove_data_from_table remove_data_from_table = self.sql_query_boilerplates.remove_data_from_table
 
SQLQueryBoilerplates.remove_data_from_table drop_data_from_table = self.sql_query_boilerplates.remove_data_from_table
 

Protected Attributes

SQLTimeManipulation.get_correct_now_value _get_correct_now_value = self.sql_time_manipulation.get_correct_now_value
 
SQLTimeManipulation.get_correct_current_date_value _get_correct_current_date_value = self.sql_time_manipulation.get_correct_current_date_value
 

Detailed Description

The class in charge of managing a SQL database

Definition at line 13 of file sql_manager.py.

Constructor & Destructor Documentation

◆ __init__()

src.lib.sql.sql_manager.SQL.__init__ ( self,
str url,
int port,
str username,
str password,
str db_name,
int success = 0,
int error = 84,
bool debug = False ) 
The constructor of the SQL class
Args:
    url (str): _description_
    port (int): _description_
    username (str): _description_
    password (str): _description_
    db_name (str): _description_
    success (int, optional): _description_. Defaults to 0.
    error (int, optional): _description_. Defaults to 84.
    debug (bool, optional): _description_. Defaults to False.

Definition at line 18 of file sql_manager.py.

◆ __del__()

None src.lib.sql.sql_manager.SQL.__del__ ( self) 
    Disconnect the database when the class is destroyed

Definition at line 95 of file sql_manager.py.

Field Documentation

◆ _get_correct_current_date_value

SQLTimeManipulation.get_correct_current_date_value src.lib.sql.sql_manager.SQL._get_correct_current_date_value = self.sql_time_manipulation.get_correct_current_date_value
protected

Definition at line 71 of file sql_manager.py.

◆ _get_correct_now_value

SQLTimeManipulation.get_correct_now_value src.lib.sql.sql_manager.SQL._get_correct_now_value = self.sql_time_manipulation.get_correct_now_value
protected

Definition at line 70 of file sql_manager.py.

◆ datetime_to_string

SQLTimeManipulation.datetime_to_string src.lib.sql.sql_manager.SQL.datetime_to_string = self.sql_time_manipulation.datetime_to_string

Definition at line 68 of file sql_manager.py.

◆ db_name

str src.lib.sql.sql_manager.SQL.db_name = db_name

Definition at line 38 of file sql_manager.py.

◆ debug

bool src.lib.sql.sql_manager.SQL.debug = debug

Definition at line 31 of file sql_manager.py.

◆ describe_table

SQLQueryBoilerplates.describe_table src.lib.sql.sql_manager.SQL.describe_table = self.sql_query_boilerplates.describe_table

Definition at line 86 of file sql_manager.py.

◆ disp

Disp src.lib.sql.sql_manager.SQL.disp = None

Definition at line 40 of file sql_manager.py.

◆ drop_data_from_table

SQLQueryBoilerplates.remove_data_from_table src.lib.sql.sql_manager.SQL.drop_data_from_table = self.sql_query_boilerplates.remove_data_from_table

Definition at line 93 of file sql_manager.py.

◆ error

int src.lib.sql.sql_manager.SQL.error = error

Definition at line 33 of file sql_manager.py.

◆ get_data_from_table

SQLQueryBoilerplates.get_data_from_table src.lib.sql.sql_manager.SQL.get_data_from_table = self.sql_query_boilerplates.get_data_from_table

Definition at line 88 of file sql_manager.py.

◆ get_table_column_names

SQLQueryBoilerplates.get_table_column_names src.lib.sql.sql_manager.SQL.get_table_column_names = self.sql_query_boilerplates.get_table_column_names

Definition at line 84 of file sql_manager.py.

◆ get_table_names

SQLQueryBoilerplates.get_table_names src.lib.sql.sql_manager.SQL.get_table_names = self.sql_query_boilerplates.get_table_names

Definition at line 85 of file sql_manager.py.

◆ get_table_size

SQLQueryBoilerplates.get_table_size src.lib.sql.sql_manager.SQL.get_table_size = self.sql_query_boilerplates.get_table_size

Definition at line 89 of file sql_manager.py.

◆ insert_data_into_table

SQLQueryBoilerplates.insert_data_into_table src.lib.sql.sql_manager.SQL.insert_data_into_table = self.sql_query_boilerplates.insert_data_into_table

Definition at line 87 of file sql_manager.py.

◆ insert_or_update_data_into_table

SQLQueryBoilerplates.insert_or_update_data_into_table src.lib.sql.sql_manager.SQL.insert_or_update_data_into_table = self.sql_query_boilerplates.insert_or_update_data_into_table

Definition at line 91 of file sql_manager.py.

◆ password

str src.lib.sql.sql_manager.SQL.password = password

Definition at line 37 of file sql_manager.py.

◆ port

int src.lib.sql.sql_manager.SQL.port = port

Definition at line 35 of file sql_manager.py.

◆ remove_data_from_table

SQLQueryBoilerplates.remove_data_from_table src.lib.sql.sql_manager.SQL.remove_data_from_table = self.sql_query_boilerplates.remove_data_from_table

Definition at line 92 of file sql_manager.py.

◆ sql_manage_connections

SQLManageConnections src.lib.sql.sql_manager.SQL.sql_manage_connections = None

Definition at line 41 of file sql_manager.py.

◆ sql_query_boilerplates

SQLQueryBoilerplates src.lib.sql.sql_manager.SQL.sql_query_boilerplates = None

Definition at line 43 of file sql_manager.py.

◆ sql_time_manipulation

SQLTimeManipulation src.lib.sql.sql_manager.SQL.sql_time_manipulation = None

Definition at line 42 of file sql_manager.py.

◆ string_to_datetime

SQLTimeManipulation.string_to_datetime src.lib.sql.sql_manager.SQL.string_to_datetime = self.sql_time_manipulation.string_to_datetime

Definition at line 69 of file sql_manager.py.

◆ success

int src.lib.sql.sql_manager.SQL.success = success

Definition at line 32 of file sql_manager.py.

◆ update_data_in_table

SQLQueryBoilerplates.update_data_in_table src.lib.sql.sql_manager.SQL.update_data_in_table = self.sql_query_boilerplates.update_data_in_table

Definition at line 90 of file sql_manager.py.

◆ url

str src.lib.sql.sql_manager.SQL.url = url

Definition at line 34 of file sql_manager.py.

◆ username

str src.lib.sql.sql_manager.SQL.username = username

Definition at line 36 of file sql_manager.py.

The documentation for this class was generated from the following file: