elo | Electric Light Orchestration - telldusd / tdtool interface

The cause of the error is that you are calling sheet too many times, and each call is a request which takes time to process and ultimately leads to the timeout. The easy sounding solution is reduce the calls of sheet.getRange() and sheet.setValue() and sheet.getName() etc… so that you ideally do them once per each sheet you are working on. A simple example would be as follows, where everything is done once (except the api call, which ideally should also be done using a bulk api).

For me, you should replace association table (pool_user) with association model (UserPool).

You don't need to sort additionally already created indices , when you create indices in mongoDB you specify in what direction they need to be sorted(ascending(1) or descending(-1)) , so when you search multiple documents based on some field the result will be already sorted based on this field index order. Afcourse you can specify explicitly if you need the result in reverse order or sorted by other field.

Maybe this can be a starting spot for you. The serializer grabs the __dict__ attribute from the object and makes a new dict-of-dicts, then writes it to JSON. The deserializer creates a dummy object, then updates the __dict__ on the way in.

Firebase Realtime Database transactions run against a single path in your database. There is currently no way to run a transaction against multiple path, so the common approach is to run the transaction against the lowest-level shared path (/paintings in your case).

This can indeed lead to more contention as you have more users performing concurrent transactions.

The only alternative I've used at times is to build my own transaction mechanism using:

1. Multi-path updates, to perform both writes at the same time.
2. Security rules, to only allow the transition that make sense in my use-case.
3. Client-side retries, so that contention or outdated data are still handled correctly.

This is fairly non-trivial even for simple cases, and may require changing your data structure and/or adding additional values to each request. But if you get past those hurdles, it will allow you to run a "transaction" across multiple paths.

Do you just mean print it to the html page that you are looking at?

You can just put a div on the page where you are running this

and then

"FileNotFoundError" is the give-away. That means that the file you pass to getatime cannot be found. file is returned by os.walk, so you can be pretty sure it does actually exist, so why can't it be found? Because you need to provide the path to the file, and os.walk only returns the filename.

Try this instead:

Working example in Stackblitz