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'