public void ExecuteResourceScript_Drop()
{
var options = new DbScriptExecuteOptions("Shuhari_Framework_TestDb", null, true);
DbFixtures.DropDatabase(options);
AssertDbExist("Shuhari_Framework_TestDb", false);
}
public void ExecResourceScript_Create_ReplaceDbName()
{
var options = new DbScriptExecuteOptions("Shuhari_Framework_OtherDb", null, true);
DbFixtures.CreateDatabase(options);
AssertDbExist("Shuhari_Framework_OtherDb", true);
}
private static void ExecuteResourceScript(DbScriptExecuteOptions options, string scriptPath)
{
var filePath = Path.Combine(options.WorkDirectory, Path.GetFileName(scriptPath));
typeof(DbFixtures).Assembly.GetResource(scriptPath).CopyToFile(filePath);
var response = new CommandLine("sqlcmd")
.SetWorkingDirectory(options.WorkDirectory)
.AddArg("-i")
.AddArg(Path.GetFileName(scriptPath))
.AddArg("-v")
.AddArg(string.Format("db=\"{0}\"", options.DbName))
.Exec();
if (options.Output)
{
Console.WriteLine(response);
}
}
public static void DropDatabase(DbScriptExecuteOptions options)
{
ExecuteResourceScript(options, "Data/Scripts/drop.sql");
}
/// <summary>
/// Create testbase
/// </summary>
public static void CreateDatabase(DbScriptExecuteOptions options)
{
ExecuteResourceScript(options, "Data/Scripts/create.sql");
}
