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))