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:
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>")
