public void TestCreateFileFormat1()
{
TGSqlParser sqlParser = new TGSqlParser(EDbVendor.dbvsnowflake);
sqlParser.sqltext = @"CREATE FILE FORMAT IF NOT EXISTS TestFormat11
TYPE = CSV
FIELD_DELIMITER = 'c';";
Assert.IsTrue(sqlParser.parse() == 0);
Assert.IsTrue(sqlParser.sqlstatements[0].sqlstatementtype == ESqlStatementType.sstCreateFileFormat);
TCreateFileFormatStmt sql = (TCreateFileFormatStmt)sqlParser.sqlstatements[0];
Assert.IsTrue(sql.FileFormatName.ToString().Equals(@"TestFormat11"
, StringComparison.CurrentCultureIgnoreCase));
Assert.IsTrue(sql.FormatOptions.ToString().Equals(@"TYPE = CSV
FIELD_DELIMITER = 'c'"
, StringComparison.CurrentCultureIgnoreCase));
}
public void TestCreateFileFormat2()
{
TGSqlParser sqlParser = new TGSqlParser(EDbVendor.dbvsnowflake);
sqlParser.sqltext = @"CREATE FILE FORMAT IF NOT EXISTS TestFormat
TYPE = CSV
COMMENT = 'Test comment';";
Assert.IsTrue(sqlParser.parse() == 0);
Assert.IsTrue(sqlParser.sqlstatements[0].sqlstatementtype == ESqlStatementType.sstCreateFileFormat);
TCreateFileFormatStmt sql = (TCreateFileFormatStmt)sqlParser.sqlstatements[0];
Assert.IsTrue(sql.FileFormatName.ToString().Equals(@"TestFormat"
, StringComparison.CurrentCultureIgnoreCase));
// Console.WriteLine(sql.FormatOptions.ToString());
Assert.IsTrue(sql.FormatOptions.ToString().Equals(@"TYPE = CSV
COMMENT = 'Test comment'"
, StringComparison.CurrentCultureIgnoreCase));
}
