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: