def create_user(self):
for i in range(self.number1):
user = User()
user.fullname = fake.name()
user.surname = fake.name()
user.address = fake.address()
user.age = fake.random_int(min=18, max=100)
user.company = fake.company()
user.status = fake.country()
user.creatingdate = fake.date()
user.save()
def create_user(self):
for i in range(self.number1):
user = User()
user.fullname = str(np.NaN)
user.surname = fake.first_name()
user.address = str(np.NaN)
user.age = str(np.NaN)
user.company = str(np.NaN)
user.status = str(np.NaN)
user.creatingdate = str(np.NaN)
user.save()
def Generate_User(n):
for i in range(number1):
# Step.1 Insert User Data with User's Account Number
user = User()
user.fullname = fake.name()
user.surname = fake.name()
user.address = fake.address()
user.age = fake.random_int(min=18, max=100)
user.company = fake.company()
user.status = fake.country()
user.creatingdate = fake.date()
user.save()
def create_user(self):
for i in range(self.number1):
user = User()
user.fullname = fake.name() if (n1 == 1 or n2 == 1) else None
user.surname = fake.name() if (n1 == 2 or n2 == 2) else None
user.address = fake.address() if (n1 == 3 or n2 == 3) else None
user.age = fake.random_int(
min=18, max=100) if (n1 == 4 or n2 == 4) else None
user.company = fake.company() if (n1 == 5 or n2 == 5) else None
if n1 == 6 or n2 == 6:
status = fake.random_int(min=0, max=1)
if status == 1:
user.status = 'Active'
else:
user.status = 'Deactive'
else:
user.status = None
user.creatingdate = fake.date() if (n1 == 7 or n2 == 7) else None
user.save()
print(
f'\nYou have generated {self.number1} rows for User tables successfully'
)
def InsertAddress(self):
for i in range(self.number):
user = User()
user.address = fake.address()
user.save()
from faker import Faker
import random
fake = Faker()
number1 = eval(input("How many Fake data you want for User?"))
# number2 = 100 eval(input("How many Fake data you want for Account?"))
# fk = [i for i in range(number1)]
for i in range(number1):
# Step.1 Insert User Data with User's Account Number
user = User()
user.fullname = fake.name()
user.surname = fake.name()
user.address = fake.address()
user.age = fake.random_int(min=18, max=100)
user.company = fake.company()
user.status = fake.country()
user.creatingdate = fake.date()
user.save()
# Step.2 Insert Fake data to Account Sheet
account = Account()
account.amount = int(fake.random_int())
account.creatingdate = fake.date()
account.account = fake.credit_card_number(card_type=None)
account.save()
'''
count = 0
while count < 100:
U.Creating_Date = fake.date()
U.save()
for i in range(number2):
# Step 2 Insert data into Account Sheet
A.Amount = int(fake.random_int())
A.Creating_Date = fake.date()
A.number_id = random.choice(fk)
A.save()
'''
for i in range(100):
# Step.1 Insert Fake data to Account Sheet
A.Amount = int(fake.random_int())
A.Creating_Date = fake.date()
# Random pick PK in User Sheet
A.number_id = random.randint(1, A.id)
# Step.2 Insert Fake data to User Sheet
U.FullName = fake.name()
U.Surname = fake.name()
U.address = fake.address()
U.Age = fake.random_int(min=18, max=100)
U.Company = fake.company()
U.Status = fake.random_int()
U.Creating_Date = fake.date()
A.save()
U.save()
def InsertAddress(self):
user = User()
user.address = fake.address()
user.save()
