def delete(my, log=False): column = my.get_value("name") search_type = my.get_value("search_type") search_type_obj = SearchType.get(search_type) table = search_type_obj.get_table() database = search_type_obj.get_database() # remove it from the table if log: AlterTableUndo.log_drop(database, table, column) sql = DbContainer.get(database) try: from pyasm.search.sql import Sql if Sql.get_database_type() == 'SQLServer': statement = 'ALTER TABLE [%s] DROP "%s" %s' % \ (table, column) else: statement = 'ALTER TABLE "%s" DROP COLUMN "%s"' % (table, column) sql.do_update(statement) except SqlException, e: print("WARNING: %s" % e)
def delete(my,log=False): column = my.get_value("name") search_type = my.get_value("search_type") search_type_obj = SearchType.get(search_type) table = search_type_obj.get_table() database = search_type_obj.get_database() # remove it from the table if log: AlterTableUndo.log_drop(database, table, column) sql = DbContainer.get(database) try: from pyasm.search.sql import Sql if Sql.get_database_type() == 'SQLServer': statement = 'ALTER TABLE [%s] DROP "%s" %s' % \ (table, column) else: statement = 'ALTER TABLE "%s" DROP COLUMN "%s"' % (table, column) sql.do_update(statement) except SqlException, e: print("WARNING: %s" % e )
def execute(my): search_type_obj = SearchType.get(my.search_type) database = search_type_obj.get_database() table = search_type_obj.get_table() alter = AlterTable(my.search_type) alter.drop(my.attr_name) # log it first before committing AlterTableUndo.log_drop(database,table, my.attr_name) alter.commit()
def execute(self): search_type_obj = SearchType.get(self.search_type) database = search_type_obj.get_database() table = search_type_obj.get_table() alter = AlterTable(self.search_type) alter.drop(self.attr_name) # log it first before committing AlterTableUndo.log_drop(database,table, self.attr_name) alter.commit()