1 from unfold.plugin import Plugin
3 from django.template.loader import render_to_string
5 # XXX We need naming helpers in the python Plugin class also, used in template
7 class QueryEditor(Plugin):
9 def template_file(self):
10 return "query_editor.html"
12 def requirements (self):
19 'css/query_editor.css',
26 def json_settings_list (self):
27 return ['plugin_uuid', 'domid', 'query_uuid']
29 def export_json_settings (self):
32 def template_env(self, request):
34 metadata = self.page.get_metadata()
35 md_fields = metadata.details_by_object('resource')
37 # XXX use django templating system here
38 for md_field in md_fields['column']:
40 if md_field['type'] == 'string':
41 if 'allowed_values' in md_field:
42 allowed_values = md_field['allowed_values'].split(',')
45 for v in allowed_values:
47 options.append(v_desc[0])
53 filter_input = render_to_string('filter_input_string_values.html', env)
57 'field': md_field['name']
59 filter_input = render_to_string('filter_input_string.html', env)
61 elif md_field['type'] == 'int':
62 allowed_values = md_field.get('allowed_values', '0,0').split(',')
65 'field': md_field['name'],
66 'min' : allowed_values[0],
67 'max' : allowed_values[1]
69 filter_input = render_to_string('filter_input_integer.html', env)
73 'field': md_field['name']
75 filter_input = render_to_string('filter_input_others.html', env)
78 'name': md_field['name'],
79 'type': md_field['type'],
80 'resource_type': 'N/A',
81 'filter_input': filter_input,
83 'checked': md_field['name'] in self.query.get_select()
85 return { 'fields': fields }