CD2 - Try to use dap initdb to get all tables but table argement is required

[SunnyYeung]

I am trying to populate a database with ALL the tables in the Canvas namespace.

I am following the instructions on this documentation to initialize my database using the initdb command.

Below is my CLI:

dap initdb --connection-string my_connection_string --namespace canvas

but I get an error saying the table argument is required.

dap initdb: error: the following arguments are required: --table

Is there a way to get all the tables instead of running the initdb command manually for the 89 tables on the Canvas namespace?

Thanks!

[robotcars]

The commands are a little confusing at first, because they use 'db', but they are single table only.

dap --loglevel info --logfile courses.log initdb --namespace canvas --table courses;

[SunnyYeung]

Hi Robotcars,

Thanks for replying.

I tried your code but I got an error:
2024-09-11 17:33:57,268 - ERROR - 404, message='Not Found', url='https://api-gateway.instructure.com/dap/query/canvas/table/courses;/schema'

Is the "--loglevel info --logfile courses.log" part supposed to enable a complete initialization of all the tables or is that your custom command to log the activity of this line?

Is there a way to download all the tables or looping though them is the only way?

Thanks,

Sunny