Python DBSESSION.order_by方法代码示例

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
 def taskyears():
     """
         return the distinct financial years available in the database
     """
     query = DBSESSION().query(distinct(Invoice.financial_year))
     query = query.order_by(Invoice.financial_year)
     years = [year[0] for year in query]
     current = datetime.date.today().year
     if current not in years:
         years.append(current)
     return years

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
 def expenseyears():
     """
     return distinct expense years available in the database
     """
     query = DBSESSION().query(distinct(ExpenseSheet.year))
     query = query.order_by(ExpenseSheet.year)
     years = [year[0] for year in query]
     current = datetime.date.today().year
     if current not in years:
         years.append(current)
     return years

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
 def query(cls, keys=None, active=True):
     """
         Return a query
     """
     if keys:
         query = DBSESSION().query(*keys)
     else:
         query = super(Company, cls).query()
     if active:
         query = query.filter(cls.active == True)
     return query.order_by(cls.name)

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
def get_expensesheet_years(company):
    """
    List of years an expensesheet has been retrieved for
    """
    query = DBSESSION().query(distinct(ExpenseSheet.year)).filter_by(
        company_id=company.id
    )
    years = [data[0] for data in query.order_by(desc(ExpenseSheet.year))]

    today = datetime.date.today()
    if today.year not in years:
        years.insert(0, today.year)
    return years

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
 def get_tasks(cls, instance, offset=None, limit=None):
     from autonomie.models.task import Task
     query = DBSESSION().query(Task)
     query = query.filter(Task.company_id == instance.id)
     query = query.filter(
         Task.type_.in_(('invoice', 'estimation', 'cancelinvoice'))
     )
     query = query.order_by(desc(Task.status_date))
     if offset is not None:
         query = query.offset(offset)
     if limit is not None:
         query = query.limit(limit)
     return query

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
 def get_customer_codes_and_names(cls, company):
     """
     Return a query for code and names of customers related to company
     :param company: the company we're working on
     :returns: an orm query loading Customer instances with only the columns
     we want
     :rtype: A Sqlalchemy query object
     """
     from autonomie.models.customer import Customer
     query = DBSESSION().query(Customer)
     query = query.options(load_only('code', 'name'))
     query = query.filter(Customer.code != None)
     query = query.filter(Customer.company_id == company.id)
     return query.order_by(Customer.code)

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
def get_users_options(roles=None):
    """
    Return the list of active users from the database formatted as choices:
        [(user_id, user_label)...]

    :param role: roles of the users we want
        default:  all
        values : ('contractor', 'manager', 'admin'))
    """
    query = DBSESSION().query(User).options(
        load_only('id', 'firstname', 'lastname')
    )

    # Only User accounts with logins
    query = query.join(Login).filter(Login.active == True)

    query = query.order_by(User.lastname)

    if roles and not hasattr(roles, "__iter__"):
        roles = [roles]

    query = _filter_by_group(query, roles)
    return [(unicode(u.id), format_account(u)) for u in query]

# 需要导入模块: from autonomie_base.models.base import DBSESSION [as 别名]
# 或者: from autonomie_base.models.base.DBSESSION import order_by [as 别名]
 def last(cls, grid_class, company_id):
     query = DBSESSION().query(grid_class).filter_by(company_id=company_id)
     query = query.order_by(desc(grid_class.date))
     return query.first()