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