Skip to content

Latest commit

 

History

History
72 lines (56 loc) · 3.4 KB

05_node_adding_data.md

File metadata and controls

72 lines (56 loc) · 3.4 KB
Raw

Adding Data to your database

Using a In-Memory Database

cds watch automatically bootstraps a database by default - unless told otherwise. It drastically speeds up turn-around times in local development and furthermore allows self-contained testing.

Since we already have an SQLite in-memory database that was automatically created, let's now fill it with some test data.

Adding Initial Data in .csv Files

You can fill your database with initial data by adding a few plain CSV files. For each entity that you want to populate with mock-data, you can add the mockdata files using the naming convention {enityNamespace}-{entityName}.csv files in the db/data folder or use the following command (either in a new terminal or you stop the running cds watch for now):

cds add data

It will generate .csv templates which can be filled with the following content. Please make sure that you replace the full content of the file including the header columns.

sap.capire.incidents-Conversations.csv

ID, Incidents_ID, timestamp,author,message
2b23bb4b-4ac7-4a24-ac02-aa10cabd842c,3b23bb4b-4ac7-4a24-ac02-aa10cabd842c, 1995-12-17T03:24:00Z,Cloudy Mac Cloudscale,my cloud does not scale!
2b23bb4b-4ac7-4a24-ac02-aa10cabd843c,3a4ede72-244a-4f5f-8efa-b17e032d01ee,1995-12-18T04:24:00Z,Gladys Boothby,What exactly is wrong?
9583f982-d7df-4aad-ab26-301d4a157cd7,3583f982-d7df-4aad-ab26-301d4a157cd7,2022-09-04T12:00:00Z,Sunny Sunshine,"Solar panel is broken, please check"
9583f982-d7df-4aad-ab26-301d4a158cd7,3ccf474c-3881-44b7-99fb-59a2a4668418,2022-09-04T13:00:00Z,Bradley Flowers,What exactly is wrong?

sap.capire.incidents-Customers.csv

ID,firstName,lastName,email,phone,streetAddress,city,postcode
8fc8231b-f6d7-43d1-a7e1-725c8e988d18,Cloudy,Mac Cloudscale,cloudy.mac.cloudscale@demo.com,+44-555-123,4 Cloud Road, Cloud City, 1234"
feb04eac-f84f-4232-bd4f-80a178f24a17,Sherlock,Holmes,sherlock.holmes@demo.com,,221B Baker Street,London,NW1 6XE
2b87f6ca-28a2-41d6-8c69-ccf16aa6389d,Sunny,Sunshine,sunny.sunshine@demo.com,+01-555-789,11111 W Sunset Blv,Los Angeles,90049

sap.capire.incidents-Incidents.csv

ID,customer_ID,title,urgency_code,status_code
3b23bb4b-4ac7-4a24-ac02-aa10cabd842c,8fc8231b-f6d7-43d1-a7e1-725c8e988d18,my cloud does not scale!,H,C
3a4ede72-244a-4f5f-8efa-b17e032d01ee,feb04eac-f84f-4232-bd4f-80a178f24a17,Ran out of tea,H,N
3ccf474c-3881-44b7-99fb-59a2a4668418,feb04eac-f84f-4232-bd4f-80a178f24a17,Violin broken,M,N
3583f982-d7df-4aad-ab26-301d4a157cd7,2b87f6ca-28a2-41d6-8c69-ccf16aa6389d,Solar panel broken,H,I

sap.capire.incidents-Status.csv

code;descr
N;new
A;assigned 
I;in_process 
H;on_hold
R;resolved 
C;closed

sap.capire.incidents-Urgency.csv

code;descr
H;high
M;medium
L;low

Once added, the running cds watch will automatically refresh the data.

You can open the application by using Command Palette (F1 or Command+Shift+P) -> Ports: Preview and selecting the port 4004. Alternatively, you can click the http://localhost:4004 link in the cds watch log output (which is automatically redirected to the correct cloud URL). In your browser, you will now be able to see the data in the corresponding endpoints.

In contrast to other tutorials that you run on your local machine you can't use localhost because you don't develop on your local host. ;)

Proceed with the next step: Adding Fiori Elements