VOOZH about

URL: https://apilogicserver.github.io/Docs/Sample-Database/

⇱ Sample DB, Project - API Logic Server


Skip to content

Sample DB, Project

The sample application is created from the pre-installed sample database shown below (tutorial here). It is an extension to Northwind that includes additional relationships:

  • multiple relationships between Department / Employee
  • multi-field relationships between Order / Location
  • self-relationships in Department

👁 Sample Database

You can create projects for it with or without logic, as described below.

Northwind without logic

To install without pre-installed customizations for the API and Logic:

ApiLogicServercreate--project_name=nw_sample_nocust--db_url=nw-
Open the project in your IDE, and open the readme for a walk-through:

👁 Tutorial Welcome

Add Customizations

The tour begins with a review of the uncustomized project.

This illustrates the level of automation you can expect with your own projects.

The tutorial then shows how to add customizations:

ApiLogicServeradd-cust

👁 sample-customize

This installs:

  1. Logic: The integrity of this database is enforced with this logic
  2. Integration: this Kafka logic

Add Security

Finally, as shown above, add security (defaulting to sqlite-based authorization):

ApiLogicServeradd-auth

Northwind with Logic

You can also create the project with the logic pre-installed:

ApiLogicServercreate--project_name=nw_sample--db_url=nw+
 

Sample-ai

The ChatGPT-based sample is structured as follows:

👁 Sample-ai Database

Basic Demo

The ChatGPT-based sample is structured as follows:

👁 Sample-ai Database