using Agendas.NHibernate;

namespace Agendas.Repositories.Tests.Infraestructure
{
	public static class NhHelperTest
	{
		public static void CleanDb()
		{
			var sf = NhHelper.GetSessionFactory();

			var session = sf.OpenStatelessSession();
			session.CreateSQLQuery("DELETE FROM Ponentes").ExecuteUpdate();
			session.CreateSQLQuery("DELETE FROM Patrocinadores").ExecuteUpdate();
			session.CreateSQLQuery("DELETE FROM Evento").ExecuteUpdate();
			session.CreateSQLQuery("DELETE FROM Patrocinador").ExecuteUpdate();
			session.CreateSQLQuery("DELETE FROM Roles").ExecuteUpdate();
			session.CreateSQLQuery("DELETE FROM Persona").ExecuteUpdate();
		}
	}
}