Back
AppwriteException (AppwriteException: , ClientException: Connection reset by peer)
- 0
- Self Hosted
- Functions
- Databases
I am tring to update 3000 + database records the permissions not the data .
TypeScript
import 'dart:async';
import 'dart:io';
import 'package:dart_appwrite/dart_appwrite.dart';
import 'package:starter_template/const.dart';
import 'package:starter_template/models/post.dart';
import 'package:starter_template/post_service.dart';
// This is your Appwrite function
// It's executed each time we get a request
Future<dynamic> main() async {
// Why not try the Appwrite SDK?
//
final client = Client()
.setEndpoint(Platform.environment['ENDPOINT']!)
.setProject(Platform.environment['APPWRITE_FUNCTION_PROJECT_ID'])
.setKey(Platform.environment['APPWRITE_API_KEY']);
final databases = Databases(client);
final x = await PostService(database: databases).getAllPosts();
print(x.length);
List<Future> futures = [];
for (var i = 0; i < x.length; i++) {
final post = x[i];
final d = databases.updateDocument(
databaseId: databaseID,
collectionId: postCOL,
documentId: post.id!,
//data: post.toJson(),
permissions: [
Permission.delete(Role.user(post.authorId!)),
Permission.update(Role.user(post.authorId!))
],
);
futures.add(d);
}
await Future.wait(futures);
exit(0);
}
TL;DR
- Update database records permissions by using pagination and creating smaller batches.
- Use the correct syntax for functions in Dart, refer to the Appwrite documentation.
- Ensure that the `Platform.environment` variables are correctly set.
- Issue could be due to attempting to update all records at once, causing a Connection Reset error.- use pagination & a slight delay to update all these docs' permissions. A single shot for updating (via
Futures) could fail. Create smaller batches. - use the correct syntax for functions, see - https://appwrite.io/docs/products/functions/develop#entrypoint and select
Dart. - make sure the
Platform.environmentare correctly set.
Recommended threads
- Can't really use the S3 storage device
hi, I've linked my local MinIO Instance (it's just for testing, not for prod.) to my appwrite instance, when i'm uploading a file it's getting uploaded to the S...
- Next.js SSR Site Times Out on First Visi...
Hey everyone, I'm running a Next.js SSR site on a self-hosted Appwrite server (v1.9.0), and I've noticed a strange behavior that I'm hoping someone can help me...
- Quota not resetting
hi, im using appwrite's free tier plani hit my read limts last month and the billing cycle said it would reset on june 4th but that is today, the billing cycle ...