python-basics/sql-index/main.py at main · Brave-Python/python-basics

35 lines (28 loc) · 836 Bytes

# imports

import sqlite3

from faker import Faker

# connect to the db

db_conn = sqlite3.connect('people_db.db')

db_cursor = db_conn.cursor()

# create table

db_cursor.execute('''CREATE TABLE people (

id INTEGER PRIMARY KEY,

name TEXT,

email TEXT,

job TEXT)''')

# create and insert records

fake = Faker()

Faker.seed(42)

num_records = 100000

for _ in range(num_records):

first = fake.first_name()

last = fake.last_name()

name = f"{first} {last}"

domain = fake.domain_name()

email = f"{first}.{last}@{domain}"

job = fake.job()

db_cursor.execute('INSERT INTO people (name, email, job) VALUES (?,?,?)', (name,email,job))

# commit the transaction and close the cursor and db connection

db_conn.commit()

db_cursor.close()

db_conn.close()

Provide feedback