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