@app.route("/api/analyses")
def analyses_list():
    cursor = connection.cursor()
    query = "select inserted,upload_user,image_name,substances,thumbnail from predictions order by inserted desc"
    cursor.execute(query)
    r = [dict((cursor.description[i][0], str(value))
              for i, value in enumerate(row)) for row in cursor.fetchall()]
    json_output = json.dumps(r)
    cursor.close()
    return json_output


@app.route("/api/testdata")
def create_data():
    cursor = connection.cursor()
    timestamp = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
    raw_image = [[]]
    predicted_image = [[]]
    thumbnail = np.random.randint(0, 255, (20, 20))
    upload_user = "robbert"
    image_name = "image_" + str(timestamp)
    substances = "soy:99.5,corn;0.5"
    query = "insert into predictions(inserted, upload_user, image_name, raw_image, thumbnail, predicted_image, substances)" \
     " values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')".format(timestamp,upload_user,image_name,raw_image, thumbnail,predicted_image, substances)
    print(query)
    cursor.execute(query)
    cursor.commit()
    cursor.close()
    return "inserted query {} successful".format(query)