using FluentNHibernate.Cfg;
using FluentNHibernate.Cfg.Db;
using NHibernate;
using NHibernate.Cfg;
using NHibernate.Tool.hbm2ddl;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SSS.Models
{
    public static class DbSession
    {
        private static ISessionFactory _sessionFactory;
        public static ISessionFactory Factory
        {
            get { return _sessionFactory ?? (_sessionFactory = CreateSessionFactory()); }
        }
        public static ISession OpenSession()
        {
            return Factory.OpenSession();
        }

        private static ISessionFactory CreateSessionFactory()
        {
            return Fluently.Configure()
                .Database(
                    MySQLConfiguration.Standard
                        .ConnectionString("server=server;user id=user;database=database;password=password") //connection string encryption
                //Your connectionstring goes here.
                )
                .Mappings(m =>
                    m.FluentMappings.AddFromAssemblyOf<DbMappings>())
                .ExposeConfiguration(TreatConfiguration)
                .BuildSessionFactory();
        }


        private static void TreatConfiguration(Configuration configuration)
        {
            var update = new SchemaUpdate(configuration);
            update.Execute(false, true);
        }

    }
}