packages.config « Tango.PPC.Storage « Modules « PPC « Visual_Studio « Software - Tango - Twine softwares

about summary refs log tree commit diff stats

path: root/Software/Visual_Studio/PPC/Modules/Tango.PPC.Storage/packages.config

blob: b3daf0d6cedea8f07fbc879c0d983021145335af (plain)

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="EntityFramework" version="6.2.0" targetFramework="net461" />
</packages>

0000DD; font-weight: bold } /* Literal.Number.Float */ .highlight .mh { color: #0000DD; font-weight: bold } /* Literal.Number.Hex */ .highlight .mi { color: #0000DD; font-weight: bold } /* Literal.Number.Integer */ .highlight .mo { color: #0000DD; font-weight: bold } /* Literal.Number.Oct */ .highlight .sa { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Affix */ .highlight .sb { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Backtick */ .highlight .sc { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Char */ .highlight .dl { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Delimiter */ .highlight .sd { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Doc */ .highlight .s2 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Double */ .highlight .se { color: #0044dd; background-color: #fff0f0 } /* Literal.String.Escape */ .highlight .sh { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Heredoc */ .highlight .si { color: #3333bb; background-color: #fff0f0 } /* Literal.String.Interpol */ .highlight .sx { color: #22bb22; background-color: #f0fff0 } /* Literal.String.Other */ .highlight .sr { color: #008800; background-color: #fff0ff } /* Literal.String.Regex */ .highlight .s1 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Single */ .highlight .ss { color: #aa6600; background-color: #fff0f0 } /* Literal.String.Symbol */ .highlight .bp { color: #003388 } /* Name.Builtin.Pseudo */ .highlight .fm { color: #0066bb; font-weight: bold } /* Name.Function.Magic */ .highlight .vc { color: #336699 } /* Name.Variable.Class */ .highlight .vg { color: #dd7700 } /* Name.Variable.Global */ .highlight .vi { color: #3333bb } /* Name.Variable.Instance */ .highlight .vm { color: #336699 } /* Name.Variable.Magic */ .highlight .il { color: #0000DD; font-weight: bold } /* Literal.Number.Integer.Long */

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Tango.SQLExaminer
{
    public class ExaminerSequenceConfigurationRunner
    {
        public event EventHandler<String> Log;
        public event EventHandler<ExaminerSequenceItem> ScriptExecuting;

        public String SequenceFile { get; private set; }

        public Core.DataSource Source { get; private set; }

        public Core.DataSource Target { get; private set; }

        public String MachineSerialNumber { get; private set; }

        public String ScriptsFolder { get; private set; }

        public ExaminerSequenceConfiguration Configuration { get; private set; }

        public ExaminerSequenceConfigurationRunner(String sequenceFile, String scriptsFolder, Core.DataSource source, Core.DataSource target, String machineSerialNumber)
        {
            SequenceFile = sequenceFile;
            ScriptsFolder = scriptsFolder;
            Source = source;
            Target = target;
            MachineSerialNumber = machineSerialNumber;
            Configuration = ExaminerSequenceConfiguration.FromFile(sequenceFile);
        }

        public Task Run()
        {
            return Task.Factory.StartNew(() =>
            {
                ExaminerSequenceConfiguration sequence = Configuration;

                foreach (var item in sequence.Items.OrderBy(x => x.Index))
                {
                    ScriptExecuting?.Invoke(this, item);

                    ExaminerConfigurationBuilder builder = new ExaminerConfigurationBuilder(Path.Combine(ScriptsFolder, item.FileName));


                    if (item.Direction == ExaminerSequenceItemDirection.SourceToTarget)
                    {
                        builder.SetSource(Source);
                        builder.SetTarget(Target);
                    }
                    else
                    {
                        builder.SetSource(Target);
                        builder.SetTarget(Source);
                    }

                    if (item.RequiresSerialNumber)
                    {
                        builder.SetMachineSerialNumber(MachineSerialNumber);
                    }

                    builder.Synchronize();

                    ExaminerProcess process = new ExaminerProcess(builder.Build(), item.Type == ExaminerSequenceItemType.Schema ? ExaminerProcessType.Schema : ExaminerProcessType.Data);
                    process.Progress += (x, msg) =>
                    {
                        if (msg != null && !msg.Contains("SQL Examiner"))
                        {
                            Log?.Invoke(this, msg);
                        }
                    };

                    var result = process.Execute().Result;

                    if (result.ExitCode != ExaminerProcessExitCode.Success)
                    {
                        throw new InvalidDataException(String.Format("Synchronization script '{0}' has terminated with exit code '{1}'.", item.Name, result.ExitCode));
                    }
                }

            });
        }
    }
}