using Microsoft.Data.SqlClient;
using Quadarax.Application.QLiberace.Base;
using Quadarax.Application.QLiberace.Base.Repositories;
using Quadarax.Application.QLiberace.Common.Domain;
using Quadarax.Application.QLiberace.Console.Commands.Base;
using Quadarax.Foundation.Core.Data.Domain;
using Quadarax.Foundation.Core.QConsole.Argument;
using Quadarax.Foundation.Core.QConsole.Attributes;
using Quadarax.Foundation.Core.QConsole;
using Quadarax.Foundation.Core.Value;
using Quadarax.Foundation.Core.Data.Interface.Domain;

namespace Quadarax.Application.QLiberace.Console
{
       [CommandDefinition]
       internal class TestCmd : DbContextCommand
    {

        #region *** Properties ***

        public override string Name => Constants.Commands.Test.Name;
        public override string Description => Constants.Commands.Test.Description;
        
        #endregion
        #region *** Fields ***

        #endregion

        #region *** Constructor ***

        public TestCmd(Engine engine) : base(engine)
        {
        }
        #endregion
        
        #region *** EXECUTE ***
        protected override Result OnExecute(IDomainContextResolver resolver)
        {
            WriteInfo("Running test...");
            var resultCode = Constants.ReturnCodes.Ok;
            try
            {
                var uow = new UnitOfWork<QlbrcDbContext>(resolver);
                var repo = new RepoTenant(uow.As<IDataDomain>(), new QlbrcContext(null, null, 1));

                var tenant = repo.GetByCode("default");
                WriteInfo(tenant?.ToString());
            }
            catch (SqlException e)
            {
                return HandleConnectionException(e);
            }

            return new Result(resultCode);
        }

        
        #endregion

        #region *** Private operations ***
        
        #endregion
    }
}