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
- IMPORTANT! SOC-2 Request Failing
Issue requesting SOC-2. If tried other/private browser as well as filling in optional fields.
- Appwrite-injected variables are not avai...
I am using rust-1.83 as a runtime and try to access APPWRITE_FUNCTION_API_ENDPOINT or APPWRITE_FUNCTION_API_KEY during runtime. Both are not set during my execu...
- Can you suppress row $meta data?
When using listRows with a 'select' query to limit the response [for performance], I'm still getting extra columns (eg. `$id`, `$sequence`, `$createdAt`, `$upda...