private bool FileNamesAreNotTheSame(ScriptsRunInfo executedScript, string foundScript)
{
var foundScriptFileName = Path.GetFileName(foundScript);
var areNotSameFileName = executedScript.ScriptName.ToLower() != foundScriptFileName.ToLower();
return(areNotSameFileName);
}
public override IEnumerable <string> Execute(SqlConnection connection)
{
var scripts = new List <string>();
var statement = string.Format(
"select scripts.* from [{0}] scripts",
ScriptsRunInfo.GetTableName());
var executedScripts =
connection
.Query <ScriptsRunInfo>(statement)
.Select(si => new ScriptsRunInfo {
ScriptName = si.ScriptName
})
.Distinct()
.ToList();
if (executedScripts.Any())
{
scripts.AddRange(FindScriptsThatHaveNotBeenExecutedBefore(executedScripts));
scripts.AddRange(FindScriptsThatHaveExecutedButChanged(connection, executedScripts));
}
else
{
scripts.AddRange(FoundScripts);
}
return(scripts
.Distinct()
.ToList());
}
public void RecordScriptInfoRun(ScriptsRunInfo info)
{
if (!_allScriptsRun.Any(s => s.ScriptName == info.ScriptName))
{
_allScriptsRun.Add(info);
}
}
private void RaiseOnScriptInfoRecorded(ScriptsRunInfo info)
{
var evt = OnScriptInfoRecorded;
if (evt == null)
{
return;
}
evt(info);
}
private bool IsScriptRunInfoTablePresent()
{
var statement = string.Format(
@"SELECT Present = Count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[{0}]') AND type in (N'U')",
ScriptsRunInfo.GetTableName());
using (var connection = _configuration.GetConnection())
{
return(connection.Query <int>(statement).FirstOrDefault() > 0);
}
}
private bool ContentHasChanged(
SqlConnection connection,
ScriptsRunInfo recordedScript,
string foundScript)
{
var found = new ScriptAccessor(foundScript);
var foundInfo = new ScriptsRunInfo {
ScriptText = found.Read()
};
return(foundInfo.ScriptHash != recordedScript.ScriptHash);
}
private void UpdateScriptInfoWithDeploymentId(ScriptsRunDeployInfo deployInfo, ScriptsRunInfo runInfo)
{
var statement = string.Format("update [{0}] set [DeployInfoId] = {1} where [Id] = {2}",
ScriptsRunInfo.GetTableName(),
deployInfo.Id.ToString(),
runInfo.Id.ToString());
using (var connection = _configuration.GetConnection())
{
connection.Execute(statement);
}
}
private void UpdateScriptForVersion(ScriptsRunInfo info, long?versionId = null)
{
if (!versionId.HasValue)
{
return;
}
var update = string.Format("update [{0}] set [versioninfoid] = {1} where id = {2}",
ScriptsRunInfo.GetTableName(),
versionId,
info.Id.ToString());
using (var connection = _configuration.GetConnection())
{
connection.Execute(update);
}
}
private IEnumerable <ScriptsRunInfo> GetAllScriptsForCurrentVersion(out VersionInfo versionInfo)
{
versionInfo = GetMaxVersion();
if (versionInfo == null)
{
return(new List <ScriptsRunInfo>());
}
var statement = string.Format("select s.* from [{0}] s where [VersionInfoId] ='{1}'",
ScriptsRunInfo.GetTableName(),
versionInfo.Id);
using (var connection = _configuration.GetConnection())
{
var scripts = connection.Query <ScriptsRunInfo>(statement).ToList();
return(scripts);
}
}
protected IEnumerable <ScriptsRunInfo> GetExecutedScriptsFromHistory()
{
var statement = string.Format(
@"select scripts.ScriptName, scripts.ScriptHash
from [{0}] scripts
group by scripts.ScriptName, scripts.ScriptHash",
ScriptsRunInfo.GetTableName());
using (var connection = Configuration.GetConnection())
{
return(connection
.Query <ScriptsRunInfo>(statement)
.Select(si => new ScriptsRunInfo
{
ScriptName = si.ScriptName,
ScriptHash = si.ScriptHash
})
.Distinct()
.ToList());
}
}
private void CheckForScriptsRunInfoTable()
{
Logger.InfoFormat("Creating [{0}] table, if it does not exist..", ScriptsRunInfo.GetTableName());
CreateInfoTable("scriptsruninfo_create.sql");
}
