Gama / LawBrainer /data_script.py
mogg7's picture
Upload 18 files
2dc6624 verified
Raw History Blame Contribute Delete
771 Bytes
# 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.")