X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Finitializers%2Fmigrator.ts;h=77203ae24139ac9f40cceb7a86f1927af545687f;hb=1d26d05fd9e919b94a57b7c09cda101fde664d5f;hp=539e2bc8fbaeb17a6ba52af3334db7296086fb6e;hpb=c1e791bad0b079af67398f6407221e6dcbb573dd;p=github%2FChocobozzz%2FPeerTube.git diff --git a/server/initializers/migrator.ts b/server/initializers/migrator.ts index 539e2bc8f..77203ae24 100644 --- a/server/initializers/migrator.ts +++ b/server/initializers/migrator.ts @@ -1,8 +1,9 @@ import * as path from 'path' -import { readdirPromise } from '../helpers/core-utils' import { logger } from '../helpers/logger' import { LAST_MIGRATION_VERSION } from './constants' import { sequelizeTypescript } from './database' +import { readdir } from 'fs-extra' +import { QueryTypes } from 'sequelize' async function migrate () { const tables = await sequelizeTypescript.getQueryInterface().showAllTables() @@ -13,8 +14,13 @@ async function migrate () { let actualVersion: number | null = null - const [ rows ] = await sequelizeTypescript.query('SELECT "migrationVersion" FROM "application"') - if (rows && rows[0] && rows[0].migrationVersion) { + const query = 'SELECT "migrationVersion" FROM "application"' + const options = { + type: QueryTypes.SELECT as QueryTypes.SELECT + } + + const rows = await sequelizeTypescript.query<{ migrationVersion: number }>(query, options) + if (rows?.[0]?.migrationVersion) { actualVersion = rows[0].migrationVersion } @@ -52,9 +58,9 @@ export { // --------------------------------------------------------------------------- async function getMigrationScripts () { - const files = await readdirPromise(path.join(__dirname, 'migrations')) + const files = await readdir(path.join(__dirname, 'migrations')) const filesToMigrate: { - version: string, + version: string script: string }[] = []