rules-framework
rules-framework copied to clipboard
Add support for SQLServer provider
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:
- Repository + Data Model implementation
- Schema creation scripts
- Automatic schema creation on application startup (using scripts) --> not mandatory, but useful.
Proposed schema:
NOTE: refer to KafkaFlow Retry extension which might help to create a solution to automate schema creation.
I will work on a proposal comprising a database schema (high-level) to address this need.
TODO's Tasks:
- Run Database scripts at the beginning of the tests.
- Use Rules.Framework package in SQL test project instead of project reference.