-
Notifications
You must be signed in to change notification settings - Fork 0
/
SalesPerson.py
executable file
·38 lines (30 loc) · 1.41 KB
/
SalesPerson.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
import psycopg2
from faker import Faker
def create_salesperson(db):
cursor = db.cursor()
fake = Faker()
cursor.execute("""
CREATE TABLE IF NOT EXISTS SalesPerson (
SalesPersonID SERIAL PRIMARY KEY,
SP_Name VARCHAR(50),
Gender VARCHAR(10) NOT NULL,
DateOfBirth DATE NOT NULL,
MobileNo VARCHAR(15) NOT NULL,
email VARCHAR(100) NOT NULL,
Address1 VARCHAR(100) NOT NULL,
Address2 VARCHAR(100) NOT NULL,
City VARCHAR(50) NOT NULL,
State VARCHAR(50) NOT NULL,
PinCode VARCHAR(20) NOT NULL
)
""")
salesperson_data = []
for i in range(1, 21):
salesperson_data.append((i, fake.name(), fake.random_element(["Male", "Female"]), fake.date_of_birth(minimum_age=25, maximum_age=65),
fake.phone_number()[:11], fake.email(), fake.street_address(), fake.secondary_address(), fake.city(),
fake.state(), fake.zipcode()))
insert_salesperson_query = "INSERT INTO SalesPerson (SalesPersonID, SP_Name, Gender, DateOfBirth, MobileNo, email, Address1, Address2, City, State, PinCode) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
cursor.executemany(insert_salesperson_query, salesperson_data)
db.commit()
cursor.close()
print("SalesPerson table created and populated successfully.")