一个使用sqlite3的脚本，包括attach到本地

发布时间：2020-12-12 23:34:51 所属栏目：百科来源：网络整理

导读：import sqlite3class MySum: def __init__(self): self.count = 0 def step(self,value): self.count += value def finalize(self): return self.countcon = sqlite3.connect(":memory:")con.create_aggregate("mysum",1,MySum)cur = con.cursor()cur.execut

import sqlite3 class MySum: def __init__(self): self.count = 0 def step(self,value): self.count += value def finalize(self): return self.count con = sqlite3.connect(":memory:") con.create_aggregate("mysum",1,MySum) cur = con.cursor() cur.execute("create table test(i)") cur.execute("insert into test(i) values (3)") cur.execute("insert into test(i) values (4)") cur.execute("select mysum(i) from test") print cur.fetchone()[0] cur.execute("attach 'z://a.db' as localdb") cur.execute("create table localdb.test as select * from test") cur.execute("insert into localdb.test values (5)") con.commit() con.close

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!