using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.SQLExaminer;

namespace Tango.PPC.SchemaSynchronizer.CLI
{
    class Program 
    {
        static void Main(string[] args)
        {
            Core.DataSource source = new Core.DataSource();
            source.Address = "localhost\\SQLEXPRESS";
            source.Catalog = "Tango";

            Core.DataSource target = new Core.DataSource();
            target.Address = "localhost\\SQLPPC";
            target.Catalog = "Tango";

            ExaminerConfigurationBuilder builder = new ExaminerConfigurationBuilder(ExaminerConfigurationType.Schema);

            builder.
                SetSource(source).
                SetTarget(target).
                Synchronize();

            var config = builder.Build();

            ExaminerProcess process = new ExaminerProcess(config, ExaminerProcessType.Schema);
            process.Progress += (x, msg) => 
            {
                Console.WriteLine(msg);
            };
            var result = process.Execute().Result;

            if (result.ExitCode == ExaminerProcessExitCode.Success)
            {
                Console.ForegroundColor = ConsoleColor.Green;
                Console.WriteLine("Completed!");
            }
            else
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Failed!");
            }

            Console.ReadLine();
        }
    }
}