示例#1
0
    def __init__(self, db_session):
        BaseFlow.__init__(self, db_session, CashFlowItem)

        self.table = Table(self.__table_name__,
                           self.db_session.metadata,
                           Column('id', Integer, primary_key=True),
                           Column('type', Integer, nullable=False),
                           Column('user_id', Integer), #ForeignKey('user.id')),
                           Column('value', Float, nullable=False), #TODO: Change to real Type
                           Column('day', Integer, nullable=False),
                           Column('month', Integer, nullable=False),
                           Column('year', Integer, nullable=False),
                           Column('hour', String(8), nullable=False),
                           Column('notes', Text)
                          )

        self.mapper = mapper(CashFlowItem, self.table)
示例#2
0
    def __init__(self, db_session):
        BaseFlow.__init__(self, db_session, HistoryItem)

        self.table = Table(self.__table_name__,
                           self.db_session.metadata,
                           Column('id', Integer, primary_key=True),
                           Column('day', Integer, nullable=False),
                           Column('month', Integer, nullable=False),
                           Column('year', Integer, nullable=False),
                           Column('machine_id', Integer), #ForeignKey('machine.id')),
                           Column('time', String(8), nullable=False),
                           Column('mac', String(20), nullable=False),
                           Column('ip', String(16), nullable=False),
                           Column('start_time', String(8), nullable=False),
                           Column('end_time', String(8), nullable=False),
                           Column('user_id', Integer), #ForeignKey('user.id')),
                          )

        self.mapper = mapper(HistoryItem, self.table)
示例#3
0
    def __init__(self, db_session):
        BaseFlow.__init__(self, db_session, OpenDebtOtherItem)

        self.table = Table(self.__table_name__,
                           self.db_session.metadata,
                           Column('id', Integer, primary_key=True),
                           Column('day', Integer, nullable=False),
                           Column('month', Integer, nullable=False),
                           Column('year', Integer, nullable=False),
                           Column('time', String(8), nullable=False),
                           Column('start_time', String(8), nullable=False),
                           Column('end_time', String(8), nullable=False),
                           Column('user_id', Integer), #ForeignKey('user.id')),
                           Column('value', Float, nullable=False), #TODO: Change to real Type
                           Column('notes', Text),
                           Column('id_description', Integer, ForeignKey('description_opendebts_other.id'))
                          )

        self.mapper = mapper(OpenDebtOtherItem, self.table,
                        properties={'description_opendebts_other':relation(DescriptionOpenDebtsOther)})