Django model and views to summarize and plot an uploaded CSV











up vote
1
down vote

favorite












I have a simple web application where a user uploads a CSV of some dataset and some summary statistics and box plots are displayed. I heard that it is better to have so called skinny views and fat models, though I'm unsure how is best to divide the work. How could I improve my database schema and division of labour?



views.py



class HomeView(View):
"""View that handles when users land on the homepage"""

def get(self, request):
return render(request, 'summary/home.html')

# Will currently raise an HttpResponseNotAllowed if POST request received to home

@method_decorator(login_required, name='dispatch')
class UploadView(TemplateView):
"""Users land here after successfully signing in and are prompted to upload a CSV file"""
form_class = UploadFileForm
template_name = 'summary/uploads.html'

def get(self, request):
form = self.form_class()
datasets = Dataset.objects.filter(user=request.user)
context = {
'datasets': datasets,
'csv_form': form,
'within_dataset_limit': request.user.within_dataset_limit()
}
return render(request, self.template_name, context=context)

def post(self, request):
form = self.form_class(request.POST, request.FILES)
if form.is_valid():
uploaded_file = request.FILES['dataset_file']
datasets = Dataset.objects.filter(user=request.user)
context = {
'datasets': datasets,
'csv_form': form,
'within_dataset_limit': request.user.within_dataset_limit(),
}
# Check the file is a CSV
if not str(uploaded_file).lower().endswith('.csv'):
context['error'] = 'File not in CSV format.'
return render(request, 'summary/uploads.html', context)
# Check the file size is within the set limit
elif not 0 < uploaded_file.size < request.user.max_dataset_size:
context['error'] = 'File exceeds size limit.'
return render(request, 'summary/uploads.html', context)
else:
ds = Dataset(user=request.user, dataset_name=str(uploaded_file), dataset_file=uploaded_file)
ds.save()
return redirect(f'/{request.user.pk}/{ds.id}/overview/')

@method_decorator(login_required, name='dispatch')
class OverviewView(TemplateView):
"""Display head and summary statistics of the uploaded dataset"""
template_name = 'summary/overview.html'

def get(self, request, upk, dpk):
if request.user.pk == upk:
ds = Dataset.objects.get(pk=dpk)
head, summary, df = dataset_stats(ds)
request.session['dataframe'] = df.to_json()
context = {
'first_five': head,
'summary_stats': summary,
}
return render(request, self.template_name, context)

def delete_dataset(request, upk, dpk):
if request.method == 'POST':
if request.user.is_authenticated and request.user.pk == upk:
try:
ds = Dataset.objects.get(pk=dpk)
os.remove(ds.dataset_file.path)
ds.delete()
return HttpResponse(status=200)
except Dataset.DoesNotExist:
return HttpResponseNotFound()
return HttpResponseForbidden()
return HttpResponseBadRequest()

def boxplot(request):
"""Generation of boxplots to be moved to computation server"""
# Get the selected columns from the overview view
selected_columns = request.GET['selectedColumns']
selected_columns = json.loads(selected_columns)
code, boxplot_html = generate_plots(selected_columns, request.session.get('dataframe'))
if boxplot_html is not None:
return HttpResponse(status=code, content=boxplot_html)
else:
error = "Could not create your plots"
return HttpResponse(status=code, content=error)


models.py



def get_upload_path(instance, filename):
return "user_{}/{}".format(instance.user.pk, filename)

class Dataset(models.Model):
user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, null=True)
dataset_name = models.CharField(max_length=100)
date_added = models.DateTimeField(auto_now_add=True)
dataset_file = models.FileField(upload_to=get_upload_path)

def __str__(self):
return self.dataset_name

def save(self, *args, **kwargs):
user = CustomUser.objects.get(username=self.user)
if user.num_datasets == user.max_datasets:
return # Exceeding the max number of datasets
else:
user.num_datasets += 1
user.save()
super().save(*args, **kwargs)

def delete(self, *args, **kwargs):
user = CustomUser.objects.get(username=self.user)
user.num_datasets -= 1
user.save()
super().delete(*args, **kwargs)









share|improve this question









New contributor




awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
























    up vote
    1
    down vote

    favorite












    I have a simple web application where a user uploads a CSV of some dataset and some summary statistics and box plots are displayed. I heard that it is better to have so called skinny views and fat models, though I'm unsure how is best to divide the work. How could I improve my database schema and division of labour?



    views.py



    class HomeView(View):
    """View that handles when users land on the homepage"""

    def get(self, request):
    return render(request, 'summary/home.html')

    # Will currently raise an HttpResponseNotAllowed if POST request received to home

    @method_decorator(login_required, name='dispatch')
    class UploadView(TemplateView):
    """Users land here after successfully signing in and are prompted to upload a CSV file"""
    form_class = UploadFileForm
    template_name = 'summary/uploads.html'

    def get(self, request):
    form = self.form_class()
    datasets = Dataset.objects.filter(user=request.user)
    context = {
    'datasets': datasets,
    'csv_form': form,
    'within_dataset_limit': request.user.within_dataset_limit()
    }
    return render(request, self.template_name, context=context)

    def post(self, request):
    form = self.form_class(request.POST, request.FILES)
    if form.is_valid():
    uploaded_file = request.FILES['dataset_file']
    datasets = Dataset.objects.filter(user=request.user)
    context = {
    'datasets': datasets,
    'csv_form': form,
    'within_dataset_limit': request.user.within_dataset_limit(),
    }
    # Check the file is a CSV
    if not str(uploaded_file).lower().endswith('.csv'):
    context['error'] = 'File not in CSV format.'
    return render(request, 'summary/uploads.html', context)
    # Check the file size is within the set limit
    elif not 0 < uploaded_file.size < request.user.max_dataset_size:
    context['error'] = 'File exceeds size limit.'
    return render(request, 'summary/uploads.html', context)
    else:
    ds = Dataset(user=request.user, dataset_name=str(uploaded_file), dataset_file=uploaded_file)
    ds.save()
    return redirect(f'/{request.user.pk}/{ds.id}/overview/')

    @method_decorator(login_required, name='dispatch')
    class OverviewView(TemplateView):
    """Display head and summary statistics of the uploaded dataset"""
    template_name = 'summary/overview.html'

    def get(self, request, upk, dpk):
    if request.user.pk == upk:
    ds = Dataset.objects.get(pk=dpk)
    head, summary, df = dataset_stats(ds)
    request.session['dataframe'] = df.to_json()
    context = {
    'first_five': head,
    'summary_stats': summary,
    }
    return render(request, self.template_name, context)

    def delete_dataset(request, upk, dpk):
    if request.method == 'POST':
    if request.user.is_authenticated and request.user.pk == upk:
    try:
    ds = Dataset.objects.get(pk=dpk)
    os.remove(ds.dataset_file.path)
    ds.delete()
    return HttpResponse(status=200)
    except Dataset.DoesNotExist:
    return HttpResponseNotFound()
    return HttpResponseForbidden()
    return HttpResponseBadRequest()

    def boxplot(request):
    """Generation of boxplots to be moved to computation server"""
    # Get the selected columns from the overview view
    selected_columns = request.GET['selectedColumns']
    selected_columns = json.loads(selected_columns)
    code, boxplot_html = generate_plots(selected_columns, request.session.get('dataframe'))
    if boxplot_html is not None:
    return HttpResponse(status=code, content=boxplot_html)
    else:
    error = "Could not create your plots"
    return HttpResponse(status=code, content=error)


    models.py



    def get_upload_path(instance, filename):
    return "user_{}/{}".format(instance.user.pk, filename)

    class Dataset(models.Model):
    user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, null=True)
    dataset_name = models.CharField(max_length=100)
    date_added = models.DateTimeField(auto_now_add=True)
    dataset_file = models.FileField(upload_to=get_upload_path)

    def __str__(self):
    return self.dataset_name

    def save(self, *args, **kwargs):
    user = CustomUser.objects.get(username=self.user)
    if user.num_datasets == user.max_datasets:
    return # Exceeding the max number of datasets
    else:
    user.num_datasets += 1
    user.save()
    super().save(*args, **kwargs)

    def delete(self, *args, **kwargs):
    user = CustomUser.objects.get(username=self.user)
    user.num_datasets -= 1
    user.save()
    super().delete(*args, **kwargs)









    share|improve this question









    New contributor




    awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






















      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I have a simple web application where a user uploads a CSV of some dataset and some summary statistics and box plots are displayed. I heard that it is better to have so called skinny views and fat models, though I'm unsure how is best to divide the work. How could I improve my database schema and division of labour?



      views.py



      class HomeView(View):
      """View that handles when users land on the homepage"""

      def get(self, request):
      return render(request, 'summary/home.html')

      # Will currently raise an HttpResponseNotAllowed if POST request received to home

      @method_decorator(login_required, name='dispatch')
      class UploadView(TemplateView):
      """Users land here after successfully signing in and are prompted to upload a CSV file"""
      form_class = UploadFileForm
      template_name = 'summary/uploads.html'

      def get(self, request):
      form = self.form_class()
      datasets = Dataset.objects.filter(user=request.user)
      context = {
      'datasets': datasets,
      'csv_form': form,
      'within_dataset_limit': request.user.within_dataset_limit()
      }
      return render(request, self.template_name, context=context)

      def post(self, request):
      form = self.form_class(request.POST, request.FILES)
      if form.is_valid():
      uploaded_file = request.FILES['dataset_file']
      datasets = Dataset.objects.filter(user=request.user)
      context = {
      'datasets': datasets,
      'csv_form': form,
      'within_dataset_limit': request.user.within_dataset_limit(),
      }
      # Check the file is a CSV
      if not str(uploaded_file).lower().endswith('.csv'):
      context['error'] = 'File not in CSV format.'
      return render(request, 'summary/uploads.html', context)
      # Check the file size is within the set limit
      elif not 0 < uploaded_file.size < request.user.max_dataset_size:
      context['error'] = 'File exceeds size limit.'
      return render(request, 'summary/uploads.html', context)
      else:
      ds = Dataset(user=request.user, dataset_name=str(uploaded_file), dataset_file=uploaded_file)
      ds.save()
      return redirect(f'/{request.user.pk}/{ds.id}/overview/')

      @method_decorator(login_required, name='dispatch')
      class OverviewView(TemplateView):
      """Display head and summary statistics of the uploaded dataset"""
      template_name = 'summary/overview.html'

      def get(self, request, upk, dpk):
      if request.user.pk == upk:
      ds = Dataset.objects.get(pk=dpk)
      head, summary, df = dataset_stats(ds)
      request.session['dataframe'] = df.to_json()
      context = {
      'first_five': head,
      'summary_stats': summary,
      }
      return render(request, self.template_name, context)

      def delete_dataset(request, upk, dpk):
      if request.method == 'POST':
      if request.user.is_authenticated and request.user.pk == upk:
      try:
      ds = Dataset.objects.get(pk=dpk)
      os.remove(ds.dataset_file.path)
      ds.delete()
      return HttpResponse(status=200)
      except Dataset.DoesNotExist:
      return HttpResponseNotFound()
      return HttpResponseForbidden()
      return HttpResponseBadRequest()

      def boxplot(request):
      """Generation of boxplots to be moved to computation server"""
      # Get the selected columns from the overview view
      selected_columns = request.GET['selectedColumns']
      selected_columns = json.loads(selected_columns)
      code, boxplot_html = generate_plots(selected_columns, request.session.get('dataframe'))
      if boxplot_html is not None:
      return HttpResponse(status=code, content=boxplot_html)
      else:
      error = "Could not create your plots"
      return HttpResponse(status=code, content=error)


      models.py



      def get_upload_path(instance, filename):
      return "user_{}/{}".format(instance.user.pk, filename)

      class Dataset(models.Model):
      user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, null=True)
      dataset_name = models.CharField(max_length=100)
      date_added = models.DateTimeField(auto_now_add=True)
      dataset_file = models.FileField(upload_to=get_upload_path)

      def __str__(self):
      return self.dataset_name

      def save(self, *args, **kwargs):
      user = CustomUser.objects.get(username=self.user)
      if user.num_datasets == user.max_datasets:
      return # Exceeding the max number of datasets
      else:
      user.num_datasets += 1
      user.save()
      super().save(*args, **kwargs)

      def delete(self, *args, **kwargs):
      user = CustomUser.objects.get(username=self.user)
      user.num_datasets -= 1
      user.save()
      super().delete(*args, **kwargs)









      share|improve this question









      New contributor




      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      I have a simple web application where a user uploads a CSV of some dataset and some summary statistics and box plots are displayed. I heard that it is better to have so called skinny views and fat models, though I'm unsure how is best to divide the work. How could I improve my database schema and division of labour?



      views.py



      class HomeView(View):
      """View that handles when users land on the homepage"""

      def get(self, request):
      return render(request, 'summary/home.html')

      # Will currently raise an HttpResponseNotAllowed if POST request received to home

      @method_decorator(login_required, name='dispatch')
      class UploadView(TemplateView):
      """Users land here after successfully signing in and are prompted to upload a CSV file"""
      form_class = UploadFileForm
      template_name = 'summary/uploads.html'

      def get(self, request):
      form = self.form_class()
      datasets = Dataset.objects.filter(user=request.user)
      context = {
      'datasets': datasets,
      'csv_form': form,
      'within_dataset_limit': request.user.within_dataset_limit()
      }
      return render(request, self.template_name, context=context)

      def post(self, request):
      form = self.form_class(request.POST, request.FILES)
      if form.is_valid():
      uploaded_file = request.FILES['dataset_file']
      datasets = Dataset.objects.filter(user=request.user)
      context = {
      'datasets': datasets,
      'csv_form': form,
      'within_dataset_limit': request.user.within_dataset_limit(),
      }
      # Check the file is a CSV
      if not str(uploaded_file).lower().endswith('.csv'):
      context['error'] = 'File not in CSV format.'
      return render(request, 'summary/uploads.html', context)
      # Check the file size is within the set limit
      elif not 0 < uploaded_file.size < request.user.max_dataset_size:
      context['error'] = 'File exceeds size limit.'
      return render(request, 'summary/uploads.html', context)
      else:
      ds = Dataset(user=request.user, dataset_name=str(uploaded_file), dataset_file=uploaded_file)
      ds.save()
      return redirect(f'/{request.user.pk}/{ds.id}/overview/')

      @method_decorator(login_required, name='dispatch')
      class OverviewView(TemplateView):
      """Display head and summary statistics of the uploaded dataset"""
      template_name = 'summary/overview.html'

      def get(self, request, upk, dpk):
      if request.user.pk == upk:
      ds = Dataset.objects.get(pk=dpk)
      head, summary, df = dataset_stats(ds)
      request.session['dataframe'] = df.to_json()
      context = {
      'first_five': head,
      'summary_stats': summary,
      }
      return render(request, self.template_name, context)

      def delete_dataset(request, upk, dpk):
      if request.method == 'POST':
      if request.user.is_authenticated and request.user.pk == upk:
      try:
      ds = Dataset.objects.get(pk=dpk)
      os.remove(ds.dataset_file.path)
      ds.delete()
      return HttpResponse(status=200)
      except Dataset.DoesNotExist:
      return HttpResponseNotFound()
      return HttpResponseForbidden()
      return HttpResponseBadRequest()

      def boxplot(request):
      """Generation of boxplots to be moved to computation server"""
      # Get the selected columns from the overview view
      selected_columns = request.GET['selectedColumns']
      selected_columns = json.loads(selected_columns)
      code, boxplot_html = generate_plots(selected_columns, request.session.get('dataframe'))
      if boxplot_html is not None:
      return HttpResponse(status=code, content=boxplot_html)
      else:
      error = "Could not create your plots"
      return HttpResponse(status=code, content=error)


      models.py



      def get_upload_path(instance, filename):
      return "user_{}/{}".format(instance.user.pk, filename)

      class Dataset(models.Model):
      user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, null=True)
      dataset_name = models.CharField(max_length=100)
      date_added = models.DateTimeField(auto_now_add=True)
      dataset_file = models.FileField(upload_to=get_upload_path)

      def __str__(self):
      return self.dataset_name

      def save(self, *args, **kwargs):
      user = CustomUser.objects.get(username=self.user)
      if user.num_datasets == user.max_datasets:
      return # Exceeding the max number of datasets
      else:
      user.num_datasets += 1
      user.save()
      super().save(*args, **kwargs)

      def delete(self, *args, **kwargs):
      user = CustomUser.objects.get(username=self.user)
      user.num_datasets -= 1
      user.save()
      super().delete(*args, **kwargs)






      python django






      share|improve this question









      New contributor




      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited yesterday









      200_success

      127k15148412




      127k15148412






      New contributor




      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 2 days ago









      awcot

      61




      61




      New contributor




      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      awcot is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.



























          active

          oldest

          votes











          Your Answer





          StackExchange.ifUsing("editor", function () {
          return StackExchange.using("mathjaxEditing", function () {
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["\$", "\$"]]);
          });
          });
          }, "mathjax-editing");

          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "196"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          awcot is a new contributor. Be nice, and check out our Code of Conduct.










           

          draft saved


          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcodereview.stackexchange.com%2fquestions%2f208478%2fdjango-model-and-views-to-summarize-and-plot-an-uploaded-csv%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          awcot is a new contributor. Be nice, and check out our Code of Conduct.










           

          draft saved


          draft discarded


















          awcot is a new contributor. Be nice, and check out our Code of Conduct.













          awcot is a new contributor. Be nice, and check out our Code of Conduct.












          awcot is a new contributor. Be nice, and check out our Code of Conduct.















           


          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcodereview.stackexchange.com%2fquestions%2f208478%2fdjango-model-and-views-to-summarize-and-plot-an-uploaded-csv%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Mont Emei

          Province de Neuquén

          Journaliste