Python

Search

how to append data in django queryset

def getDatat():
    qs = CustomerInformation.objects.filter(salesDepartment__in=[d]).filter(created_date__range=(start,end))
    qs = qs.annotate(date=TruncMonth('created_date')).values('date').annotate(lead_count=Count('status',filter=Q(status="lead"))).annotate(client_count=Count('status',filter=Q(status="client")))
    qs = qs.values('date', 'client_count', 'lead_count')
    this_v = None
    for next_v in qs:
         if this_v is None:
            this_v = next_v
            yield this_v
            continue
         # Do logic for checking if there's any needed extra values between this_v and next_V
         # yield extra values
         this_v = next_v
         yield this_v

Comment

PREVIOUS	NEXT

Code Example
Python :: how to convert string to int in python
Python :: datetime conversion
Python :: python print not working
Python :: List Get a Element
Python :: django edit object foreign key id
Python :: pandas filter
Python :: itertools count
Python :: insert in python
Python :: delete multiple dataframes at once in python
Python :: python pandas how to access a column
Python :: cache-control no cache django
Python :: python find length of list
Python :: python multidimensional dictionary
Python :: how to standardize the image data to have values between 0 and 1
Python :: leetcode python
Python :: python minimum
Python :: python webview
Python :: sort dataframe by function
Python :: python string: .upper()
Python :: array sort in python
Python :: matplotlib matshow log scale
Python :: python incrémentation
Python :: activate virtual environment python in linux
Python :: generating random numbers numpy
Python :: pass in python
Python :: discord.py get client avatar
Python :: opencv python install windows
Python :: Show all column names and indexes dataframe python
Python :: Sound alerts in Jupyter for code completion and exceptions
Python :: Python OPERATORS, Data Types: LIST, SET, TUPLE, DICTIONARY

Search

PYTHON

how to append data in django queryset

ADD CONTENT