期待像风一样的自由
python--sqlite数据库Demo
上一篇 /
下一篇 2011-10-15 00:16:55
/ 个人分类:PythonDemo
#!/usr/bin/pyhton
#-*- coding: utf-8 -*-
__metaclass__=type #new type
import sqlite3
def convert(value):
if value.startswith('~'):
return value.strip('~')
if not value:
value='0'
#print value
return float(value)
def insertSQL():
conn=sqlite3.connect('mytest.db')
curs=conn.cursor()
##创建表food3,字段为id,desc,fat
curs.execute('''
CREATE TABLE food3(
id TEXT PRIMARY KEY,
desc TEXT,
fat TEXT
)
''')
querystr='INSERT INTO food3 VALUES (?,?,?)'
##读取myDB文本内容,该文本内容以^为分割符的多行记录
for line in open('myDB.txt'):
fields = line.split('^')
vals=[convert(f) for f in fields]
curs.execute(querystr, vals) ##插入记录
conn.commit()
conn.close()
insertSQL()
def querySQL():
conn=sqlite3.connect('mytest.db')
curs=conn.cursor()
query='SELECT * FROM food3'
curs.execute(query)
names=[f[0] for f in curs.description]
for row in curs.fetchall():
for pair in zip(names,row):
print '%s : %s' % pair
print
conn.close()
querySQL()
收藏
举报
TAG: