Python DBSession.query方法代码示例

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listGroupUser(self,**kw):
     groups = DBSession.query(Group).all();
     self.listgroup = [];
     for group in groups:
         self.listgroup.append({'id' : group.group_id ,
                           'name' :  group.group_name 
                      }); 
    
     return dict(root = self.listgroup,total=str(len(self.listgroup)));

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def showProgramClinicReport(cls,startDate, stopDate,book_type,bookSearch,offset=0,limit=15):
     
     query = DBSession.query(cls).filter( and_( cls.activate == '1', and_( cls.book_detail.like(bookSearch) ,and_( cls.book_type_id == book_type ,cls.book_recive.between(startDate, stopDate)  ) )) );
     count = query.count();
     list = query.order_by(desc(cls.book_number)).limit(limit).offset(offset).all();
     #DBSession.query(cls).filter(between(cls.book_recive, startDate, stopDate)).all();
     print count ;
     
     return count, list;   

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def search(cls,fiscalyear = None, group= None, subgroup= None):
     sql = "1=1 ";
     if (fiscalyear):
         sql = sql + " and fiscal_year = " + fiscalyear;
     if(group):
         sql = sql + " and revenue_list_id = " + group;
     if(subgroup):
         sql = sql + " and revenue_sub_list_id = " + subgroup;
      
         
     log.info(sql);
     return DBSession.query(cls).filter(sql).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listUser(self,**kw):
     #users = DBSession.query(User).all();
     groups = DBSession.query(Group).all();
     self.list = [];
     for group in groups:
         for guser in group.users:
             self.list.append({'id' : guser.user_id ,
                      'name' : guser.user_name,
                      'display' : guser.display_name,
                      'email' : guser.email_address,
                      'group_id' :  group.group_id,
                      'group' : group.group_name
                      }); 
    
     return dict(root = self.list,total=str(len(self.list)));

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def search(cls,fiscalyear=None,division=None,section=None,status=None,projectType=None,start=0,limit=25):
     
     sql = "1=1 ";
     if (fiscalyear):
         sql = sql + " and fiscal_year = " + fiscalyear;
     if(projectType):
         sql = sql + " and project_type_id = " + projectType;
     if(division):
         sql = sql + " and division_id = " + division;
     if(section):
         sql = sql + " and section_id = " + section;
     if(status):
         sql = sql + " and project_status_id = " + status ;
         
     log.info(sql);
     return DBSession.query(cls).filter(sql).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listPrimarySchool(cls):
     return DBSession.query(cls).filter(  cls.high_school==str(0) ).order_by(cls.school_id).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listAll(cls):
     return DBSession.query(cls).order_by(cls.dental_child_dev_center_service_id).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def by_email_address(cls, email):
     """Return the user object whose email address is ``email``."""
     return DBSession.query(cls).filter_by(email_address=email).first()

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listAll(cls):
     return DBSession.query(cls).order_by(cls.project_status_id).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listAll(cls):
     return DBSession.query(cls).order_by(cls.years_id).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listAll(cls):
     return DBSession.query(cls).filter(  cls.revenue_list_id != '0' ).order_by(cls.revenue_list_id).all();

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def by_user_name(cls, username):
     """Return the user object whose user name is ``username``."""
     return DBSession.query(cls).filter_by(user_name=username).first()

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listAll(cls):
     return DBSession.query(cls).order_by(cls.book_type_id).all(); 

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def getById(cls,id):
     return DBSession.query(cls) .get(str(id));  

# 需要导入模块: from comcenter.model import DBSession [as 别名]
# 或者: from comcenter.model.DBSession import query [as 别名]
 def listByGroup(cls,group):
     return DBSession.query(cls).filter(  cls.revenue_list_id==str(group) ).order_by(cls.revenue_list_id ).all();