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 phase_jsondata(): table = DataTable(request.args, Phase, Phase.query, ["id", "no", "name", "desc", "status_text"]) table.searchable(lambda qs, sq: qs.filter( or_(Phase.name.contains(sq), Phase.no.contains(sq), Phase.desc.contains(sq)))) return json.dumps(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 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 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 jsonhistory(): history = db.session.query(models.Processed) table = DataTable(request.args, models.Processed, history, [ ("date", "time", lambda i: "{}".format(i.time.strftime('%Y/%m/%d')) if i.stopped else '<span class="orange">{}</span>'.format(_("Currently watching..."))), ("ipaddress", lambda i: "{}".format(i.get_xml().find('Player').get("address"))), ("user", lambda i: '<a href="{0}" class="invert-link">{1}</a>'.format(url_for('user', name=i.user), i.user)), ("platform"), ("title", lambda i: u'<a class="invert-link" href="{0}">{1}</a>'.format(url_for('info', id=i.get_xml_value('ratingKey')), i.title)), ("type", lambda i: "{}".format(i.get_xml_value("type"))), ("streaminfo", lambda i: '<a href="#" data-link="{0}" class="orange" data-target="#streamModal" data-toggle="modal"><i class="glyphicon glyphicon glyphicon-info-sign"></i></a>'.format(url_for('streaminfo',id=i.id)) if i.platform != "Imported" else ''), ("time",lambda i: "{}".format(i.time.strftime('%H:%M'))), ("paused_counter", lambda i: "{} min".format(int(i.paused_counter)/60) if i.paused_counter else "0 min" ), ("stopped", lambda i: "{}".format(i.stopped.strftime('%H:%M')) if i.stopped else "n/a"), ("duration", lambda i: "{} min".format(int((((i.stopped - i.time).total_seconds() - (int(i.paused_counter or 0))) /60))) if i.stopped else "n/a"), ("completed", lambda i: '<span class="badge badge-warning">{}%</span>'.format(helper.getPercentage(i.get_xml_value("duration") if i.platform == "Imported" else i.get_xml_value("viewOffset"), i.get_xml_value("duration")))), ]) table.searchable(lambda queryset, user_input: perform_some_search(queryset, user_input)) return json.dumps(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 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 data(): table = DataTable( request.form, models.Mooch, db.session.query(models.Mooch), [("Image"), ("Name", "LastName", lambda i: "{}, {}".format(i.LastName, i.FirstName)), ("Affiliation"), ("Position"), ("Hired", "DateHired", lambda i: "{}".format(i.DateHired.strftime("%m/%d/%Y"))), ("Left", "DateLeft", lambda i: "{}".format(i.DateLeft.strftime("%m/%d/%Y"))), ("Total Days", "TotalTime", lambda i: "{:,}".format( (i.DateLeft - i.DateHired).days)), ("Under Trump", "TrumpTime", lambda i: "{:,}".format(models.trumpTime(i.DateHired, i.DateLeft))), ("Mooches", "MoochesTime"), ("Fired/Resign", "LeaveType"), ("Notes", lambda i: "{}".format(titlecase(i.Notes))), ("Sources")]) table.searchable( lambda queryset, user_input: perform_search(queryset, user_input)) return json.dumps(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 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 test_search(self): user, addr = self.make_user("Silly Sally", "Silly Sally Road") user2, addr2 = self.make_user("Silly Sall", "Silly Sally Roa") self.session.add_all((user, user2)) self.session.commit() req = self.make_params(search={ "value": "Silly Sally" }) table = DataTable(req, User, self.session.query(User), [("name", "full_name")]) table.searchable(lambda qs, sq: qs.filter(User.full_name.startswith(sq))) results = table.json() assert len(results["data"]) == 1 req = self.make_params(search={ "value": "Silly Sall" }) table = DataTable(req, User, self.session.query(User), [("name", "full_name")]) results = table.json() assert len(results["data"]) == 2
def jsonhistory(): history = db.session.query(models.Processed) table = DataTable(request.args, models.Processed, history, [ ("date", "time", lambda i: "{}".format(i.time.strftime('%Y/%m/%d')) if i.stopped else '<span class="orange">{}</span>'.format( _("Currently watching..."))), ("ipaddress", lambda i: "{}".format(i.get_xml().find('Player').get("address"))), ("user", lambda i: '<a href="{0}" class="invert-link">{1}</a>'.format( url_for('user', name=i.user), i.user)), ("platform"), ("title", lambda i: u'<a class="invert-link" href="{0}">{1}</a>'. format(url_for('info', id=i.get_xml_value('ratingKey')), i.title)), ("type", lambda i: "{}".format(i.get_xml_value("type"))), ("streaminfo", lambda i: '<a href="#" data-link="{0}" class="orange" data-target="#streamModal" data-toggle="modal"><i class="glyphicon glyphicon glyphicon-info-sign"></i></a>' .format(url_for('streaminfo', id=i.id)) if i.platform != "Imported" else ''), ("time", lambda i: "{}".format(i.time.strftime('%H:%M'))), ("paused_counter", lambda i: "{} min".format(int(i.paused_counter) / 60) if i.paused_counter else "0 min"), ("stopped", lambda i: "{}".format(i.stopped.strftime('%H:%M')) if i.stopped else "n/a"), ("duration", lambda i: "{} min".format( int((( (i.stopped - i.time).total_seconds() - (int(i.paused_counter or 0))) / 60))) if i.stopped else "n/a"), ("completed", lambda i: '<span class="badge badge-warning">{}%</span>'.format( helper.getPercentage( i.get_xml_value("duration") if i.platform == "Imported" else i .get_xml_value("viewOffset"), i.get_xml_value("duration")))), ]) table.searchable( lambda queryset, user_input: perform_some_search(queryset, user_input)) return json.dumps(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())