def update_show_in_list(mysql_cxn,
s_table: str = '',
s_name: str = '',
i_value: int = 0) -> bool:
"""
:param mysql_cxn: object - Database connection object
:param s_table: str - Table name to update
:param s_name: str - Record name to update
:param i_value: int - New field value
:return: bool - Id of the updated record
"""
# DECLARE VARIABLES
# UPDATE THE RECORD
mysql_cur = mysql_cxn.cursor()
s_sql: str = "UPDATE `" + s_table + \
"` SET `show_in_list_summary` = " + str(i_value) + \
" WHERE `name` = '" + s_name + "';"
# print(s_sql)
mysql_cur.execute('START TRANSACTION;')
mysql_cur.execute(s_sql)
mysql_cur.execute('COMMIT;')
mysql_cur.close()
# UPDATE THE LOG
b_return = True
if func_configure.l_debug_project:
print('Updated: Fabrik show-in-list ' + s_name + ' to ' + str(i_value))
if func_configure.l_log_project:
func_file.write_log(
'%t UPDATE SHOW-IN-LIST: ' + s_name + ' to ' + str(i_value),
func_configure.s_path_project + 'log/')
return b_return
def update_button_group(mysql_cxn,
s_table: str = '',
s_name: str = '',
s_label: str = '') -> bool:
"""
:param mysql_cxn: object - Database connection object
:param s_table: str - Table name to update
:param s_name: str - Record name to update
:param s_label: str - New field value
:return: bool - Id of the updated record
"""
# DECLARE VARIABLES
i_record: int = 0
l_updated: bool = False
# READ THE CURRENT RECORD
mysql_cur = mysql_cxn.cursor()
s_sql = "SELECT `id`,`params` FROM `" + s_table + "` WHERE `name` = '" + s_name + "';"
# print(s_sql)
mysql_cur.execute(s_sql)
o_records = mysql_cur.fetchall()
# print(mysql_cur.rowcount)
for row in o_records:
l_updated = False
i_record = row[0]
s_data: str = row[1]
# print(s_data)
if '"btnGroup":"0"' in s_data and '0' != s_label:
l_updated = True
s_data = s_data.replace('"btnGroup":"0"',
'"btnGroup":"' + s_label + '"')
elif '"btnGroup":"1"' in s_data and '1' != s_label:
l_updated = True
s_data = s_data.replace('"btnGroup":"1"',
'"btnGroup":"' + s_label + '"')
# print(s_data)
# UPDATE THE CURRENT RECORD
if i_record > 0 and l_updated:
s_sql = "UPDATE `" + s_table + "` SET `params` = '" + s_data + "' WHERE `id` = " + str(
i_record) + ";"
# print(s_sql)
mysql_cur.execute('START TRANSACTION;')
mysql_cur.execute(s_sql)
mysql_cur.execute('COMMIT;')
# CLOSE THE CONNECTION
mysql_cur.close()
# UPDATE THE LOG
b_return = True
if func_configure.l_debug_project:
print('Updated: Fabrik button group ' + s_name + ' to ' + s_label)
if func_configure.l_log_project:
func_file.write_log(
'%t UPDATE BUTTON GROUP: ' + s_name + ' to ' + s_label,
func_configure.s_path_project + 'log/')
return b_return
def update_label(mysql_cxn,
s_table: str = '',
s_name: str = '',
s_label: str = '') -> bool:
"""
:param mysql_cxn: object - Database connection object
:param s_table: str - Table name to update
:param s_name: str - Record name to update
:param s_label: str - New field value
:return: bool - Id of the updated record
"""
# DECLARE VARIABLES
# UPDATE THE RECORD
mysql_cur = mysql_cxn.cursor()
s_sql: str = "UPDATE `" + s_table + "` SET `label` = '" + s_label + "' WHERE `name` = '" + s_name + "';"
# print(s_sql)
mysql_cur.execute('START TRANSACTION;')
mysql_cur.execute(s_sql)
mysql_cur.execute('COMMIT;')
mysql_cur.close()
# UPDATE THE LOG
b_return = True
if func_configure.l_debug_project:
print('Updated: Fabrik label ' + s_name + ' to ' + s_label)
if func_configure.l_log_project:
func_file.write_log('%t UPDATE LABEL: ' + s_name + ' to ' + s_label,
func_configure.s_path_project + 'log/')
return b_return
def error_message(e,
s_subject: str = '',
s_body: str = ''):
"""
Error message handler.
:param e: Error object
:param s_subject: Mail subject
:param s_body: Mail body
:return: Nothing
"""
# IMPORT OWN MODULES
from _my_modules import func_configure
from _my_modules import func_file
# from _my_modules import func_mail
# from _my_modules import func_sms
# DECLARE VARIABLES
s_mess = str(e).replace("'", "")
s_mess = s_mess.replace('"', '')
s_mess = s_mess.replace(':', '')
s_mess = s_mess.replace('[', '')
s_mess = s_mess.replace(']', '')
s_mess = s_mess.replace('(', '')
s_mess = s_mess.replace(')', '')
# DISPLAY
print(s_mess)
print("E: ", e)
print("TYPE(E): ", type(e))
print("TYPE(E)NAME: ", type(e).__name__)
print("JOIN(E).ARGS: ", e.args)
# DEFINE THE ERROR TEMPLATE AND MESSAGE
template = "Exception type {0} occurred. Arguments:\n{1!r}"
message = template.format(type(e).__name__, e.args)
print("MESSAGE: ", message)
"""
# SEND MAIL
if func_configure.l_mail_project and s_subject != '' and s_body != '':
# s_body1 = s_body + '\n' + type(e).__name__ + '\n' + "".join(e.args)
s_body1 = s_body + '\n' + s_mess
func_mail.Mail('std_fail_gmail', s_subject, s_body1)
"""
"""
# SEND MESSAGE
if func_configure.l_mess_project:
# s_body1 = s_body + ' | ' + type(e).__name__ + ' | ' + "".join(e.args)
s_body1 = s_body + ' | ' + s_mess
func_sms.send_telegram('', 'administrator', s_body1)
"""
# WRITE ERROR TO LOG
if func_configure.l_log_project:
func_file.write_log("%t ERROR: " + type(e).__name__, func_configure.s_path_project + 'log/')
func_file.write_log("%t ERROR: " + s_mess, func_configure.s_path_project + 'log/')
return
from _my_modules import func_file
from _my_modules import func_system
import func_fabrik_01_groupcreate
import func_fabrik_02_formcreate
import func_fabrik_03_formgroup
import func_fabrik_04_listcreate
# DECLARE VARIABLES
l_questions: bool = True
i_group: int = 0
i_form: int = 0
i_form_group: int = 0
# OPEN THE LOG WRITER
if func_configure.l_log_project:
func_file.write_log("Now")
func_file.write_log("SCRIPT: FABRIK_ALL")
func_file.write_log("------------------")
# CALL THE GROUP CREATE FUNCTION
try:
i_group = func_fabrik_01_groupcreate.fabrik_group_create(l_questions)
print("Group: " + str(i_group))
if func_configure.l_log_project:
func_file.write_log("%t GROUP CREATED: " + str(i_group))
except Exception as e:
func_system.error_message(e)
# CALL THE FORM CREATE FUNCTION
try:
i_form = func_fabrik_02_formcreate.fabrik_form_create(l_questions)
def fabrik_element_create(b_input: bool = False,
b_loop: bool = False,
s_type: str = "0",
s_group: str = "0",
s_order: str = "0",
s_name: str = "0",
s_label: str = "0") -> None:
"""
:param b_input: Force keyboard input
:param b_loop: Force element input to loop
:param s_type: Fabrik element type
:param s_group: Fabrik group id
1=Internalid
2=Date created
:param s_order: Fabrik element ranking order
:param s_name: Fabrik element field name
:param s_label: Fabrik element label
:return: None
"""
# IMPORT SYSTEM MODULES
# IMPORT OWN MODULES
from _my_modules import func_configure
from _my_modules import func_file
from _my_modules import func_mysql
"""
INDEX
ENVIRONMENT
INPUT DATABASE
OPEN DATABASE
INPUT ELEMENT
INTERNALID SETUP
FIELD 50 NOTEMPTY SETUP
TEXTAREA 1024 SETUP
RADIOBUTTON 15 SETUP
JDATE FROM TODAY NOTEMPTY SETUP
JDATE TO 2099 SETUP
JDATE CREATED SETUP
JDATE MODIFIED SETUP
FIELD MODIFIED BY SETUP
"""
"""*************************************************************************
ENVIRONMENT
*************************************************************************"""
if b_input:
func_configure.l_debug_project = True
if func_configure.l_debug_project:
print("FABRIK CREATE ELEMENT STEP 5")
print("----------------------------")
print("ENVIRONMENT")
# DECLARE VARIABLES
s_database: str = func_configure.s_joomla_database
s_database_input = s_database
s_table: str = func_configure.s_joomla_prefix + "_fabrik_elements"
s_table_input = s_table
s_created_by: str = func_configure.s_user_id
l_loop: bool = True
s_sql_fields = """
INSERT INTO %TABLE% (
`name`,
`group_id`,
`plugin`,
`label`,
`checked_out`,
`checked_out_time`,
`created`,
`created_by`,
`created_by_alias`,
`modified`,
`modified_by`,
`width`,
`height`,
`default`,
`hidden`,
`eval`,
`ordering`,
`show_in_list_summary`,
`filter_type`,
`filter_exact_match`,
`published`,
`link_to_detail`,
`primary_key`,
`auto_increment`,
`access`,
`use_in_page_title`,
`parent_id`,
`params`
) VALUES ("""
"""*************************************************************************
INPUT DATABASE
*************************************************************************"""
if func_configure.l_debug_project:
print("INPUT DATABASE AND TABLE")
# INPUT DATABASE NAME
if b_input:
print("")
print("Default fabrik database: " + s_database)
s_database_input = input("Fabrik DATABASE name? ")
if s_database_input == "":
s_database_input = s_database
# INPUT TABLE NAME
if b_input:
print("")
print("Default fabrik table: " + s_table)
s_table_input = input("Fabrik TABLE name? ")
if s_table_input == "":
s_table_input = s_table
# INFUSE TABLE NAME IN SQL STRING
s_sql_fields = s_sql_fields.replace("%TABLE%", s_table_input)
"""*************************************************************************
OPEN DATABASE
*************************************************************************"""
if func_configure.l_debug_project:
print("OPEN DATABASE")
# Connect to the oracle database
mysql_connection = func_mysql.mysql_open(s_database_input)
curs = mysql_connection.cursor()
if func_configure.l_log_project:
func_file.write_log("%t OPEN DATABASE: " + s_database_input)
"""*************************************************************************
INPUT ELEMENT
*************************************************************************"""
while l_loop:
# INPUT FABRIK ELEMENT GROUP NUMBER
s_group_input = s_group
if b_input or s_group_input == "0" or s_group_input == "":
print("")
print("Default fabrik group id: " + s_group)
while s_group_input == "" or s_group_input == "0":
s_group_input = input("Fabrik element GROUP id? ")
# INPUT FABRIK ELEMENT ORDER NUMBER
s_order_input = s_order
if b_input or s_order_input == "0" or s_order_input == "":
print("")
print("Default fabrik order number: " + s_order)
while s_order_input == "" or s_order_input == "0":
s_order_input = input("Fabrik element ORDER number? ")
# INPUT FABRIK ELEMENT FIELD NAME
s_name_input = s_name
if b_input or s_name_input == "0" or s_name_input == "":
print("")
print("Default fabrik element field name: " + s_name)
while s_name_input == "" or s_name_input == "0":
s_name_input = input("Fabrik element FIELD NAME? ")
# INPUT FABRIK ELEMENT LABEL
s_label_input = s_label
if b_input or s_label_input == "0" or s_label_input == "":
print("")
print("Default fabrik element label: " + s_label)
while s_label_input == "" or s_label_input == "0":
s_label_input = input("Fabrik element LABEL? ")
# INPUT FABRIK ELEMENT TYPE
s_type_input = s_type
if b_input or s_type_input == "0" or s_type_input == "":
print("")
print("INPUT ELEMENT TYPE 0 = CANCEL")
print("INPUT ELEMENT TYPE 1 = INTERNALID")
print("INPUT ELEMENT TYPE 99 = EXIT")
print("")
print("Default fabrik element type: " + s_type)
s_type_input = input("Fabrik ELEMENT type? ")
while s_type_input == "0" or s_type_input == "":
s_type_input = input("Fabrik ELEMENT type? ")
# SHOW ALL VARIABLES
if func_configure.l_debug_project:
print("")
print("VALUES COLLECTED:")
print("Database: " + s_database_input)
print("Table: " + s_table_input)
print("Type: " + s_type_input)
print("Group: " + s_group_input)
print("Order: " + s_order_input)
print("Field: " + s_name_input)
print("Label: " + s_label_input)
"""********************************************************************
INTERNALID SETUP
********************************************************************"""
if s_type_input == "internalid":
if func_configure.l_debug_project:
print("CREATE ELEMENT 1 INTERNALID")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'internalid',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
11,
6,
'',
0,
0,
%ORDERNUMBER%,
0,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"inc_in_adv_search":"0"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT INTERNALID: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
FIELD 50 NOTEMPTY SETUP
********************************************************************"""
if s_type_input == "field_50_notempty":
if func_configure.l_debug_project:
print("CREATE FIELD")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'field',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
30,
6,
'',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"maxlength":"50",
"bootstrap_class":"input-xxlarge",
"can_order":"1",
"validations":{"plugin":["notempty"],
"plugin_published":["1"],
"validate_in":["both"],
"validation_on":["both"],
"validate_hidden":["1"],
"must_validate":["1"],
"show_icon":["0"]}
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT FIELD 50 NOEMPTY: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
TEXTAREA 1024 SETUP
********************************************************************"""
if s_type_input == "textarea_1024":
if func_configure.l_debug_project:
print("CREATE FIELD")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'textarea',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
40,
6,
'',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"bootstrap_class":"input-xxlarge",
"textarea-showmax":"1",
"textarea-maxlength":"1024",
"textarea_limit_type":"word"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT TEXTAREA 1024: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
RADIOBUTTON 15 SETUP
********************************************************************"""
if s_type_input == "radiobutton_15":
if func_configure.l_debug_project:
print("CREATE FIELD")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'radiobutton',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
40,
6,
'',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"sub_options":{"sub_values":["0","1","2","3","4","5"],
"sub_labels":["No value","Rare","Unlikely","Possible","Likely","Certain"],
"sub_initial_selection":["0"]},
"options_per_row":"1"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT RADIOBUTTON 15: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
RADIOBUTTON YESNO SETUP
********************************************************************"""
if s_type_input == "radiobutton_yesno":
if func_configure.l_debug_project:
print("CREATE FIELD")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'radiobutton',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
40,
6,
'',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"sub_options":{"sub_values":["1","0"],
"sub_labels":["Yes","No"],
"sub_initial_selection":["1"]},
"btnGroup":"1"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT RADIOBUTTON YESNO: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
JDATE FROM TODAY NOTEMPTY SETUP
********************************************************************"""
if s_type_input == "jdate_from_today":
if func_configure.l_debug_project:
print("CREATE ELEMENT JDATE FROM TODAY")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'jdate',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
10,
6,
'',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"bootstrap_class":"input-small",
"jdate_store_as_local":"1",
"jdate_defaulttotoday":"1",
"validations":{"plugin":["notempty"],
"plugin_published":["1"],
"validate_in":["both"],
"validation_on":["both"],
"validate_hidden":["1"],
"must_validate":["1"],
"show_icon":["0"]}
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT JDATE FROM TODAY: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
JDATE TO 2099 SETUP
********************************************************************"""
if s_type_input == "jdate_to_2099":
if func_configure.l_debug_project:
print("CREATE ELEMENT JDATE TO 2099")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'jdate',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
10,
6,
'2099-12-31',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"bootstrap_class":"input-small",
"jdate_store_as_local":"1",
"jdate_defaulttotoday":"1",
"isgreaterorlessthan-message":["Compulsory date"],
"isgreaterorlessthan-greaterthan":["3"],
"isgreaterorlessthan-comparewith":["1134"],
"compare_value":[""],
"isgreaterorlessthan-allow_empty":["0"],
"isgreaterorlessthan-validation_condition":[""],
"tip_text":["To date must be later than from date above!"],
"icon":[""],
"validations":{"plugin":["isgreaterorlessthan"],
"plugin_published":["1"],
"validate_in":["both"],
"validation_on":["both"],
"validate_hidden":["1"],
"must_validate":["1"],
"show_icon":["0"]}
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT JDATE TO 2099: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
JDATE CREATED
********************************************************************"""
if s_type_input == "jdate_created":
if func_configure.l_debug_project:
print("CREATE ELEMENT JDATE CREATED")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'jdate',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
10,
6,
'',
1,
0,
%ORDERNUMBER%,
0,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"jdate_store_as_local":"1",
"jdate_defaulttotoday":"1"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT JDATE CREATED: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
JDATE MODIFIED SETUP
********************************************************************"""
if s_type_input == "jdate_modified":
if func_configure.l_debug_project:
print("CREATE ELEMENT JDATE MODIFIED")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'jdate',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
10,
6,
'',
1,
0,
%ORDERNUMBER%,
0,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
"jdate_store_as_local":"1",
"jdate_defaulttotoday":"1",
"jdate_alwaystoday":"1"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT JDATE MODIFIED: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
"""********************************************************************
FIELD MODIFIED BY SETUP
********************************************************************"""
if s_type_input == "field_modified_by":
if func_configure.l_debug_project:
print("CREATE FIELD MODIFIED BY")
# INSERT GROUP RECORD
s_sql = s_sql_fields + """
'%FIELDNAME%',
%GROUPID%,
'field',
'%LABEL%',
0,
'0000-00-00 00:00:00',
NOW(),
%CREATEDBY%,
'python',
'0000-00-00 00:00:00',
0,
30,
6,
'',
0,
0,
%ORDERNUMBER%,
1,
NULL,
1,
1,
0,
0,
0,
1,
0,
0,
'{
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FIELDNAME%", s_name_input)
s_sql = s_sql.replace("%GROUPID%", s_group_input)
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATEDBY%", s_created_by)
s_sql = s_sql.replace("%ORDERNUMBER%", s_order_input)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT ELEMENT FIELD MODIFIED BY: " +
s_database_input + "." + s_table_input +
": " + s_label_input)
# CLOSE LOOP
if not b_loop or s_type_input == "99":
l_loop = False
# CLEAN UP
s_group = s_group_input
s_name = "0"
s_label = "0"
s_type = "0"
# RETURN NEWLY CREATED GROUP NUMBER
return
def update_bootstrap_class(mysql_cxn,
s_table: str = '',
s_name: str = '',
s_label: str = '') -> bool:
"""
:param mysql_cxn: object - Database connection object
:param s_table: str - Table name to update
:param s_name: str - Record name to update
:param s_label: str - New field value
:return: bool - Id of the updated record
"""
# DECLARE VARIABLES
i_record: int = 0
l_updated: bool = False
# READ THE CURRENT RECORD
mysql_cur = mysql_cxn.cursor()
s_sql = "SELECT `id`,`params` FROM `" + s_table + "` WHERE `name` = '" + s_name + "';"
# print(s_sql)
mysql_cur.execute(s_sql)
o_records = mysql_cur.fetchall()
# print(mysql_cur.rowcount)
for row in o_records:
l_updated = False
i_record = row[0]
s_data: str = row[1]
# print(s_data)
if '"bootstrap_class":"input-mini"' in s_data and 'input-mini' != s_label:
l_updated = True
s_data = s_data.replace("input-mini", s_label)
elif '"bootstrap_class":"input-small"' in s_data and 'input-small' != s_label:
l_updated = True
s_data = s_data.replace("input-small", s_label)
elif '"bootstrap_class":"input-medium"' in s_data and 'input-medium' != s_label:
l_updated = True
s_data = s_data.replace("input-medium", s_label)
elif '"bootstrap_class":"input-large"' in s_data and 'input-large' != s_label:
l_updated = True
s_data = s_data.replace("input-large", s_label)
elif '"bootstrap_class":"input-xlarge"' in s_data and 'input-xlarge' != s_label:
l_updated = True
s_data = s_data.replace("input-xlarge", s_label)
elif '"bootstrap_class":"input-xxlarge"' in s_data and 'input-xxlarge' != s_label:
l_updated = True
s_data = s_data.replace("input-xxlarge", s_label)
# print(s_data)
# UPDATE THE CURRENT RECORD
if i_record > 0 and l_updated:
s_sql = "UPDATE `" + s_table + "` SET `params` = '" + s_data + "' WHERE `id` = " + str(
i_record) + ";"
# print(s_sql)
mysql_cur.execute('START TRANSACTION;')
mysql_cur.execute(s_sql)
mysql_cur.execute('COMMIT;')
# CLOSE THE CONNECTION
mysql_cur.close()
# UPDATE THE LOG
b_return = True
if func_configure.l_debug_project:
print('Updated: Fabrik bootstrap class ' + s_name + ' to ' + s_label)
if func_configure.l_log_project:
func_file.write_log(
'%t UPDATE BOOTSTRAP CLASS: ' + s_name + ' to ' + s_label,
func_configure.s_path_project + 'log/')
return b_return
def fabrik_group_create(b_input: bool = False, s_label: str = "0") -> int:
"""
:param b_input: bool - Force keyboard input
:param s_label: str - Fabrik group label
:return: int - Fabrik group id number
"""
# IMPORT SYSTEM MODULES
# IMPORT OWN MODULES
from _my_modules import func_configure
from _my_modules import func_file
from _my_modules import func_mysql
"""
INDEX
ENVIRONMENT
INPUT
OPEN DATABASE
INSERT GROUP RECORD
"""
"""*************************************************************************
ENVIRONMENT
*************************************************************************"""
if b_input:
func_configure.l_debug_project = True
if func_configure.l_debug_project:
print("FABRIK CREATE GROUP STEP 1")
print("--------------------------")
print("ENVIRONMENT")
# DECLARE VARIABLES
s_database: str = func_configure.s_joomla_database
s_table: str = func_configure.s_joomla_prefix + "_fabrik_groups"
s_created_by: str = func_configure.s_user_id
i_return: int = 0
"""*************************************************************************
INPUT
*************************************************************************"""
if func_configure.l_debug_project:
print("INPUT")
# Input the joomla mysql fabrik DATABASE name
s_database_input = s_database
if b_input:
print("")
print("Default fabrik database: " + s_database)
s_database_input = input("Fabrik DATABASE name? ")
if s_database_input == "":
s_database_input = s_database
# Input the joomla mysql fabrik TABLE name
s_table_input = s_table
if b_input:
print("")
print("Default fabrik table: " + s_table)
s_table_input = input("Fabrik TABLE name? ")
if s_table_input == "":
s_table_input = s_table
# INPUT THE JOOMLA MYSQL FABRIK LIST LABEL
s_label_input = s_label
if b_input or s_label_input == "0":
print("")
print("Default fabrik group label: " + s_label)
while s_label_input == "" or s_label_input == "0":
s_label_input = input("Fabrik GROUP label? ")
print("")
"""*************************************************************************
OPEN DATABASE
*************************************************************************"""
if func_configure.l_debug_project:
print("OPEN DATABASE")
# Connect to the oracle database
mysql_connection = func_mysql.mysql_open(s_database_input)
curs = mysql_connection.cursor()
if func_configure.l_log_project:
func_file.write_log("%t OPEN DATABASE: " + s_database_input)
"""*************************************************************************
INSERT GROUP RECORD
*************************************************************************"""
if func_configure.l_debug_project:
print("INSERT GROUP RECORD")
# INSERT GROUP RECORD
s_sql = "INSERT INTO `" + s_table_input + "` (" + """
`name`,
`css`,
`label`,
`published`,
`created`,
`created_by`,
`created_by_alias`,
`modified`,
`modified_by`,
`checked_out`,
`checked_out_time`,
`is_join`,
`private`,
`params`
""" + ") VALUES (" + """
'%LABEL%',
'',
'View/Add/Edit %LABEL%',
1,
NOW(),
%CREATED_BY%,
'Python',
'0000-00-00 00:00:00',
0,
0,
'0000-00-00 00:00:00',
0,
0,
''
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CREATED_BY%", s_created_by)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT RECORD: " + s_database_input + "." +
s_table_input + ": " + s_label_input)
# GET NEWLY CREATED GROUP NUMBER
curs.execute("SELECT " + s_table_input + ".id, " + s_table_input +
".name FROM " + s_table_input + " WHERE " + s_table_input +
".name = '" + s_label_input + "'")
for row in curs.fetchall():
if func_configure.l_debug_project:
print("Created group " + str(row[0]))
i_return = row[0]
# RETURN NEWLY CREATED GROUP NUMBER
return i_return
def fabrik_form_group(b_input: bool = False, s_group: str = "0", s_form: str = "0"):
"""
"""
# IMPORT SYSTEM MODULES
# IMPORT OWN MODULES
from _my_modules import func_configure
from _my_modules import func_file
from _my_modules import func_mysql
""" INDEX ******************************************************************
ENVIRONMENT
INPUT
OPEN DATABASE
INSERT FORM GROUP RECORD
*************************************************************************"""
if func_configure.l_debug_project:
print("FABRIK CREATE FORM GROUP STEP 3")
print("-------------------------------")
print("ENVIRONMENT")
# DECLARE VARIABLES
s_database: str = func_configure.s_joomla_database
s_table: str = func_configure.s_joomla_prefix + "_fabrik_formgroup"
i_return: int = 0
"""*************************************************************************
INPUT
*************************************************************************"""
if func_configure.l_debug_project:
print("INPUT")
# INPUT THE JOOMLA MYSQL FABRIK DATABASE NAME
s_database_input = s_database
if b_input:
print("")
print("Default fabrik database: " + s_database)
s_database_input = input("Fabrik DATABASE name? ")
if s_database_input == "":
s_database_input = s_database
# INPUT THE JOOMLA MYSQL TABLE NAME
s_table_input = s_table
if b_input:
print("")
print("Default fabrik table name: " + s_table)
s_table_input = input("Fabrik TABLE name? ")
if s_table_input == "":
s_table_input = s_table
# INPUT THE JOOMLA MYSQL FABRIK GROUP NUMBER
s_group_input = s_group
if b_input or s_group_input == "0":
print("")
print("Default fabrik group id: " + s_group)
while s_group_input == "" or s_group_input == "0":
s_group_input = input("Fabrik GROUP number? ")
print("")
# INPUT THE JOOMLA MYSQL FABRIK FORM NUMBER
s_form_input = s_form
if b_input or s_form_input == "0":
print("")
print("Default fabrik form id: " + s_form)
while s_form_input == "" or s_form_input == "0":
s_form_input = input("Fabrik FORM number? ")
"""*************************************************************************
OPEN DATABASE
*************************************************************************"""
if func_configure.l_debug_project:
print("OPEN DATABASE")
# Connect to the oracle database
mysql_connection = func_mysql.mysql_open(s_database_input)
curs = mysql_connection.cursor()
if func_configure.l_log_project:
func_file.write_log("%t OPEN DATABASE: " + s_database_input)
"""*************************************************************************
INSERT FORM GROUP RECORD
*************************************************************************"""
if func_configure.l_debug_project:
print("INSERT FORMGROUP RECORD")
# INSERT GROUP RECORD
s_sql = "INSERT INTO `" + s_table_input + "` (" + """
form_id,
group_id,
ordering
""" + ") VALUES (" + """
%FORM%,
%GROUP%,
1
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%FORM%", s_form_input)
s_sql = s_sql.replace("%GROUP%", s_group_input)
# print(s_sql) # DEBUG
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT RECORD: " +
s_database_input + "." +
s_table_input + ": Group:" +
s_group_input + " Form:" +
s_form_input)
# GET NEWLY CREATED FORMGROUP NUMBER
s_sql = "SELECT " + s_table_input + ".id " +\
"FROM " + s_table_input + " " +\
"WHERE " + s_table_input + ".form_id=%FORM% AND " + s_table_input + ".group_id=%GROUP%"
s_sql = s_sql.replace("%FORM%", s_form_input)
s_sql = s_sql.replace("%GROUP%", s_group_input)
# print(s_sql) # DEBUG
curs.execute(s_sql)
for row in curs.fetchall():
if func_configure.l_debug_project:
print("Form group " + str(row[0]))
i_return = row[0]
return i_return
UPDATE FINDING MASTER
UPDATE FINDING LIKELIHOODS
UPDATE FINDING CONTROL VALUES
END
"""
"""****************************************************************************
ENVIRONMENT
****************************************************************************"""
# UPDATE LOG
if func_configure.l_debug_project:
print("SCRIPT: UPDATE IA FABRIK")
print("------------------------")
if func_configure.l_log_project:
func_file.write_log("Now")
func_file.write_log('SCRIPT: UPDATE IA FABRIK')
func_file.write_log('------------------------')
# DECLARE VARIABLES
mysql_cxn = func_mysql.mysql_open(False, func_configure.s_joomla_database)
l_finding_master: bool = True
l_finding_likelihood: bool = False
l_finding_control_value: bool = False
"""****************************************************************************
UPDATE FINDING MASTER
****************************************************************************"""
if l_finding_master:
# UPDATE LOG
def fabrik_list_create(b_input: bool = False,
s_form: str = "0",
s_target: str = "0",
s_key_field: str = "0",
s_label: str = "0") -> int:
"""
:param b_input: bool - Force keyboard input
:param s_form: str - Fabrik form id
:param s_target: str - Table name
:param s_key_field: str - Table key field
:param s_label: str - Fabrik list label
:return: int - Fabrik list id
"""
# IMPORT SYSTEM MODULES
# IMPORT OWN MODULES
from _my_modules import func_configure
from _my_modules import func_file
from _my_modules import func_mysql
"""
INDEX
ENVIRONMENT
INPUT
OPEN DATABASE
INSERT LIST RECORD
"""
"""*************************************************************************
ENVIRONMENT
*************************************************************************"""
if func_configure.l_debug_project:
print("FABRIK CREATE LIST STEP 4")
print("--------------------------")
print("ENVIRONMENT")
# DECLARE VARIABLES
s_database: str = func_configure.s_joomla_database
s_table: str = func_configure.s_joomla_prefix + "_fabrik_lists"
s_created_by: str = func_configure.s_user_id
i_return: int = 0
# DATABASE CONNECTION
if func_configure.s_name_project == "IANWU":
s_connection = "2"
else:
s_connection = "1"
"""*************************************************************************
INPUT
*************************************************************************"""
if func_configure.l_debug_project:
print("INPUT")
# INPUT THE JOOMLA MYSQL FABRIK DATABASE NAME
s_database_input = s_database
if b_input:
print("")
print("Default fabrik database: " + s_database)
s_database_input = input("Fabrik DATABASE name? ")
if s_database_input == "":
s_database_input = s_database
# INPUT THE JOOMLA MYSQL TABLE NAME
s_table_input = s_table
if b_input:
print("")
print("Default fabrik list table: " + s_table)
s_table_input = input("Fabrik TABLE name? ")
if s_table_input == "":
s_table_input = s_table
# INPUT THE JOOMLA MYSQL FABRIK LIST LABEL
s_label_input = s_label
if b_input or s_label_input == "0":
print("")
print("Default fabrik list label: " + s_label)
while s_label_input == "" or s_label_input == "0":
s_label_input = input("Fabrik LIST label? ")
print("")
# INPUT THE JOOMLA MYSQL FABRIK FORM NUMBER
s_form_input = s_form
if b_input or s_form_input == "0":
print("")
print("Default fabrik form id: " + s_form)
while s_form_input == "" or s_form_input == "0":
s_form_input = input("Fabrik FORM number? ")
print("")
# INPUT THE JOOMLA MYSQL FABRIK LIST TARGET TABLE NAME
s_target_input = s_target
if b_input or s_target_input == "0":
print("")
print("Default fabrik target table name: " + s_target)
while s_target_input == "" or s_target_input == "0":
s_target_input = input("Fabrik LIST target table name? ")
print("")
# INPUT THE JOOMLA MYSQL FABRIK LIST KEY FIELD
s_key_field_input = s_key_field
if b_input or s_key_field_input == "0":
print("")
print("Default fabrik list key field: " + s_key_field)
while s_key_field_input == "" or s_key_field_input == "0":
s_key_field_input = input("Fabrik LIST key field? ")
"""*************************************************************************
OPEN DATABASE
*************************************************************************"""
if func_configure.l_debug_project:
print("OPEN DATABASE")
# Connect to the oracle database
mysql_connection = func_mysql.mysql_open(s_database_input)
curs = mysql_connection.cursor()
if func_configure.l_log_project:
func_file.write_log("%t OPEN DATABASE: " + s_database_input)
"""*************************************************************************
INSERT LIST RECORD
*************************************************************************"""
if func_configure.l_debug_project:
print("INSERT LIST RECORD")
# INSERT LIST RECORD
s_sql = "INSERT INTO `" + s_table_input + "` (" + """
`label`,
`introduction`,
`form_id`,
`db_table_name`,
`db_primary_key`,
`auto_inc`,
`connection_id`,
`created`,
`created_by`,
`created_by_alias`,
`modified`,
`modified_by`,
`checked_out`,
`checked_out_time`,
`published`,
`publish_up`,
`publish_down`,
`access`,
`hits`,
`rows_per_page`,
`template`,
`order_by`,
`order_dir`,
`filter_action`,
`group_by`,
`private`,
`params`
""" + ") VALUES (" + """
'%LABEL%',
'',
%FORM%,
'%TABLE_TARGET%',
'%TABLE_TARGET%.%KEY_FIELD%',
1,
%CONNECTION%,
NOW(),
%CREATED_BY%,
'Python',
'0000-00-00 00:00:00',
0,
0,
'0000-00-00 00:00:00',
1,
'0000-00-00 00:00:00',
'0000-00-00 00:00:00',
1,
1,
10,
'bootstrap',
'[""]',
'["ASC"]',
'onchange',
'',
0,
'{
"bootstrap_condensed_class":"1",
"allow_add":"9",
"allow_delete":"3"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%LABEL%", s_label_input)
s_sql = s_sql.replace("%CONNECTION%", s_connection)
s_sql = s_sql.replace("%CREATED_BY%", s_created_by)
s_sql = s_sql.replace("%FORM%", s_form_input)
s_sql = s_sql.replace("%TABLE_TARGET%", s_target_input)
s_sql = s_sql.replace("%KEY_FIELD%", s_key_field_input)
# print(s_sql) # DEBUG
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT RECORD: " + s_database_input + "." +
s_table_input + ": " + s_label_input)
# GET NEWLY CREATED LIST NUMBER
curs.execute("SELECT " + s_table_input + ".id, " + s_table_input +
".label " + "FROM " + s_table_input + " " + "WHERE " +
s_table_input + ".label = '" + s_label_input + "'")
for row in curs.fetchall():
if func_configure.l_debug_project:
print("Created list " + str(row[0]))
i_return = row[0]
# RETURN NEWLY CREATED GROUP NUMBER
return i_return
def fabrik_form_create(b_input: bool = False, s_form: str = "0") -> int:
"""
:param b_input: bool - Force keyboard input
:param s_form: str - Fabrik form label
:return: int - Fabrik form id
"""
# IMPORT SYSTEM MODULES
# IMPORT OWN MODULES
from _my_modules import func_configure
from _my_modules import func_file
from _my_modules import func_mysql
"""
INDEX
ENVIRONMENT
INPUT
OPEN DATABASE
INSERT FORM RECORD
"""
"""*************************************************************************
ENVIRONMENT
*************************************************************************"""
if b_input:
func_configure.l_debug_project = True
if func_configure.l_debug_project:
print("FABRIK CREATE FORM STEP 2")
print("-------------------------")
print("ENVIRONMENT")
# DECLARE VARIABLES
s_database: str = func_configure.s_joomla_database
s_table: str = func_configure.s_joomla_prefix + "_fabrik_forms"
s_created_by: str = func_configure.s_user_id
i_return: int = 0
"""*************************************************************************
INPUT
*************************************************************************"""
if func_configure.l_debug_project:
print("INPUT")
# Input the joomla mysql fabrik DATABASE name
s_database_input = s_database
if b_input:
print("")
print("Default fabrik database: " + s_database)
s_database_input = input("Fabrik DATABASE name? ")
if s_database_input == "":
s_database_input = s_database
# Input the joomla mysql fabrik TABLE name
s_table_input = s_table
if b_input:
print("")
print("Default fabrik table name: " + s_table)
s_table_input = input("Fabrik TABLE name? ")
if s_table_input == "":
s_table_input = s_table
# INPUT THE JOOMLA MYSQL FABRIK LIST LABEL
s_form_input = s_form
if b_input or s_form_input == "0":
print("")
print("Default fabrik list form: " + s_form)
while s_form_input == "" or s_form_input == "0":
s_form_input = input("Fabrik FORM label? ")
print("")
"""*************************************************************************
OPEN DATABASE
*************************************************************************"""
if func_configure.l_debug_project:
print("OPEN DATABASE")
# Connect to the oracle database
mysql_connection = func_mysql.mysql_open(s_database_input)
curs = mysql_connection.cursor()
if func_configure.l_log_project:
func_file.write_log("%t OPEN DATABASE: " + s_database_input)
"""*************************************************************************
INSERT FORM RECORD
*************************************************************************"""
if func_configure.l_debug_project:
print("INSERT FORM RECORD")
# INSERT FORM RECORD
s_sql = "INSERT INTO `" + s_table_input + "` (" + """
`label`,
`record_in_database`,
`error`,
`intro`,
`created`,
`created_by`,
`created_by_alias`,
`modified`,
`modified_by`,
`checked_out`,
`checked_out_time`,
`publish_up`,
`publish_down`,
`reset_button_label`,
`submit_button_label`,
`form_template`,
`view_only_template`,
`published`,
`private`,
`params`
""" + ") VALUES (" + """
'%LABEL%',
1,
'Some parts of your form have not been correctly filled in!',
'',
NOW(),
%CREATED_BY%,
'Python',
'0000-00-00 00:00:00',
0,
0,
'0000-00-00 00:00:00',
'0000-00-00 00:00:00',
'0000-00-00 00:00:00',
'Reset',
'Save',
'bootstrap',
'bootstrap',
1,
0,
'{
"apply_button":"1",
"goback_button":"1",
"pdf_size":"a4"
}'
""" + ");"
# print(s_sql) # DEBUG
s_sql = s_sql.replace("%LABEL%", s_form_input)
s_sql = s_sql.replace("%CREATED_BY%", s_created_by)
curs.execute(s_sql)
mysql_connection.commit()
if func_configure.l_log_project:
func_file.write_log("%t INSERT RECORD: " + s_database_input + "." +
s_table_input + ":" + s_form_input)
# GET NEWLY CREATED FORM NUMBER
curs.execute("SELECT " + s_table_input + ".id, " + s_table_input +
".label FROM " + s_table_input + " WHERE " + s_table_input +
".label = '" + s_form_input + "'")
for row in curs.fetchall():
if func_configure.l_debug_project:
print("Created list " + str(row[0]))
i_return = row[0]
# RETURN NEWLY CREATED FORM NUMBER
return i_return
