()
| 8 | DB_PATH = os.path.join(DB_PATH, "crawl4ai.db") |
| 9 | |
| 10 | def init_db(): |
| 11 | global DB_PATH |
| 12 | conn = sqlite3.connect(DB_PATH) |
| 13 | cursor = conn.cursor() |
| 14 | cursor.execute(''' |
| 15 | CREATE TABLE IF NOT EXISTS crawled_data ( |
| 16 | url TEXT PRIMARY KEY, |
| 17 | html TEXT, |
| 18 | cleaned_html TEXT, |
| 19 | markdown TEXT, |
| 20 | extracted_content TEXT, |
| 21 | success BOOLEAN, |
| 22 | media TEXT DEFAULT "{}", |
| 23 | links TEXT DEFAULT "{}", |
| 24 | metadata TEXT DEFAULT "{}", |
| 25 | screenshot TEXT DEFAULT "" |
| 26 | ) |
| 27 | ''') |
| 28 | conn.commit() |
| 29 | conn.close() |
| 30 | |
| 31 | def alter_db_add_screenshot(new_column: str = "media"): |
| 32 | check_db_path() |
no test coverage detected
searching dependent graphs…