import pymssql


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

cur.execute('use COMMONDB;')
'''
cur.execute("SELECT * FROM db_info WHERE db_name='P1805020'")
res = cur.fetchall()
print res

#cur.execute("UPDATE data_routing SET db_id = '357' WHERE logger_id='orkadecateveremet'")
cur.execute("UPDATE data_routing SET db_id = '374' WHERE logger_id='orkavrdrijksweg' AND auth_token='cks8ab5ee5f4f22d49ff56b0ec88db4e'")

cur.execute("SELECT db_id, db_adjusted FROM db_info ORDER BY db_adjusted desc")
res = cur.fetchall()
print res
'''

db_arr = [1,2]
cur.execute("""SELECT db_info.host, db_info.port, db_info.db_name, 
                        db_info.db_type, db_info.username, db_info.psw, 
                        data_routing.master_db, db_info.db_adjusted 
            FROM db_info 
            JOIN data_routing ON db_info.db_id=data_routing.db_id
            WHERE data_routing.logger_id = %s AND data_routing.auth_token=%s""", ('Logger111222','be4visionp6ma9HDmqt5HJGujJNixeZ7'))
res = cur.fetchall()
for row in res:
    print row          

conn.commit()
conn.close()