def get(self): """ Render and return JSON response for GET /ajax/ofx """ args = request.args.to_dict() args_dict = self._args_dict(args) if self._have_column_search(args_dict) and args['search[value]'] == '': args['search[value]'] = 'FILTERHACK' table = DataTable( args, OFXTransaction, db_session.query(OFXTransaction), [('date', 'date_posted', lambda i: i.date_posted.strftime('%Y-%m-%d')), ('amount', lambda a: float(a.amount)), ('account', 'account.name', lambda i: "{} ({})".format(i.name, i.id)), ('type', 'trans_type'), 'name', 'memo', 'description', 'fitid', ('last_stmt', 'statement.id'), ('last_stmt_date', 'statement.as_of', lambda i: i.as_of.strftime('%Y-%m-%d')), ('reconcile_id', 'reconcile', lambda i: None if i.reconcile is None else i.reconcile.id)]) table.add_data(acct_id=lambda o: o.account_id) if args['search[value]'] != '': table.searchable(lambda qs, s: self._filterhack(qs, s, args_dict)) return jsonify(table.json())
def get(self): """ Render and return JSON response for GET /ajax/ofx """ args = request.args.to_dict() args_dict = self._args_dict(args) if self._have_column_search(args_dict) and args['search[value]'] == '': args['search[value]'] = 'FILTERHACK' table = DataTable(args, Transaction, db_session.query(Transaction), [('date', lambda i: i.date.strftime('%Y-%m-%d')), ('amount', 'actual_amount', lambda a: float(a.actual_amount)), 'description', ('account', 'account.name', lambda i: "{} ({})".format(i.name, i.id)), ('scheduled', 'scheduled_trans_id'), ('budgeted_amount'), ('reconcile_id', 'reconcile', lambda i: None if i.reconcile is None else i.reconcile.id)]) table.add_data( acct_id=lambda o: o.account_id, budgets=lambda o: [{ 'name': bt.budget.name, 'id': bt.budget_id, 'amount': bt.amount, 'is_income': bt.budget.is_income } for bt in sorted( o.budget_transactions, key=lambda x: x.amount, reverse=True)], id=lambda o: o.id) if args['search[value]'] != '': table.searchable(lambda qs, s: self._filterhack(qs, s, args_dict)) return jsonify(table.json())
def test_extra_data(self): self.make_data(10) req = self.make_params() table = DataTable(req, User, self.session.query(User), ["id"]) table.add_data(id_multiplied=lambda i: i.id * 10) result = table.json() assert all(r["id"] * 10 == r["DT_RowData"]["id_multiplied"] for r in result["data"])
def request_group_tests(request): # Server side processing for DataTables plugin in_cases = DBSession.query(TestGroupMembership.test_id).\ filter(TestGroupMembership.group_id == request.matchdict['group_id']) not_cases = DBSession.query(TestCase).filter(~TestCase.id.in_(in_cases)) table = DataTable(request.GET, TestCase, not_cases, ["id"]) table.add_data(link=lambda o: request.route_url("view_test", test_id=o.id)) table.searchable(lambda queryset, userinput: queryset.filter(TestCase.id.op('~')(userinput))) return table.json()
def request_group_tests(request): # Server side processing for DataTables plugin in_cases = DBSession.query(TestGroupMembership.test_id).\ filter(TestGroupMembership.group_id == request.matchdict['group_id']) not_cases = DBSession.query(TestCase).filter(~TestCase.id.in_(in_cases)) table = DataTable(request.GET, TestCase, not_cases, ["id"]) table.add_data(link=lambda o: request.route_url("view_test", test_id=o.id)) table.searchable(lambda queryset, userinput: queryset.filter( TestCase.id.op('~')(userinput))) return table.json()
def test_extra_data(self): self.make_data(10) req = self.make_params() table = DataTable(req, User, self.session.query(User), [ "id" ]) table.add_data(id_multiplied=lambda i: i.id * 10) result = table.json() assert all(r["id"] * 10 == r["DT_RowData"]["id_multiplied"] for r in result["data"])
def get(self): """ Render and return JSON response for GET /ajax/projects """ args = request.args.to_dict() args_dict = self._args_dict(args) if self._have_column_search(args_dict) and args['search[value]'] == '': args['search[value]'] = 'FILTERHACK' table = DataTable( args, Project, db_session.query(Project), ['name', 'total_cost', 'remaining_cost', 'is_active', 'notes']) table.add_data(id=lambda o: o.id) if args['search[value]'] != '': table.searchable(lambda qs, s: self._filterhack(qs, s, args_dict)) return jsonify(table.json())
def compare_table(request): # Server Side processing for Datatables. res = DBSession.query(Run.test_id, Run.id.label('run_id'), aliased_run.id.label('alt_id'), Run.result, aliased_run.result.label("alt_result")).\ join(aliased_run, Run.test_id == aliased_run.test_id).\ filter(Run.job_id == request.matchdict['job_id_source']).\ filter(aliased_run.job_id == request.matchdict['job_id_dest']).\ filter(aliased_run.result != Run.result) table = DataTable(request.GET, Run, res, [("test_id"), ("run_id"), ("alt_id"), ("result"), ("alt_result")]) table.add_data(link =lambda o: request.route_url("view_test", test_id=o.test_id)) table.add_data(sourcelink=lambda o: request.route_url("view_test_run", test_id=o.run_id)) table.add_data(destlink =lambda o: request.route_url("view_test_run", test_id=o.alt_id)) table.searchable(lambda queryset, userinput: queryset.\ filter(Run.test_id.op('~')(userinput))) return table.json()
def request_job_table(request): # Server side processing for DataTables plugin job = request.matchdict['job_id'] query = DBSession.query(Run.id, Run.test_id, Run.stdout, Run.stderr, Run.result).filter(Run.job_id == job) resultFilter = request.params.getall('resultFilter[]') if resultFilter: query = query.filter(Run.result.in_(resultFilter)) groupFilter = request.params.getall('select-group[]') if groupFilter: group_subquery = DBSession.query(TestGroupMembership.test_id) \ .filter(TestGroupMembership.group_id.in_(groupFilter)) query = query.filter(Run.test_id.in_(group_subquery)) groupExcludeFilter = request.params.getall('exclude-group[]') if groupExcludeFilter: groupExc_subquery = DBSession.query(TestGroupMembership.test_id) \ .filter(TestGroupMembership.group_id.in_(groupExcludeFilter)) query = query.filter(~Run.test_id.in_(groupExc_subquery)) classifierFilter = request.params.getall('select-classifier[]') if classifierFilter: subquery = DBSession.query(Run.id).join(TestRunClassification) \ .filter(Run.job_id == job) \ .filter(TestRunClassification.classifier_id.in_(classifierFilter)) query = query.filter(Run.id.in_(subquery)) classifierFilter = request.params.getall('exclude-classifier[]') if classifierFilter: subquery = DBSession.query(Run.id).join(TestRunClassification) \ .filter(Run.job_id == job) \ .filter(TestRunClassification.classifier_id.in_(classifierFilter)) query = query.filter(~Run.id.in_(subquery)) table = DataTable(request.GET, Run, query, ["test_id", "stdout", "stderr", "result"]) table.add_data( link=lambda o: request.route_url("view_test_run", test_id=o.id)) # Search for similarity in Results or Regex in test_id table.searchable(lambda queryset, userinput: queryset.filter(or_(cast(Run.result, Text).\ like('%' + userinput.upper() + '%'), Run.test_id.op('~')(userinput)))) return table.json()
def test_classifier(request): classifier = DBSession.query(TestClassifier) \ .filter_by(id=request.matchdict['classifier_id']) \ .first() col = getattr(Run, str(classifier.column)) matched_runs = DBSession.query(Run.id, Run.test_id, col) \ .filter(col.op('~')(classifier.pattern)) if request.params['job_id']: matched_runs = matched_runs.filter(Run.job_id == request.params['job_id']) table = DataTable(request.GET, Run, matched_runs, ["id", "test_id", classifier.column]) table.add_data(link=lambda o: request.route_url("view_test_run", test_id=o.id)) table.searchable(lambda queryset, userinput: queryset.filter(Run.test_id.op('~')(userinput))) return table.json()
def get(self): """ Render and return JSON response for GET /ajax/ofx """ args = request.args.to_dict() args_dict = self._args_dict(args) if self._have_column_search(args_dict) and args['search[value]'] == '': args['search[value]'] = 'FILTERHACK' table = DataTable( args, ScheduledTransaction, db_session.query(ScheduledTransaction), [ 'is_active', ( 'amount', lambda a: float(a.amount) ), 'description', ( 'account', 'account.name', lambda i: "{} ({})".format(i.name, i.id) ), ( 'budget', 'budget.name', lambda i: "{} {}({})".format( i.name, '(income) ' if i.is_income else '', i.id ) ), 'recurrence_str', 'schedule_type' ] ) table.add_data( acct_id=lambda o: o.account_id, budget_id=lambda o: o.budget_id, id=lambda o: o.id ) if args['search[value]'] != '': table.searchable(lambda qs, s: self._filterhack(qs, s, args_dict)) return jsonify(table.json())
def cheque_ajax(request): # database connection engine = create_engine(EARL) Session = sessionmaker(bind=engine) session = Session() # query #cheques = session.query(Cheque).order_by(desc(jbissue_date)).limit(length) #cheques = session.query(Cheque).order_by(desc(Cheque.jbissue_date)) # datatable recci = request.GET status = 'I' if request.POST: status = request.POST.get('status') recci = request.POST cheques = session.query(Cheque).filter_by(jbstatus=status) table = DataTable(recci, Cheque, cheques, [ 'jbseqno', 'jbchkno', 'jbchknolnk', 'jbstatus', 'jbstatus_date', 'jbimprt_date', 'jbaccount', 'jbamount', 'jbamountlnk', 'jbpayee' ]) if not recci: return JsonResponse( {'message':"Missing GET/POST data for 'status' field"}, safe=False ) else: table.add_data(link=lambda o: reverse_lazy('cheque_detail', args=[o.jbchkno])) table.add_data(pk=lambda o: o.jbchkno) #table.searchable(lambda queryset, user_input: cheque_search(queryset, user_input)) session.close() jason = table.json() # DT_RowData dictionary contains a key named 'link', which is # a proxy object and JsonResponse() barfs on it, so we remove it for check in jason.get('data'): check.pop('DT_RowData', None) return JsonResponse(jason, safe=False)
def request_job_table(request): # Server side processing for DataTables plugin job = request.matchdict['job_id'] query = DBSession.query(Run.id, Run.test_id, Run.stdout, Run.stderr, Run.result).filter(Run.job_id == job) resultFilter = request.params.getall('resultFilter[]') if resultFilter: query = query.filter(Run.result.in_(resultFilter)) groupFilter = request.params.getall('select-group[]') if groupFilter: group_subquery = DBSession.query(TestGroupMembership.test_id) \ .filter(TestGroupMembership.group_id.in_(groupFilter)) query = query.filter(Run.test_id.in_(group_subquery)) groupExcludeFilter = request.params.getall('exclude-group[]') if groupExcludeFilter: groupExc_subquery = DBSession.query(TestGroupMembership.test_id) \ .filter(TestGroupMembership.group_id.in_(groupExcludeFilter)) query = query.filter(~Run.test_id.in_(groupExc_subquery)) classifierFilter = request.params.getall('select-classifier[]') if classifierFilter: subquery = DBSession.query(Run.id).join(TestRunClassification) \ .filter(Run.job_id == job) \ .filter(TestRunClassification.classifier_id.in_(classifierFilter)) query = query.filter(Run.id.in_(subquery)) classifierFilter = request.params.getall('exclude-classifier[]') if classifierFilter: subquery = DBSession.query(Run.id).join(TestRunClassification) \ .filter(Run.job_id == job) \ .filter(TestRunClassification.classifier_id.in_(classifierFilter)) query = query.filter(~Run.id.in_(subquery)) table = DataTable(request.GET, Run, query, ["test_id", "stdout", "stderr", "result"]) table.add_data(link=lambda o: request.route_url("view_test_run", test_id=o.id)) # Search for similarity in Results or Regex in test_id table.searchable(lambda queryset, userinput: queryset.filter(or_(cast(Run.result, Text).\ like('%' + userinput.upper() + '%'), Run.test_id.op('~')(userinput)))) return table.json()
def get(self, project_id): """ Render and return JSON response for GET /ajax/projects/<int:project_id>/bom_items """ args = request.args.to_dict() args_dict = self._args_dict(args) if self._have_column_search(args_dict) and args['search[value]'] == '': args['search[value]'] = 'FILTERHACK' table = DataTable( args, BoMItem, db_session.query(BoMItem).filter( BoMItem.project_id.__eq__(project_id)), [ 'name', 'quantity', 'unit_cost', 'is_active', 'notes', 'url', 'id' ]) table.add_data(line_cost=lambda o: float(o.unit_cost) * o.quantity) if args['search[value]'] != '': table.searchable(lambda qs, s: self._filterhack(qs, s, args_dict)) return jsonify(table.json())
def test_classifier(request): classifier = DBSession.query(TestClassifier) \ .filter_by(id=request.matchdict['classifier_id']) \ .first() col = getattr(Run, str(classifier.column)) matched_runs = DBSession.query(Run.id, Run.test_id, col) \ .filter(col.op('~')(classifier.pattern)) if request.params['job_id']: matched_runs = matched_runs.filter( Run.job_id == request.params['job_id']) table = DataTable(request.GET, Run, matched_runs, ["id", "test_id", classifier.column]) table.add_data( link=lambda o: request.route_url("view_test_run", test_id=o.id)) table.searchable(lambda queryset, userinput: queryset.filter( Run.test_id.op('~')(userinput))) return table.json()
def get(self): """ Render and return JSON response for GET /ajax/ofx """ args = request.args.to_dict() args_dict = self._args_dict(args) if self._have_column_search(args_dict) and args['search[value]'] == '': args['search[value]'] = 'FILTERHACK' table = DataTable( args, FuelFill, db_session.query(FuelFill).filter( FuelFill.vehicle.has(is_active=True)), [('date', lambda i: i.date.strftime('%Y-%m-%d')), ('vehicle', 'vehicle.name'), 'odometer_miles', 'reported_miles', 'calculated_miles', 'level_before', 'level_after', 'fill_location', 'cost_per_gallon', 'total_cost', ('gallons', lambda i: i.gallons.quantize(Decimal('.001'), rounding=ROUND_FLOOR)), 'reported_mpg', 'calculated_mpg', 'notes']) table.add_data(vehicle_id=lambda o: o.vehicle_id) if args['search[value]'] != '': table.searchable(lambda qs, s: self._filterhack(qs, s, args_dict)) return jsonify(table.json())
def compare_table(request): # Server Side processing for Datatables. res = DBSession.query(Run.test_id, Run.id.label('run_id'), aliased_run.id.label('alt_id'), Run.result, aliased_run.result.label("alt_result")).\ join(aliased_run, Run.test_id == aliased_run.test_id).\ filter(Run.job_id == request.matchdict['job_id_source']).\ filter(aliased_run.job_id == request.matchdict['job_id_dest']).\ filter(aliased_run.result != Run.result) table = DataTable(request.GET, Run, res, [("test_id"), ("run_id"), ("alt_id"), ("result"), ("alt_result")]) table.add_data( link=lambda o: request.route_url("view_test", test_id=o.test_id)) table.add_data(sourcelink=lambda o: request.route_url("view_test_run", test_id=o.run_id)) table.add_data(destlink=lambda o: request.route_url("view_test_run", test_id=o.alt_id)) table.searchable(lambda queryset, userinput: queryset.\ filter(Run.test_id.op('~')(userinput))) return table.json()