In the SAP Cloud Application Programming model, we can use the following command line to store Entity data using a Persistent Database.
cds deploy –to sqlite:my.db
cds deploy –to sqlite:my.db
filling sap.capire.bookshop.Authors from db\data\sap.capire.bookshop-Authors.csv
filling sap.capire.bookshop.Books from db\data\sap.capire.bookshop-Books.csv
/> successfully deployed to ./my.db
/> updated ./package.json
This command generates a my.db file under the project folder.
.db file format cannot be opened directly in Visual Studio Code:
You can install this Visual Studio Code extension called SQLite:
After the installation, you can see a new SQLite Explorer pane on the left of Visual Studio Code, where you can browse the database tables and views contained in the my.db file:
Right-click on the menu and select Show Table to view the contents of the specified database Table:
You can also edit your own SQLite Query and execute it by right-clicking on the Run Selected Query menu:
More of Jerry’s original articles can be found on “Wang Zixi “:
