Function cleanup

test/integration/query-interface.test.js:38–56

(sequelize)

  describe('showAllTables', () => {
    it('should not contain views', async function() {
      async function cleanup(sequelize) {
        if (dialect === 'db2') {
          await sequelize.query('DROP VIEW V_Fail');
        } else if (dialect === 'oracle') {
          const plsql = [
            'BEGIN',
            'EXECUTE IMMEDIATE',
            '\'DROP VIEW V_Fail\';',
            'EXCEPTION WHEN OTHERS THEN',
            '  IF SQLCODE != -942 THEN',
            '    RAISE;',
            '  END IF;',
            'END;'
          ].join(' ');
          await sequelize.query(plsql);
        } else {
          await sequelize.query('DROP VIEW IF EXISTS V_Fail');
        }
      }
      await this.queryInterface.createTable('my_test_table', { name: DataTypes.STRING });
      await cleanup(this.sequelize);
      const sql = dialect === 'db2' ? 'CREATE VIEW V_Fail AS SELECT 1 Id FROM SYSIBM.SYSDUMMY1' : `CREATE VIEW V_Fail AS SELECT 1 Id${  Support.addDualInSelect()}`;