def venues(self, cursor): venues_query = """SELECT venues.* FROM venues JOIN venue_categories ON venue_categories.venue_id = venues.id WHERE venue_categories.category_id = %s""" cursor.execute(venues_query, (self.id, )) venue_records = cursor.fetchall() return db.build_from_records(models.Venue, venue_records)
def zipcodes(self, cursor): query_str = "SELECT zipcodes.* FROM zipcodes WHERE city_id = %s" cursor.execute(query_str, (self.id, )) records = cursor.fetchall() return db.build_from_records(models.Zipcode, records)
def search(self, params, cursor): if not params: return db.find_all(Venue, cursor) search_clause, search_tuple = self.search_clause(params) cursor.execute(search_clause, search_tuple) records = cursor.fetchall() return db.build_from_records(Venue, records)
def locations(self, cursor): query_str = "SELECT locations.* FROM locations WHERE zipcode_id = %s" cursor.execute(query_str, (self.id, )) records = cursor.fetchall() return db.build_from_records(models.Location, records)
def cities(self, cursor): query_str = "SELECT cities.* FROM cities WHERE state_id = %s" cursor.execute(query_str, (self.id, )) records = cursor.fetchall() return db.build_from_records(models.City, records)