def getListings(): listing_query = ListingOwned.objects shards = get_all_shards() listings_owned = [] users = User.objects.filter( Q(username="******") | Q(username="******") | Q(username="******") ) for shard in shards: set_db_for_sharding(listing_query, shard) listings_owned += listing_query.filter(Q(user_pk=users[0].id) | Q(user_pk=users[1].id) | Q(user_pk=users[2].id)) listings_owned.sort(key=lambda x: x.price) return listings_owned
def getApartments(): apartment_query = ApartmentOwned.objects shards = get_all_shards() users = User.objects.filter( Q(username="******") | Q(username="******") | Q(username="******") ) apartments_owned = [] for shard in shards: set_db_for_sharding(apartment_query, shard) apartments_owned += apartment_query.filter( Q(user_pk=users[0].id) | Q(user_pk=users[1].id) | Q(user_pk=users[2].id)) print len(apartments_owned) apartments_owned.sort(key=lambda x: x.sqFt) return apartments_owned
def createListingCSV(): listing_query = ListingOwned.objects shards = get_all_shards() listings_owned = [] users = User.objects.filter( Q(username="******") | Q(username="******") | Q(username="******") ) for shard in shards: set_db_for_sharding(listing_query, shard) listings_owned += listing_query.filter(Q(user_pk=users[0].id) | Q(user_pk=users[1].id) | Q(user_pk=users[2].id)) listings_owned.sort(key=lambda x: x.price) with open('listing_data.csv','wb') as fp: writer = csv.writer(fp, delimiter=',') for listing in listings_owned: row = [str(listing.title), str(listing.price), str(listing.user_pk), str(listing.duration), str(int(listing.is_booked))] writer.writerow(row)
def createApartmentCSV(): apartment_query = ApartmentOwned.objects shards = get_all_shards() apartments_owned = [] users = User.objects.filter( Q(username="******") | Q(username="******") | Q(username="******") ) # print users for shard in shards: set_db_for_sharding(apartment_query, shard) apartments_owned += apartment_query.filter( Q(user_pk=users[0].id) | Q(user_pk=users[1].id) | Q(user_pk=users[2].id) ) apartments_owned.sort(key=lambda x: x.sqFt) with open('apart_data.csv', 'wb') as fp: writer = csv.writer(fp, delimiter=',') for apartment in apartments_owned: row = [str(apartment.city),str(apartment.zip), str(apartment.sqFt), str(apartment.user_pk), str(apartment.min_from_subway), str(apartment.state), str(apartment.street), str(apartment.year)] writer.writerow(row)
def editApartments(): sorted_mins = create_mins_from_subway(10000) apartment_query = ApartmentOwned.objects shards = get_all_shards() users = User.objects.filter( Q(username="******") | Q(username="******") | Q(username="******") ) apartments_owned = [] for shard in shards: set_db_for_sharding(apartment_query, shard) apartments_owned += apartment_query.filter( Q(user_pk=users[0].id) | Q(user_pk=users[1].id) | Q(user_pk=users[2].id)) # apartments_owned = apartments_owned.order_by('sqFt') print len(apartments_owned) apartments_owned.sort(key=lambda x: x.sqFt) for i in range(10000): # print apartments_owned[i] min_from_subway = sorted_mins[i] apartments_owned[i].min_from_subway = min_from_subway apartments_owned[i].save() print "another one"