public void TestTeradataRenameTable() { parser.sqltext = "RENAME TABLE renA TO renX;"; int ret = parser.parse(); Assert.IsTrue(ret == 0, parser.Errormessage); Assert.IsTrue(parser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstrename); TRenameStmt renameTable = (TRenameStmt)parser.sqlstatements.get(0); Assert.IsTrue(renameTable.NewName.ToString().Equals("renX", StringComparison.CurrentCultureIgnoreCase)); Assert.IsTrue(renameTable.OldName.ToString().Equals("renA", StringComparison.CurrentCultureIgnoreCase)); }
public void testColumn() { TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix); sqlparser.sqltext = "RENAME COLUMN customer.customer_num TO c_num;"; Assert.IsTrue(sqlparser.parse() == 0); TRenameStmt stmt = (TRenameStmt)sqlparser.sqlstatements.get(0); Assert.IsTrue(stmt.OldName.ToString().Equals("customer.customer_num", StringComparison.CurrentCultureIgnoreCase)); Assert.IsTrue(stmt.NewName.ToString().Equals("c_num", StringComparison.CurrentCultureIgnoreCase)); Assert.IsTrue(stmt.ObjectType == EDbObjectType.column); }
public void testTable() { TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix); sqlparser.sqltext = "RENAME TABLE new_table TO items;"; Assert.IsTrue(sqlparser.parse() == 0); TRenameStmt stmt = (TRenameStmt)sqlparser.sqlstatements.get(0); Assert.IsTrue(stmt.OldName.ToString().Equals("new_table", StringComparison.CurrentCultureIgnoreCase)); Assert.IsTrue(stmt.NewName.ToString().Equals("items", StringComparison.CurrentCultureIgnoreCase)); Assert.IsTrue(stmt.ObjectType == EDbObjectType.table); }