def view_components(context, request):
print('Incoming request')
r = context.retrieve()
if r is None:
raise HTTPNotFound()
else:
db.connectToDb()
print db.dictionary
return [db.dictionary]
def onOpenDb(self, e):
"""Create and show the Open FileDialog"""
dlg = wx.FileDialog(
self, message="Choose a Db file containing Lending Club loans",
defaultDir = self.currentDirectory,
defaultFile = "",
wildcard = "CSV file (*.db)|*.db|All files (*.*)|*.*",
style = wx.OPEN | wx.CHANGE_DIR
)
if dlg.ShowModal() == wx.ID_OK:
path = dlg.GetPath()
db.connectToDb(path)
dlg.Destroy()
def onOpenDb(self, e):
"""Create and show the Open FileDialog"""
dlg = wx.FileDialog(
self,
message="Choose a Db file containing Lending Club loans",
defaultDir=self.currentDirectory,
defaultFile="",
wildcard="CSV file (*.db)|*.db|All files (*.*)|*.*",
style=wx.OPEN | wx.CHANGE_DIR)
if dlg.ShowModal() == wx.ID_OK:
path = dlg.GetPath()
db.connectToDb(path)
dlg.Destroy()
def getClients():
conn = db.connectToDb()
cur = conn.cursor()
cur.execute("SELECT * FROM clients;")
query_results = cur.fetchall()
rows = []
for i in query_results:
rows.append({
"client_id": i[0],
"first_name": i[1],
"last_name": i[2],
"mi_initial": i[3],
"number1": i[4],
"number2": i[5],
"email_address": i[6],
"realtor": i[7],
"referred_by": i[8]
})
print(rows)
cur.close()
conn.close()
return jsonify(rows)
def uploadFile():
requestData = json.loads(request.data)
# try:
conn = db.connectToDb()
cur = conn.cursor()
cur.execute(
"INSERT INTO file_uploads (file_name, file_path, file_data) VALUES (%s, %s, %s)",
(
requestData.get('name'),
requestData.get('file'),
requestData.get('fileSource'),
))
conn.commit()
cur.close()
conn.close()
return {"Success": "WE DID IT"}
def addClient():
try:
conn = db.connectToDb()
cur = conn.cursor()
cur.execute(
"INSERT INTO clients (first_name, lastname, mi_initial) VALUES (%s, %s, %s)",
(
"yabba",
"dadda",
"do",
))
conn.commit()
cur.close()
conn.close()
print("INSIDE FAILED ADD CLIENT")
return jsonify(returnData)
except Exception as ex:
print("Failed to insert client into db")
def getFiles():
# try:
print("Inside the getFiles Endpoint")
conn = db.connectToDb()
cur = conn.cursor()
cur.execute("SELECT * FROM file_uploads;")
query_results = cur.fetchall()
rows = []
for i in query_results:
rows.append({
"file_id": i[3],
"file_name": i[0],
"file_data": str(bytes(i[1]))
})
print(rows)
cur.close()
conn.close()
return jsonify(rows)
import os
import wx
import wx.lib.agw.customtreectrl as CT
#import wx.lib.delayedresult as delayedresult
# Local imports
import generator
from generator import doLog
import db
# Initialize Db #
db = db.Db()
# TODO: Remove this
# Just so I don't have to manually load the db:
db.connectToDb()
# IDs #
APP_EXIT = 1
APP_OPEN_CSV = 2
APP_OPEN_DB = 3
#APP_GENERATE = 4
class MyWindow(wx.Frame):
"""This is the GUI class"""
global db
def __init__(self, *args, **kwargs):
super(MyWindow, self).__init__(*args, **kwargs)
self.SetSize((640, 480))
# Initialize User Interface #
import os
import wx
import wx.lib.agw.customtreectrl as CT
#import wx.lib.delayedresult as delayedresult
# Local imports
import generator
from generator import doLog
import db
# Initialize Db #
db = db.Db()
# TODO: Remove this
# Just so I don't have to manually load the db:
db.connectToDb()
# IDs #
APP_EXIT = 1
APP_OPEN_CSV = 2
APP_OPEN_DB = 3
#APP_GENERATE = 4
class MyWindow(wx.Frame):
"""This is the GUI class"""
global db
def __init__(self, *args, **kwargs):
super(MyWindow, self).__init__(*args, **kwargs)
self.SetSize((640, 480))
