Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sqlalchemy import create_engine
- from sqlalchemy.orm import sessionmaker
- from config import Config
- from sqlalchemy.orm import declarative_base
- from sqlalchemy import Column,String, Integer, DATETIME
- engine = create_engine(Config.SQLALCHEMY_DATABASE_URI, echo=True)
- Session = sessionmaker(bind=engine)
- session = Session()
- Base = declarative_base()
- class PPESSOA(Base):
- __tablename__ = 'PPESSOA'
- CODIGO = Column(Integer, primary_key=True)
- CPF = Column(String)
- EMAILPESSOAL = Column(String)
- EMAIL = Column(String)
- NOME = Column(String)
- NOMESOCIAL = Column(String)
- SEXO = Column(String)
- NACIONALIDADE = Column(String)
- ESTADONATAL = Column(String)
- DTNASCIMENTO = Column(DATETIME)
- CARTIDENTIDADE = Column(String)
- ORGEMISSORIDENT = Column(String)
- UFCARTIDENT = Column(String)
- CODMUNICIPIO = Column(String)
- ESTADO = Column(String)
- ppessoa:PPESSOA = session.query(PPESSOA).filter(PPESSOA.CODIGO==30861).one()
- session.commit()
- session.close()
Add Comment
Please, Sign In to add comment