-
Notifications
You must be signed in to change notification settings - Fork 0
/
api.py
87 lines (62 loc) · 1.64 KB
/
api.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
import json
import psycopg2
from flask import Flask,request
from flask import jsonify
import traceback
#import os
from flask_cors import CORS
conn = ''
def connectToDB():
global conn
try:
params = json.load(open('DBSettings.json'))
print "Connecting to database\n ->%s" %(params['dbname'])
conn = psycopg2.connect(**params)
print "Connected!\n"
return conn
except:
print "Connection couldn't be established"
app = Flask(__name__)
CORS(app)
@app.route('/')
def index():
return "Hello, World!<br>Proceed to /getdata?input=fileid for annotations"
@app.route('/getlines', methods=['GET','POST'])
def getdata():
global conn
#Check if connection is established
try:
cursor = conn.cursor()
except:
conn = connectToDB()
cursor = conn.cursor()
try:
fileid = request.args.get('input')
query1 = "SELECT lines::json FROM analytics.file WHERE fileid = %s limit 1"
cursor.execute(query1,[fileid])
output = cursor.fetchone()
return json.dumps(output[0])
except:
return 'Error'
cursor = conn.cursor()
@app.route('/getsentences', methods=['GET','POST'])
def getsentences():
global conn
#Check if connection is established
try:
cursor = conn.cursor()
except:
conn = connectToDB()
cursor = conn.cursor()
try:
fileid = request.args.get('input')
query1 = "SELECT sentences::json FROM analytics.file WHERE fileid = %s limit 1"
cursor.execute(query1,[fileid])
output = cursor.fetchone()
return json.dumps(output[0])
except:
return 'Error: '
cursor = conn.cursor()
if __name__ == '__main__':
app.run(debug=True, host = '127.0.0.1', port = 8000)
#app.run(debug=True, host = '127.0.0.1', port = 5555)