import { expect } from 'chai';
import sinon from 'sinon';
import { expectsql, getTestDialect, sequelize } from '../../support';

const dialectName = getTestDialect();

describe('QueryInterface#dropTable', () => {
  afterEach(() => {
    sinon.restore();
  });

  it('produces a DROP TABLE query with cascade', async () => {
    if (sequelize.dialect.supports.dropTable.cascade) {
      const stub = sinon.stub(sequelize, 'queryRaw');

      await sequelize.getQueryInterface().dropTable('myTable', { cascade: true });

      expect(stub.callCount).to.eq(1);
      const firstCall = stub.getCall(0);
      expectsql(firstCall.args[0] as string, {
        default: 'DROP TABLE IF EXISTS [myTable] CASCADE;',
      });
    } else {
      await expect(sequelize.getQueryInterface().dropTable('myTable', { cascade: true })).to.be.rejectedWith(`The following options are not supported by dropTableQuery in ${dialectName}: cascade`);
    }
  });
});