def update_db_with_new_entries(count, database):
# add 6 * count of lon and lat to the database
input_list = []
a = Address()
basic_lon, basic_lat = a.coordinates().values()
for i in range(count):
person = Person('uk')
lon1 = basic_lon + 40 * cos(i)
lat1 = basic_lat + 40 * sin(i)
input_list.append(
database(
username=person.full_name(),
division_order=1,
lon1=lon1,
lat1=lat1,
lon2=lon1 + 1,
lat2=lat1 + 2,
lon3=lon1 + 3,
lat3=lat1 + 2,
lon4=lon1 + 4,
lat4=lat1 + 0,
lon5=lon1 + 3,
lat5=lat1 - 2,
lon6=lon1 + 1,
lat6=lat1 - 2,
))
db.session.add_all(input_list)
db.session.commit()
def get_data(address: Address, lang: str):
return {
'address': address.address(),
'calling_code': address.calling_code(),
'city': address.city(),
'continent': address.continent(),
'coordinates': address.coordinates(),
'country': address.country(),
'country_code': get_country_code(lang),
'latitude': address.latitude(),
'longitude': address.longitude(),
'postal_code': address.postal_code(),
'state': address.state(),
'street_name': address.street_name(),
'street_number': address.street_number(),
'street_suffix': address.street_suffix(),
'zip_code': address.zip_code()
}
def ii_push_record(self, in_record: object) -> bool:
"""
Responsible for pushing records out.
Called when an input record is being sent to the plugin.
:param in_record: The data for the incoming record.
:return: False if there's a downstream error, or if there's an error with the field name, otherwise True.
"""
if not self.parent.is_initialized:
return False
#create the new fields
record_value = None
for field in enumerate(self.record_info_out):
if field[1].name == 'address_full_address':
mimesis_object = Address(self.parent.Locale)
record_value = mimesis_object.address()
if field[1].name == 'address_coordinates':
mimesis_object = Address(self.parent.Locale)
record_value = str(mimesis_object.coordinates())
if field[1].name == 'address_country':
mimesis_object = Address(self.parent.Locale)
record_value = mimesis_object.country()
if field[1].name == 'address_postal_code':
mimesis_object = Address(self.parent.Locale)
record_value = mimesis_object.postal_code()
if field[1].name == 'code_imei':
mimesis_object = Code(self.parent.Locale)
record_value = mimesis_object.imei()
if field[1].name == 'code_isbn':
mimesis_object = Code(self.parent.Locale)
record_value = mimesis_object.isbn()
if field[1].name == 'code_pin':
mimesis_object = Code(self.parent.Locale)
record_value = mimesis_object.pin()
if field[1].name == 'food_dish':
mimesis_object = Food(self.parent.Locale)
record_value = mimesis_object.dish()
if field[1].name == 'food_fruit':
mimesis_object = Food(self.parent.Locale)
record_value = mimesis_object.fruit()
if field[1].name == 'food_vegetables':
mimesis_object = Food(self.parent.Locale)
record_value = mimesis_object.vegetable()
'''if field[1].name == 'game_gaming_platform':
mimesis_object = Games(self.parent.Locale)
record_value = mimesis_object.gaming_platform()
if field[1].name == 'game_titles':
mimesis_object = Games(self.parent.Locale)
record_value = mimesis_object.game()'''
if field[1].name == 'person_blood_type':
mimesis_object = Person(self.parent.Locale)
record_value = mimesis_object.blood_type()
if field[1].name == 'person_email':
mimesis_object = Person(self.parent.Locale)
record_value = mimesis_object.email()
if field[1].name == 'person_full_name':
mimesis_object = Person(self.parent.Locale)
record_value = mimesis_object.full_name()
if field[1].name == 'person_nationality':
mimesis_object = Person(self.parent.Locale)
record_value = mimesis_object.nationality()
if field[1].name == 'person_occupation':
mimesis_object = Person(self.parent.Locale)
record_value = mimesis_object.occupation()
if field[1].name == 'person_telephone':
mimesis_object = Person(self.parent.Locale)
record_value = mimesis_object.telephone()
if field[1].name == 'science_atomic_number':
mimesis_object = Science(self.parent.Locale)
record_value = str(mimesis_object.atomic_number())
if field[1].name == 'science_chemical_element':
mimesis_object = Science(self.parent.Locale)
record_value = mimesis_object.chemical_element()
if field[1].name == 'transport_airplane':
mimesis_object = Transport(self.parent.Locale)
record_value = mimesis_object.airplane()
if field[1].name == 'transport_car':
mimesis_object = Transport(self.parent.Locale)
record_value = mimesis_object.car()
if field[1].name == 'transport_truck':
mimesis_object = Transport(self.parent.Locale)
record_value = mimesis_object.truck()
if field[1].name == 'transport_vehicle_reg_code':
mimesis_object = Transport(self.parent.Locale)
record_value = mimesis_object.vehicle_registration_code()
#pdb.set_trace()
self.record_info_out[field[0]].set_from_string(self.record_creator, record_value)
out_record = self.record_creator.finalize_record()
#self.parent.output_anchor.push_record(out_record, False)
self.record_creator.reset()
# Copy the data from the incoming record into the outgoing record.
self.record_creator.reset()
self.record_copier.done_adding()
self.record_copier.copy(self.record_creator, in_record)
# Push the record downstream and quit if there's a downstream error.
if not self.parent.output_anchor.push_record(out_record):
return False
return True
def pi_push_all_records(self, n_record_limit: int) -> bool:
"""
Called when a tool has no incoming data connection.
:param n_record_limit: Set it to <0 for no limit, 0 for no records, and >0 to specify the number of records.
:return: True for success, False for failure.
"""
if not self.is_initialized:
return False
# Save a reference to the RecordInfo passed into this function in the global namespace, so we can access it later.
record_info_out = Sdk.RecordInfo(self.alteryx_engine)
# Adds the new field to the record.
for field in self.column_name:
self.output_field = record_info_out.add_field(field, self.output_type, size=self.field_size)
# Lets the downstream tools know what the outgoing record metadata will look like, based on record_info_out.
self.output_anchor.init(record_info_out)
# Creating a new, empty record creator based on record_info_out's record layout.
record_creator = record_info_out.construct_record_creator()
#import pdb; pdb.set_trace()
#sophs code:
for record in range(self.record_limit):
for field in enumerate(record_info_out):
if field[1].name == 'address_full_address':
mimesis_object = Address(self.Locale)
record_value = mimesis_object.address()
if field[1].name == 'address_coordinates':
mimesis_object = Address(self.Locale)
record_value = str(mimesis_object.coordinates())
if field[1].name == 'address_country':
mimesis_object = Address(self.Locale)
record_value = mimesis_object.country()
if field[1].name == 'address_postal_code':
mimesis_object = Address(self.Locale)
record_value = mimesis_object.postal_code()
if field[1].name == 'code_imei':
mimesis_object = Code(self.Locale)
record_value = mimesis_object.imei()
if field[1].name == 'code_isbn':
mimesis_object = Code(self.Locale)
record_value = mimesis_object.isbn()
if field[1].name == 'code_pin':
mimesis_object = Code(self.Locale)
record_value = mimesis_object.pin()
if field[1].name == 'food_dish':
mimesis_object = Food(self.Locale)
record_value = mimesis_object.dish()
if field[1].name == 'food_fruit':
mimesis_object = Food(self.Locale)
record_value = mimesis_object.fruit()
if field[1].name == 'food_vegetables':
mimesis_object = Food(self.Locale)
record_value = mimesis_object.vegetable()
'''if field[1].name == 'game_gaming_platform':
mimesis_object = Games(self.Locale)
record_value = mimesis_object.gaming_platform()
if field[1].name == 'game_titles':
mimesis_object = Games(self.Locale)
record_value = mimesis_object.game()'''
if field[1].name == 'person_blood_type':
mimesis_object = Person(self.Locale)
record_value = mimesis_object.blood_type()
if field[1].name == 'person_email':
mimesis_object = Person(self.Locale)
record_value = mimesis_object.email()
if field[1].name == 'person_full_name':
mimesis_object = Person(self.Locale)
record_value = mimesis_object.full_name()
if field[1].name == 'person_nationality':
mimesis_object = Person(self.Locale)
record_value = mimesis_object.nationality()
if field[1].name == 'person_occupation':
mimesis_object = Person(self.Locale)
record_value = mimesis_object.occupation()
if field[1].name == 'person_telephone':
mimesis_object = Person(self.Locale)
record_value = mimesis_object.telephone()
if field[1].name == 'science_atomic_number':
mimesis_object = Science(self.Locale)
record_value = str(mimesis_object.atomic_number())
if field[1].name == 'science_chemical_element':
mimesis_object = Science(self.Locale)
record_value = mimesis_object.chemical_element()
if field[1].name == 'transport_airplane':
mimesis_object = Transport(self.Locale)
record_value = mimesis_object.airplane()
if field[1].name == 'transport_car':
mimesis_object = Transport(self.Locale)
record_value = mimesis_object.car()
if field[1].name == 'transport_truck':
mimesis_object = Transport(self.Locale)
record_value = mimesis_object.truck()
if field[1].name == 'transport_vehicle_reg_code':
mimesis_object = Transport(self.Locale)
record_value = mimesis_object.vehicle_registration_code()
record_info_out[field[0]].set_from_string(record_creator, record_value)
out_record = record_creator.finalize_record()
self.output_anchor.push_record(out_record, False)
record_creator.reset()
# Make sure that the output anchor is closed.
self.output_anchor.close()
return True
print(person.level_of_english())
print(person.nationality())
print(person.work_experience())
print(person.political_views())
print(person.worldview())
# 自定义名字pattern
templates = ['l-d', 'U-d']
for item in templates:
print(person.username(template=item))
print('\n')
print('#' * 5 + '地址' + '#' * 5)
address = Address('zh')
print(address.coordinates())
print(address.city())
print('\n')
print('#' * 5 + '地址' + '#' * 5)
business = Business('zh')
print(business.company())
print(business.company_type())
print('\n')
print('#' * 5 + '支付' + '#' * 5)
payment = Payment('zh')
print(payment.paypal())
print(payment.credit_card_expiration_date())
print('\n')
'nl', 'nl-be', 'no', 'pl', 'pt', 'pt-br', 'ru', 'sv', 'tr', 'uk', 'zh']
def random_time():
hour = random.randint(0, 23)
minute = random.randint(0, 59)
if hour < 10:
if minute < 10:
time = '0' + str(hour) + ':' + '0' + str(minute)
else:
time = '0' + str(hour) + ':' + str(minute)
else:
if minute < 10:
time = str(hour) + ':' + '0' + str(minute)
else:
time = str(hour) + ':' + str(minute)
return time
while True:
con = random.randint(0, len(country) - 1)
location = Address(country[con])
id_person = Person(country[con])
geo = location.coordinates()
key = 0
key_bytes = bytes(str(key), encoding = 'utf-8')
msg = ((((str(id_person.telephone()).replace(' ', '')).replace('+', '')).replace('(', '')).replace(')', '')).replace('-', '') + ' ' + str(geo['latitude']) + ' ' + str(geo['longitude']) + ' ' + random_time()
msg_bytes = bytes(msg, encoding = 'utf-8')
producer.send('test', key = key_bytes, value = msg_bytes)
producer.flush()
geo.clear()
time.sleep(0.25)
