import psycopg2
game="restaurantcity"
conn_string = "dbname='datawarehouse' port='5439' user='USERHERE' password='PASSWORDHERE' host='redshift.pro.rc.laicosp.net'";
print("Connecting to database\n        ->%s" % (conn_string))
conn = psycopg2.connect(conn_string)

cursor = conn.cursor()

cursor.execute("""set search_path to """ + game + """;""")
cursor.execute("""
SELECT DISTINCT session_id FROM log_session_start WHERE datetime>='2017-03-05' AND datetime<'2017-03-06' AND platform='android' ORDER BY session_id;
""")
d=cursor.fetchall()

f = open("RSsessions.txt", "w")
for i in d:
    f.write(str(i[0])+"\n")
f.close()