public void ObfuscatingFormatReformatMatch(string FileName)
        {
            string      inputSQL       = Utils.GetTestFileContent(FileName, Utils.INPUTSQLFOLDER);
            ITokenList  tokenized      = _tokenizer.TokenizeSQL(inputSQL);
            XmlDocument parsedOriginal = _parser.ParseSQL(tokenized);

            string      obfuscatedSql   = _obfuscatingFormatter.FormatSQLTree(parsedOriginal);
            ITokenList  tokenizedAgain  = _tokenizer.TokenizeSQL(obfuscatedSql);
            XmlDocument parsedAgain     = _parser.ParseSQL(tokenizedAgain);
            string      unObfuscatedSql = _standardFormatter.FormatSQLTree(parsedAgain);

            Utils.StripCommentsFromSqlTree(parsedOriginal);
            string standardFormattedSql = _standardFormatter.FormatSQLTree(parsedOriginal);

            if (!inputSQL.Contains(Utils.INVALID_SQL_WARNING))
            {
                Assert.AreEqual(standardFormattedSql, unObfuscatedSql, "standard-formatted vs obfuscatd and reformatted");
            }
        }
Пример #2
0
        public void ObfuscatingFormatReformatMatch(string FileName)
        {
            string     inputSQL       = Utils.GetTestFileContent(FileName, Utils.INPUTSQLFOLDER);
            ITokenList tokenized      = _tokenizer.TokenizeSQL(inputSQL);
            Node       parsedOriginal = _parser.ParseSQL(tokenized);
            string     obfuscatedSql  = _obfuscatingFormatter.FormatSQLTree(parsedOriginal);

            var inputToSecondPass = obfuscatedSql;

            if (inputToSecondPass.StartsWith(Utils.ERROR_FOUND_WARNING))
            {
                inputToSecondPass = inputToSecondPass.Replace(Utils.ERROR_FOUND_WARNING, "");
            }

            ITokenList tokenizedAgain  = _tokenizer.TokenizeSQL(inputToSecondPass);
            Node       parsedAgain     = _parser.ParseSQL(tokenizedAgain);
            string     unObfuscatedSql = _standardFormatter.FormatSQLTree(parsedAgain);

            Utils.StripCommentsFromSqlTree(parsedOriginal);
            string standardFormattedSql = _standardFormatter.FormatSQLTree(parsedOriginal);

            Assert.AreEqual(standardFormattedSql, unObfuscatedSql, "standard-formatted vs obfuscatd and reformatted");
        }