search

hotosm / galaxy-api

Backend to fetch data from Underpass
https://galaxy-api.hotosm.org/latest/redoc
GNU Affero General Public License v3.0
14 stars 5 forks source link

[BUG][DEV] Running /mapathon/detail #328

Closed NicolasGrosjean closed 2 years ago

NicolasGrosjean commented 2 years ago

Describe the bug

Even after following the README using the fixture files, there are issues when running the /mapathon/detail for example to try to reproduce #327

NicolasGrosjean commented 2 years ago

First issue:

  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/app.py", line 272, in get_mapathon_detailed_result
    total_contributors_result = self.database.executequery(
  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/app.py", line 156, in executequery
    raise err
  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/app.py", line 143, in executequery
    print_psycopg2_exception(err)
  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/app.py", line 85, in print_psycopg2_exception
    raise err
  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/app.py", line 135, in executequery
    self.cursor.execute(query)
  File "/home/nicolas/miniconda3/envs/galaxy/lib/python3.8/site-packages/psycopg2/extras.py", line 146, in execute
    return super().execute(query, vars)
psycopg2.errors.UndefinedFunction: function public.editors_per_user(bigint, unknown, unknown) does not exist
LINE 27:         public.editors_per_user(user_id,
                 ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
NicolasGrosjean commented 2 years ago

Second issue:

  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/app.py", line 299, in __init__
    self.database = Database(get_db_connection_params("TM"))
  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/config.py", line 101, in get_db_connection_params
    raise ex
  File "/home/nicolas/Documents/GitHub/galaxy-api/./src/galaxy/config.py", line 97, in get_db_connection_params
    connection_params = dict(config.items(dbIdentifier))
  File "/home/nicolas/miniconda3/envs/galaxy/lib/python3.8/configparser.py", line 849, in items
    raise NoSectionError(section)
configparser.NoSectionError: No section: 'TM'
NicolasGrosjean commented 2 years ago

The 2 issues were fixed by the above PR but we still need to add fixtures to this database.