def resource_get_all(context, user_id=None, show_deleted=False,
limit=None, marker=None, sort_keys=None, sort_dir=None,
filters=None, tenant_safe=True):
query = soft_delete_aware_query(context, models.Resource,
show_deleted=show_deleted)
if tenant_safe:
query = query.filter_by(user_id=context.tenant_id)
elif user_id:
query = query.filter_by(user_id=user_id)
if filters is None:
filters = {}
sort_key_map = {
consts.RES_CREATED_AT: models.Resource.created_at.key,
consts.RES_UPDATED_AT: models.Resource.updated_at.key,
consts.RES_RESOURCE_TYPE: models.Resource.resource_type.key,
consts.RES_USER_ID: models.Resource.user_id.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Resource, filters)
return _paginate_query(context, query, models.Node,
limit=limit, marker=marker,
sort_keys=keys, sort_dir=sort_dir,
default_sort_keys=['created_at']).all()
def event_get_all(context, user_id=None, limit=None, marker=None,
sort_keys=None, sort_dir=None, filters=None,
start_time=None, end_time=None, tenant_safe=True,
show_deleted=False):
query = soft_delete_aware_query(context, models.Event,
show_deleted=show_deleted)
if tenant_safe:
query = query.filter_by(user_id=context.tenant_id)
elif user_id:
query = query.filter_by(user_id=user_id)
if start_time:
query = query.filter_by(models.Event.timestamp >= start_time)
if end_time:
query = query.filter_by(models.Event.timestamp <= end_time)
if filters is None:
filters = {}
sort_key_map = {
consts.EVENT_ACTION: models.Event.action.key,
consts.EVENT_RESOURCE_TYPE: models.Event.resource_type.key,
consts.EVENT_TIMESTAMP: models.Event.timestamp.key,
consts.EVENT_USER_ID: models.Event.user_id.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Resource, filters)
return _paginate_query(context, query, models.Node,
limit=limit, marker=marker,
sort_keys=keys, sort_dir=sort_dir,
default_sort_keys=['timestamp']).all()
def policy_get_all(context,
limit=None,
marker=None,
sort_keys=None,
sort_dir=None,
filters=None,
show_deleted=False):
query = soft_delete_aware_query(context,
models.Policy,
show_deleted=show_deleted)
if filters is None:
filters = {}
sort_key_map = {
consts.POLICY_NAME: models.Policy.name.key,
consts.POLICY_CREATED_AT: models.Policy.created_at.key,
consts.POLICY_UPDATED_AT: models.Policy.updated_at.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Policy, filters)
return _paginate_query(context,
query,
models.Policy,
limit=limit,
marker=marker,
sort_keys=keys,
sort_dir=sort_dir,
default_sort_keys=['id']).all()
def rule_get_all(context,
show_deleted=False,
limit=None,
marker=None,
sort_keys=None,
sort_dir=None,
filters=None):
query = soft_delete_aware_query(context,
models.Rule,
show_deleted=show_deleted)
if filters is None:
filters = {}
sort_key_map = {
consts.RULE_NAME: models.Rule.name.key,
consts.RULE_TYPE: models.Rule.type.key,
consts.RULE_CREATED_AT: models.Rule.created_at.key,
consts.RULE_UPDATED_AT: models.Rule.updated_at.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Rule, filters)
return _paginate_query(context,
query,
models.Rule,
limit=limit,
marker=marker,
sort_keys=keys,
sort_dir=sort_dir,
default_sort_keys=['created_at']).all()
def user_get_all(context,
show_deleted=False,
limit=None,
marker=None,
sort_keys=None,
sort_dir=None,
filters=None):
query = soft_delete_aware_query(context,
models.User,
show_deleted=show_deleted)
if filters is None:
filters = {}
sort_key_map = {
consts.USER_CREATED_AT: models.User.created_at.key,
consts.USER_UPDATED_AT: models.User.updated_at.key,
consts.USER_BALANCE: models.User.balance.key,
consts.USER_STATUS: models.User.status.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.User, filters)
return _paginate_query(context,
query,
models.User,
limit=limit,
marker=marker,
sort_keys=keys,
sort_dir=sort_dir,
default_sort_keys=['id']).all()
def event_get_all(context,
user_id=None,
limit=None,
marker=None,
sort_keys=None,
sort_dir=None,
filters=None,
start_time=None,
end_time=None,
tenant_safe=True,
show_deleted=False):
query = soft_delete_aware_query(context,
models.Event,
show_deleted=show_deleted)
if tenant_safe:
query = query.filter_by(user_id=context.tenant_id)
elif user_id:
query = query.filter_by(user_id=user_id)
if start_time:
query = query.filter_by(models.Event.timestamp >= start_time)
if end_time:
query = query.filter_by(models.Event.timestamp <= end_time)
if filters is None:
filters = {}
sort_key_map = {
consts.EVENT_ACTION: models.Event.action.key,
consts.EVENT_RESOURCE_TYPE: models.Event.resource_type.key,
consts.EVENT_TIMESTAMP: models.Event.timestamp.key,
consts.EVENT_USER_ID: models.Event.user_id.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Resource, filters)
return _paginate_query(context,
query,
models.Node,
limit=limit,
marker=marker,
sort_keys=keys,
sort_dir=sort_dir,
default_sort_keys=['timestamp']).all()
def policy_get_all(context, limit=None, marker=None,
sort_keys=None, sort_dir=None,
filters=None, show_deleted=False):
query = soft_delete_aware_query(context, models.Policy,
show_deleted=show_deleted)
if filters is None:
filters = {}
sort_key_map = {
consts.POLICY_NAME: models.Policy.name.key,
consts.POLICY_CREATED_AT: models.Policy.created_at.key,
consts.POLICY_UPDATED_AT: models.Policy.updated_at.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Policy, filters)
return _paginate_query(context, query, models.Policy,
limit=limit, marker=marker,
sort_keys=keys, sort_dir=sort_dir,
default_sort_keys=['id']).all()
def rule_get_all(context, show_deleted=False, limit=None,
marker=None, sort_keys=None, sort_dir=None,
filters=None):
query = soft_delete_aware_query(context, models.Rule,
show_deleted=show_deleted)
if filters is None:
filters = {}
sort_key_map = {
consts.RULE_NAME: models.Rule.name.key,
consts.RULE_TYPE: models.Rule.type.key,
consts.RULE_CREATED_AT: models.Rule.created_at.key,
consts.RULE_UPDATED_AT: models.Rule.updated_at.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Rule, filters)
return _paginate_query(context, query, models.Rule,
limit=limit, marker=marker,
sort_keys=keys, sort_dir=sort_dir,
default_sort_keys=['created_at']).all()
def user_get_all(context, show_deleted=False, limit=None,
marker=None, sort_keys=None, sort_dir=None,
filters=None):
query = soft_delete_aware_query(context, models.User,
show_deleted=show_deleted)
if filters is None:
filters = {}
sort_key_map = {
consts.USER_CREATED_AT: models.User.created_at.key,
consts.USER_UPDATED_AT: models.User.updated_at.key,
consts.USER_BALANCE: models.User.balance.key,
consts.USER_STATUS: models.User.status.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.User, filters)
return _paginate_query(context, query, models.User,
limit=limit, marker=marker,
sort_keys=keys, sort_dir=sort_dir,
default_sort_keys=['id']).all()
def resource_get_all(context,
user_id=None,
show_deleted=False,
limit=None,
marker=None,
sort_keys=None,
sort_dir=None,
filters=None,
tenant_safe=True):
query = soft_delete_aware_query(context,
models.Resource,
show_deleted=show_deleted)
if tenant_safe:
query = query.filter_by(user_id=context.tenant_id)
elif user_id:
query = query.filter_by(user_id=user_id)
if filters is None:
filters = {}
sort_key_map = {
consts.RES_CREATED_AT: models.Resource.created_at.key,
consts.RES_UPDATED_AT: models.Resource.updated_at.key,
consts.RES_RESOURCE_TYPE: models.Resource.resource_type.key,
consts.RES_USER_ID: models.Resource.user_id.key,
}
keys = _get_sort_keys(sort_keys, sort_key_map)
query = db_filters.exact_filter(query, models.Resource, filters)
return _paginate_query(context,
query,
models.Node,
limit=limit,
marker=marker,
sort_keys=keys,
sort_dir=sort_dir,
default_sort_keys=['created_at']).all()
