[ARCHIVED] How to convert schema.json to SQL DDL statements?

[olibar]

I hope you are all doing well.

I am trying to convert the schema.json file that I get when using the Canvas Data API to SQL DDL so I can build tables
inside my database.
However, I am unable to find a tool or program that can convert the JSON
schema into SQL.

Is there any program or tool that you all use to convert the JSON file into DDL?
Can anyone share with me the DDL?

How do you process the schema.json file at your organization?

Thank you very much.

Ramiro Oliva

Boston College

[will_wyatt]

I did this. It ended up being a bit more compliated than I thought it would be. Lots of issue like Oracle 11g identifier length restrictions, what are the field types, etc., etc. I ended up writing code to fetch the schema from instructure, apply a bunch of transformations for naming conventions and length, output SQL for tables, primary and foreign keys. The code generates create and drop statement files for Oracle. I need to clean it up a little bit, but will try to put the whole project in a public source repo early next week.

In addition, the code can fetch dumps using the standard cavasDataCli and then insert those dumps against the schema that was parsed and converted into database DDL. Sorry I can't post it today, but I'll make every effort to do so early next week.

[olibar]

Thank you very much Will.

I appreciate any help you can share.

Ramiro

[olibar]

Hi Will,

I hope you are doing well.

Just wanted to follow up with on this.

Any help is appreciated.

Ramiro

[will_wyatt]

Here is a gist of what my code generated for schema version 2.0.0.

tables_create.sql · GitHub