def generate(db, count): print "Populating table: members" with open("firstnames_female.txt") as f: firstnames_female = f.readlines() with open("firstnames_male.txt") as f: firstnames_male = f.readlines() with open("lastnames.txt") as f: lastnames = f.readlines() with open("cities.txt") as f: cities = f.readlines() # At least one member per call should use a "samordningsnummer", and also about one in a hundred randomly # http://www.skatteverket.se/privat/sjalvservice/blanketterbroschyrer/broschyrer/info/707.4.39f16f103821c58f680007997.html samordning_index = int(random.random() * count) samordning_frequency = 0.01 # At least one member per call should use extra letter after street number extra_address_letter_index = int(random.random() * count) # At least one member per call should use apartment number information in address apartment_number_index = int(random.random() * count) # At least one member per call should use extra info such as c/o or att: in address address_extra_info = int(random.random() * count) generated_ids = [] for i in range(1, count+1): is_female = random.random() < 0.5 member = Member() member.created_at = common.get_random_datetime(datetime.datetime(2013,1,1), datetime.datetime.now()) member.updated_at = common.get_random_datetime(member.created_at, datetime.datetime.now()) member.email = common.get_short_unique_string() + '@test.makerspace.se' if is_female: member.firstname = common.get_random_item(firstnames_female).strip() else: member.firstname = common.get_random_item(firstnames_male).strip() member.lastname = common.get_random_item(lastnames).strip() member.civicregno = make_civic_regno(is_female, i == samordning_index or random.random() < samordning_frequency) member.country = 'SE' member.phone = make_phone_number() member.address = make_address(i == extra_address_letter_index, i == apartment_number_index) member.city = common.get_random_item(cities).strip() # Apparently the connection between city and zip code is intellectual property in Sweden member.zipcode = "%03d%02d" % (int(random.random()*900)+100, int(random.random()*100)) member.address2 = make_address2(i == address_extra_info, firstnames_female, lastnames) try: generated_ids.append(common.insert_into_table(db, 'members', member)) except: print "Failed to populate members table" raise return generated_ids
def generate(db, report, count): print "Populating table: members" with open("firstnames_female.txt") as f: firstnames_female = f.readlines() with open("firstnames_male.txt") as f: firstnames_male = f.readlines() with open("lastnames.txt") as f: lastnames = f.readlines() with open("cities.txt") as f: cities = f.readlines() # At least one member per call should use a "samordningsnummer" # http://www.skatteverket.se/privat/sjalvservice/blanketterbroschyrer/broschyrer/info/707.4.39f16f103821c58f680007997.html samordning_index = random.randint(0, count - 1) # At least one member per call should use extra letter after street number extra_address_letter_index = random.randint(0, count - 1) # At least one member per call should use apartment number information in address apartment_number_index = random.randint(0, count - 1) # At least one member per call should use extra info such as c/o or att: in address address_extra_info_index = random.randint(0, count - 1) members = {} for i in xrange(count): is_female = common.chance(0.5) force_samordningsnummer = (i == samordning_index) force_extra_address_letter = (i == extra_address_letter_index) force_apartment_number = (i == apartment_number_index) force_extra_address_info = (i == address_extra_info_index) member = Member() member.created_at = common.get_random_datetime( datetime.datetime(2013, 1, 1), datetime.datetime.now()) member.updated_at = common.get_random_datetime(member.created_at, datetime.datetime.now()) member.email = common.get_short_unique_string() + '@test.makerspace.se' if is_female: member.firstname = random.choice(firstnames_female).strip() else: member.firstname = random.choice(firstnames_male).strip() member.lastname = random.choice(lastnames).strip() member.civicregno = make_civic_regno( db, is_female, force_samordningsnummer or common.chance(0.01)) member.country = 'SE' member.phone = make_phone_number() member.address = make_address(force_extra_address_letter, force_apartment_number) member.city = random.choice(cities).strip() # Apparently the connection between city and zip code is intellectual property in Sweden member.zipcode = "%03d%02d" % (int(random.random() * 900) + 100, int(random.random() * 100)) member.address2 = make_address2(force_extra_address_info, firstnames_female, lastnames) try: member_id = common.insert_into_table(db, 'members', member) except: print "FAILED to insert members row" raise members[member_id] = member if force_samordningsnummer: report.append(("Samordningsnummer", member)) if force_extra_address_letter: report.append(("Letter on street number", member)) if force_apartment_number: report.append(("Address includes apartment number", member)) if force_extra_address_info: report.append(("Extra address line", member)) return members
def generate(db, report, count): print "Populating table: members" with open("firstnames_female.txt") as f: firstnames_female = f.readlines() with open("firstnames_male.txt") as f: firstnames_male = f.readlines() with open("lastnames.txt") as f: lastnames = f.readlines() with open("cities.txt") as f: cities = f.readlines() # At least one member per call should use a "samordningsnummer" # http://www.skatteverket.se/privat/sjalvservice/blanketterbroschyrer/broschyrer/info/707.4.39f16f103821c58f680007997.html samordning_index = random.randint(0, count-1) # At least one member per call should use extra letter after street number extra_address_letter_index = random.randint(0, count-1) # At least one member per call should use apartment number information in address apartment_number_index = random.randint(0, count-1) # At least one member per call should use extra info such as c/o or att: in address address_extra_info_index = random.randint(0, count-1) members = {} for i in xrange(count): is_female = common.chance(0.5) force_samordningsnummer = (i == samordning_index) force_extra_address_letter = (i == extra_address_letter_index) force_apartment_number = (i == apartment_number_index) force_extra_address_info = (i == address_extra_info_index) member = Member() member.created_at = common.get_random_datetime(datetime.datetime(2013,1,1), datetime.datetime.now()) member.updated_at = common.get_random_datetime(member.created_at, datetime.datetime.now()) member.email = common.get_short_unique_string() + '@test.makerspace.se' if is_female: member.firstname = random.choice(firstnames_female).strip() else: member.firstname = random.choice(firstnames_male).strip() member.lastname = random.choice(lastnames).strip() member.civicregno = make_civic_regno(db, is_female, force_samordningsnummer or common.chance(0.01)) member.country = 'SE' member.phone = make_phone_number() member.address = make_address(force_extra_address_letter, force_apartment_number) member.city = random.choice(cities).strip() # Apparently the connection between city and zip code is intellectual property in Sweden member.zipcode = "%03d%02d" % (int(random.random()*900)+100, int(random.random()*100)) member.address2 = make_address2(force_extra_address_info, firstnames_female, lastnames) try: member_id = common.insert_into_table(db, 'members', member) except: print "FAILED to insert members row" raise members[member_id] = member if force_samordningsnummer: report.append(("Samordningsnummer", member)) if force_extra_address_letter: report.append(("Letter on street number", member)) if force_apartment_number: report.append(("Address includes apartment number", member)) if force_extra_address_info: report.append(("Extra address line", member)) return members