Postgres, mysql support

[lastlink]

Is your feature request related to a problem? Please describe. Be able to support postgres and mysql unit test for getting coverage. Postgres has several sql unit testing frameworks such as pgtap and mysql has some perl based unit tests https://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_QUICK_START.html or mytap

Describe the solution you'd like An additional parameter to specify sql provider used. May have to add additional sub projects to deploy the different databases looks liked sqitch May be the best tool for that. github actions will work fine w/ a postgres and mysql integrated docker test.

Describe alternatives you've considered Could add more support if tracing in different providers supported and or a new project completely forked off of this maybe if you think this deviates from the current project.

I may await your response on whether this should be part of this project or a new project.

=== Please at me @GoEddie so I receive a notification

[GoEddie]

Do the other database systems have a way to track which statements have been called?

In MSSQL we use the etw tracing and statement completed which gives the details of the statement.

We would also need a parser to break procedures into statements - do they exist for the other databases?

Before .NET was cross platform I would have said that this isn’t the right project but it might be.

Ed

[lastlink]

• these would all require investigation for tracing the statements being called. if you are fine w/ these being part of this project I see 2 main phases
• besides the db function to call for getting the tracing, dotnet core already has sql providers for postgres and mysql which I've used and are very similar which matching apis to the sql server .net framework Microsoft.EntityFrameworkCore see https://github.com/lastlink/dotnet-ci-pipelines/blob/master/MyProject.Repository.Test/Helper/TestDbContext.cs

  else if (databaseProvider.ToLower().Trim().Equals("mysql"))
              {
                  optionsBuilder.UseMySQL(connectionString);
              }

phases

1. a sqitch schema project w/ unit tests for each db type
2. SQLCover statement tracking if possible.

[davemurp]

Did anything ever come of this particular feature request? Having the ability to generate coverage reports for my postgres dbs as well as sql server using the same tooling would be such a massive benefit. For what it is worth, I endorse/approve/up-vote this idea and would really like to see it soon.