Investigate DBML and dbdiagram.io

[krlmlr]

for drawing.

See r-dbi/DBI#312 for detail.

[smgogarten]

I'd like to be able to import DBML files into R. Is adding that functionality to dm already underway, or planned soon?

[krlmlr]

Thanks. We don't have a deadline for this feature yet. Would you like to share a DBML file you'd like to import?

Note that this issue refers to https://www.dbml.org/home/.

[smgogarten]

Here's an example file: https://github.com/UW-GAC/primed_data_models/blob/02fc6519dc02f3bdd8a9cfdcbf87083c092e2bc1/PRIMED_data_model_draft.dbml

My goal is to load the DBML file into a dm object to define the data model, and then be able to check that another set of data frames conforms to that model.

[krlmlr]

Thanks. I tried dbml2sql, but it doesn't seem to offer the JSON output that the JS module promises: https://www.dbml.org/js-module/ . If we can convert to JSON, we might be able to create a dm from that.

I found https://github.com/UW-GAC/AnvilDataModels/blob/main/inst/extdata/data_model.tsv, I wonder how did you create the tsv representation?

[smgogarten]

I typed it in manually with a spreadsheet editor. My current plan (until a DBML parser exists in R) is to switch to maintaining the data model as tsv, which I can then import to dm or write to DBML using the functions in the AnvilDataModels package.

[krlmlr]

There's a TypeScript based visualization project for DBML at https://github.com/softwaretechnik-berlin/dbml-renderer. Might be worthwhile packaging this as an htmlwidget.