def dbSelect(self, table=None, listColumns=None): db = backbone.get_db() listSelection = ", ".join(listColumns) try: cur = db.execute('SELECT ' + listSelection + ' from ' + table) results = cur.fetchall() except: results = ["Incorrect Column"] # return render_template('home.html', labels=labels, results=results, list=list) return (results)
def __init__(self): nn = "NOT NULL" self.tableNames = ['Bill', 'dbNames', 'cows'] self.id = {'id' : 'Integer PRIMARY KEY autoincrement'} self.name = {'name': ' varchar(75) ' + nn} self.creationDate = {'dateCreated' : 'DATE'} self.lastName = {'LastName','varchar(255) ' + nn} self.fistName = {'FirstName','varchar(255) ' + nn} self.address = {'Address', 'varchar(255) ' + nn} self.city = {'City', 'varchar(255) ' + nn} self.feed = backbone.get_db()
def __init__(self): ''' Takes the URL Query request, compares to our static dict, and looks through our database ''' ''' {Table Name: Code Name found through URL Query } ''' self.tableNames = {'Bill':'billing', 'cows':'test', 'queryTableNames':'d'} ''' Same thing here, URL Query to predetermined dict, compares and continues to database ''' self.operatorList = {'SELECT':'view', 'CREATE':'insert','DROP':'delete','UPDATE':'update'} ''' Let's put our database connection on standby''' self.feed = backbone.get_db() self.default = {}
def dbSelectForResults(self, table=None, operator=None, searchColumns="*"): db = backbone.get_db() listSelection = ", ".join(searchColumns) try: cur = db.execute(operator + ' ' + listSelection + ' FROM ' + table) return cur.fetchall() except: self.default = {"No Results found or error with operator": False}