Microservice architecture / API Gateway + Monolithic API

[alexeysp11]

Description

API methods:

• POST /api/sql/execute (parameter: query)
• POST /api/sql/create-table (parameters: tableName, columns, types).
• DELETE /api/sql/drop-table (parameter: tableName).
• POST /api/sql/insert (parameters: tableName, rowData).

Steps:

• Use dependencies from velocipede-utils (e.g. VelocipedeUtils.Shared.DbOperations, VelocipedeUtils.Shared.WpfExtensions).
• sqlviewer / Refactoring, DbConnections #19
• Creating the First Service (API Gateway + Monolithic API)
  • Create controllers for retrieving metadata (e.g., /api/metadata/tables, /api/metadata/columns).
  • Create a controller for executing SQL queries (e.g., /api/sql/execute).
  • WPF client: Update your WPF application to access these API endpoints instead of directly using the ORM library.
• sqlviewer / basic authentication + data sources #21
• To ensure idempotency of requests, do the following: 1) the client sends a request with a unique Idempotency-Key, 2) the server processes the request and saves the key with the response in temporary storage, 3) If a request with the same key arrives, the server returns the saved response without re-executing the business logic.
• Documentation.