L7z6SuR5

1import sqlite3
2 
3def CreateDB():
4    databaseConnect = sqlite3.connect('databaseForCourseWork.db')  # creation DB
5    cursor = databaseConnect.cursor()  # Creation object-cursor
6    sqlDB = """
7        CREATE TABLE IF NOT EXISTS Employee (
8            id_emloyee INTEGER PRIMARY KEY AUTOINCREMENT,
9            Email VARCHAR(255),
10            Password VARCHAR(255),
11            FirstName VARCHAR(255),
12            LastName VARCHAR(255),
13            Age INT(150),
14            Education VARCHAR(255),
15            Country VARCHAR(255),
16            City VARCHAR(255),
17            CurrentPosition VARCHAR(255),
18            Relocate BOOL,
19            Interests TEXT,
20            Skills TEXT
21        );
22        CREATE TABLE  IF NOT EXISTS Employer (
23            id_employer INTEGER PRIMARY KEY AUTOINCREMENT,
24            Email VARCHAR(255),
25            Password VARCHAR(255),
26            FirstName VARCHAR(255),
27            LastName VARCHAR(255),
28            Age INT(150),
29            Education VARCHAR(255),
30            Country VARCHAR(255),
31            City VARCHAR(255),
32            CurrentPosition VARCHAR(255),
33            Company VARCHAR(255),
34            id_vacancy INT(255)
35        );
36        CREATE TABLE  IF NOT EXISTS Vacancy (
37            id_vacancy INTEGER PRIMARY KEY AUTOINCREMENT,
38            Country VARCHAR(255),
39            City VARCHAR(255),
40            Salary INT(100000),
41            Info TEXT,
42            CodeEmployer INT(100000)
43        );
44        CREATE TABLE IF NOT EXISTS Result(
45            id_result INTEGER PRIMARY KEY AUTOINCREMENT,
46            code_vacancy INT(100000),
47            CodeEmployer INT(100000),
48            CodeEmployee INT(100000)
49        );
50    """
51    sqlInsertData = """
52        INSERT INTO Employee VALUES ('ksenyaholovko@gmail.com', '1234', 'Ksenya', 'Holovko',
53        '20', 'LPNU,CS', 'Ukraine', 'Lviv', 'Student LPNU', 'True', 'Art, Queen, Mage', 'Art, Logic')
54		INSERT INTO Employee VALUES ('ak@gmail.com', '1111', 'Annie', 'Key',
55        '25', 'LPNU,CS', 'Ukraine', 'Lviv', 'Inoxoft', 'True', 'Travel, Code, Coffe, Cakes', 'All connected with P')
56    """
57 
58    try:
59        cursor.executescript(sqlDB)
60        cursor.executescript(sqlInsertData)
61    except sqlite3.DatabaseError as err:
62        print("Error:", err)
63    else:
64        print("Success")
65 
66    databaseConnect.commit()
67    cursor.close()
68    databaseConnect.close()
69 
70 
71 
72 
73CreateDB()