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)