def post(self, request):
sql = request.POST.get('sql')
show = url_get_show(request)
query = Query(sql=sql, title="Playground")
passes_blacklist, failing_words = query.passes_blacklist()
error = MSG_FAILED_BLACKLIST % ', '.join(failing_words) if not passes_blacklist else None
run_query = not bool(error) if show else False
return self.render_with_sql(request, query, run_query=run_query, error=error)
def get(self, request, query_id):
query, form = QueryView.get_instance_and_form(request, query_id)
query.save() # updates the modified date
show = url_get_show(
request
) # if a query is timing out, it can be useful to nav to /query/id/?show=0
vm = query_viewmodel(request, query, form=form, show_results=show)
return self.render_template('explorer/query.html', vm)
def post(self, request):
sql = request.POST.get('sql')
show = url_get_show(request)
query = Query(sql=sql, title="Playground")
passes_blacklist, failing_words = query.passes_blacklist()
error = MSG_FAILED_BLACKLIST % ', '.join(failing_words) if not passes_blacklist else None
run_query = not bool(error) if show else False
return self.render_with_sql(request, query, run_query=run_query, error=error)
def get(self, request, query_id):
query, form = QueryView.get_instance_and_form(request, query_id)
query.save() # updates the modified date
show = url_get_show(request)
rows = url_get_rows(request)
vm = query_viewmodel(request.user, query, form=form, run_query=show, rows=rows)
fullscreen = url_get_fullscreen(request)
template = 'fullscreen' if fullscreen else 'query'
return self.render_template('explorer/%s.html' % template, vm)
def get(self, request, query_id):
query, form = QueryView.get_instance_and_form(request, query_id)
query.save() # updates the modified date
show = url_get_show(request)
rows = url_get_rows(request)
vm = query_viewmodel(request.user, query, form=form, run_query=show, rows=rows)
fullscreen = url_get_fullscreen(request)
template = 'fullscreen' if fullscreen else 'query'
return self.render_template('explorer/%s.html' % template, vm)
def post(self, request, query_id):
if not app_settings.EXPLORER_PERMISSION_CHANGE(request.user):
return HttpResponseRedirect(
reverse_lazy('query_detail', kwargs={'query_id': query_id}))
show = url_get_show(request)
query, form = QueryView.get_instance_and_form(request, query_id)
success = form.is_valid() and form.save()
vm = query_viewmodel(request,
query,
form=form,
run_query=show,
message="Query saved." if success else None)
return self.render_template('explorer/query.html', vm)
def post(self, request, query_id):
if not app_settings.EXPLORER_PERMISSION_CHANGE(request.user):
return HttpResponseRedirect(
reverse_lazy('query_detail', kwargs={'query_id': query_id})
)
show = url_get_show(request)
query, form = QueryView.get_instance_and_form(request, query_id)
success = form.is_valid() and form.save()
vm = query_viewmodel(request.user,
query,
form=form,
run_query=show,
rows=url_get_rows(request),
message="Query saved." if success else None)
return self.render_template('explorer/query.html', vm)
def post(self, request):
ret = super().post(request)
if self.get_form().is_valid():
show = url_get_show(request)
query, form = QueryView.get_instance_and_form(request, self.object.id)
success = form.is_valid() and form.save()
vm = query_viewmodel(
request.user,
query,
form=form,
run_query=show,
rows=url_get_rows(request),
page=url_get_page(request),
message="Query created." if success else None,
log=False,
)
if vm['form'].errors:
self.object.delete()
return self.render_template('explorer/query.html', vm)
return ret
def get(self, request, query_id):
query, form = QueryView.get_instance_and_form(request, query_id)
query.save() # updates the modified date
show = url_get_show(request) # if a query is timing out, it can be useful to nav to /query/id/?show=0
vm = query_viewmodel(request, query, form=form, run_query=show)
return self.render_template('explorer/query.html', vm)
def get(self, request, query_id):
query, form = QueryView.get_instance_and_form(request, query_id)
query.save() # updates the modified date
show = url_get_show(request)
vm = query_viewmodel(request, query, form=form, run_query=show)
return self.render_template('explorer/query.html', vm)
def post(self, request):
sql = request.POST.get('sql')
show = url_get_show(request)
query = Query(sql=sql, title="Playground", connection=request.POST.get('connection'))
run_query = True if show else False
return self.render_with_sql(request, query, run_query=run_query)
