SQL file to create tables in your dashboard


#1

How do you create the tables in your account - SQLite from the SQL files I have. Is there a tool to convert the DDLs to JSON definition which can then be uploaded to create similar table in DreamFactory. ?


Create table in online sandbox environment
#2

There is not currently any such tool.

If you’d like to see an example of how to construct the json for your tables, check out this file, which is part of the sample app: https://github.com/dreamfactorysoftware/angular-sdk/blob/master/schema.json

This is how the tables are added to your db service for the sample app.


#3

Actually I was able to figure out. I created a db file on my local instance of the sqlite3 on mac.
I used the SQL file I had create the entire tables in my local instance of sqlite. Then I overwrite the db.sql3 file created by the DreamFactory new SQLLite driver/database service with the file I had and it loaded all the tables.