def test_drop_add_column3(self):
        stmts = [CREATE_STMT2, DROP_COL_STMT]
        inmap = self.std_map()
        inmap['schema public'].update({'table t1': {
            'columns': [{'c2': {'type': 'text'}}, {'c3': {'type': 'date'}},
                        {'c4': {'type': 'text'}}]}})
        sql = self.to_sql(inmap, stmts)
        assert fix_indent(sql[0]) == "ALTER TABLE t1 ADD COLUMN c3 date"
        assert fix_indent(sql[1]) == "ALTER TABLE t1 ADD COLUMN c4 text"
        assert sql[2] == "ALTER TABLE t1 DROP COLUMN c1"
Drop and re-add table columns from table with dropped column
dataset/ETHPy150Open perseas/Pyrseas/tests/dbobject/test_column.py/ColumnToSqlTestCase.test_drop_add_column3