frictionlessdata / tableschema-sql-py

Generate SQL tables, load and extract data, based on JSON Table Schema descriptors.
MIT License
60 stars 19 forks source link

Support all Table Schema constraints #11

Closed roll closed 4 years ago

roll commented 8 years ago

Requires #27

Initial implementation restrictions:

Reference:

zaneselvans commented 4 years ago

Hey @roll, @cmgosnell and I were noticing that these constraints aren't getting integrated into the database schema when we load the PUDL datapackages into SQLite, and we do depend especially on ENUM to make sure that the contents are valid... My guess right now is that goodtables won't be fast enough to practically validate our larger datasets, so we were imagining that actually loading the data into the database would be checking a lot of the structural / constraint issues. But for that to work I think we would need to get these constraints into the database schema. Might we able to add this issue to the catalyst-pilot work?

roll commented 4 years ago

Thanks @zaneselvans. Added it - https://github.com/frictionlessdata/pilot-catalyst/issues/17