JohnnieRunner 0.0.1

生成测试数据库

$ mysql -u root -p
mysql> create database johnnie;
Query OK, 1 row affected (0.01 sec)

mysql> exit;
Bye

定义o/r映射器结构

fromjohnnieimportAbstractModel,create_sessionfromjohnnie.typesimportColumn,String,Integersession=create_session('localhost','root','root user password','johnnie')classRepositories(AbstractModel):classMeta:session=sessionid=Column('id',Integer(unsigned=True),primary_key=True)name=Column('name',String(255),nullable=False)author=Column('author',String(255),nullable=False)url=Column('url',String(255),nullable=False)

创建模型表

$ python
>>> from hoge import Repositories
>>> Repositories.metadata.create_all(Repositories.get_session_engine())
>>> exit()

创建实体

>>> from hoge import Repositories
>>> entity= Repositories(name="JohnnieRunner", author="teitei-tk", url="https://github.com/teitei-tk/JohnnieRunner")

or

>>> entity_data={"name": "JohnnieRunner", "author": "teitei-tk", "url": "https://github.com/teitei-tk/JohnnieRunner"}
>>> entity= Repositories.new(entity_data)

创建记录

>>> entity.save()
True

mysql>select*fromrepositories;+----+---------------+-----------+--------------------------------------------+
|id|name|author|url|+----+---------------+-----------+--------------------------------------------+
|1|JohnnieRunner|teitei-tk|https://github.com/teitei-tk/JohnnieRunner|+----+---------------+-----------+--------------------------------------------+
1rowinset(0.00sec)mysql>

读取记录

>>> entity= Repositories.get(1)

or

>>> entity= Repositories.find(1)

>>> entity.name
u"JohnnieRunner"
>>> entity.author
u"teitei-tk"
>>> entity.url
u"https://github.com/teitei-tk/JohnnieRunner"

更新记录

>>> entity.name = u"update_test"
>>> entity.save()
True

mysql>select*fromrepositories;+----+-------------+-----------+--------------------------------------------+
|id|name|author|url|+----+-------------+-----------+--------------------------------------------+
|1|update_test|teitei-tk|https://github.com/teitei-tk/JohnnieRunner|+----+-------------+-----------+--------------------------------------------+
mysql>

删除记录

>>> entity.delete()
True

mysql>select*fromrepositories;Emptyset(0.00sec)