1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
from django.views.generic import simple
from django.http import HttpResponse
from models import Master
import json
import time
def get_current(request):
#current = int(time.time())*1000000
#time.gmtime(Master.objects.using('nop').all()[6000].timestamp//1000000)
# select all where timestamp < givenTS, get most recent one -> order DESC
# reverse sorted. get the first object = last played
result = Master.objects.using('nop').all()[0]
response = json.dumps({'artist': result.artist, 'title': result.title})
#return HttpResponse(response, mimetype='application/json')
return HttpResponse(response, mimetype='text/plain')
def get(request, year=None, month=None, day=None, hour=None, minute=None):
try:
# tm_year,tm_mon,tm_mday,tm_hour,tm_min,tm_sec,tm_wday,tm_yday,tm_isdst
ts = int(time.mktime((
int(year),
int(month),
int(day),
int(hour),
int(minute),0,0,0,-1))) * 1000000
result = Master.objects.using('nop').filter(timestamp__lt=ts)[:5]
response = json.dumps(
[{'artist': item.artist, 'title': item.title, 'album': item.album,
'datetime': time.strftime('%Y-%m-%d %H:%M',
time.localtime(item.timestamp//1000000)),
'showtitle': item.showtitle} for item in result])
except: # all errors
response = ''
#return HttpResponse(response, mimetype='application/json')
return HttpResponse(response, mimetype='text/plain')
def nop_form(request):
extra_context = {'year':None, 'month':None, 'day':None, 'hour':None, 'minute': None}
if 'year' in request.GET:
pass
return simple.direct_to_template(request, extra_context=extra_context, template='nop/nop_form.html')
|
