def __init__(self, db_session):
BaseManager.__init__(self, db_session, Perfil)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('perfil_description', String(40))
)
self.mapper = mapper(Perfil, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Pais)
pais = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', String(100))
)
self.mapper = mapper(Pais, pais)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, DescriptionOpenDebtsOther)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', Text, nullable=True),
Column('quantity', Integer, nullable=True)
)
self.mapper = mapper(DescriptionOpenDebtsOther, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, DescriptionBlockBorrow)
descriptionBlockBorrow = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', Text)
)
self.mapper = mapper(DescriptionBlockBorrow, descriptionBlockBorrow)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Schooling)
schooling = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', String(100))
)
#cria um mapeamento entre a tabela type_deficiency e a classe TypeDeficiency.
self.mapper = mapper(Schooling, schooling)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, SituationOccupation)
situationOccupation = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', String(100))
)
#cria um mapeamento entre a tabela situation_occupation e a classe SituationOccupation.
self.mapper = mapper(SituationOccupation, situationOccupation)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, State)
state = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('name', String(100)),
Column('sigla', String(100))
)
self.mapper = mapper(State, state)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Perfil_User)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('user_id', Integer, ForeignKey('user.id')),
Column('perfil_id', Integer, ForeignKey('perfil.id')),
)
self.mapper = mapper(Perfil_User, self.table,
properties={'user': relation(User), 'perfil': relation(Perfil)})
self.db_session = db_session
def __init__(self, db_session):
BaseManager.__init__(self, db_session, ReasonAlienation)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', Text)
)
self.mapper = mapper(ReasonAlienation, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, City)
city = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('id_state', Integer), #ForeignKey('state.id'))
Column('name', String(50)),
Column('codigo_ibge', String(50))
)
self.mapper = mapper(City, city)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Cash)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('date_time_open', DateTime, primary_key=True),
Column('user_id', Integer),
Column('date_time_close', DateTime),
Column('balance', Float)
)
self.mapper = mapper(AlienationMachine, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Occupation)
occupation = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('description', String(50))
)
#cria um mapeamento entre a tabela situation_occupation e a classe SituationOccupation.
self.mapper = mapper(Occupation, occupation,
#properties={'situation_occupation':relation(SituationOccupation)},
allow_column_override=True)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, UserCategory)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('name', String(25), nullable=False, unique=True),
Column('allow_login', Boolean, default=True),
Column('custom_price_hour', Boolean, default=False),
Column('price_hour', Float, default=0),
Column('time_limit_machine', DateTime, default=0)
)
self.mapper = mapper(UserCategory, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Version)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('name', String(25), nullable=False, unique=True),
Column('value', String(40), nullable=False),
Column('codigo_aps', String(40), nullable=False),
Column('codigo_onid', String(40), nullable=False)
)
#cria um mapeamento entre a tabela versions e a classe Version.
self.mapper = mapper(Version, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, RegistroGeral)
registroGeral = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('numero_ident', String(10)),
Column('orgao_expeditor', String(10)),
Column('state', Integer),#ForeignKey('state.id'))
Column('date_expedicao', String(10)),
Column('user', Integer) #ForeignKey('user.id'))
)
#cria um mapeamento entre a tabela situation_occupation e a classe SituationOccupation.
self.mapper = mapper(RegistroGeral, registroGeral)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, BlockBorrow)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('id_description_block_borrow', Integer, ForeignKey('description_block_borrow.id')),
Column('long_description', Text),
Column('date_block', DateTime),
Column('date_unblock', DateTime),
Column('user', Integer)
)
self.mapper = mapper(BlockBorrow, self.table,
properties={'description_block_borrow':relation(DescriptionBlockBorrow)})
def __init__(self, db_session):
BaseManager.__init__(self, db_session, ScheduleOfBorrow)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('id_user', Integer),
Column('responsible_user', String(255)),
Column('borrowed_date', DateTime),
Column('return_date', DateTime),
Column('comment', Text),
Column('name_heritage', String(255))
)
self.mapper = mapper(ScheduleOfBorrow, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, CertidaoNascimento)
certidaoNascimento = Table(self.__table_name__,
self.db_session.metadata,
Column('registro', Integer, primary_key=True),
Column('estado', String(10)),
Column('cidade', String(10)),
Column('cartorio', String(255)),
Column('livro', String(20)),
Column('folha', String(100)),
Column('user', Integer) #ForeignKey('user.id'))
)
#cria um mapeamento entre a tabela situation_occupation e a classe SituationOccupation.
self.mapper = mapper(CertidaoNascimento, certidaoNascimento)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, ReserveOfBorrow)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('id_user', Integer), #ForeignKey('user.id')),
Column('id_heritage', Integer), #ForeignKey('heritage.id')),
Column('id_machines', Integer), #ForeignKey('machine.id')),
Column('responsible_user', Integer),
Column('reserve_date', DateTime),
Column('reserve_date_fim', DateTime),
Column('comment', Text)
)
self.mapper = mapper(ReserveOfBorrow, self.table)#,
def __init__(self, db_session):
BaseManager.__init__(self, db_session, MachineCategory)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('name', String(25), nullable=False, unique=True),
Column('custom_logo', Boolean, default=False),
Column('custom_background', Boolean, default=False),
Column('logo_path', String(100), nullable=True),
Column('background_path', String(100), nullable=True),
Column('custom_price_hour', Boolean, default=False),
Column('price_hour', Float, default=0),
Column('cam_be_borrowed', Boolean)
)
self.mapper = mapper(MachineCategory, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, AlienationMachine)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('user_alienation', Integer),
Column('id_reason', Integer),
Column('date_alienation', DateTime),
Column('date_unalienation', DateTime),
Column('comment', Text, nullable=True),
Column('user_unalienation', Integer, nullable=True),
Column('heritage_id', Integer),
Column('machine_id', Integer)
)
self.mapper = mapper(AlienationMachine, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Machine)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('name', String(25), nullable=False, unique=True),
Column('hash_id', String(100), nullable=False),
Column('description', Text),
Column('ip', String(16)),
Column('mac', String(20)),
Column('hostname', String(12)),
Column('last_user_id', Integer), #ForeignKey('user.id')),
Column('category_id', Integer), #ForeignKey('machine_category.id')),
Column('alienat_id', Integer) #, ForeignKey('alienat_machine.id'))
)
self.mapper = mapper(Machine, self.table)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Address)
self.address = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('address', String(255), nullable=True),
Column('bairro', String(100), nullable=True),
Column('cep', String(10), nullable=True),
Column('city', Integer),
Column('state', Integer), #ForeignKey('state.id')),
Column('pais', Integer), #ForeignKey('pais.id'))
Column('user', Integer) #, ForeignKey('user.id'))
)
self.mapper = mapper(Address, self.address,
# properties={'user':relation(User)
# 'pais':relation(Pais)
# },
allow_column_override=True)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, User)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('nick', String(20), nullable=False, unique=True),
Column('full_name', String(50), nullable=False),
Column('email', String(50)),
Column('responsible', String(50)),
Column('cpf', String(20)),
Column('birth', String(10)), #CHANGE TO DATE FORMAT
Column('marital_status', Integer),
Column('phone', String(50)),
Column('notes', Text),
Column('schooling', Integer),
Column('curriculo', Text),
Column('last_login', DateTime),
Column('last_machine_id', Integer), #ForeignKey('machines.id')),
Column('active', Boolean, default=True),
Column('reg_date', DateTime),
Column('login_count', Integer, default=0),
Column('sex', Integer),
Column('occupation', Integer),
Column('situation_occupation', Integer),
Column('type_deficiency', Integer),
Column('renda_familiar', Integer),
Column('etnia', Integer),
Column('credit', Float, default=0),
Column('password', String(32), nullable=False),
Column('category_id', Integer), #ForeignKey('user_category.id')),
Column('alterado', Boolean, default=False),
Column('logado', Boolean, default=False),
Column('autorizoEnvio', Boolean, default=False)
)
self.db_session = db_session
self.mapper = mapper(User, self.table,
#properties={'user_category':relation(UserCategory)},
allow_column_override=True)
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Heritage)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('name', String(255), nullable=False),
Column('number_ben', String(40), nullable=False),
Column('description', Text),
Column('borrow_id', Integer, ForeignKey('schedule_of_borrow.id')),
Column('value', String(45)),
Column('model', String(45)),
Column('brand', String(20)),
Column('reserve_id', Integer),
Column('alienat_id', Integer),
Column('machine_id', Integer)
)
self.mapper = mapper(Heritage, self.table,
properties={'schedule_of_borrow':relation(ScheduleOfBorrow)
})
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Telecentro)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('first_responsible', String(40), nullable=True),
Column('secund_responsible', String(40), nullable=True),
Column('name', String(255), nullable=True),
Column('fone_number_comer', String(10), nullable=True),
Column('fone_number_cel', String(10), nullable=True),
Column('fone_number_fax', String(10), nullable=True),
Column('fone_number_respon1', String(10), nullable=True),
Column('fone_number_respon2', String(10), nullable=True),
Column('cnpj', String(20), nullable=True),
Column('address', Text, nullable=True),
Column('cep', String(20), nullable=True),
Column('city', String(40), nullable=True),
Column('uf', String(5), nullable=True)
)
self.mapper = mapper(Telecentro, self.table)
