File size: 771 Bytes
2dc6624
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
# db_setup.py
import sqlite3

def create_tables(db_name="companies.db"):
    conn = sqlite3.connect(db_name)
    cursor = conn.cursor()
    cursor.execute("""

        CREATE TABLE IF NOT EXISTS companies (

            id INTEGER PRIMARY KEY AUTOINCREMENT,

            name TEXT NOT NULL,

            primary_link TEXT NOT NULL

        )

    """)
    cursor.execute("""

        CREATE TABLE IF NOT EXISTS secondary_links (

            id INTEGER PRIMARY KEY AUTOINCREMENT,

            company_id INTEGER,

            secondary_link TEXT,

            FOREIGN KEY (company_id) REFERENCES companies (id)

        )

    """)
    conn.commit()
    conn.close()

if __name__ == "__main__":
    create_tables()
    print("Database and tables created.")