Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class KindOfCoupons:
- def get_coupons(self, cur, names):
- coupons = {}
- for name in names:
- coupons[name] = cur.execute("SELECT * FROM "" + name + "" ;")
- return coupons
- def connect_redshift(self):
- conn = psycopg2.connect("dbname=dbname host=host user=user password=password port=000")
- return conn.cursor()
- def get_coupon_used_type(self):
- cur = self.connect_redshift()
- names = ["TABLE", "TABLE_B", "TABLE_C"]
- coupons = self.get_coupons(cur, names)
- coupons[names[0]][0]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement