search

VulcanAnalytics / DBTester

Simplified MSSQL database testing library
GNU General Public License v3.0
1 stars 2 forks source link

Implement features for a new database #40

Open darrencomeau opened 5 years ago

darrencomeau commented 5 years ago

consider making abstract methods ANSI SQL compliant and use an interface which includes those methods.

This would be the framework for database interoperability.

Anything which couldn't be written in ANSI SQL would need to be implemented in individual concrete database classes and a test framework would have to be updated when moving from one to the other.

If some databases have similar capabilities then a new interface with those capabilities could be shared

darrencomeau commented 5 years ago

NB, the interface isn't ANSI SQL compliant, the database is.

darrencomeau commented 5 years ago

To do this justice, would require automated tests and for that I would need a database engine available.

My current CI pipeline uses Azure DevOps. For an MSSQL database it is easy as they supply the cutdown database engine found with Visual Studio - LocalDB.

For anything else such as MySQL, Oracle or Postgres I would need to provision my own build agent.

Will take this out of the 1.0.0 milestone and hope to include this as demand grows.