ajwdewit / agera5tools Goto Github PK

Hello,

i'm trying to use agera5 as a weather data input to the model!
A few days ago I downloaded agera5 from the research area using the python package cdsapi. But I found out today that you have already developed one of these packages!

In your example you seem to be working on data that has already been downloaded locally, but I don't know what the example data looks like, can you please provide the example data?

And I would like to do an area-by-image simulation, how can this agera5tools package help me?

Thank you very much for taking your valuable time to develop such a python package and a python implementation of the WOFOST model, they have helped me a lot!

Problem:
sqlalchemy > 2.0 yield error message
sqlalchemy.exc.ArgumentError: expected schema argument to be a string, got <class 'sqlalchemy.engine.base.Engine'>.

Trial and error：
Followed the documentation on sqlalchemy website about creating sqlite db https://docs.sqlalchemy.org/en/20/core/engines.html#sqlite

changed the dsn argument value into a string with double quote in the configuration file
dsn: "sqlite:///C:\\Users\\GitRepos\\DataGathering\\Climate\\agera5.db"

Still not working

Tried installing an older version followed the suggestion https://github.com/Jacob-Stevens-Haas/tehom/issues/25#issuecomment-1630266724

WORKED

So the SOLUTION

pip uninstall sqlalchemy 

pip install sqlalchemy<2.0 

Documentation:
https://github.com/ajwdewit/agera5tools/edit/main/doc/user_guide.rst

In Google colab, the example code does not run because writing to /tmp is not permitted.
It would be good to allow the user to specify the working directory (e.g. $HOME/ager5tools).
In Google colab, this could /content/agera5tools.