public void testRawStatements() { const string BASE_SQL_DIR = @"../../../../../../../gsp_sqlfiles/TestCases/"; string rootdir = 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); }