def upload(request):
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
new_file = UploadFile(file=request.FILES['file'],
user=request.user)
print(new_file)
new_file.save()
return HttpResponseRedirect(reverse('upload'))
else:
form = UploadFileForm()
uploads_root = settings.MEDIA_ROOT
json_table, json_columns = f.excel_to_json(
uploads_root + "/user_4/Data1_light.xlsx", 3)
models = f.get_models_details()
data = {
'form': form,
'table': json_table,
'columns': json_columns,
'table_models': models,
'user': request.user.id
}
#data=RequestContext(request, data2)
return render(request, 'app/OPEX/upload.html', data)
def get_json_table(request):
if request.method == 'GET':
uploads_root = settings.MEDIA_ROOT
file = request.GET['file']
user_id = request.GET['user_id']
json_table, json_columns = f.excel_to_json(
uploads_root + "/user_" + user_id + "/" + file, 3)
data = {'json_table': json_table, 'json_columns': json_columns}
data = json.dumps(data, cls=DjangoJSONEncoder)
return HttpResponse(data)