Python中Sqlite的使用
1.python中如何sqlite
下面的示例是通过拼接sql语句，来使用sqlite数据的。
from sqlalchemy import *db = create_engine('sqlite:///tutorial.db')db.echo = False # Try changing this to True and see what happens#metadata = BoundMetaData(db)metadata = MetaData(db)users = Table('users', metadata, Column('user_id', Integer, primary_key=True), Column('name', String(40)), Column('age', Integer), Column('password', String),)users.create()i = users.insert()i.execute(name='Mary', age=30, password='secret')i.execute({'name': 'John', 'age': 42}, {'name': 'Susan', 'age': 57}, {'name': 'Carl', 'age': 33})#如果表已经存在，可以通过下面获取表对象#users = Table('users',metadata,autoload=True)s = users.select()rs = s.execute()row = rs.fetchone()print 'Id:', row[0]print 'Name:', row['name']print 'Age:', row.ageprint 'Password:', row[users.c.password]for row in rs: print row.name, 'is', row.age, 'years old'