python 操作数据库

SQLite数据库更新示例

原创于 2017-02-03 16:30:05 发布 · 363 阅读

0 ·

CC 4.0 BY-SA版权

python 专栏收录该内容

3 篇文章

订阅专栏

def sql(cadillac): #连接sqlite
        connection=sqlite3.connect("E:\esl-working-1.3.7_rc2-sp8\db.sqlite")
        cursor=connection.cursor()
        cursor.execute(cadillac)
        cursor.close()
        connection.commit()
if __name__ == '__main__':
    n = 0
    print ctime() + "正在进行更新，轮次：" + str(n)

    # while True:
    #     time.sleep(10)
    #     n = n +1
    # #     # conmysql("update")
    #     conmysql("update  hs_goods set price1  = ('"+str(n)+"')")
    #     # conmysql("update  hs_goods set price1  = 'str(n)'")
    while True:
        n = n +1
        time.sleep(5)
        sql("update  sales_list set Price  = ('"+str(n)+"')")