def work_get_all(): myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'}) query = """ SELECT id, name, content_id, createdate, lastdate, active FROM table_work """ results = myDB.executeQueryDict(query) return json.dumps(results)
def run_main(): myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'}) myQuery = """ SELECT * FROM table_work """ results = myDB.executeQueryDict(myQuery) return render_template('main.html', title='My Title', main='My Main', results=results)
def work_get_all(): myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'}) query = """ SELECT name, content_id, createdate, lastdate, active FROM table_work """ results = myDB.executeQueryDict(query) return render_template('main.html', title='My Title', main='My Main', results=results)
def work_get(id): myDB = WEBDB(dbfile, {'logging': 'on', 'type': 'sqlite'}) workquery = """ SELECT w.id, w.name, w.content_id, w.createdate, w.lastdate, w.active, c.content_blob FROM table_work w, table_content c WHERE w.content_id = c.id AND w.id = """ + str(id) + """ """ results = myDB.executeQueryDict(workquery) return json.dumps(results)