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()



def getVotes(username):

cursor.execute("""

SELECT [ImagePath1]

,[ImagePath2]

FROM [dbo].[Vote]

WHERE [Username] = ?

""", username)



return cursor.fetchall()