Hey I want to retrieve all documents using my python function, for which I am using pagination
I am getting this error: {"error":"Expecting value: line 1 column 1 (char 0)"}
(Also could you refer me docs/ examples for pagination in python, I couldn't really find anything)
This is my function
def main(req, res):
try:
client = Client()
if not req.variables.get('APPWRITE_FUNCTION_ENDPOINT') or not req.variables.get('APPWRITE_FUNCTION_API_KEY'):
print('Environment variables are not set. Function cannot use Appwrite SDK.')
else:
(
client
.set_endpoint(req.variables.get('APPWRITE_FUNCTION_ENDPOINT', None))
.set_project(req.variables.get('APPWRITE_FUNCTION_PROJECT_ID', None))
.set_key(req.variables.get('APPWRITE_FUNCTION_API_KEY', None))
.set_self_signed(True)
)
databases = Databases(client)
def fetch_documents(cursor):
all_docs = []
query_options = [
Query.orderDesc("age"),
Query.limit(25),
]
while True:
response = databases.list_documents(
'647ac763cf53ed9xxxxx',
'647ac820ba38520xxxxx',
query_options
)
try:
if cursor:
last_id = response['documents'][-1]['$id']
query_options.append(Query.cursorAfter(last_id))
cursor = False
documents = response['documents']
all_docs.extend(documents)
if len(documents) < 25:
break
last_id = documents[-1]['$id']
query_options[-1] = Query.cursorAfter(last_id)
except Exception as e:
all_docs = ["error"]
print(e)
break
return all_docs
return res.json({
"result": fetch_documents(True),
})
except Exception as e:
return res.json({
"error": str(e)
})```
The docs on pagination are here: https://appwrite.io/docs/pagination. The idea is the same, just change the syntax for python
How about you test that fetch documents function locally?
Also, did you create the endpoint variable? If so, what did you set the value to?
I set it to https://cloud.appwrite.io/v1
Yeah, actually that's what I tried😅
Okay, so I was debugging my code line by line, and I get this error
{"error":"type object 'Query' has no attribute 'orderDesc'"}
this is how I imported query from appwrite.query import Query
What am I doing wrong?
Query.orderDesc("age"),
Query.limit(25),
]
response = databases.list_documents(
'647ac763cf53edxxxxx',
'647ac820ba38520xxxx',
query_options
)```
um if I remove that query,
I get type object 'Query' has no attribute 'cursorAfter'
Are the name of functions different in python? Where can I find python version of these functions😢
Okay, I figured it out
Recommended threads
- Appwrite project paused
I have github student account. The auth has been paused however the database is working fine. I cant see any option to resume from my console panel. It is just ...
- MongoDb Database Breaks integer[] & bigi...
I've got a table with the below column created. When I try to insert the value `[-3408048000]` into it, the dart sdk cloud function call is successful (no error...
- Appwrite Functions cold start
Hello. I'm seeing really long cold starts on Appwrite Cloud Functions and wanted to know if this is expected. My function just authenticates the user, fetches ...