using System.Threading.Tasks;
using Util.Data.Sql;
using Util.Tests.Configs;
using Util.Tests.Models;

namespace Util.Data.Dapper.Tests.SqlQuery {
    /// <summary>
    /// Oracle Sql查询对象测试 - 获取单个对象测试
    /// </summary>
    public partial class OracleQueryTest {
        /// <summary>
        /// 测试获取单个实体
        /// </summary>
        [Fact]
        public void TestExecuteSingle() {
            var result = _sqlQuery.Select( "ProductId as Id,Code" ).From( "Product" ).Where( "ProductId", TestConfig.Id ).ExecuteSingle<Product>();
            Assert.Equal( TestConfig.Id, result.Id );
            Assert.Equal( TestConfig.Value, result.Code );
        }

        /// <summary>
        /// 测试获取单个实体
        /// </summary>
        [Fact]
        public async Task TestExecuteSingleAsync() {
            var result = await _sqlQuery.Select( "ProductId as Id,Code" ).From( "Product" ).Where( "ProductId", TestConfig.Id ).ExecuteSingleAsync<Product>();
            Assert.Equal( TestConfig.Id, result.Id );
            Assert.Equal( TestConfig.Value, result.Code );
        }

        /// <summary>
        /// 测试获取单个实体
        /// </summary>
        [Fact]
        public void TestToEntity() {
            var result = _sqlQuery.Select( "ProductId as Id,Code" ).From( "Product" ).Where( "ProductId", TestConfig.Id ).ToEntity<Product>();
            Assert.Equal( TestConfig.Id, result.Id );
            Assert.Equal( TestConfig.Value, result.Code );
        }

        /// <summary>
        /// 测试获取单个实体
        /// </summary>
        [Fact]
        public async Task TestToEntityAsync() {
            var result = await _sqlQuery.Select( "ProductId as Id,Code" ).From( "Product" ).Where( "ProductId", TestConfig.Id ).ToEntityAsync<Product>();
            Assert.Equal( TestConfig.Id, result.Id );
            Assert.Equal( TestConfig.Value, result.Code );
        }
    }
}