def get_city(name):
flt = rt.lookup_filter('name', name)
try:
return City.objects.exclude(
type__in=[PlaceTypes.county, PlaceTypes.province]).get(flt)
except City.DoesNotExist:
raise Exception("No city named %r" % name)
def get_city(name):
flt = rt.lookup_filter('name', name)
try:
return City.objects.exclude(
type__in=[PlaceTypes.county, PlaceTypes.province]).get(flt)
except City.DoesNotExist:
raise Exception("No city named %r" % name)
def lookup_city(name):
flt = rt.lookup_filter('name', name)
try:
return Place.objects.get(flt)
except Place.MultipleObjectsReturned:
raise Exception("20190406 Multiple cities {} for {} : {}".format(
name, flt, Place.objects.filter(flt)))
except Place.DoesNotExist:
# city = Place.objects.get(name=name)
raise Exception("20190406 City {} not found in {} ({})".format(
name, Place.objects.all(), flt))
return
def lookup_city(name):
flt = rt.lookup_filter('name', name)
try:
return Place.objects.get(flt)
except Place.MultipleObjectsReturned:
raise Exception("20190406 Multiple cities {} for {} : {}".format(
name, flt, Place.objects.filter(flt)))
except Place.DoesNotExist:
# city = Place.objects.get(name=name)
raise Exception("20190406 City {} not found in {} ({})".format(
name, Place.objects.all(), flt))
return
def make_city(country_id, name=None, **kw):
if False: # AFTER17:
kw.setdefault('type', PlaceTypes.city.pk)
if kw.get('type',False) and isinstance(kw.get('type',False),PlaceType):
kw['type'] = kw['type'].pk
else:
kw.setdefault('type', PlaceTypes.city)
flt = rt.lookup_filter(
'name', name, country__isocode=country_id, **kw)
try:
return Place.objects.get(flt)
# return Place.objects.exclude(type__in=[
# PlaceTypes.county, PlaceTypes.province]).get(flt)
except MultipleObjectsReturned:
#~ qs = Place.objects.exclude(type=PlaceTypes.county).filter(country__isocode=country_id,name=name)
raise Exception("Oops, there are multiple cities for %r", name)
except Place.DoesNotExist:
obj = city(name, country_id, **kw)
obj.full_clean()
obj.save()
return obj
def make_city(country_id, name=None, **kw):
if False: # AFTER17:
kw.setdefault('type', PlaceTypes.city.pk)
if kw.get('type', False) and isinstance(kw.get('type', False),
PlaceType):
kw['type'] = kw['type'].pk
else:
kw.setdefault('type', PlaceTypes.city)
flt = rt.lookup_filter('name', name, country__isocode=country_id, **kw)
try:
return Place.objects.get(flt)
# return Place.objects.exclude(type__in=[
# PlaceTypes.county, PlaceTypes.province]).get(flt)
except MultipleObjectsReturned:
#~ qs = Place.objects.exclude(type=PlaceTypes.county).filter(country__isocode=country_id,name=name)
raise Exception("Oops, there are multiple cities for %r", name)
except Place.DoesNotExist:
obj = city(name, country_id, **kw)
obj.full_clean()
obj.save()
return obj
def objects():
ceo = rt.models.contacts.RoleType.objects.filter(
rt.lookup_filter('name', "CEO")).first()
# if qs.count() != 1:
# raise Exception("Oops, we have {} CEO's in {}".format(qs.count(), qs))
# yield site_company_objects()
aachen = lookup_city('Aachen')
eupen = lookup_city('Eupen')
raeren = lookup_city('Raeren')
angleur = lookup_city('Angleur')
paris = lookup_city('Paris')
amsterdam = lookup_city('Amsterdam')
vigala = lookup_city('Vigala')
rumma = company(
'Rumma & Ko OÜ', '78003', vigala, 'Uus tn', '1',
url="http://www.saffre-rumma.net/")
if dd.is_installed('vat'):
rumma.vat_id = "EE100588749"
# a vat_id is required for generating valid XML from payment order
yield rumma
settings.SITE.site_config.update(site_company=rumma)
ausdemwald = company('Bäckerei Ausdemwald', '4700', eupen, 'Vervierser Straße', '45')
yield ausdemwald
yield company('Bäckerei Mießen', '4700', eupen, 'Gospert', '103')
yield company('Bäckerei Schmitz', '4700', eupen, 'Aachener Straße', '53')
mergelsberg = company('Garage Mergelsberg', '4730', raeren, 'Hauptstraße', '13')
yield mergelsberg
yield company('Donderweer BV', '4816 AR', 'Breda', 'Edisonstraat', '12')
yield company('Van Achter NV', '4836 LG', 'Breda', 'Hazeldonk', '2')
yield company('Hans Flott & Co', '22453', 'Hamburg', 'Niendorfer Weg', '532')
yield company('Bernd Brechts Bücherladen', '80333', aachen, 'Brienner Straße', '18')
yield company('Reinhards Baumschule', '12487 ', 'Berlin', 'Segelfliegerdamm', '123')
yield company('Moulin Rouge', '75018', 'Paris', 'Boulevard de Clichy', '82')
yield company('Auto École Verte', '54000 ', 'Nancy', 'rue de Mon Désert', '12')
yield person(eupen, 'Andreas', 'Arens', gender=dd.Genders.male,
phone="+32 87123456", email="*****@*****.**")
annette = person(eupen, 'Annette', 'Arens', gender=dd.Genders.female,
phone="+32 87123457", email="*****@*****.**")
yield annette
yield person(eupen, 'Hans', 'Altenberg', gender=dd.Genders.male)
alfons = person(eupen, 'Alfons', 'Ausdemwald', gender=dd.Genders.male)
yield alfons
yield person(eupen, 'Laurent', 'Bastiaensen', gender=dd.Genders.male)
yield person(eupen, 'Charlotte', 'Collard', gender=dd.Genders.female)
yield person(eupen, 'Ulrike', 'Charlier', gender=dd.Genders.female)
yield person(eupen, 'Marc', 'Chantraine', gender=dd.Genders.male)
yield person(eupen, 'Daniel', 'Dericum', gender=dd.Genders.male)
yield person(eupen, 'Dorothée', 'Demeulenaere', gender=dd.Genders.female)
yield person(eupen, 'Dorothée', 'Dobbelstein-Demeulenaere',
gender=dd.Genders.female)
yield person(eupen, 'Dorothée', 'Dobbelstein', gender=dd.Genders.female)
yield person(eupen, 'Berta', 'Ernst', gender=dd.Genders.female)
yield person(eupen, 'Bernd', 'Evertz', gender=dd.Genders.male)
yield person(eupen, 'Eberhart', 'Evers', gender=dd.Genders.male)
yield person(eupen, 'Daniel', 'Emonts', gender=dd.Genders.male)
yield person(eupen, 'Edgar', 'Engels', gender=dd.Genders.male)
yield person(eupen, 'Luc', 'Faymonville', gender=dd.Genders.male)
yield person(eupen, 'Germaine', 'Gernegroß', gender=dd.Genders.female)
yield person(eupen, 'Gregory', 'Groteclaes', gender=dd.Genders.male)
yield person(eupen, 'Hildegard', 'Hilgers', gender=dd.Genders.female)
yield person(eupen, 'Henri', 'Hilgers', gender=dd.Genders.male)
yield person(eupen, 'Irene', 'Ingels', gender=dd.Genders.female)
yield person(eupen, 'Jérémy', 'Jansen', gender=dd.Genders.male)
yield person(eupen, 'Jacqueline', 'Jacobs', gender=dd.Genders.female)
yield person(eupen, 'Johann', 'Johnen', gender=dd.Genders.male)
yield person(eupen, 'Josef', 'Jonas', gender=dd.Genders.male)
yield person(eupen, 'Jan', 'Jousten', gender=dd.Genders.male)
yield person(eupen, 'Karl', 'Kaivers', gender=dd.Genders.male)
yield person(eupen, 'Guido', 'Lambertz', gender=dd.Genders.male)
yield person(eupen, 'Laura', 'Laschet', gender=dd.Genders.female)
yield person(eupen, 'Line', 'Lazarus', gender=dd.Genders.female)
yield person(eupen, 'Josefine', 'Leffin', gender=dd.Genders.female)
yield person(eupen, 'Marc', 'Malmendier', gender=dd.Genders.male)
yield person(eupen, 'Melissa', 'Meessen', gender=dd.Genders.female)
yield person(eupen, 'Michael', 'Mießen', gender=dd.Genders.male)
yield person(eupen, 'Marie-Louise', 'Meier', gender=dd.Genders.female)
yield person(raeren, 'Erich', 'Emonts', gender=dd.Genders.male)
yield person(raeren, 'Erwin', 'Emontspool', gender=dd.Genders.male)
yield person(raeren, 'Erna', 'Emonts-Gast', gender=dd.Genders.female)
yield person(raeren, 'Alfons', 'Radermacher', gender=dd.Genders.male)
yield person(raeren, 'Berta', 'Radermacher', gender=dd.Genders.female)
yield person(raeren, 'Christian', 'Radermacher', gender=dd.Genders.male)
yield person(raeren, 'Daniela', 'Radermacher', gender=dd.Genders.female)
yield person(raeren, 'Edgard', 'Radermacher', gender=dd.Genders.male)
yield person(raeren, 'Fritz', 'Radermacher', gender=dd.Genders.male)
yield person(raeren, 'Guido', 'Radermacher', gender=dd.Genders.male)
yield person(raeren, 'Hans', 'Radermacher', gender=dd.Genders.male)
yield person(raeren, 'Hedi', 'Radermacher', gender=dd.Genders.female)
yield person(raeren, 'Inge', 'Radermacher', gender=dd.Genders.female)
yield person(raeren, 'Jean', 'Radermacher', gender=dd.Genders.male)
# special challenges for alphabetic ordering
yield person(raeren, 'Didier', 'di Rupo', gender=dd.Genders.male)
yield person(raeren, 'David', 'da Vinci', gender=dd.Genders.male)
yield person(raeren, 'Vincent', 'van Veen', gender=dd.Genders.male)
yield person(raeren, 'Õie', 'Õunapuu', gender=dd.Genders.female)
otto = person(raeren, 'Otto', 'Östges', gender=dd.Genders.male)
yield otto
erna = person(raeren, 'Erna', 'Ärgerlich', gender=dd.Genders.female)
yield erna
yield person(angleur, 'Bernard', 'Bodard', title='Dr.')
yield person(angleur, 'Jean', 'Dupont')
yield person(amsterdam, 'Mark', 'Martelaer',
gender=dd.Genders.male)
yield person(amsterdam, 'Rik', 'Radermecker',
gender=dd.Genders.male)
yield person(amsterdam, 'Marie-Louise', 'Vandenmeulenbos',
gender=dd.Genders.female)
yield person(aachen, 'Emil', 'Eierschal', gender=dd.Genders.male)
yield person(aachen, 'Lisa', 'Lahm', gender=dd.Genders.female)
yield person(aachen, 'Bernd', 'Brecht', gender=dd.Genders.male)
yield person(aachen, 'Karl', 'Keller', gender=dd.Genders.male)
yield person(paris, 'Robin', 'Dubois', gender=dd.Genders.male)
denis = person(paris, 'Denis', 'Denon', gender=dd.Genders.male)
yield denis
jerome = person(paris, 'Jérôme', 'Jeanémart', gender=dd.Genders.male)
yield jerome
nr = 1
for p in rt.models.contacts.Person.objects.filter(city=eupen):
p.street = STREETS.pop()
p.stret_no = str(nr)
p.save()
nr += 1
yield rt.models.contacts.Role(company=ausdemwald, person=annette, type=ceo)
yield rt.models.contacts.Role(company=mergelsberg, person=erna, type=ceo)
yield rt.models.contacts.Role(company=rumma, person=erna, type=ceo)
