def create_order_address(mycursor):
user = RandomUser()
sql = '''
INSERT INTO `ecommerce_address` (`first_name`, `last_name`, `phone_number`, `street`, `city`, `postcode`, `created_at`, `updated_at`, `country_code`, `province_code`, `province_name`)
VALUES
(%s, %s, %s, %s, %s, %s, now(), now(), 'PT', NULL, NULL);
'''
args = (user.get_first_name(), user.get_last_name(), user.get_phone(),
user.get_street(), user.get_city(), user.get_postcode())
mycursor.execute(sql, args)
return mycursor.lastrowid
def _add_user_to_optimized_phonebook(self, user: RandomUser):
self._optimized_phonebook.add_person(
Person(first_name=user.get_first_name(),
last_name=user.get_last_name(),
city=user.get_city(),
phone=user.get_phone()))
def _add_user_to_simple_phonebook(self, user: RandomUser):
self._simple_phonebook.add_person(
dict(first_name=user.get_first_name(),
last_name=user.get_last_name(),
phone=user.get_phone(),
city=user.get_city()))
first = []
last = []
username = []
phone = []
gender = []
email = []
N = 50
for i in range(N):
user = RandomUser()
first.append(user.get_first_name())
last.append(user.get_last_name())
username.append(user.get_username())
phone.append(user.get_phone())
gender.append(user.get_gender())
email.append(user.get_email())
df = pd.DataFrame(columns=[
'First_Name', 'Last_Name', 'Gender', 'Username', 'Phone', 'Email'
])
df['First_Name'] = first
df['Last_Name'] = last
df['Gender'] = gender
df['Username'] = username
df['Phone'] = phone
df['Email'] = email
df
