public void TestInformixFiles()
{
String[] allfiles = System.IO.Directory.GetFiles(UnitTestCommon.BASE_SQL_DIR() + @"informix\", "*.sql", System.IO.SearchOption.AllDirectories);
int cnt = 0;
foreach (var file in allfiles)
{
FileInfo info = new FileInfo(file);
UnitTestCommon.checkFile(parser, info.FullName);
cnt++;
}
}
public void TestRedshiftFiles2()
{
String[] allfiles = System.IO.Directory.GetFiles(UnitTestCommon.BASE_SQL_DIR() + @"new_dotnet\redshift\", "*.sql", System.IO.SearchOption.AllDirectories);
int cnt = 0;
List <string> excludeFiles = new List <string> {
"modulo.sql", "qualified_name_drop_table.sql", "with_clause_select_insert.sql"
};
foreach (var file in allfiles)
{
FileInfo info = new FileInfo(file);
if (UnitTestCommon.excludeFile(info.Name, excludeFiles))
{
continue;
}
UnitTestCommon.checkFile(parser, info.FullName);
cnt++;
}
}
public void TestPostgreSQLFiles2()
{
String[] allfiles = System.IO.Directory.GetFiles(UnitTestCommon.BASE_SQL_DIR + @"new_dotnet\postgresql\", "*.sql", System.IO.SearchOption.AllDirectories);
int cnt = 0;
List <String> excludeFiles = new List <string> {
"like_in_select_list.sql", "modulo.sql", "with_clause_select_insert.sql",
"with_select_create_view.sql"
};
foreach (var file in allfiles)
{
FileInfo info = new FileInfo(file);
if (UnitTestCommon.excludeFile(info.Name, excludeFiles))
{
continue;
}
UnitTestCommon.checkFile(parser, info.FullName);
cnt++;
}
}
public void testRawStatements()
{
string rootdir = UnitTestCommon.BASE_SQL_DIR() + @"mdx\";
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvmdx);
sqlparser.sqlfilename = rootdir + "case.sql";
sqlparser.getrawsqlstatements();
Assert.IsTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmdxselect);
Assert.IsTrue(sqlparser.sqlstatements.get(1).sqlstatementtype == ESqlStatementType.sstmdxselect);
sqlparser.sqlfilename = rootdir + "createmember.sql";
sqlparser.getrawsqlstatements();
Assert.IsTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmdxcreatemember);
sqlparser.sqlfilename = rootdir + "createsessioncube.sql";
sqlparser.getrawsqlstatements();
Assert.IsTrue(sqlparser.sqlstatements.size() == 1);
Assert.IsTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmdxcreatesessioncube);
sqlparser.sqlfilename = rootdir + "createsubcube.sql";
sqlparser.getrawsqlstatements();
Assert.IsTrue(sqlparser.sqlstatements.size() == 6);
Assert.IsTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmdxcreatesubcube);
Assert.IsTrue(sqlparser.sqlstatements.get(1).sqlstatementtype == ESqlStatementType.sstmdxselect);
Assert.IsTrue(sqlparser.sqlstatements.get(2).sqlstatementtype == ESqlStatementType.sstmdxcreatesubcube);
Assert.IsTrue(sqlparser.sqlstatements.get(3).sqlstatementtype == ESqlStatementType.sstmdxselect);
Assert.IsTrue(sqlparser.sqlstatements.get(4).sqlstatementtype == ESqlStatementType.sstmdxcreatesubcube);
Assert.IsTrue(sqlparser.sqlstatements.get(5).sqlstatementtype == ESqlStatementType.sstmdxselect);
sqlparser.sqlfilename = rootdir + "drillthrough.sql";
sqlparser.getrawsqlstatements();
Assert.IsTrue(sqlparser.sqlstatements.size() == 1);
Assert.IsTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmdxdrillthrough);
sqlparser.sqlfilename = rootdir + "scope.sql";
sqlparser.getrawsqlstatements();
Assert.IsTrue(sqlparser.sqlstatements.size() == 2);
Assert.IsTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmdxscope);
Assert.IsTrue(sqlparser.sqlstatements.get(1).sqlstatementtype == ESqlStatementType.sstmdxscope);
}
