public void SqlExecuteScalarTest()
{
// Initialise Instance
var target = new SqlExecute { Action = SqlExecuteAction.ExecuteScalar };
var parameters = new Dictionary<string, object>
{
{ "Sql", "SELECT CONVERT(CHAR(10), GETDATE(), 103), @P1, @P2" },
{ "ConnectionString", "Data Source=.;Initial Catalog=;Integrated Security=True" },
{ "UseTransaction", true },
{ "Parameters", new [] {"@P1=1", "@P2=2"} }
};
// Create a WorkflowInvoker and add the IBuildDetail Extension
WorkflowInvoker invoker = new WorkflowInvoker(target);
var actual = invoker.Invoke(parameters);
// Test the result
Assert.AreEqual(DateTime.Now.ToString("dd/MM/yyyy", System.Globalization.CultureInfo.GetCultureInfo("en-gb")), actual["ScalarResult"].ToString());
}
public void SqlExecuteFilesTest()
{
// Create a temp file and write some dummy attribute to it
FileInfo f = new FileInfo(System.IO.Path.GetTempFileName());
File.WriteAllLines(f.FullName, new[] { "SELECT CONVERT(CHAR(10), GETDATE(), 103)" });
// Initialise Instance
var target = new SqlExecute { Action = SqlExecuteAction.Execute };
// Declare additional parameters
var parameters = new Dictionary<string, object>
{
{ "Files", new[] { f.FullName } },
{ "ConnectionString", "Data Source=.;Initial Catalog=;Integrated Security=True" },
{ "UseTransaction", true },
{ "CommandTimeout", 30 },
};
// Create a WorkflowInvoker and add the IBuildDetail Extension
WorkflowInvoker invoker = new WorkflowInvoker(target);
invoker.Invoke(parameters);
}
