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"
