debug-scalr-remote-ip

gistfile1.txt

#!/opt/scalr-server/embedded/bin/python
import yaml
import pymysql

QUERY = "SELECT * FROM messages WHERE type='in' AND message_name='Hello';"


def main():
    with open("/opt/scalr-server/etc/scalr/config.yml") as f:
        conf = yaml.load(f)
    my = conf["scalr"]["connections"]["mysql"]

    db = pymysql.connect(my["host"], my["user"], my["pass"], my["name"], my["port"])
    c = db.cursor()
    c.execute(QUERY)
    for row in c.fetchall():
        print row


if __name__ == "__main__":
    main()