ESGF / esg-publisher

ESGF Publisher
http://esg-publisher.readthedocs.org/
9 stars 22 forks source link

esgintialize incompatible with SQLAlchemy v1.3.0 #145

Open sashakames opened 5 years ago

sashakames commented 5 years ago

INFO 2019-03-12 15:35:22,812 Updating schema version directory to /usr/local/conda/envs/esgf-pub/lib/python2.7/site-packages/esgcet/schema_migration Traceback (most recent call last): File "/usr/local/conda/envs/esgf-pub/bin/esginitialize", line 195, in main(sys.argv[1:]) File "/usr/local/conda/envs/esgf-pub/bin/esginitialize", line 120, in main values={'repository_path':repo_path}) File "", line 1, in File "/usr/local/conda/envs/esgf-pub/lib/python2.7/site-packages/sqlalchemy/sql/selectable.py", line 1915, in update **kwargs File "/usr/local/conda/envs/esgf-pub/lib/python2.7/site-packages/sqlalchemy/sql/dml.py", line 762, in init self._whereclause = _literal_as_text(whereclause) File "/usr/local/conda/envs/esgf-pub/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 4471, in _literal_as_text return _literal_as(element, _no_text_coercion) File "/usr/local/conda/envs/esgf-pub/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 4457, in _literal_as return text_fallback(element) File "/usr/local/conda/envs/esgf-pub/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 4501, in _no_text_coercion "extra": "%s " % extra if extra else "", sqlalchemy.exc.ArgumentError: Textual SQL expression "repository_id='ESG-CET no..." should be explicitly declared as text("repository_id='ESG-CET no...")

sashakames commented 4 years ago

Need to test with Python3. we have upgraded