logviewer/devices/views.py

   1 from django.shortcuts import render
   2 from django.http import HttpResponse, HttpRequest
   3 import os
   4 import sqlite3
   5 import time
   6 import json
   7 import pprint
   8
   9 from django.views.decorators.csrf import csrf_exempt
  10
  11 def load_db(query):
  12     dir_list = os.listdir("logs/")
  13     connection = sqlite3.connect("logs/"+dir_list[0])
  14     #connection.row_factory = lambda cursor, row: row[0]
  15     cursor = connection.cursor()
  16     rows = cursor.execute(query).fetchall()
  17     return(rows)
  18
  19 @csrf_exempt
  20 def index(request,devicename):
  21     dev=list(load_db("select cast(device as text) from devices where devkey = \""+devicename+"\""))
  22     (dev_info,) = dev[0]
  23     #dev_string = "{ \"recordsTotal\": "+str(dev_count)+", \"data\": ["
  24     #dev_list = list(load_db("select cast(device as text) from devices limit 50"))
  25     #for device in dev_list:
  26     #    (dev,) = device
  27     #    dev_string = dev_string + dev + ","
  28     #dev_string = dev_string[:-1]
  29     #dev_string = dev_string + "],\"draw\": 5,\"recordsFiltered\": "+str(dev_count)+"}"
  30     return HttpResponse(dev_info, content_type='text/json')
  31