Python Session.query Examples

Example #1

 def update(self):
     self.request.set('disable_border', True)
     self.dados = []
     session = Session()
     items = session.query(db.UF).all()
     for i in items:
         self.dados.append({
             'id': i.id,
             'sigla': i.sigla,
             'nome': i.nome,
         })

Example #2

 def update(self):
     self.request.set('disable_border', True)
     self.dados = []
     session = Session()
     items = session.query(db.Pessoa).all()
     for i in items:
         self.dados.append({
             'id': i.id,
             'nome': i.nome,
             'email': i.email,
         })

Example #3

File: views.py Project: jeferlelis/xiru.alchemyform

 def update(self):
     self.request.set('disable_border', True)
     self.dados = []
     session = Session()
     items = session.query(db.Pessoa).all()
     for i in items:
         self.dados.append({
            'id': i.id,
            'nome': i.nome,
            'email': i.email,
            })

Example #4

File: views.py Project: jeferlelis/xiru.alchemyform

 def update(self):
     self.request.set('disable_border', True)
     self.dados = []
     session = Session()
     items = session.query(db.UF).all()
     for i in items:
         self.dados.append({
            'id': i.id,
            'sigla': i.sigla,
            'nome': i.nome,
            })

Example #5

 def getContent(self):
     session = Session()
     return session.query(self.klass).get(self.rec_id())

Example #6

File: base.py Project: jeferlelis/xiru.alchemyform

 def getContent(self):
     session = Session()
     return session.query(self.klass).get(self.rec_id())

Example #7

File: vocabulary.py Project: jeferlelis/xiru.alchemyform

 def __call__(self, context):
     session = Session()
     query = session.query(db.UF).order_by(db.UF.nome).all()
     return SimpleVocabulary([SimpleTerm(a.id, a.id, a.nome) for a in query])