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