'sqlmigrate outputs forward looking SQL.'

@override_settings(MIGRATION_MODULES={'migrations': 'migrations.test_migrations'})
def test_sqlmigrate_forwards(self):

    out = io.StringIO()
    call_command('sqlmigrate', 'migrations', '0001', stdout=out)
    output = out.getvalue().lower()
    index_tx_start = output.find(connection.ops.start_transaction_sql().lower())
    index_op_desc_author = output.find('--    create    model    author')
    index_create_table = output.find('create    table')
    index_op_desc_tribble = output.find('--    create    model    tribble')
    index_op_desc_unique_together = output.find('--    alter    unique_together')
    index_tx_end = output.find(connection.ops.end_transaction_sql().lower())
    self.assertGreater(index_tx_start, (-1), 'Transaction    start    not    found')
    self.assertGreater(index_op_desc_author, index_tx_start, 'Operation    description    (author)    not    found    or    found    before    transaction    start')
    self.assertGreater(index_create_table, index_op_desc_author, 'CREATE    TABLE    not    found    or    found    before    operation    description    (author)')
    self.assertGreater(index_op_desc_tribble, index_create_table, 'Operation    description    (tribble)    not    found    or    found    before    CREATE    TABLE    (author)')
    self.assertGreater(index_op_desc_unique_together, index_op_desc_tribble, 'Operation    description    (unique_together)    not    found    or    found    before    operation    description    (tribble)')
    self.assertGreater(index_tx_end, index_op_desc_unique_together, 'Transaction    end    not    found    or    found    before    operation    description    (unique_together)')
