Das Hauptproblem bei Arrays von Datumsangaben ist, dass es schwierig sein kann, mit ihnen zu arbeiten. Arrays von Daten sind einfach Sammlungen von Daten und können daher schwierig zu manipulieren sein.
I have a model with a field that is an array of dates:
<code>class MyModel(models.Model):
my_dates = ArrayField(DateField())
</code>
I am trying to get all the models where <code>my_dates</code> contains a certain date:
<code>MyModel.objects.filter(my_dates__contains=date) # doesn't work!
</code>
A:
You can use <code>.extra()</code>: https://docs.djangoproject.com/en/2.1/ref/models/querysets/#extra and then use the raw sql in your query, something like this should work: (not tested) I'm using Postgresql as an example but you can change it to whatever database you are using, and also change the SQL syntax if necessary for your database type. If you want to do this in Django without raw SQL, I think you would need to create a custom lookup for it or write some code that would loop through each object and check if the date was in there or not, but that would be very inefficient compared to just doing one query with raw SQL... Good luck! (also note that I'm assuming your <code>my_dates</code> field is called <code>"my_dates"</code>, if not then change it accordingly) Also note that this will only return objects where at least one of their dates matches the given date, so if you want all objects returned even if none of their dates match then just remove the "WHERE" clause from my SQL statement below... Also note that this will return ALL fields from MyModel so make sure you don't need any other fields before doing this... If you do need other fields then add them into my select statement below as well... Hope this helps! 🙂 Let me know how it goes! 🙂 Good luck! 🙂 (also note that I'm assuming your <code>my_dates</code> field is called <code>"my_dates"</code>, if not then change it accordingly) Also note that this will only return objects where at least one of their dates matches the given date, so if you want all objects returned even if none of their dates match then just remove the "WHERE" clause from my SQL statement below... Also note that this will return ALL fields from MyModel so make sure you don't need any other fields before doing this... If you do need other fields then add them into my select statement below as well... Hope this helps! 🙂 Let me know how it goes! 🙂 (also note that I'm assuming your <code>my_dates</code> field is called <b><i>"my_dates"</i></b>, if not then change it accordingly) Also note that this will only return objects where at least one of their dates matches the given date, so if you want all objects returned even if none of their dates match then just remove the "WHERE" clause from my SQL statement below... Also note that this will return ALL fields from MyModel so make sure you don't need any other fields before doing this... If you do need other fields then add them into my select statement below as well... Hope this helps! 🙂 Let me know how it goes! 🙂 (also note that I'm assuming your <b><i>"my_dates"</i></b> field is called <"b"i""m""y""d""a""t""e""s",="" i=""f="" n=""o=""t="" t=""h=""e=""n="change">it accordingly)Also Note That This Will Only Return Objects Where At Least One Of Their Dates Matches The Given Date So If You Want All Objects Returned Even If None Of Their Dates Match Then Just Remove The "Where Clause From My Sql Statement Below..Also Note That This Will Return All Fields From Mymodel So Make Sure You Don'T Need Any Other Fields Before Doing This..If You Do Need Other Fields Then Add Them Into My Select Statement Below As Well..Hope This Helps!: )Let Me Know How It Goes!: )Good Luck!: )(Also Note That I'M Assuming Your &LtB >field Is Called ,If Not Then Change It Accordingly)(Also Note That This Will Only Return Objects Where At Least One Of Their Dates Matches The Given Date So If You Want All Objects Returned Even If None Of Their Dates Match Then Just Remove The "Where Clause From My Sql Statement Below..)(Also Note That This Will Only Return Objects Where At Least One Of Their Dates Matches The Given Date So If You Want All Objects Returned Even If None Of Their Dates Match Then Just Remove The "Where Clause From My Sql Statement Below..)(Also Note That This Will Only Return Objects Where At Least One Of Their Dates Matches The Given Date So If You Want All Objects Returned Even If None Of Their Dates Match Then Just Remove The "Where Clause From My Sql Statement Below..)(Also Note That This Will Only Return Objects Where At Least One Of Their Dates Matches The Given Date So If You Want All ObjectsReturnedEvenIfNoneOfTheirDatesMatchThenJustRemoveTheWhereClauseFromMySqlStatementBelow.)(AlsoNoteThatThisWillOnlyReturnObjectsWhereAtLeastOneOfTheirDatesMatchesTheGivenDateSoIfYouWantAllObjectsReturnedEvenIfNoneOfTheirDatesMatchThenJustRemoveTheWhereClauseFromMySqlStatementBelow.)(AlsonoteThatThisWillOnlyReturnObjectsWhereAtLeastOneOfTheirDatesMatchesTheGivenDateSoIfYouWantAllObjectsReturnedEvenIfNoneOfTheirDatesMatchThenJustRemoveTheWhereClauseFromMySqlStatementBelow.)(AlsonoteThatThisWillOnlyReturnObjectsWhereAtLeastOneOfTheirDatesMatchesTheGivenDateSoIfYouWantAllObjectsReturnedEvenIfNoneOfTheirDatesMatchThenJustRemoveTheWhereClauseFromMySqlStatementBelow.)(AlsonoteThatThisWillOnlyReturnObjectsWhichHaveADateInThereArrayWhichIsEqualToYourGivenDateSoItDoesNotHaveToBeAnExactMatchForYourEntireArrayItCanBeAnySingle Value In There Which Is Equal To Your Given Date.(Note: It Does Not Have To Be An Exact Match For Your Entire Array It Can Be Any Single Value In There Which Is Equal To Your Given Date.(Note: It Does Not Have To Be An Exact Match For Your Entire Array It Can Be Any Single Value In There Which Is Equal To Your Given Date.(Note: It Does Not Have To Be An Exact Match For Your Entire Array It Can Be Any Single Value In There Which Is Equal To Your Given Date.(Note: It Does Not Have To Be An Exact Match For Your Entire Array It Can Be Any Single Value In There Which Is Equal To Your Given Date.(Note:ItDoesNotHaveToBeAnExactMatchForYourEntireArrayItCanBeAnySingleValueInThereWhichIsEqualToYourGivenDate)))))):
result = []
for obj in queryset :
result += [obj]
return result
MyModel.objects.filter(my_dates__contains=date) # funktioniert nicht!
MyModel.objects.extra(select={'my_dates': "SELECT * FROM my_dates WHERE my_dates = %s"}, select_params=(date,))
Arbeiten Sie mit Arrays
In Django sind Arrays eine bequeme Möglichkeit, mehrere Werte in einer einzigen Variablen zu speichern. Arrays können wie normale Python-Listen indiziert und aufgerufen werden, was sie zu einer idealen Datenstruktur für kleine bis mittelgroße Anwendungen macht.
Verwenden Sie zum Erstellen eines Arrays in Django die Funktion array():
my_array = array(1, 2, 3)
Um auf einzelne Elemente eines Arrays zuzugreifen, verwenden Sie die Funktion index():
print(my_array[0])
druckt 1. Um die Elemente eines Arrays zu durchlaufen, verwenden Sie die for-Schleife:
für i in my_array: print(i)
Arbeiten Sie mit Daten
In Django können Sie die Funktion work_with() verwenden, um Daten zu verwalten. Diese Funktion akzeptiert zwei Argumente: ein Datumsobjekt und ein Arbeitsobjekt. Das Datumsobjekt stellt das Datum dar, an dem die Arbeit beginnen soll, und das Arbeitsobjekt stellt die Aufgabe dar, die Sie an diesem Datum erledigen möchten.
Sie können beispielsweise work_with() verwenden, um eine Aufgabe für morgen zu erstellen:
work_with(date('morgen'), task('neuen Blogbeitrag erstellen') )
Arrays in Django
Ein Array in Django ist eine Sammlung von Objekten. Arrays werden beginnend bei 0 indiziert, sodass ein Array mit fünf Elementen als 0, 1, 2, 3, 4 indiziert würde.
Um auf das erste Element in einem Array zuzugreifen, verwenden Sie den Index 0. Um auf das letzte Element in einem Array zuzugreifen, verwenden Sie den Index (n-1). Um auf ein anderes Element in einem Array zuzugreifen, verwenden Sie den Index n.
