python sqlite3更新数据_Python 代码库之sqlite数据库update更新数据(含源码)

Python 代码库之sqlite数据库update更新数据(含源码)

数据更新函数

def update_task(conn, task):

"""

update priority, begin_date, and end date of a task

:param conn:

:param task:

:return: project id

"""

sql = ''' UPDATE tasks

SET priority = ? ,

begin_date = ? ,

end_date = ?

WHERE id = ?'''

cur = conn.cursor()

cur.execute(sql, task)

创建链接函数

def create_connection(db_file):

""" create a database connection to the SQLite database

specified by the db_file

:param db_file: database file

:return: Connection object or None

"""

try:

conn = sqlite3.connect(db_file)

return conn

except Error as e:

print(e)

return None

测试代码

def main():

database = "pythonsqlite.db"

# create a database connection

conn = create_connection(database)

with conn:

update_task(conn, (2, '2015-01-04', '2015-01-06',2))

if __name__ == '__main__':

main()

更多精彩代码请关注我的专栏