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