SQLAlchemyORM与Core结合使用实例解析

from sqlalchemy import create_engine
engine = create_engine('sqlite:///:memory:', echo=True)

from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()

from sqlalchemy import MetaData
metadata = MetaData()

from sqlalchemy import Table, Column, Integer, String

users_table = Table('users', metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String),
    Column('fullname', String),
    Column('password', String))

# metadata.create_all(engine) # 方法一
users_table.create(engine) # 方法二

class User(object):
    def __init__(self, name, fullname, password):
        self.name = name
        self.fullname = fullname
        self.password = password

    def __repr__(self):
        return "" % (self.name, self.fullname, self.password)

from sqlalchemy.orm import mapper
mapper(User, users_table)

# 添加用户
new_user = User('ed', 'Ed Jones', 'edspassword')
session.add(new_user)
session.commit()

# 导入必要的模块
from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String
from sqlalchemy.orm import sessionmaker, mapper

# 数据库连接
engine = create_engine('sqlite:///:memory:', echo=True)

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 初始化元数据
metadata = MetaData()

# 定义表
users_table = Table('users', metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String),
    Column('fullname', String),
    Column('password', String))

# 创建表
users_table.create(engine)

# 定义类
class User(object):
    def __init__(self, name, fullname, password):
        self.name = name
        self.fullname = fullname
        self.password = password

    def __repr__(self):
        return "" % (self.name, self.fullname, self.password)

# 类与表映射
mapper(User, users_table)

# 数据操作
new_user = User('ed', 'Ed Jones', 'edspassword')
session.add(new_user)
session.commit()