def get(self,eventname,eventid): event = read("""select e.*,c.name as categoryname from event e inner join eventcategory c on e.categoryid = c.id where e.id={};""".format(eventid), False) if(event): print("Event ",event) prices = get_prices(event['id']) print("Prices") print(prices) if prices != None: event['prices'] = prices discounts = get_discounts(event['id']) print("Discount") print(discounts) if discounts != None: event['discounts'] = discounts return event
def get(self,eventid,couponcode): discount = read((""" select discountname,discounttype from discounts where eventid = {} and couponcode = '{}';""").format(eventid,couponcode), False) if discount is not None: return {"verified":"true", "discountname": discount['discountname'], "discounttype": discount['discounttype']} else: return {"verified":"false"}
def get_discounts(eventid): return read("""select * from discounts where eventid = {}""".format(eventid))
def get_prices(eventid): return read("""select * from price where eventid = {}""".format(eventid))
def get(self,category = None): categories = read("select * from eventcategory order by name asc;") return categories
def get(self,category = None): return read("""select e.id,e.name,e.location,e.url,e.eventstart,c.name as categoryname from topevents t inner join event e on t.eventid=e.id inner join eventcategory c on e.categoryid = c.id;""")
def get(self): return read("""select e.id,e.name,e.location,e.url,e.eventstart,c.name as categoryname from banners s inner join event e on s.eventid=e.id inner join eventcategory c on e.categoryid = c.id;""")