Django + Postgre +高图

2024-05-02 • 问答

如何计算来自Django的Postgresql数据库上的行并使用highchart显示？

例如：我想显示第二天从早上7.00到早上7.00有多少记录/行。

型号：

from django.db import models
   from datetime import datetime,date

class hujan(models.Model):
    id = models.AutoField(primary_key=True)
    tanggal = models.DateTimeField(auto_now_add=True)
    dtinms = models.IntegerField()
    hujan = models.FloatField()

序列化器：

from rest_framework import serializers
from .models import hujan,cahayasuhukelembapan

class hujanSerializer(serializers.ModelSerializer):
    class Meta:
        model = hujan
        fields = ('tanggal','dtinms','hujan')

观看次数：

from django.shortcuts import render,get_object_or_404
from django.http import HttpResponse,JsonResponse
from rest_framework.views import APIView
from rest_framework.response import Response
from rest_framework.renderers import TemplateHTMLRenderer
from .models import hujan
from .serializers import hujanSerializer

def homePageView(request):
  return render(request,'homepage.html')

class hujanlistall(APIView):
    def get(self,request):
        Hujan = hujan.objects.all()
        serializer = hujanSerializer(Hujan,many=True)
        return JsonResponse(serializer.data,safe=False)

public function add(Request $request) { $emails = $request->input('email'); $primary = $request->input('primary'); $ban = $request->input('ban'); $invalid = $request->input('invalid'); $emailAddresses = array(); $i = 0; foreach ($emails as $emailKey => $emailValue) { $emailAddresses[$emailKey] = [ 'emailAddress' => $emailValue,'invalid' => $invalid[$i]?$invalid[$i]:'','lower' => $emailAddresses,'ban' => $ban[$i]?$ban[$i]:'','primary' => $primary[$i]?$primary[$i]:'' ]; $i++; } dd($emailAddresses); }

Django + Postgre +高图

lanyangyang1 回答：Django + Postgre +高图

大家都在问