C# (CSharp) SQLParser.Tests SqlFormatter 예제들

예제 #1

파일: SqlFormatterTests.cs 프로젝트: flipworldit/SqlFormatter

        public void SimpleQueryWithColumns()
        {
            var query = "SELECT name, fio FROM TESTABLEtttV";

            var visiter = new SqlFormatter();

            SQLParser.Parser.Parse(query.ToUpper(), visiter, Enums.SQLType.TSql);

            var result = visiter.GetText();

            var expectedResult =
                @"SELECT
    NAME,
    FIO
FROM TESTABLETTTV";

            Debug.WriteLine(result);
            Assert.AreEqual(expectedResult, result, "Результирующие запросы должны быть равны");
        }

예제 #2

파일: SqlFormatterTests.cs 프로젝트: flipworldit/SqlFormatter

        public void inner_JOIN()
        {
            var query = "SELECT name FROM T1 INNER JOIN T2 ON T1.F = T2.F";

            var visiter = new SqlFormatter();

            SQLParser.Parser.Parse(query.ToUpper(), visiter, Enums.SQLType.TSql);

            var result = visiter.GetText();

            var expectedResult =
                @"SELECT
    NAME
FROM T1
    INNER JOIN T2 ON T1.F = T2.F";

            Debug.WriteLine(result);
            Assert.AreEqual(expectedResult, result, "Результирующие запросы должны быть равны");
        }

예제 #3

파일: SqlFormatterTests.cs 프로젝트: flipworldit/SqlFormatter

        public void GroupBy()
        {
            var query = "SELECT F FROM T1 GROUP BY F";

            var visiter = new SqlFormatter();

            SQLParser.Parser.Parse(query.ToUpper(), visiter, Enums.SQLType.TSql);

            var result = visiter.GetText();

            var expectedResult =
                @"SELECT
    F
FROM T1
GROUP BY F";

            Debug.WriteLine(result);
            Assert.AreEqual(expectedResult, result, "Результирующие запросы должны быть равны");
        }

예제 #4

파일: SqlFormatterTests.cs 프로젝트: flipworldit/SqlFormatter

        public void UnionQuery()
        {
            var query = "SELECT name FROM T1 union SELECT fio FROM T2";

            var visiter = new SqlFormatter();

            SQLParser.Parser.Parse(query.ToUpper(), visiter, Enums.SQLType.TSql);

            var result = visiter.GetText();

            var expectedResult =
                @"SELECT
    NAME
FROM T1
UNION
SELECT
    FIO
FROM T2";

            Debug.WriteLine(result);
            Assert.AreEqual(expectedResult, result, "Результирующие запросы должны быть равны");
        }