Util/test/Util.Datas.Tests.Integration/Sql/Builders/Base/ColumnCollectionTest.cs

using Util.Datas.Sql.Builders.Core;
using Xunit;

namespace Util.Datas.Tests.Sql.Builders.Base {
    /// <summary>
    /// 列集合测试
    /// </summary>
    public class ColumnCollectionTest {
        /// <summary>
        /// 列集合
        /// </summary>
        private readonly ColumnCollection _columns;

        /// <summary>
        /// 测试初始化
        /// </summary>
        public ColumnCollectionTest() {
            _columns = new ColumnCollection();
        }

        /// <summary>
        /// 添加列集合
        /// </summary>
        [Fact]
        public void TestAddColumns_1() {
            _columns.AddColumns("a");
            Assert.Equal( 1, _columns.Count );
            Assert.Equal( "a", _columns[0].Name );
        }

        /// <summary>
        /// 添加列集合 - 表别名
        /// </summary>
        [Fact]
        public void TestAddColumns_2() {
            _columns.AddColumns( "a","b" );
            Assert.Equal( 1, _columns.Count );
            Assert.Equal( "a", _columns[0].Name );
            Assert.Equal( "b", _columns[0].TableAlias );
        }

        /// <summary>
        /// 添加列集合 - 多个列
        /// </summary>
        [Fact]
        public void TestAddColumns_3() {
            _columns.AddColumns( "a,b" );
            Assert.Equal( 2, _columns.Count );
            Assert.Equal( "a", _columns[0].Name );
            Assert.Equal( "b", _columns[1].Name );
        }

        /// <summary>
        /// 添加列集合 - 列带表别名
        /// </summary>
        [Fact]
        public void TestAddColumns_4() {
            _columns.AddColumns( "a.b,c" );
            Assert.Equal( 2, _columns.Count );
            Assert.Equal( "a", _columns[0].TableAlias );
            Assert.Equal( "b", _columns[0].Name );
            Assert.Equal( "c", _columns[1].Name );
        }

        /// <summary>
        /// 添加列集合 - 设置表别名
        /// </summary>
        [Fact]
        public void TestAddColumns_5() {
            _columns.AddColumns( "a.b,c","d" );
            Assert.Equal( 2, _columns.Count );
            Assert.Equal( "a", _columns[0].TableAlias );
            Assert.Equal( "b", _columns[0].Name );
            Assert.Equal( "d", _columns[1].TableAlias );
            Assert.Equal( "c", _columns[1].Name );
        }

        /// <summary>
        /// 添加列集合 - 列别名
        /// </summary>
        [Fact]
        public void TestAddColumns_6() {
            _columns.AddColumns( "  a . b  as  e, c  f ", "d" );
            Assert.Equal( 2, _columns.Count );
            Assert.Equal( "a", _columns[0].TableAlias );
            Assert.Equal( "b", _columns[0].Name );
            Assert.Equal( "e", _columns[0].ColumnAlias );
            Assert.Equal( "d", _columns[1].TableAlias );
            Assert.Equal( "c", _columns[1].Name );
            Assert.Equal( "f", _columns[1].ColumnAlias );
        }

        /// <summary>
        /// 移除列
        /// </summary>
        [Fact]
        public void TestAddColumns_7() {
            _columns.AddColumns( "a.b,c", "d" );
            _columns.AddColumns( "e.f" );
            _columns.RemoveColumns("d.c");
            Assert.Equal( 2, _columns.Count );
            Assert.Equal( "a", _columns[0].TableAlias );
            Assert.Equal( "b", _columns[0].Name );
            Assert.Equal( "e", _columns[1].TableAlias );
            Assert.Equal( "f", _columns[1].Name );
        }
    }
}