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)