我们绝对被SqlAlchemy所宠坏.
下面的内容直接从
tutorial,
真的很容易设置和工作.
设置您的环境(我正在使用SQLite内存数据库进行测试):
>>> from sqlalchemy import create_engine
>>> engine = create_engine('sqlite:///:memory:', echo=True)
>>> from sqlalchemy import Table, Column, Integer, String, MetaData
>>> metadata = MetaData()
定义你的表:
>>> players_table = Table('players', metadata,
... Column('id', Integer, primary_key=True),
... Column('name', String),
... Column('score', Integer)
... )
>>> metadata.create_all(engine) # create the table
如果您打开日志记录,您将看到SqlAlchemy为您创建的SQL.
定义你的班级:
>>> class Player(object):
... def __init__(self, name, score):
... self.name = name
... self.score = score
...
... def __repr__(self):
... return "" % (self.name, self.score)
将课程映射到你的桌子上:
>>> from sqlalchemy.orm import mapper
>>> mapper(Player, players_table)
创建一个球员:
>>> a_player = Player('monty', 0)
>>> a_player.name
'monty'
>>> a_player.score
0
就这样,你现在有一个你的播放器表.另外,SqlAlchemy的googlegroup很棒.迈克拜耳很快回答问题.