You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
310 B
18 lines
310 B
import sqlite3
|
|
|
|
conn = sqlite3.connect("spider.db")
|
|
cursor = conn.cursor()
|
|
|
|
cursor.execute("""
|
|
CREATE TABLE IF NOT EXISTS tasks (
|
|
task_id TEXT PRIMARY KEY,
|
|
url TEXT,
|
|
status TEXT,
|
|
result TEXT,
|
|
error TEXT,
|
|
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
)
|
|
""")
|
|
|
|
conn.commit()
|
|
conn.close()
|