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()
