import sqlite3
def create_table():
conn = sqlite3.connect('employment.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS employees (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
position TEXT,
resume TEXT)''')
conn.commit()
conn.close()
def add_employee(name, position, resume):
conn = sqlite3.connect('employment.db')
c = conn.cursor()
c.execute("INSERT INTO employees (name, position, resume) VALUES (?, ?, ?)",
(name, position, resume))
conn.commit()
conn.close()
def view_resumes():
conn = sqlite3.connect('employment.db')
c = conn.cursor()
c.execute("SELECT * FROM employees")
rows = c.fetchall()
for row in rows:
print(f"ID: {row[0]}, Name: {row[1]}, Position: {row[2]}, Resume: {row[3]}")
conn.close()
if __name__ == "__main__":
create_table()
while True:
print("\n1. Add Employee\n2. View Resumes\n3. Exit")
choice = input("Enter your choice: ")
if choice == "1":
name = input("Enter employee name: ")
position = input("Enter employee position: ")
resume = input("Enter resume details: ")
add_employee(name, position, resume)
elif choice == "2":
view_resumes()
elif choice == "3":
break
else:
print("Invalid choice!")
]]