def remove_views(apps, schema_editor):
# Remove materialized views for all queries of content type TestCase.
Query = apps.get_model("lava_results_app", "Query")
db_alias = schema_editor.connection.alias
for query in Query.objects.using(db_alias).all():
if query.content_type.model == "testcase":
QueryMaterializedView.drop(query.id)
def remove_views(apps, schema_editor):
# Remove materialized views for all queries of content type TestCase.
Query = apps.get_model("lava_results_app", "Query")
db_alias = schema_editor.connection.alias
for query in Query.objects.using(db_alias).filter(
content_type__model='testcase'):
QueryMaterializedView.drop(query.id)
def query_detail(request, username, name):
query = get_object_or_404(Query, owner__username=username, name=name)
query_conditions = query.serialize_conditions()
view_exists = QueryMaterializedView.view_exists(query.id)
return render_to_response(
'lava_results_app/query_detail.html', {
'query': query,
'query_conditions': query_conditions,
'view_exists': view_exists,
'bread_crumb_trail': BreadCrumbTrail.leading_to(
query_detail, username=username, name=name),
'context_help': BreadCrumbTrail.leading_to(query_list),
'condition_form': QueryConditionForm(
instance=None,
initial={'query': query, 'table': query.content_type}),
}, RequestContext(request)
)
def query_detail(request, username, name):
query = get_object_or_404(Query, owner__username=username, name=name)
query_conditions = Query.serialize_conditions(
query.querycondition_set.all())
view_exists = QueryMaterializedView.view_exists(query.id)
template = loader.get_template('lava_results_app/query_detail.html')
return HttpResponse(template.render(
{
'query': query,
'query_conditions': query_conditions,
'view_exists': view_exists,
'bread_crumb_trail': BreadCrumbTrail.leading_to(
query_detail, username=username, name=name),
'context_help': ['lava-queries-charts'],
'condition_form': QueryConditionForm(
instance=None,
initial={'query': query, 'table': query.content_type}),
}, request=request)
)
def handle(self, *args, **options):
for query in Query.objects.all().filter(is_live=False):
QueryMaterializedView.drop(query.id)