def mget_all(offset=None, limit=None, count=False, ids_only=False):
"""Get a list of all configured roles
"""
page_clause, order_clause = build_clauses(count, order_by='date_created',
valid_orders=ORDER_FIELDS)
fields = get_fields_for_sql(count=count, ids_only=ids_only)
query_vars = {'offset': offset, 'limit': limit}
with gus.config.get_db_conn().cursor() as c:
c.execute("""
SELECT
%s
FROM
chef_roles cr
%s
%s """ % (fields, order_clause, page_clause), query_vars)
res = c.fetchall()
return res
def mget_all(count=False, ids_only=False, offset=None, limit=None):
'''Return all projects, in date created order
'''
fields = get_fields_for_sql(count=count, ids_only=ids_only)
page_clause, order_clause = build_clauses(count=count,
default_order='project_id')
query_vars = {'offset': offset, 'limit': limit}
with gus.config.get_db_conn().cursor() as c:
c.execute('''
SELECT
%s
FROM
projects p
%s
%s
''' % (fields, order_clause, page_clause), query_vars)
res = c.fetchall()
return res
def mget_all(offset=None, limit=None, count=False, ids_only=False):
'''List all environments
'''
fields = get_fields_for_sql(count=count, ids_only=ids_only)
page_clause, order_clause = build_clauses(count=count,
default_order='environment_id')
query_vars = {'offset': offset, 'limit': limit}
with gus.config.get_db_conn().cursor() as c:
c.execute("""
SELECT
%s
FROM
environments e
%s
%s
""" % (fields, order_clause, page_clause), query_vars)
res = c.fetchall()
return res
def mget_by_project(project_id, offset=None, limit=None, count=False,
ids_only=False):
"""Get a list of all roles the given project is associated with
"""
page_clause, order_clause = build_clauses(count, order_by='date_created',
valid_orders=ORDER_FIELDS)
fields = get_fields_for_sql(count=count, ids_only=ids_only)
query_vars = {'offset': offset, 'limit': limit, 'project_id': project_id}
with gus.config.get_db_conn().cursor() as c:
c.execute("""
SELECT
%s
FROM
chef_roles cr
JOIN chef_roles_xref_projects x ON (x.chef_role_id = cr.chef_role_id)
WHERE
x.project_id = %%(project_id)s
%s
%s """ % (fields, order_clause, page_clause), query_vars)
res = c.fetchall()
return res
def mget_by_project(project_id, count=False, limit=None, offset=None,
ids_only=False):
"""Get all release candidates for the given project
"""
page_clause, order_clause = build_clauses(count, order_by='date_created',
valid_orders=ORDER_FIELDS)
fields = get_fields_for_sql(count=count, ids_only=ids_only)
query_vars = {'project_id': project_id, 'limit': limit, 'offset': offset}
with gus.config.get_db_conn().cursor() as c:
query = """
SELECT
%s
FROM
release_candidates rc
WHERE
project_id = %%(project_id)s
%s
%s
""" % (fields, order_clause, page_clause)
c.execute(query, query_vars)
res = c.fetchall()
return res
def mget_by_project_branch(project_id, branch_name, count=False, limit=None,
offset=None, ids_only=False):
"""Get all release candidates for the given project and branch
"""
page_clause, order_clause = build_clauses(count)
fields = get_fields_for_sql(count=count, ids_only=ids_only)
query_vars = {'project_id': project_id, 'branch_name': branch_name,
'offset': offset, 'limit': limit}
with gus.config.get_db_conn().cursor() as c:
query = """
SELECT
%s
FROM
release_candidates rc
WHERE
project_id = %%(project_id)s
AND
branch_name = %%(branch_name)s
%s
%s""" % (fields, order_clause, page_clause)
c.execute(query, query_vars)
res = c.fetchall()
return res
