import pymssql


conn = pymssql.connect(server='db01.be4energy.com', user='be4visionadmin', password='cdg4s!fcv')
cur = conn.cursor()

cur.execute('use COMMONDB;')

#cur.execute("ALTER TABLE data_routing DROP CONSTRAINT data_routing_pkey")
#cur.execute("ALTER TABLE data_routing ADD CONSTRAINT data_routing_pkey PRIMARY KEY (logger_id, auth_token, db_id)")
'''cur.execute('SELECT * FROM authentication')
print cur.fetchall()'''

#cur.execute("INSERT INTO data_routing (logger_id, db_id, auth_token) VALUES ('Logger111222', '3', 'be4visionp6ma9HDmqt5HJGujJNixeZ7')")
#cur.execute("INSERT INTO data_routing (logger_id, db_id, auth_token) VALUES ('Logger111222', '2', 'be4visionp6ma9HDmqt5HJGujJNixeZ7')")
#cur.execute("ALTER TABLE db_info DROP COLUMN master_db")
#cur.execute("UPDATE data_routing SET master_db=0 WHERE logger_id='Logger111222' AND db_id=3")

#cur.execute("UPDATE data_routing SET master_db=1 ")
cur.execute("ALTER TABLE data_routing ALTER COLUMN master_db bit NOT NULL")


conn.commit()
conn.close()