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
- How to use Sites on selfhosted appwrite
whenever I try to create a site even with template it says 404 nginx error
- How to send Webhooks to internal network
When saving the URL for sending Webhooks, Appwrite checks if it's a valid external domain name so entering internal IP address or docker hostnames won't save th...
- Collections list not showing up when try...
I'm trying to create new relationship attribute but both one way and two way relationship is not showing up collections list to connect with my relationship att...