rules-framework icon indicating copy to clipboard operation
rules-framework copied to clipboard

Add support for SQLServer provider

Open martinhonovais opened this issue 3 years ago • 2 comments

Purpose

Have support to manage rules using a SQL Server repository to persist them.

Main functionalities

  • Add rules on SQL Server repository
  • Get rules from SQL Server repository
  • Update rules on SQL Server repository
  • Configure optionally a schema - default is dbo when omitted.

Proposal

Development can be partitioned into 3 parts:

  1. Repository + Data Model implementation
  2. Schema creation scripts
  3. Automatic schema creation on application startup (using scripts) --> not mandatory, but useful.

Proposed schema:

image

NOTE: refer to KafkaFlow Retry extension which might help to create a solution to automate schema creation.

martinhonovais avatar Jan 26 '22 11:01 martinhonovais

I will work on a proposal comprising a database schema (high-level) to address this need.

luispfgarces avatar Jan 26 '22 12:01 luispfgarces

TODO's Tasks:

  • Run Database scripts at the beginning of the tests.
  • Use Rules.Framework package in SQL test project instead of project reference.

Daniel-C-Dias avatar Oct 21 '22 16:10 Daniel-C-Dias