Ticket #86: test_concrete.py

from elixir import *
from datetime import datetime

class Event(Entity):
    using_options(inheritance='concrete', tablename='__event')
    _start = Field(DateTime, required=True, colname='start')
    _finish = Field(DateTime, required=True, colname='finish')

    def set_start(self, value):
        self._start = value
    start = property(lambda e: e._start, set_start)

    def set_finish(self, value):
        self._finish = value
    finish = property(lambda e: e._finish, set_finish)

class Shift(Event):
    using_options(inheritance='concrete', shortnames=True)

metadata.bind = 'sqlite://'
metadata.bind.echo = True

setup_all(True)

shift = Shift(start=datetime.now(), finish=datetime.now())

session.commit()
session.expunge_all()

shifts = Shift.query.all()
for shift in shifts:
    print "Shift(start=%s, finish=%s)" % (shift.start, shift.finish)