0001-csvdatasource-remove-unused-view-CsvDataView-36789.patch
| passerelle/apps/csvdatasource/views.py | ||
|---|---|---|
| 16 | 16 | |
| 17 | 17 |
import os |
| 18 | 18 | |
| 19 |
from django.core.urlresolvers import reverse |
|
| 20 | 19 |
from django.http import HttpResponse |
| 21 | 20 |
from django.shortcuts import get_object_or_404 |
| 22 |
from django.views.generic.detail import SingleObjectMixin |
|
| 23 | 21 |
from django.views.generic import View, UpdateView, CreateView, DeleteView |
| 24 | 22 | |
| 25 |
from passerelle import utils |
|
| 26 | ||
| 27 | 23 |
from .forms import QueryForm |
| 28 | 24 |
from .models import CsvDataSource, Query |
| 29 | 25 | |
| 30 | 26 | |
| 31 |
class CsvDataView(View, SingleObjectMixin): |
|
| 32 |
model = CsvDataSource |
|
| 33 | ||
| 34 |
@utils.protected_api('can_access')
|
|
| 35 |
@utils.to_json() |
|
| 36 |
def get(self, request, *args, **kwargs): |
|
| 37 |
params = request.GET |
|
| 38 |
filters = [] |
|
| 39 |
for column_title in [t.strip() for t in self.get_object().columns_keynames.split(',') if t]:
|
|
| 40 |
if column_title in params.keys(): |
|
| 41 |
query_value = request.GET.get(column_title, '') |
|
| 42 |
if 'case-insensitive' in params: |
|
| 43 |
filters.append("%s.lower() == %r" % (column_title, query_value.lower()))
|
|
| 44 |
else: |
|
| 45 |
filters.append("%s == %r" % (column_title, query_value))
|
|
| 46 |
query = Query(filters='\n'.join(filters)) |
|
| 47 |
return self.get_object().execute_query(request, query, **params.dict()) |
|
| 48 | ||
| 49 | ||
| 50 | 27 |
class NewQueryView(CreateView): |
| 51 | 28 |
model = Query |
| 52 | 29 |
form_class = QueryForm |
| 53 |
- |
|