jsonschema2db
jsonschema2db copied to clipboard
better
Generate tables dynamically from a JSON Schema and insert data
I already pushed this to PyPI (which I have access to still) but I can't update the repo directly. Hoping someone at Better can merge :)
I'm trying to install and am getting the following: ``` pip install jsonschema2db Collecting jsonschema2db Downloading JSONSchema2DB-1.0.1.tar.gz (9.3 kB) Collecting change_case==0.5.2 Downloading change_case-0.5.2.tar.gz (8.6 kB) Collecting iso8601==0.1.12 Downloading iso8601-0.1.12-py3-none-any.whl (12...
I was trying to install this utility but got the following error. Just thought you might want to know. I have tried doing this on my mac (homebrew) and now...
Would it be better to generate a model file that can create db，Then Create db table from model file?
I noticed when [inspecting types](https://github.com/better/jsonschema2db/blob/master/jsonschema2db.py#L169) that the [postgres array type](https://www.postgresql.org/docs/9.1/arrays.html) is not supported. Are there plans to support it? Openapi has an array type which triggered this issue for me.
@erikbern just kill this PR whenever you see fit - create abstract base class - create JSONSchemaToSnowflake class - make input params a bit more generic - add very basic...
https://github.com/better/jsonschema2db/blob/60832f5f38d6a257920508c09fec3a65daed4e4c/jsonschema2db.py#L365 If every key string in S3 should start with a `/` then the path where this key is appended should not have a `/` otherwise you will end up...
I would like to have a dry_run parameter for create_tables insert_items that just prints out the statements without actually executing them. Default can be False (meaning the statements will be...
https://github.com/better/jsonschema2db/blob/60832f5f38d6a257920508c09fec3a65daed4e4c/jsonschema2db.py#L238 In `create_tables` I should be able to direct the call to do nothing if the schema exists. Maybe add an option to direct create_tables to avoid dropping the schema.
Each entity is defined in a separate json schema file. Each schema has an `$id` and I use this id in other files using `$ref`. This works fine for example...
