using DbUp;
using Sentry;
using System;
using System.Reflection;

namespace Neo.Legitimate.Web.DBUp
{
    public static class DatabaseUpdator
    {
        private static string _connectionString = null;
        private static string ConnectionString
        {
            get
            {
                if (_connectionString == null)
                    _connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

                return _connectionString;
            }
        }

        public static void UpdateDB()
        {
            var connectionString = ConnectionString;

            EnsureDatabase.For.SqlDatabase(connectionString);

            var upgrader = DeployChanges.To
                    .SqlDatabase(connectionString)
                    .WithScriptsAndCodeEmbeddedInAssembly(Assembly.GetExecutingAssembly(), (string s) => s.Contains("Legitimate"))
                    .LogToConsole()
                    .Build();

            var result = upgrader.PerformUpgrade();
        }
    }
}