def t010_Sector(self):
"""Settori di applicazione"""
L.i("SectorTestData load start")
c = 0
for el in TestData.listSectors:
L.i(" Dataloaded #{0}".format(c)); c+=1;
sector = Sector( title = el['title'], description= el['description'])
self.sectors.append(sector)
sector.put()
L.i("SectorTestData load ended")
return True
def t010_Sector(self):
"""Settori di applicazione"""
L.i("SectorTestData load start")
c = 0
for el in TestData.listSectors:
L.i(" Dataloaded #{0}".format(c))
c += 1
sector = Sector(title=el['title'], description=el['description'])
self.sectors.append(sector)
sector.put()
L.i("SectorTestData load ended")
return True
def import_ideas(soup, commit=True):
print 'Importing ideas...'
# <table class="bottomline" width="100%">
rows = soup\
.find('table', 'bottomline')\
.find('tbody')\
.findAll('tr', recursive=False)
ideas = []
for i, row in enumerate(rows[:-1]):
votes, content = row.findAll('td', recursive=False)
raw = unicode(content)
# Pull out content first
title, author, sector = content.findAll('a')[:3]
idea_id = find_int(title['href'])
raw_date = sector.nextSibling
created_at = parse_idea_date(raw_date)
author = make_author(author)
sector_id = find_int(sector['href'])
sector = Sector.get_by_id(sector_id)
upvotes_el = votes.find('strong')
upvotes = find_int(upvotes_el.string.strip())
downvotes = upvotes_el.nextSibling.nextSibling.nextSibling
downvotes = find_int(str(downvotes).strip())
views = find_int(re.search(r'(\d+) Views', raw).group(1))
stage = re.search(r'Stage : (\w+)', raw).group(1)
# Create the idea
key = db.Key.from_path('Idea', idea_id)
idea = Idea(
key=key,
author=author,
sector=sector,
title=unicode(title.string),
upvotes=upvotes,
downvotes=downvotes,
views=views,
stage=stage,
created_at=created_at,
tags=['Idea'])
ideas.append(idea)
print ' - %s by %s' % (idea, author)
if commit:
db.put(ideas)
return ideas
def get_queryset(self):
queryset = Sector.objects()
calle = self.request.query_params.get('calle', None)
sector = self.request.query_params.get('sector', None)
if calle:
queryset = queryset.filter(Q(calles__iexact=calle))
return queryset.only("numeroSector")
if sector:
queryset = queryset.filter(Q(numeroSector=sector))
return queryset
def loadsectors():
for i in range(1, 5):
new_sector = Sector()
db.session.add(new_sector)
for i in range(1, 5):
with open('Sector ' + str(i)) as sector:
for line in sector.readlines():
loclat, loclong = line.split(', ')
new_parking = Parking()
new_parking.sectorid = i
new_parking.loclat = loclat
new_parking.loclong = loclong
new_parking.available = 2
new_parking.disability = random.choice(range(0, 2))
db.session.add(new_parking)
db.session.commit()
flash("successfully added parking spots")
return redirect(url_for('login'))
def generate_sectors(session, sectors_data):
""" Get or create sectors using static config data. """
print(sectors_data)
for sector_name, sector_data in sectors_data.items():
try:
sector = get_sector(session, sector_name=sector_name)
except NoResultFound:
print(f"{sector_name} not in db, creating it")
sector = Sector(name=sector_name)
session.add(sector)
cities_data = sector_data.pop("cities")
for city_name, city_data in cities_data.items():
try:
get_city(session, city_name=city_name)
except NoResultFound:
print(f"{city_name} not found, creating it")
coordinate = Coordinate.load(city_data["location"])
location = get_location(session, sector, coordinate)
create_city(session, city_name, location)
load_map(session, f"data/maps/{sector.name}.map", sector)
def retrieve(self, request, id=None, **kwargs):
queryset = Sector.objects(id=id)
serializer = SectorSerializer(queryset[0])
return Response([serializer.data])
def create_sectors():
if Sector.query.first() is None:
for i in range(1, 11):
sector = Sector(name=str(i))
db.session.add(sector)
db.session.commit()
def get_facet(self, facet, criteria):
return Sector.get_by_id(int(criteria))
