def setup_database(request): message = None try: current_user = request.user.get_profile() except : UserProfile.objects.create(user=request.user).save() current_user = request.user.get_profile() if request.method == 'POST': form = user_profile_form(request.POST, instance=current_user) if form.is_valid(): form.save() if request.POST['database_engine'] == 'sqlite': try: f = request.FILES['sqlite_database_file']#get sqlite database file handle_uploaded_file(f, DATABASE_PATH,current_user.user.username + '.db') #Save file content to uploaded folder except : c = RequestContext(request) message = 'You must input sqlite file' return render_to_response("registration/database_setup.html", { 'form' : form, 'message' : message}, context_instance = c) else: form = user_profile_form(instance=current_user) c = RequestContext(request) return render_to_response("registration/database_setup.html", { 'form' : form}, context_instance = c)
def setup_database(request): message = None try: current_user = request.user.get_profile() except: UserProfile.objects.create(user=request.user).save() current_user = request.user.get_profile() if request.method == 'POST': form = user_profile_form(request.POST, instance=current_user) if form.is_valid(): form.save() if request.POST['database_engine'] == 'sqlite': try: f = request.FILES[ 'sqlite_database_file'] #get sqlite database file handle_uploaded_file( f, DATABASE_PATH, current_user.user.username + '.db') #Save file content to uploaded folder except: c = RequestContext(request) message = 'You must input sqlite file' return render_to_response("registration/database_setup.html", { 'form': form, 'message': message }, context_instance=c) else: form = user_profile_form(instance=current_user) c = RequestContext(request) return render_to_response("registration/database_setup.html", {'form': form}, context_instance=c)
def upload_file(request): #This function handle upload action message = None if request.method == 'POST': # If file fom is submitted form = upload_file_form(request.POST, request.FILES) if form.is_valid(): #Cheking form validate f = request.FILES['file'] fileName, fileExtension = os.path.splitext(f.name) if fileExtension != ('.xls'): message = 'wrong file extension' else: now = datetime.datetime.now() temp = Upload(filestore=str(now.year) + str(now.day) + str(now.month) + str(now.hour) + str(now.minute) + str(now.second) + f.name, filename=f.name, description=request.POST['description'], upload_time=datetime.datetime.now()) handle_uploaded_file( f, FILE_UPLOAD_PATH, temp.filestore) #Save file content to uploaded folder generator, response = generate(temp.filestore, request) if generator != "ok": message = generator c = RequestContext(request) os.remove(FILE_UPLOAD_PATH + '/' + temp.filestore) return render_to_response(UPLOAD, { 'form': form, 'message': message }, context_instance=c) else: temp.save() #Save file information into database message = "Uploaded successfully. Your uploaded and generated file will be stored shortly. You should download them in the file list page as soon as possible!" c = RequestContext(request) file_list = [temp] return render_to_response(FILE_LIST, { 'file_list': file_list, 'message': message }, context_instance=c) else: message = "Error" #return HttpResponseRedirect('http://127.0.0.1:8000/admin') else: #if file is not submitted that generate the upload form form = upload_file_form() c = RequestContext(request) return render_to_response(UPLOAD, { 'form': form, 'message': message }, context_instance=c)
def upload_file(request): # This function handle upload action message = None if request.method == "POST": # If file fom is submitted form = upload_file_form(request.POST, request.FILES) if form.is_valid(): # Cheking form validate f = request.FILES["file"] fileName, fileExtension = os.path.splitext(f.name) if fileExtension != (".xls"): message = "wrong file extension" else: now = datetime.datetime.now() temp = Upload( filestore=str(now.year) + str(now.day) + str(now.month) + str(now.hour) + str(now.minute) + str(now.second) + f.name, filename=f.name, description=request.POST["description"], upload_time=datetime.datetime.now(), ) handle_uploaded_file(f, FILE_UPLOAD_PATH, temp.filestore) # Save file content to uploaded folder generator, response = generate(temp.filestore, request) if generator != "ok": message = generator c = RequestContext(request) os.remove(FILE_UPLOAD_PATH + "/" + temp.filestore) return render_to_response(UPLOAD, {"form": form, "message": message}, context_instance=c) else: temp.save() # Save file information into database message = "Uploaded successfully. Your uploaded and generated file will be stored shortly. You should download them in the file list page as soon as possible!" c = RequestContext(request) file_list = [temp] return render_to_response( FILE_LIST, {"file_list": file_list, "message": message}, context_instance=c ) else: message = "Error" # return HttpResponseRedirect('http://127.0.0.1:8000/admin') else: # if file is not submitted that generate the upload form form = upload_file_form() c = RequestContext(request) return render_to_response(UPLOAD, {"form": form, "message": message}, context_instance=c)