hRPVkHjL

1import sqlite3
2from employee import employee
3
4connection = sqlite3.connect("employee.db")
5
6connection_cursor = connection.cursor()
7
8def create_employee_table():
9
10    connection_cursor.execute(""" CREATE TABLE IF NOT EXISTS employee (
11                                            id integer PRIMARY KEY,
12                                            first_name text,
13                                            last_name text,
14                                            pay_roll integer
15                                            )""")
16
17    connection.commit()
18
19    connection.close()
20
21create_employee_table()
22
23def create_employee():
24    connection_cursor.execute(""" INSERT INTO employee (first_name, last_name, pay_roll)
25                                VALUES (Vardenis, Pavardenis, 200)""")
26
27    connection.commit()
28
29    connection.close()
30
31def get_employee():
32    connection_cursor.execute(""" SELECT * FROM employee """)
33
34    connection.commit()
35
36    connection.close()
37
38
39create_employee_table()
40
41def update_employee():
42
43def delete_employee():