def delete_account(self): try: conn = mysql.connector.connect(**config) cursor = conn.cursor() except Exception as e: mlog.error(TAG,"Unable to conenct to MyBanking Database.") print(''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="show_register.py">BACK</a> </div> ''') print(helperHTML.get_html_end_preset()) sys.exit() delete_acc = "DELETE FROM ACCOUNT WHERE ACC_NUMBER = " + str(self.acc_number) error = None try: cursor.execute(delete_acc) conn.commit() except Exception as e: error = str(e) mlog.error(TAG,"Error: " + error) cursor.close() conn.close()
def insert_to_account(self): try: conn = mysql.connector.connect(**config) cursor = conn.cursor() except Exception as e: mlog.error(TAG,"Unable to conenct to MyBanking Database.") print(''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="show_register.py">BACK</a> </div> ''') print(helperHTML.get_html_end_preset()) sys.exit() insert_account = "INSERT INTO ACCOUNT(ACC_NUMBER, NAME, BANK_NAME, BRANCH_NAME, IFSC_CODE, BALANCE) " insert_account += "VALUES (" + str(self.acc_number) + ", '" + str(self.name) + "' , '" + str(self.bank_name) + "' , '" + str(self.branch_name) + "' ," insert_account += "'" + str(self.ifsc_code) + "' , "+ str(self.__balance_amt) + ");" mlog.debug(TAG, insert_account) insert_status = False error = None try: cursor.execute(insert_account) conn.commit() except Exception as e: error = str(e) mlog.error(TAG,"Error: " + error) insert_status = True cursor.close() conn.close() return insert_status, error
def get_account_details(self, account_number): mlog.debug(TAG, "get_account_details(" + str(account_number) + ")") self.transaction_success = False self.transaction_message = "" all_recs = None try: query_account = "SELECT name, number, ifsc_code, bank_name, branch_name, balance FROM account WHERE number=" + str( account_number) + ";" self.db_connection.query(query_account) all_recs = conn.store_result() except Exception as e: self.transaction_message = str(e) mlog.error(TAG, "Error: " + str(e)) obj_account = None if all_recs != None and all_recs.num_rows() > 0: row = all_recs.fetch_row() for item in row: obj_account = Account() obj_account.set(acc_number=int(str(item[1])), acc_name=str(item[0], 'utf-8'), bank=str(item[3], 'utf-8'), branch=str(item[4], 'utf-8'), ifsc=str(item[2], 'utf-8'), balance_amt=int(str(item[5]))) self.transaction_success = True self.transaction_message = "Successfully fetched account details" else: self.transaction_success = False self.transaction_message = "Unable to fetch account details.." return obj_account
def insert_to_user(self): try: conn = mysql.connector.connect(**config) cursor = conn.cursor() except Exception as e: mlog.error(TAG,"Unable to conenct to MyBanking Database.") print(''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="show_register.py">BACK</a> </div> ''') print(helperHTML.get_html_end_preset()) sys.exit() insert_user = "******" + str(self.acc_number) insert_user += ", '" + str(self.login_name) + "' , '" + str(self.login_key) + "' );" mlog.debug(TAG, insert_user) insert_status = False error = None try: cursor.execute(insert_user) conn.commit() except Exception as e: error = str(e) mlog.error(TAG,"Error: " + error) insert_status = True cursor.close() conn.close() return insert_status, error
def get_session_accout_no(): session_fosr = open(SESSION_FILE,'r') value = session_fosr.read() session_fosr.close() account_number = 0 try: account_number = int(value) except Exception as e: mlog.error("SESSION", "Something went wrong with session.txt content:"+str(value)+" >>" + str(e)) return account_number
def register_new_account(self, account_obj): mlog.debug(TAG, "register_new_account()") self.transaction_success = False self.transaction_message = "" try: sql_insert = "INSERT INTO account(number,name,ifsc_code,bank_name,branch_name,balance)" sql_insert += " VALUES(" + str( account_obj.number ) + ", '" + account_obj.name + "', '" + account_obj.ifsc_code + "', '" + account_obj.bank_name + "', '" + account_obj.branch_name + "'," + str( account_obj.balance) + ")" self.db_connection.query(sql_insert) self.transaction_success = True self.transaction_message = "Successfully registered new user!" except Exception as e: self.transaction_message = str(e) mlog.error(TAG, "Error: " + error_message) return self.transaction_success
def initialize(self): mlog.debug(TAG, "initialize()") transaction_success = False transaction_message = "" try: mlog.debug(TAG, "Establishing database connection..") self.db_connection = _mysql.connect(db_config.db_host, db_config.db_user, db_config.db_password, db_config.db_name) transaction_success = True except Exception as e: mlog.error(TAG, "Unable to conenct to MyBanking Database.") transaction_message = ''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="show_dashboard.py">BACK</a> </div> ''' return transaction_success
def update_account_details(self, account_obj): mlog.debug(TAG, "set_account_details(" + str(account_obj.number) + ")") self.transaction_success = False self.transaction_message = "" all_recs = None try: query_update = "UPDATE account SET name='" + str( account_obj.name) + "', ifsc_code='" + str( account_obj.ifsc_code) + "', bank_name='" + str( account_obj.bank_name) + "', branch_name='" + str( account_obj.branch_name) + "', balance=" + str( account_obj.balance) + " WHERE number=" + str( account_obj.number) + ";" self.db_connection.query(query_update) self.transaction_success = True self.transaction_message = "Successfully updated account details in DB." except Exception as e: self.transaction_message = str(e) mlog.error(TAG, "Error: " + str(e)) return self.transaction_success
print(helperHTML.get_html_init()) print(helperHTML.get_html_start_preset()) print("<h4>Reset password status:</h4><br><br>") login_name = "" login_key = "" login_key_confirm = "" mlog.debug(TAG,"Fetching form values..") try: form_entries = cgi.FieldStorage() login_name = form_entries.getvalue("login_name") login_key = form_entries.getvalue("login_key") login_key_confirm = form_entries.getvalue("login_key_confirm") except Exception as e: mlog.error(TAG,"Error: " + str(e)) error_message = None if(login_name == None or login_key == None or login_key_confirm == None) : error_message = "<br><p>Failed to change password! Invalid attributes provided. Try again with valid attributes</p>" else: reset_validator = Validator() if reset_validator.validate_login_name(login_name,6,15) == False: error_message = reset_validator.message elif reset_validator.validate_login_key(login_key,6,12) == False: error_message = reset_validator.message elif login_key != login_key_confirm: error_message = "<P>New password and confirm passwords did not match!</p>" mlog.error(TAG,"Reset password validator error message: " + str(error_message)) if error_message != None:
mlog.debug( TAG, "In do_deposit_money with no active session. So prompting to sign in again.." ) print(helperHTML.get_html_invalid_session_preset()) print(helperHTML.get_html_end_preset()) sys.exit() account_number = helperSession.get_session_accout_no() deposit_amount = 0 mlog.debug(TAG, "Fetching form values..") try: form_entries = cgi.FieldStorage() deposit_amount = form_entries.getvalue("deposit_amount") except Exception as e: mlog.error(TAG, "Error: " + str(e)) #--------------------------------------------MENU DETAILS---------------------------------------------------- #Show MENU.. print(''' <div id="entry" > <a id="dashboard_menu_a" href="show_dashboard.py">DASHBOARD</a> <a id="dashboard_menu_a" href="show_add_payee.py">Add Payee</a> <a id="dashboard_menu_a" href="show_remove_payee.py">Remove Payee</a> <a id="dashboard_menu_a" href="show_deposit_money.py">Deposit Money</a> <a id="dashboard_menu_a" href="show_money_transfer.py">Money Transfer</a> <a id="dashboard_menu_a" href="logout.py">Logout</a> </div> ''') print("<div id=\"entry\" >") print("<h4> Deposit money status:</h4><br><br>")
TAG, "In show_remomve_payee with no active session. So prompting to sign in again.." ) print(helperHTML.get_html_invalid_session_preset()) print(helperHTML.get_html_end_preset()) sys.exit() #ELSE: Show list of payees to remove account_number = helperSession.get_session_accout_no() try: mlog.debug(TAG, "Establishing database connection..") conn = mysql.connector.connect(**config) cursor = conn.cursor() except Exception as e: mlog.error(TAG, "Unable to conenct to MyBanking Database.") print(''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="show_dashboard.py">BACK</a> </div> ''') print(helperHTML.get_html_end_preset()) # print(e) sys.exit() #--------------------------------------------MENU DETAILS---------------------------------------------------- #Show MENU.. print(''' <div id="entry" > <a id="dashboard_menu_a" href="show_dashboard.py">DASHBOARD</a>
import mlog from helperRegEx import Validator TAG = "DOLOGIN" mlog.debug(TAG, "Trying to login..") cgitb.enable() print(helperHTML.get_html_init()) login_name = "" login_key = "" mlog.debug(TAG, "Fetching form values..") try: form_entries = cgi.FieldStorage() login_name = form_entries.getvalue("login_name") login_key = form_entries.getvalue("login_key") except Exception as e: mlog.error(TAG, "Error: " + str(e)) #if invalid attributes, show error and eixt. error_message = None login_validator = Validator() if login_validator.validate_login_name(login_name, 6, 10) == False: error_message = login_validator.message elif login_validator.validate_login_key(login_key, 6, 10) == False: error_message = login_validator.message mlog.error(TAG, "login validator error message: " + str(error_message)) if error_message != None: print(helperHTML.get_html_start_preset()) print(''' <h4>Failed to login:</h4> <div id="entry" >
if (helperSession.any_session_active() == False): #Show session inactive.. mlog.debug( TAG, "In dashboard with no active session. So prompting to sign in again..") print(helperHTML.get_html_invalid_session_preset()) print(helperHTML.get_html_end_preset()) sys.exit() mlog.debug(TAG, "In dashboard with active session..") try: mlog.debug(TAG, "Establishing database connection..") conn = _mysql.connect(db_config.db_host, db_config.db_user, db_config.db_password, db_config.db_name) except Exception as e: mlog.error(TAG, "Unable to conenct to MyBanking Database.") helperSession.end_session() print(''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="index.py">HOME</a> </div> ''') print(helperHTML.get_html_end_preset()) # print(e) sys.exit() all_recs = None account_number = helperSession.get_session_accout_no() try: query_user = "******" + str(
beneficiery_account = 0 beneficiery_bank = '' beneficiery_branch = '' beneficiery_ifsc_code = '' transfer_amount = 0 mlog.debug(TAG, "Fetching form values..") try: form_entries = cgi.FieldStorage() beneficiery_name = form_entries.getvalue("beneficiery_name") beneficiery_account = form_entries.getvalue("beneficiery_account") beneficiery_bank = form_entries.getvalue("beneficiery_bank") beneficiery_branch = form_entries.getvalue("beneficiery_branch") beneficiery_ifsc_code = form_entries.getvalue("beneficiery_ifsc_code") transfer_amount = form_entries.getvalue("transfer_amount") except Exception as e: mlog.error(TAG, "Error: " + str(e)) mlog.debug(TAG, "Showing menu..") #--------------------------------------------MENU DETAILS---------------------------------------------------- #Show MENU.. print(''' <div id="entry" > <a id="dashboard_menu_a" href="show_dashboard.py">DASHBOARD</a> <a id="dashboard_menu_a" href="show_add_payee.py">Add Payee</a> <a id="dashboard_menu_a" href="show_remove_payee.py">Remove Payee</a> <a id="dashboard_menu_a" href="show_transfer_money.py">Deposit Money</a> <a id="dashboard_menu_a" href="show_money_transfer.py">Money Transfer</a> <a id="dashboard_menu_a" href="logout.py">Logout</a> </div> ''') print("<div id=\"entry\" >")
account_number = helperSession.get_session_accout_no() payee_name = "" payee_account = 0 payee_bank = "" payee_branch = "" payee_ifsc_code = "" mlog.debug(TAG, "Fetching form values..") try: form_entries = cgi.FieldStorage() payee_name = form_entries.getvalue("payee_name") payee_account = form_entries.getvalue("payee_account") payee_bank = form_entries.getvalue("payee_bank") payee_branch = form_entries.getvalue("payee_branch") payee_ifsc_code = form_entries.getvalue("payee_ifsc_code") except Exception as e: mlog.error(TAG, "Error: " + str(e)) #--------------------------------------------MENU DETAILS---------------------------------------------------- #Show MENU.. print(''' <div id="entry" > <a id="dashboard_menu_a" href="show_dashboard.py">DASHBOARD</a> <a id="dashboard_menu_a" href="show_add_payee.py">Add Payee</a> <a id="dashboard_menu_a" href="show_remove_payee.py">Remove Payee</a> <a id="dashboard_menu_a" href="show_deposit_money.py">Deposit Money</a> <a id="dashboard_menu_a" href="show_money_transfer.py">Money Transfer</a> <a id="dashboard_menu_a" href="logout.py">Logout</a> </div> ''') print("<div id=\"entry\" >") print("<h4> Add Payee status:</h4><br><br>")
import helperSession import mlog import mysql.connector from database.db_config import config TAG = "SHOW_REGISTER.py" mlog.debug(TAG, "At show_register.py!") cgitb.enable() print(helperHTML.get_html_init()) try: mlog.debug(TAG, "Establishing database connection..") conn = mysql.connector.connect(**config) cursor = conn.cursor() except Exception as e: mlog.error(TAG, "Unable to conenct to MyBanking Database:" + str(e)) print(''' <h4>Unable to conenct to MyBanking Database.</h4> <div id="entry" > <a href="home.py">BACK</a> </div> ''') print(helperHTML.get_html_end_preset()) sys.exit() all_recs = None try: select_max_acc = "select max(acc_number) as maximum from account" cursor.execute(select_max_acc) all_recs = cursor.fetchall() except Exception as e: