import sqlite3
from sqlite3 import Error
def create_connection(db_file):
""" create a database connection to the SQLite database
specified by db_file
:param db_file: database file
:return: Connection object or None
"""
conn = None
try:
conn = sqlite3.connect(db_file)
except Error as e:
print(e)
return conn
def create_task(conn, task):
"""
Create a new task
:param conn:
:param task:
:return:
"""
sql = ''' INSERT INTO main_post(title,content,category,created_on,tag,post_status)
VALUES(?,?,?,?,?,?) '''
cur = conn.cursor()
cur.execute(sql, task)
conn.commit()
return cur.lastrowid
database = r"Desktop\django-blog\blog\db.sqlite3"
conn = create_connection(database)
## 可以反复使用
id = create_task(conn, (x[1], x[2], category, x[4], html, 1))
参考SQLite Python: Inserting Data