python之torndb连接数据库

1.安装方式
sudo easy_install Torndb

2.连接数据库

db=torndb.Connection(host+":"+str(port),db,user=user,password=pwd)

cre_sql="create table blog(id int,content text)"
db.execute(cre_sql)
string='wawuee'
exe='insert into blog(id,content)values(%d,"%s")'%(1,string)
db.execute(exe)

a=db.get('select * from blog where id=1')
print a

b=db.query('select * from blog')
print b