Refactor code to support extensibility to other RDBMS

rdagumampan / yuniql

Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!

https://yuniql.io

Apache License 2.0

418 stars 64 forks source link

Refactor code to support extensibility to other RDBMS #16

Closed rdagumampan closed 4 years ago

rdagumampan commented 4 years ago

With most RDMS relatively similar in execution flow, it would be good to refactor the code to make an open interface to support other databases such as MySql, PosgreSQL, Amazon RDS, MemSQL.

rdagumampan commented 4 years ago

The solution has been refactored heavily to provide support for other RDMS platforms. An assembly Yuniql.Extensibility provides the interface needed to implement. A typical development flow would be:

Implement IDataService
Implement ICsvImportService
Refactor MigrationServiceFactory
Place self-contained assembly in _plugins\{platform} such as _plugins\pgsql for Posgre SQL
Copy and implement integration tests

rdagumampan commented 4 years ago

The code has been extensively refactored to verify the extensibility. The PostgreSql is a demo case on how to support other RDBMS platforms. Contributors would have to implement IDataService and ITestDataService and run the platform tests targetting the new platform.

For example to run platform tests for PostgreSql, the following environment variables must be set:

SETX YUNIQL_TEST_TARGET_PLATFORM = "postgresql"
SETX YUNIQL_TEST_CONNECTION_STRING = "your-pgsql-connection-string"