def ft_api_status(): # First, read the database and obtain all the info conn = ft_db_connect_sqlite() c = conn.cursor() c.execute('SELECT id, userid, starttime, stoptime, status FROM `work`;') result = c.fetchall() conn.close() # Second, make a response resp = make_response() resp.headers['Content-Type'] = 'text/xml' resp.data = render_template('status.xml', result=result) return resp
def ft_api_obtain(work_id): # First, open database conn and find the record conn = ft_db_connect_sqlite() c = conn.cursor() try: work_id = int(work_id) except ValueError: abort(400) found = False for i in c.execute('SELECT status, output FROM `work` WHERE id=?;', (work_id,)): found = True break if not found or not i[0] == "S": # NOT SUCCESSFUL abort(404) resp =make_response(i[1], 200) resp.headers['Content-Type'] = 'application/pdf' conn.close() return resp