

def test_undo_create_sequence_in_schema(self):
    'Revert creating a sequence in a non-public schema'
    inmap = self.std_map()
    inmap.update({
        'schema s1': {
            'sequence seq1': {
                'start_value': 1,
                'increment_by': 1,
                'max_value': None,
                'min_value': None,
                'cache_value': 1,
            },
        },
    })
    sql = self.to_sql(inmap, ['CREATE SCHEMA s1'], revert=True)
    assert (sql == ['DROP SEQUENCE s1.seq1'])

dataset/ETHPy150Open perseas/Pyrseas/tests/dbobject/test_sequence.py SequenceUndoSqlTestCase.test_undo_create_sequence_in_schema/original