/// <summary>
/// <para>Gets list of SQL test data scripts that have not been ran against the target database</para>
/// <para>Default script directory is ~/App_Data/scripts/ but it can bet set to any physical path</para>
/// <para>-Script directory path must exist</para>
/// <para>Returns a list of string with names of pending test data sql scripts</para>
/// </summary>
/// <param name="connectionString"></param>
/// <param name="scriptDirectory"></param>
/// <returns>RReturns a list of string with names of pending test data sql scripts</returns>
public List <string> PendingTestData(string connectionString, string scriptDirectory = "")
{
if (scriptDirectory == "")
{
scriptDirectory = Path.Combine(AppDomain.CurrentDomain.GetData("DataDirectory").ToString(), "scripts");
}
if (!Directory.Exists(scriptDirectory))
{
throw new ArgumentException("There are no scripts in the defined data directory.");
}
if (!DatabaseExists(connectionString))
{
var result = new List <string>();
result.Add("Database does not exist");
return(result);
}
var filelocator = new SqlFileLocator();
var allfiles = new List <string>();
allfiles.AddRange(filelocator.GetSqlFilenames(scriptDirectory, "TestData").ToList());
var executedfiles = _queryExecutor.GetExecutedTestDataScripts(_connectionStringGenerator.GetConnectionSettings(connectionString));
return(allfiles.Select(f => f.Replace(Path.GetDirectoryName(f) + "\\", "")).Except(executedfiles).ToList());
}
