def connect_to_database(): username, password = db_connect_creds.read_creds() db_connection = MySQLdb.connect(host='localhost', user=username, passwd=password) cursor = db_connection.cursor() db_setup.create_db(cursor, WPA_CRACK_DB, username, password) cursor.execute('USE %s' % WPA_CRACK_DB) cursor.execute('''CREATE TABLE IF NOT EXISTS content ( key1 VARCHAR(64), key2 VARCHAR(64) ) ''')
# copyrighted © 2020 # This is script is to be used for ethical purposes only import MySQLdb import ast import os import wx from datetime import datetime import db_connect_creds import db_setup username, password = db_connect_creds.read_creds() cxn = MySQLdb.connect('localhost', user=username, passwd=password) cur = cxn.cursor() db_setup.create_db(cur, db_setup.INFERNAL_DB, username, password) cxn.commit() cxn.close() cxn = MySQLdb.connect('localhost', user=username, passwd=password, db=db_setup.INFERNAL_DB) cur = cxn.cursor() date = datetime.now() project_id = [] project_name = [] current_project_id = 0 current_project_name = ''
import MySQLdb import ast import db_connect_creds import db_setup import os import sys import wx from datetime import datetime username, password = db_connect_creds.read_creds() cxn = MySQLdb.connect('localhost', user=username, passwd=password) cur = cxn.cursor() db_setup.create_db(cur, db_setup.INFERNAL_DB, username, password) cxn.commit() cxn.close() cxn = MySQLdb.connect('localhost', user=username, passwd=password, db=db_setup.INFERNAL_DB) cur = cxn.cursor() date = datetime.now() project_id = [] project_name = [] current_project_id = 0 current_project_name = '' # TODO - this doesn't make any sense, because we've just potentially creatend an # empty database and yet we're about to query table 'Projects'. cur.execute("SELECT ProjectId,ProjectName FROM Projects") data = row = cur.fetchall() for i,y in data: