using AltNetHispano.Agendas.Domain;
using ConfOrm;
using ConfOrm.NH;
using NHibernate;
using NHibernate.Cfg;
using NHibernate.Tool.hbm2ddl;

namespace Agendas.NHibernate
{
	public static class NhHelper
	{
		private static ISessionFactory _sessionfactory;
		private static Configuration _cfg;

		public static Configuration GetConfiguration()
		{
			if (_cfg == null)
			{
				var orm = new ObjectRelationalMapper();
				orm.TablePerClass<Persona>();
				orm.TablePerClass<Evento>();
				orm.TablePerClass<Track>();
				orm.TablePerClass<TrackLog>();
				orm.TablePerClass<Cuenta>();
				orm.TablePerClass<Patrocinador>();

				orm.Cascade<Evento, Persona>(Cascade.None);
				orm.Cascade<Persona, Evento>(Cascade.None);
				
				orm.Cascade<Persona, Cuenta>(Cascade.All | Cascade.DeleteOrphans);

				var mapper = new Mapper(orm);

				var mapping = mapper.CompileMappingFor(typeof(Evento).Assembly.GetTypes());
				
				_cfg = new Configuration();
				_cfg.Configure();
				_cfg.AddDeserializedMapping(mapping, null);
			}
			return _cfg;
		}

		public static ISessionFactory GetSessionFactory()
		{
			if (_sessionfactory == null)
			{
				var cfg = GetConfiguration();

#if DEBUG
				var schemaValidator = new SchemaValidator(cfg);
				try
				{
					schemaValidator.Validate();
				}
				catch
				{
					try
					{
						var schemaUpdate = new SchemaUpdate(cfg);
						schemaUpdate.Execute(false, true);

						schemaValidator.Validate();
					}
					catch
					{
						var schemaExport = new SchemaExport(cfg);
						schemaExport.Create(false, true);
					}
				}

#endif

				_sessionfactory = cfg.BuildSessionFactory();
			}
			return _sessionfactory;
		}
	}
}