Backendless can create tables when a developer stores object hierarchies from a client application.
Also, it is possibleto manually create data tables using Backendless console.
Finally, there is one more approach which makes table creation as simple as it gets. The approach is by uploading a file which contains schema definition for every table. The schema definition may include data types for all columns, including the ones for relations.
As it has been declared a restaurant to-go order app has been built and all the tables has been created in the Backendless backend. It was used the schema export feature (to be discussed in the future) which generated a ZIP file with the schema definitions for all the tables used by the app.
The ZIP archive includes a CSV file for every table:
The structure of each CSV file is rather simple. In this case it contains just the names of the columns and the corresponding data types. Additionally, they may contain data objects too, but that will be described in a separate post. For example, the following are the contents of Location.csv:
The Backendless documentation describes the import file format for defining column names and their types.
Follow the instructions below to import the file and create all the tables for the Restaurant app in the backend:
- Download the ZIP file which contains the definition for all tables from: https://backendless.com/documentation/samples/restaurant-app-schema.zip
- Login to console, select an app (it is recommended to create a new app for this) and click the Manage icon.
- Select the Import menu item.
- Click the single Zip file link located in the description text and browse to the ZIP file from step 1 above.
- Once the file is selected, Backendless immediately starts processing it and creating data tables. As soon as the process is finished, an email is delivered to the application developer with the status of the import. The email for the restaurant-app-schema.zip file should contain the following status:
103:55:44 IMPORT_DATA Importing Started. 203:55:44 IMPORT_DATA Start import table: Menu 303:55:44 IMPORT_DATA Table 'Menu' was imported at 0 seconds 403:55:44 IMPORT_DATA Finish import table: Menu 503:55:44 IMPORT_DATA Start import table: Users 603:55:44 IMPORT_DATA Table 'Users' was imported at 0 seconds 703:55:44 IMPORT_DATA Finish import table: Users 803:55:44 IMPORT_DATA Start import table: Order 903:55:44 IMPORT_DATA Table 'Order' was imported at 0 seconds 1003:55:44 IMPORT_DATA Finish import table: Order 1103:55:45 IMPORT_DATA Start import table: Restaurant 1203:55:45 IMPORT_DATA Table 'Restaurant' was imported at 0 seconds 1303:55:45 IMPORT_DATA Finish import table: Restaurant 1403:55:45 IMPORT_DATA Start import table: Location 1503:55:45 IMPORT_DATA Table 'Location' was imported at 0 seconds 1603:55:45 IMPORT_DATA Finish import table: Location 1703:55:45 IMPORT_DATA Start import table: MenuItem 1803:55:45 IMPORT_DATA Table 'MenuItem' was imported at 0 seconds 1903:55:45 IMPORT_DATA Finish import table: MenuItem 2003:55:45 IMPORT_DATA Importing Finished.
- To confirm that all the tables, columns and relations have been created, click the Data icon. A developer should see the following tables in the list:
Review related topics: