def listAllNeighborhood():
"""
Print para verificação dos dados
places[name][0]['abbreviation_state'] = i['abbreviation_state']
places[name][1]['abbreviation_currency'] = i['abbreviation_currency']
places[name][2]['region'] = i['region']
places[name][3]['currency'] = i['currency']
places[name][4]['state'] = i['state']
places[name][5]['type'] = i['type']
places[name][6]['locality'] = i['locality']
places[name][7]['country'] = i['country']
places[name][8]['abbreviation_country'] = i['abbreviation_country']
places[name][9]['neighborhood'] = i['neighborhood']
places[name][10]['price'] = 0
places[name][11]['square_meter'] = 0
places[name][12]['price_by_meter'] = 0
"""
lista = MongoDB.list_all_places()
places = {}
for i in lista:
name = i['region'].replace('Sao Jose Dos Campos','') + ' - ' + i['neighborhood']
if name not in places:
places[name] = ['','','','','','','','','','',0,0,0]
places[name][0] = i['abbreviation_state']
places[name][1] = i['abbreviation_currency']
places[name][2] = i['region']
places[name][3] = i['currency']
places[name][4] = i['state']
places[name][5] = i['type']
places[name][6] = i['locality']
places[name][7] = i['country']
places[name][8] = i['abbreviation_country']
places[name][9] = i['neighborhood']
places[name][10] = 0
places[name][11] = 0
places[name][12] = 0
places[name][10] += i['price']
places[name][11] += i['square_meter']
for i in places:
places[i][12] = (places[i][10] / places[i][11])
print(places)
def excel():
"""
Faz um print para poder verificar todos os pontos consolidados
function()
"""
l = MongoDB.list_all_places()
places = {}
for i in l:
name = i['region'].replace('Sao Jose Dos Campos','') + ' - ' + i['neighborhood']
if name not in places:
places[name] = ['', '', 0.0, 0]
places[name][0] = i['region'].replace('Sao Jose Dos Campos','')
places[name][1] = i['neighborhood']
places[name][2] += i['price']
places[name][3] += i['square_meter']
for i in places:
places[i].append(places[i][2] / places[i][3])
for i in places:
print( '{0}\t{1}\t{2}'.format (places[i][0], places[i][1], str(places[i][4])))
def listAllPlaces():
"""
Retorna uma lista com todos os lugares, com o preco/m2
function() -> list
"""
lista = MongoDB.list_all_places()
places = {}
for i in lista:
name = i['region'].replace('Sao Jose Dos Campos','') + ' - ' + i['neighborhood']
if name not in places:
places[name] = [0.0, 0]
places[name][0] += i['price']
places[name][1] += i['square_meter']
for i in places:
places[i].append(places[i][0] / places[i][1])
result = []
for i in sorted(places.keys()):
f = "{:.2f}".format(places[i][2])
result.append([i, f])
return result
