def take_action(self, parsed_args): # args_map = { # 'name': 'name', # } # _kwargs = map_parsed_args(parsed_args, args_map) db_api = DBAPI() join = [] if parsed_args.resolved == 1: join.append((ProductPackageIssue, {'resolved': True})) elif parsed_args.resolved == 0: join.append((ProductPackageIssue, {'resolved': False})) if parsed_args.affected == 1: join.append((ProductPackageIssue, {'affected': True})) elif parsed_args.affected == 0: join.append((ProductPackageIssue, {'affected': False})) objs = db_api.query(ProductPackage, ProductPackageAdapter, join=join) cols = ( 'ID', 'Product', 'Distribution', 'Name', 'Version', ) data = ((x.id, str(x.product), str(x.distribution), x.name, x.version) for x in objs) return cols, data
def take_action(self, parsed_args): db_api = DBAPI() objs = db_api.query(DistributionPackage, DistributionPackageAdapter) cols = ('ID', 'Distribution', 'Name', 'Version') data = [(obj.id, str(obj.distribution), obj.name, obj.version) for obj in objs] data.sort(key=lambda x: ''.join((x[1], x[2]))) return cols, data
def take_action(self, parsed_args): args_map = { 'name': 'project', } _kwargs = map_parsed_args(parsed_args, args_map) db_api = DBAPI() if 'project' in _kwargs: _kwargs['project'] = db_api.get_create(SourceProject, name=_kwargs['project']) objs = db_api.query(SourcePackage, SourcePackageAdapter, **_kwargs) cols = ('ID', 'Name', 'Version') data = [(obj.id, obj.name, obj.version) for obj in objs] data.sort(key=lambda x: ''.join((x[1], x[2]))) return cols, data