The REST API for Between in python seems to not be working, I tried first storing my date as a DateTime, but that didn't work, so I switched it to a string and tried using ISOFormat but that errors out too, here's the code and error
def get_articles(self, days_tolerance: int = int(days_to_report)):
"""
Gets articles from the Appwrite Database for today that we haven't vectorized yet
"""
now = self.utils.get_now()
min_published_date = now - timedelta(days=days_tolerance)
print(f"Getting articles from {min_published_date} to {now}")
start = min_published_date.isoformat()
end = now.isoformat()
between = now - timedelta(days=days_tolerance / 2)
print(
f"Testing DateTime Between with ISO Strings: {between.isoformat()} is between {min_published_date.isoformat()} and {now.isoformat()}: {between.isoformat() > min_published_date.isoformat() and between.isoformat() < now.isoformat()}"
)
articles = self.db.list_documents(
APPWRITE_DB,
"articles",
[
Query.between(
"date",
json.dumps(start),
json.dumps(end),
),
Query.equal("used", False),
],
).get("documents")
print(f"Got articles: {articles}")
if len(articles) < 5:
search_response = self.utils.search("Crypto news today")
print(f"New articles found: {search_response}")
return self.db.list_documents(
APPWRITE_DB, "articles", [Query.between()]
)
and the error attached
this is a known issue. see https://github.com/appwrite/appwrite/issues/5650
oh
cool
?solved
Y'know, you can update the post title too
[SOLVED] Query.between in Python DateTime broken
Recommended threads
- Worker functions stuck on "Fetched 0 fun...
Appwrite Version: 1.9.0 Bug Description: The appwrite-worker-functions container gets stuck in an infinite loop logging "Fetched 0 functions..." while scheduled...
- Upgrading selfhost version?
It is okay to upgrade version to higher one, of my current version is 1.7.4 to 1.8.1. Is that safe to do cause my clients already have data on that? Also is a...
- I am using s3 for app storage but is it ...
_APP_STORAGE_DEVICE=s3 puts everything to the s3 storage but i need to be able to keep the function builds and site in the local and not waste the cloud storage...