Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for SQLServer provider #59

Open
martinhonovais opened this issue Jan 26, 2022 · 2 comments
Open

Add support for SQLServer provider #59

martinhonovais opened this issue Jan 26, 2022 · 2 comments
Assignees
Labels
enhancement New feature or request

Comments

@martinhonovais
Copy link
Contributor

martinhonovais commented Jan 26, 2022

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 martinhonovais added enhancement New feature or request help wanted Extra attention is needed labels Jan 26, 2022
@luispfgarces
Copy link
Contributor

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

@Daniel-C-Dias
Copy link
Contributor

Daniel-C-Dias commented Oct 21, 2022

TODO's Tasks:

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

7 participants