Ingest SQLDelight schemas about floorplan HOT 5 CLOSED

I should add that the galway-bus-android is probably a bit out of date....need to grab some time at some point to update it (across a number of different areas).

A more up to date one that also uses SQLDelight is https://github.com/joreilly/PeopleInSpace (though is very basic)

from floorplan.

It seems like there is a generateSchema gradle task we could use to export the DB schema.

I still haven't had the time to give it a try to see what the output looks like.

from floorplan.

Ran into a few small open source projects using SQLDelight:

• @hamen's https://github.com/hamen/messagist
• @joreilly's https://github.com/joreilly/galway-bus-android
• @martinbonnin's https://github.com/martinbonnin/Messages

After a few changes to specify a sqldelight block in their gradle script configuration, I was able to export SQLite .db files containing the database schema. Next step is understand how we can transform that into input for a FloorPlan Consumer... maybe sqlite-jdbc or would that be overkill?

from floorplan.

So, given SQLDelight exports the .db files which aren't specific to Android, but to SQLite, it makes sense to build a SQLiteConsumer that connects to these DBs, pulls out schemas mapping them as input to FloorPlan's pipeline.

I have found a more complex sample SQLite Schema that can also be used for testing.

from floorplan.

After #40, we can ingest SQLite .db files, which are also the output of SQLDelight through the schemas task.
Here we see an example PNG output with @joreilly's PeopleInSpace project after a few small gradle script changes:

Will be released as part of FloorPlan-0.2 👍

from floorplan.