search

pvcbuild / pvc

PVC -- Scaffold, Build, Publish -- Composable, extensible builds in .NET created by @stirno
http://pvcbuild.com
MIT License
117 stars 11 forks source link

Plugin: SQL scripts #40

Open stirno opened 10 years ago

stirno commented 10 years ago

Execute SQL scripts against a data source. Preferably pluggable to include multiple DB drivers/implementations.

Should start with an MS SQL Server or PostgreSQL implementation.

robinbihun commented 10 years ago

I've started work on this - what i have so far is pretty rough, but only spent an hour or so on it (on top of an hour or so playing with pvc).

https://github.com/robbihun/pvc-sql

Feedback appreciated, especially if change of direction required.

stirno commented 10 years ago

I really like what you've got there. Only thought is that I might avoid using DbProviderFactories.GetFactory because, if i remember correctly, it looks for the config file (app/web.config) for the 'other' providers which might prove awkward.

stirno commented 10 years ago

@robbihun What would you say the status is on this? Thanks!

robinbihun commented 10 years ago

I have tested it with all of the default providers and it seems good for now, this weekend i'm going to rewrite it to not use the DbProviderFactory so that if someone wanted to use a non-standard provider they dont have to change their machine.config first.

I'm wondering if a cleaner way to do this would be to have sub-modules pvc-sql-mysql, etc that load the needed dependencies if "mysql" was specified. thoughts?