TaehoonK
commented
1 day ago Looking at the code in pygeoapi, there are two ways to create a table. 1) by specifying it in config.yaml 2) Using a backup file in the DB (but only for testing)
However, I believe that method 1) only works when creating a single table. We need to create multiple tables in our case, so we will have to use the SQL file like 2) for now.
I've asked Tom, the project's maintainer, about this. If I get an answer, I'll share it with you.
Is your feature request related to a problem? Please describe. The sql files were stored in the following folder
tests/data These SQL files were being called in the main.yml workflow file of GitHub Actions:
.gitHub/workflows/main.yml
Since these SQL files were only called within main.yml, I'm wondering if mf-api requires a similar process. Currently, it's unclear how to auto create tables from program, so the documentation instructs users to create them by executing commands.
You mentioned that I should refer to “records” in the web conference, I did not know specifically which part of the process.
Describe alternatives you've considered Could you please provide instructions on the process and necessary modifications for the relevant parts? I will then implement the changes accordingly.