Python Session.query方法代碼示例

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def verify_is_admin(self):
     try:
         user = sqlsession.query(User).filter_by(userid=self.userid,password=self.password).one()
         return sqlsession.query(UserRoleMapping).filter_by(userid=self.userid,roleid=Role.ADMIN.id).count()>0
     except:
         print "No such user"
         return False

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def __init__(self,name,password):
     self.password=password
     self.userid = name
     try:
         self.lastname=sqlsession.query(User).filter_by(userid=self.userid).one().lastname
         self.firstname=sqlsession.query(User).filter_by(userid=self.userid).one().firstname
     except:
         self.lastname=self.userid
         self.firstname=''

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def __init__(self, user, name, parentname, displayname, type):
     daos = sqlsession.query(TileModel.DAO).filter_by(user=user, display=displayname, parent=parentname, name=name).all()
     if len(daos)>0:
         self.dao=daos[0]
         self.dao.type=type
     else:
         self.dao = TileModel.DAO(name=name, user=user, parentname=parentname,  displayname=displayname, type=type)
     monitors=sqlsession.query(MonitorView.DAO).filter_by \
        (display=displayname, parent=name).order_by(MonitorView.DAO.index).all()        
     self.monitors=[]
     for mon in monitors:
         try:
             self.monitors.append(MonitorView(name=mon.name, user=user, parentname=self.get_name(), displayname=displayname))
         except:
             del mon

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def __init__(self, user, name, displayname):
     daos= sqlsession.query(TelemetryWindowModel.DAO).filter_by(user=user,display=displayname,  name=name).all()
     if len(daos)>0:
         self.dao = daos[0]
     else:
         self.dao = TelemetryWindowModel.DAO(user=user,name=name, displayname=displayname)
     index=0

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def get_properties(user, parent, display):
     daos= sqlsession.query(DisplayPropertyItem.DAO).filter_by( user=user, display=display.get_name(), parent=parent.get_name()).all()
     params={}
     for dao in daos:
         tag=dao.name
         if tag != "name":
             params[tag]=dao.value
     return DisplayProperties(name=parent, user=user, parent=parent, display=display, **params)

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def __init__(self, user, name, format):
     daos = sqlsession.query(DisplayModel.DAO).filter_by(user=user, name=name).all()
     if len(daos) > 0:
         self.dao = daos[0]
     else:
         if format == None:
             self.dao = DisplayModel.DAO(name=name, format=Format.DEFAULT_FORMAT.get_name(), user=user)
         else:
             self.dao = DisplayModel.DAO(name=name, format=format, user=user)

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def __init__(self, name, user,  owner, displayname, value, type):
     self.name=name
     self.owner=owner
     daos= sqlsession.query(DisplayPropertyItem.DAO).filter_by(name=name, user=user, display=displayname, parent=owner.get_name()).all()
     if len(daos)>0:
         self.dao =daos[0]
         self.dao.type=type
     else:
         if (name=='col_span' or name=='row_span') and value==None:
             value=1
         elif value==None:
             value=0
         self.dao=DisplayPropertyItem.DAO(name=name, user=user, ownername=owner.get_name(), displayname=displayname, value=value, type=type)

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def copy_to(self, newname):
     olddisplay = self
     oldname = self.dao.name
     if newname == oldname:
         return
     daos = sqlsession.query(DisplayModel.DAO).filter_by(user=self.dao.user, name=newname).all()
     if len(daos) > 0:
         raise Exception("Name already exists")
     sqlsession.commit()
     format = self.dao.format
     user = self.dao.user
     self.dao = None
     self.dao = DisplayModel(user=user, name=newname, format=format).dao
     sqlsession.add(self.dao)
     sqlsession.commit()
     if oldname == "unnamed":
         olddisplay.delete()

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def get_models(display, user):
     daos=  sqlsession.query(TelemetryWindowModel.DAO).filter_by(user=user, display=display.get_name()).all()
     models=[]
     for dao in daos:
         models.append(TelemetryWindowModel(user=user, name=dao.name, displayname=display.get_name()))
     return models

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def verify(self):
     return sqlsession.query(User).filter_by(userid=self.userid,password=self.password).count()>0

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def get_models(user, displayname, parentname):
     daos=  sqlsession.query(TileModel.DAO).filter_by(user = user, display=displayname, parent=parentname).all()
     models=[]
     for dao in daos:
         models.append(TileModel(name=dao.name, user=user, displayname=displayname, parentname=parentname, type=dao.type))
     return models

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
UserRoleMapping.table=sqlalchemy.Table('userroles',metadata,
                            Column('id',Integer,primary_key=True),
                            Column('userid',String(80), nullable=False),
                            Column('roleid',Integer, nullable=False),
                            useexisting=True)

"""map tables to database"""
sqlalchemy.orm.mapper(User, User.table)
sqlalchemy.orm.mapper(Role, Role.table)
sqlalchemy.orm.mapper(UserRoleMapping, UserRoleMapping.table)


"""Setup user and user roles for basic admin"""
import hashlib

try:
    User.ROOT = sqlsession.query(User).filter_by(userid="admin").one()
    User.ROOT.password=hashlib.md5("admin").hexdigest()
    sqlsession.commit()
except:
    User.ROOT= User("admin", hashlib.md5("admin").hexdigest())
    sqlsession.add(User.ROOT)
    sqlsession.commit()
Role.ADMIN = Role(1,"admin")
Role.DEVELOPER = Role(2,"developer")
Role.PRODCUT_MANAGER=Role(3,"product_manager")

UserRoleMapping.ROOT = UserRoleMapping(User.ROOT,Role.ADMIN)

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def __init__(self, project_name, contract_id, project_type):
     daos=sqlsession.query(Project.DAO).filter_by(project_name=project_name).all()
     if (len(daos)>0):
         self.dao=daos[0]
     else:
         self.dao=Project.DAO(project_name, contract_id, project_type=project_type)

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def query_workbooks():
     daos=sqlsession.query(Workbook.DAO).all()
     workbooks={}
     for dao in daos:
         workbooks[dao.project_name + "." + dao.workbook_name] = Workbook(dao.project_name, dao.workbook_name)
     return workbooks

# 需要導入模塊: from calypso.model.meta import Session [as 別名]
# 或者: from calypso.model.meta.Session import query [as 別名]
 def query_projects():
     daos=sqlsession.query(Project.DAO).all()
     projects={}
     for dao in daos:
         projects[dao.project_name] = Project(dao.project_name, dao.contract_id, dao.project_type)
     return projects