from flask import Flask
import pyodbc
app = Flask(__name__)

def connect():
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=testdb;UID=me;PWD=pass')
    return cnxn.cursor()

cursor = connect()

@app.route('/ali_request_user')
def get_user_id():
cursor.execute("select user_id, user_name from users")
rows = cursor.fetchall()
    return rows

@app.route('/ali_request_image')
def getEloScore(image):
cursor.execute("""
SELECT [EloScore]
FROM [dbo].[Elo]
WHERE [ImagePath] = ?
""", image)

    return cursor.fetchone()

@app.route('/ali_request_votes')
def getVotes(username):
cursor.execute("""
SELECT [ImagePath1]
,[ImagePath2]
FROM [dbo].[Vote]
WHERE [Username] = ?
""", username)

    return cursor.fetchall()

if __name__ == '__main__':
    app.run(host='0.0.0.0', port=5123)