OpenPLZ API

The service behind OpenPLZ API. Build with .NET 9.

Technology stack

• PostgreSQL 17 as database
• ASP.NET 9 as web framework
• Entity Framework Core 9 as ORM layer
• Swagger UI for OpenAPI based documentation

Getting started

The following instructions show you how to set up a development environment on your computer.

Prerequisites

• Set up a local PosgreSQL 17 (or higher) instance.
• Clone or download this repository.
• Open the solution file OpenPlzApi.sln in Visual Studio 2022.

Configure the OpenPLZ API CLI

• Switch to the project OpenPlzApi.CLI.

• Make a copy of the the appsettings.json file and name it appsettings.Development.json.

• Exchange the content with the following JSON document and adjust the values to your needs. This configures the root folder for the data file downloads and the database connection.

  "Sources": {
    "RootFolderName": "c:\\OpenPlzApi.Downloads"
  },
  "Database": {
    "Server": "localhost",
    "Database": "OpenPlzApi",
    "Username": "postgres",
    "Password": "qwertz"
  }

Create and populate the database

• Build the OpenPlzApi.CLI project.
• Run the OpenPlzApi.CLI project with parameter initdb --import. This will create and populate the PostgreSQL database.

Configure the OpenPLZ API WebService

• Switch to the OpenPlzApi.WebService.

• Make a copy of the the appsettings.json file and name it appsettings.Development.json.

• Exchange the content with the following JSON document and adjust the values to your needs. This configures the database connection.

  "Database": {
    "Server": "localhost",
    "Database": "OpenPlzApi",
    "Username": "postgres",
    "Password": "qwertz"
  }

Build and test the API

• Build the OpenPlzApi.WebService project.
• Run the OpenPlzApi.WebService project and play with the Swagger UI.

Can I help?

Yes, that would be much appreciated. The best way to help is to post a response via the Issue Tracker and/or submit a Pull Request.