SDM.SQLgeneration

The SDM.SQLgeneration service is a Python server that generates a SQL Schema based on the model description of a Smart Data Model.

It provides an OpenAPI specification with two paths: /version and /generate.

Path: /version

• The /version path is used to provide clients with version information, including details such as the document, git hash, version, release date, and uptime.

Path: /generate

• The /generate path is a POST operation designed to generate a SQL Schema based on the provided data model.

• Request Body: The API expects a JSON object in the payload with the details of the GitHub URL to the Data Model model.yaml from which the SQL Schema will be generated, along with other necessary details.

This service simplifies the generation of SQL Schemas by providing a clear and structured API. It is particularly useful for automating the process of creating SQL Schemas based on data models, thereby streamlining the development and maintenance of databases.

Create a Python Virtual Environment

Please note that this is a Python 3.13 project. The installation is based on uv, an extremely fast Python package and project manager, written in Rust. Please follow the link to install locally.

1. Activate the virtual environment: It can be activated using the following command:

   uv venv --python 3.13

   This operation will create the corresponding .venv and in case that the version of python is not installed, uv will install the corresponding version of python. After that operation you can activate the virtual environment executing the command:

   source .venv/bin/activate

2. Install Dependencies: If the project's dependencies are not installed, the following command can be used to install them based on the requirements.txt file:

   uv pip install -r requirements.txt

3. Deactivate and exit the virtual environment: Once done, make sure to exit from the virtual environment by running this command:

   deactivate

Running the code

To run the code use the following commands and instructions:

SDM SQL schema generator

Usage:
  generator.py run (--input FILE) [--output]
  generator.py server [--host HOST] [--port PORT]
  generator.py (-h | --help)
  generator.py --version

Arguments:
  FILE   input file
  PORT   http port used by the service

Options:
  -i, --input FILEIN  description to specify the file to the script
  -o, --output        generate the corresponding output file
  -h, --host HOST     launch the server in the corresponding host
                      [default: 127.0.0.1]
  -p, --port PORT     launch the server in the corresponding port
                      [default: 5500]

  -H, --help          show this help message and exit
  -v, --version       show version and exit

To run the service, it is needed to define the corresponding full path to the cert and key files in the [./common/config.json] file.

OpenAPI documentation

the full OpenAPI specification is located under doc/openapi.yaml.

This OpenAPI specification defines two paths /version and /generate.

The /version path

• The purpose of the /version path is to provide clients with version information, including details such as the document, git hash, version, release date, and uptime.
• The API defines an endpoint for retrieving version information.
• When a GET request is sent to the /version path, the API returns a JSON object containing details such as the document, git hash, version, release date, and uptime.
• The API logs relevant information, such as the request for version information, using the provided logger.

The /generate path

• The API is a POST operation at the /generate path.
• It is designed to generate a SQL Schema based on the provided data model.

Here is the documentation for the API:

• Path: /generate

• Method: POST

• Summary: Generating a SQL Schema

• Request Body: The API expects a JSON object in the payload with the details of the GitHub URL to the Data Model model.yaml from which the SQL Schema will be generated, along with other necessary details.

  Example:

  {
    "url": "https://github.com/your-repo/your-model.yaml",
  }

  Responses: 200 OK: If the request is successful, the API returns the generated SQL Schema.

  Example Response:

  {
    "message": "Generated SQL Schema Here..."
  }

  • 400 Bad Request: If the request payload is missing or invalid, the API returns an error message.

  Example Response:

  {
    "message": "It is needed to provide a JSON object in the payload with the details of the GitHub URL to the Data Model model.yaml from which you want to generate the SQL Schema"
  }

• Upon receiving a request, the API logs relevant information, such as the request for generating a SQL Schema from a specific URL. It then validates the provided GitHub URL and, if valid, proceeds to generate the SQL Schema. If the URL is invalid, it returns an error message.

License

These server is licensed under Apache License 2.0.