Is it possible to use selects in migrations?

[sh84]

I would like something like this:

async up(): Promise<void> {
    const otherTableId = await this.execute('SELECT id FROM other_table WHERE ...');
    this.addSql('alter table test add other_table_id int');
    this.addSql('update table test set other_table_id = ' + otherTableId);
}

But I haven't found a way to make a select and get the result of its execution in the migration..

[B4nan]

There is a driver instance on the Migration class, so something like this should work:

const res = await this.driver.execute('...');

But thinking about that now, it will probably not use the same transaction.

[sh84]

I try it:

KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
at Client_MySQL2.acquireConnection (/app/node_modules/knex/lib/client.js:347:26

[B4nan]

Yeah thats the issue, migrations are executed with single connection in the pool. In next rc there is execute method that handles this.