n41m0r / cake.sqltools

Sql tools addin for Cake

Cake.SqlTools

Cake Build addin for executing sql scripts against a database

Table of contents

1. Implemented functionality
2. Referencing
3. Usage
4. Example
5. Plays well with
6. License
7. Share the love

Implemented functionality

• Execute a query against a database
• Contains a provider for MS Sql, MySql and PostgreSQL

Referencing

Cake.SqlTools is available as a nuget package from the package manager console:

Install-Package Cake.SqlTools

or directly in your build script via a cake addin directive:

#addin "Cake.SqlTools"

Usage

#addin "Cake.SqlTools"

Task("Execute-Sql-Query")
    .Description("Execute a Sql query against a database.")
    .Does(() =>
{
    ExecuteSqlQuery("CREATE DATABASE Test", new SqlQuerySettings()
    {
        Provider = "MsSql",
        ConnectionString = "blah"
    });
});

Task("Execute-Sql-File")
    .Description("Execute a Sql query  against a database, from the contents of a file.")
    .Does(() =>
{
    ExecuteSqlFile("./Scripts/Restore-DB.sql", new SqlQuerySettings()
    {
        Provider = "MsSql",
        ConnectionString = "blah"
    });
});

RunTarget("Execute-Sql-Query");

Example

A complete Cake example can be found here.

Plays well with

If your looking for a way to trigger cake tasks based on windows events or at scheduled intervals then check out CakeBoss.

License

Copyright (c) 2015 - 2016 Phillip Sharpe

Cake.SqlTools is provided as-is under the MIT license. For more information see LICENSE.

Share the love

If this project helps you in anyway then please ⭐ the repository.