Ejemplo n.º 1
0
        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
                });
            }
        }
Ejemplo n.º 2
0
        /// <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}")
            });
        }