leandrolazaro

Work fine

Aug 22nd, 2023
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.06 KB | None | 0 0
  1. from sqlalchemy import create_engine
  2. from sqlalchemy.orm import sessionmaker
  3. from config import Config
  4. from sqlalchemy.orm import declarative_base
  5. from sqlalchemy import Column,String, Integer, DATETIME
  6.  
  7. engine = create_engine(Config.SQLALCHEMY_DATABASE_URI, echo=True)
  8.  
  9. Session = sessionmaker(bind=engine)
  10. session = Session()
  11.  
  12. Base = declarative_base()
  13.  
  14. class PPESSOA(Base):
  15.  
  16.     __tablename__ = 'PPESSOA'
  17.  
  18.     CODIGO = Column(Integer, primary_key=True)
  19.  
  20.     CPF = Column(String)
  21.     EMAILPESSOAL = Column(String)
  22.     EMAIL = Column(String)
  23.     NOME = Column(String)
  24.     NOMESOCIAL = Column(String)
  25.     SEXO = Column(String)
  26.     NACIONALIDADE = Column(String)
  27.     ESTADONATAL = Column(String)
  28.     DTNASCIMENTO = Column(DATETIME)
  29.     CARTIDENTIDADE = Column(String)
  30.     ORGEMISSORIDENT = Column(String)
  31.     UFCARTIDENT = Column(String)
  32.     CODMUNICIPIO = Column(String)
  33.     ESTADO = Column(String)
  34.  
  35. ppessoa:PPESSOA = session.query(PPESSOA).filter(PPESSOA.CODIGO==30861).one()
  36. ppessoa.EMAIL = '[email protected]'
  37.  
  38. session.commit()
  39. session.close()
Add Comment
Please, Sign In to add comment