Download LawBrainer/data_script.py from TracyAI/Gama: direct link, hf CLI and curl.
- Browser
- Download file 771 Bytes
-
https://huggingface.co/spaces/TracyAI/Gama/resolve/main/LawBrainer/data_script.py
- Command line
-
hf download hf://spaces/TracyAI/Gama/LawBrainer/data_script.py
-
curl -L -o data_script.py https://huggingface.co/spaces/TracyAI/Gama/resolve/main/LawBrainer/data_script.py
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.") | |