def db_crt(): import mysql.connector as sq import time as t import authenticator auth_data = authenticator.read() uid = auth_data[0] password = auth_data[1] db = sq.connect(host='localhost', user=uid, passwd=password) cursor = db.cursor() print("Checking Database") check = 'show databases' cursor.execute(check) l = cursor.fetchall() l = [i[0] for i in l] if not 'farec' in l: qu = 'create database farec;' print("Database doesn't exist\nCreating database") cursor.execute(qu) print('Loading', end="") for i in range(0, 20): print(".", end="") t.sleep(0.01) db.commit() db.close() else: print("\nDatabase found!")
def tb_crt(): import mysql.connector as sq import time as t import authenticator auth_data = authenticator.read() uid = auth_data[0] password = auth_data[1] tb = sq.connect(host='localhost', user=uid, passwd=password, database='farec') crsr = tb.cursor() print("\nChecking Table") check2 = 'show tables' crsr.execute(check2) m = crsr.fetchall() m = [i[0] for i in m] if not 'record' in m: qu2 = 'create table record (roll int(11), name varchar(20), adm int(11), farec_id int(11) PRIMARY KEY);' print("Table doesn't exist\nCreating table") crsr.execute(qu2) print('Loading', end="") for i in range(0, 20): print(".", end="") t.sleep(0.01) print("\n") tb.commit() tb.close() else: print("\nTable found!\n------------\n")
def tb_upd(): import mysql.connector as sq from datetime import datetime import authenticator auth_data = authenticator.read() uid = auth_data[0] password = auth_data[1] db=sq.connect(host='localhost',user=uid,passwd=password,database='farec') cursor=db.cursor() now=datetime.now() dt=now.strftime("%d_%m_%Y") qu="alter table record add "+dt+" varchar(3) default 'no';" cursor.execute(qu) cursor.close() db.close() print(dt) print("Done!")
pyt = 'python3 ' print("Checking required modules") os.system( shell + 'pip3 install pillow numpy opencv-python opencv-contrib-python tabulate mysql-connector-python mysql-connector pyfiglet' ) os.system(shell + clr) import mysql.connector as sq from tabulate import tabulate import table_creator as tbc import pyfiglet as fg import authenticator if authenticator.check() == True: auth_data = authenticator.read() uid = auth_data[0] password = auth_data[1] elif authenticator.check() == False: authenticator.reg() tbc.db_crt() tbc.tb_crt() db = sq.connect(host='localhost', user=uid, passwd=password, database='farec') cursor = db.cursor() tabulate.PRESERVE_WHITESPACE = True os.system(shell + clr) banner = fg.figlet_format("FaRec") while True: