SQLAlchemy 的简单用法

来源：互联网发布：网络剧点击量排行榜编辑：程序博客网时间：2024/05/29 10:08

简单的用法

# -*- coding: utf-8 -*-from sqlalchemy import create_engine, MetaDataengine = create_engine('sqlite:///test.sqlite')metadata = MetaData(bind=engine, reflect=True)conn = engine.connect()# 创建表conn.execute('CREATE TABLE IF NOT EXISTS user(name VARCHAR, password VARCHAR)')# 创建数据conn.execute('INSERT INTO user(name, password) VALUES(?, ?)', (('tom', '123'), ('john', '321')))# 查询for row in conn.execute('SELECT * FROM user'): print row.name, row['name'], row[0]

更简单的用法

# -*- coding: utf-8 -*-from sqlalchemy import create_engine, MetaDataengine = create_engine('sqlite:///test.sqlite')# metadata = MetaData(bind=engine, reflect=True)# 创建表engine.execute('CREATE TABLE IF NOT EXISTS user(name VARCHAR, password VARCHAR)')# 创建数据engine.execute('INSERT INTO user(name, password) VALUES(?, ?)', [('tom', '123'), ('john', '321')])# 查询for row in engine.execute('SELECT * FROM user'): print row.name, row['name'], row[0]