public async Task <ExecutionResult> Execute()
{
log($"SQL Continuous Delivery start");
var path = _command.Path;
log($"Path: {path}");
// 1. get newest version from repository
log($"get newest version from repository");
var newest = _repository.GetNewestCommit(path);
// 2. get latest version from db
// database preparation
log($"database preparation start");
await _dbPrepare.Prepare();
log($"database preparation finish");
log($"get last version from database");
var latestSqlVersion = await _dbNegotiator.GetLatestSqlVersion();
var latest = RepositoryVersion.GetRepositoryVersion(latestSqlVersion);
// 3. get changed(added, modified) files from repository
log($"get changed(added, modified) files");
var changedFiles = _repository.GetChangedFiles(path, newest, latest);
// 4. exclude ignored files
log($"exclude ignored files");
_sqlSelector.Exclude(_sqlIgnoreConfiguration, ref changedFiles);
// 5. sort files
log($"sort files");
_sqlSelector.Sort(_sqlOrderConfiguration, ref changedFiles);
// 6. delivery to database
try
{
var scripts = await Task.WhenAll(changedFiles
.Where(file => file.ToLower().EndsWith(".sql"))
.Select(async file => await _fileReader.GetContentAsync($"{_command.Path}/{file}"))
.ToList());
if (!scripts.Any())
{
goto endCommand;
}
using (var trans = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
// execute all scripts
var beginTime = TimeUtility.Now;
log($"delivery start at {beginTime}");
foreach (var script in scripts)
{
log($"delivery for {string.Concat(script.Take(20))}...");
await _dbNegotiator.Execute(script);
}
var endTime = TimeUtility.Now;
log($"delivery end at {endTime}");
// insert delivery record
log($"insert delivery record");
// 1.get the latest version
var preVersion = await _dbNegotiator.GetLatestSqlVersion();
// 2.update all other records.IsLatest = false
await _dbNegotiator.SetAllNonLatest();
// 3.insert sv
var sv = new SqlVersion(_baseConfiguration.RepositoryType, newest.Version,
(endTime - beginTime).TotalMilliseconds)
{
IsLatest = true, LastVersion = preVersion?.Id
};
await _dbNegotiator.InsertSqlVersion(sv);
trans.Complete();
}
endCommand:
log($"SQL Continuous Delivery finish");
return(new ExecutionResult()
{
Success = true,
ErrorMessage = string.Empty
});
}
catch (Exception ex)
{
return(new ExecutionResult()
{
Success = false,
ErrorMessage = ex.Message
});
}
}
/// <summary>
/// Continuous Integrate
/// </summary>
/// <returns><see cref="ExecutionResult" /></returns>
public async Task <ExecutionResult> Execute()
{
log($"SQL Continuous Integrate start");
var path = _command.Path;
log($"Path: {path}");
// 1. get newest version from repository
log($"get newest version from repository");
var newest = _repository.GetNewestCommit(path);
// 2. get latest version from db
// database preparation
log($"database preparation start");
await _dbPrepare.Prepare();
log($"database preparation finish");
log($"get last version from database");
var latestSqlVersion = await _dbNegotiator.GetLatestSqlVersion();
var latest = RepositoryVersion.GetRepositoryVersion(latestSqlVersion);
// 3. get changed(added, modified) files from repository
log($"get changed(added, modified) files");
var changedFiles = _repository.GetChangedFiles(path, newest, latest);
// 4. exclude ignored files
log($"exclude ignored files");
_sqlSelector.Exclude(_sqlIgnoreConfiguration, ref changedFiles);
var hasErr = false;
var errors = new List <string>();
// 5. check grammar
foreach (var file in changedFiles)
{
if (!file.ToLower().EndsWith(".sql"))
{
continue;
}
log($"check grammar for {file}");
var script = await _fileReader.GetContentAsync($"{_command.Path}/{file}");
if (_grammarChecker.Check(script, out var errMsg))
{
continue;
}
log($"error(s) found in {file}");
errors.Add(errMsg);
hasErr = true;
}
log($"SQL Continuous Integrate finish");
return(new ExecutionResult()
{
Success = !hasErr,
ErrorMessage = errors.Count == 0 ? string.Empty : errors.Aggregate((prev, next) => $"{prev}\n{next}")
});
}