generate testing database

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

mysql> exit;
Bye

define O/R Mapper structure

from johnnie import AbstractModel, create_session
from johnnie.types import Column, String, Integer

session = create_session('localhost', 'root', 'root user password', 'johnnie')


class Repositories(AbstractModel):
    class Meta:
        session = session

    id = 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)

create model table

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

create entity

>>> 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)

create record

>>> entity.save()
True

mysql> select * from repositories;
+----+---------------+-----------+--------------------------------------------+
| id | name          | author    | url                                        |
+----+---------------+-----------+--------------------------------------------+
|  1 | JohnnieRunner | teitei-tk | https://github.com/teitei-tk/JohnnieRunner |
+----+---------------+-----------+--------------------------------------------+
1 row in set (0.00 sec)
mysql>

read record

>>> 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"

update record

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

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

delete record

>>> entity.delete()
True

mysql> select * from repositories;
Empty set (0.00 sec)