lqfbaustritte.py

#!/usr/bin/python
import psycopg2
import pprint

def main():
    sql = "SELECT id FROM member WHERE invite_code IN ("

    with open("austritte.txt", "r") as fobj:
        for line in fobj:
            if line != "":
                sql = sql + "\n  '" + line.replace("\n", "") + "',"

    sql = sql[:-1] + "\n);"

    psqlcon = "host='' dbname='liquid_feedback_lsa'"

    conn = psycopg2.connect(psqlcon)

    cursor = conn.cursor()
    cursor.execute(sql)

    print "BEGIN;"

    for row in cursor:
        print "SELECT delete_member(%s);" % (row[0])

    print "COMMIT;"

if __name__ == "__main__":
    main()