import startContainer, { Options as WithContainerOptions, killOldContainers, } from '@databases/with-container'; import {getMySqlConfigSync} from '@databases/mysql-config'; const {createConnection} = require('mysql2'); const config = getMySqlConfigSync(); const DEFAULT_MYSQL_DEBUG = !!process.env.MYSQL_TEST_DEBUG || config.test.debug; const DEFAULT_IMAGE = process.env.MYSQL_TEST_IMAGE || config.test.image; const DEFAULT_CONTAINER_NAME = process.env.MYSQL_TEST_CONTAINER_NAME || config.test.containerName; if ( process.env.MYSQL_TEST_CONNECT_TIMEOUT_SECONDS && !/^\d+$/.test(process.env.MYSQL_TEST_CONNECT_TIMEOUT_SECONDS) ) { throw new Error( 'Expected MYSQL_TEST_CONNECT_TIMEOUT_SECONDS environment variable to be a positive integer', ); } const DEFAULT_CONNECT_TIMEOUT_SECONDS = process.env .MYSQL_TEST_CONNECT_TIMEOUT_SECONDS ? parseInt(process.env.MYSQL_TEST_CONNECT_TIMEOUT_SECONDS, 10) : config.test.connectTimeoutSeconds; const DEFAULT_MYSQL_PORT = 3306; const DEFAULT_MYSQL_USER = process.env.MYSQL_TEST_USER || config.test.mySqlUser; const DEFAULT_MYSQL_PASSWORD = process.env.MYSQL_TEST_PASSWORD || config.test.mySqlPassword; const DEFAULT_MYSQL_DB = process.env.MYSQL_TEST_DB || config.test.mySqlDb; export interface Options extends Omit< WithContainerOptions, 'internalPort' | 'enableDebugInstructions' | 'testConnection' > { mysqlUser: string; mysqlPassword: string; mysqlDb: string; } export async function waitForConnection( databaseURL: string, timeoutSeconds: number, ) { const start = Date.now(); const timeoutMilliseconds = timeoutSeconds * 1000; let lastAttempt = false; while (true) { await new Promise((resolve) => setTimeout(resolve, 1000)); let conn: any; try { try { await new Promise((resolve, reject) => { let errored = false; conn = createConnection(databaseURL); const createConnectionErr: any = new Error(); conn.once('connect', () => { resolve(); }); conn.on('error', (err: any) => { if (errored) return; errored = true; createConnectionErr.message = err.message; createConnectionErr.code = err.code; createConnectionErr.errno = err.errno; createConnectionErr.sqlState = err.sqlState; reject(createConnectionErr); }); }); const result = await new Promise((resolve, reject) => { const queryErr: any = new Error(); conn.query(`SELECT 1 + 1 AS foo;`, (err: any, result: any) => { if (err) { queryErr.message = err.message; reject(queryErr); } else { resolve(result); } }); }); if (result && result[0] && result[0].foo === 2) { break; } else { if (lastAttempt) { throw new Error('Got unexpected result: ' + JSON.stringify(result)); } } } catch (ex) { if (lastAttempt) { throw ex; } } } finally { conn.end(() => { // ignore error closing connection }); } if (Date.now() - timeoutMilliseconds > start) { lastAttempt = true; } } } export async function killDatabase(options: Partial = {}) { await killOldContainers({ debug: DEFAULT_MYSQL_DEBUG, containerName: DEFAULT_CONTAINER_NAME, ...options, }); } export default async function getDatabase(options: Partial = {}) { const { mysqlUser, mysqlPassword, mysqlDb, environment, ...rawOptions }: Options = { debug: DEFAULT_MYSQL_DEBUG, image: DEFAULT_IMAGE, containerName: DEFAULT_CONTAINER_NAME, connectTimeoutSeconds: DEFAULT_CONNECT_TIMEOUT_SECONDS, mysqlUser: DEFAULT_MYSQL_USER, mysqlPassword: DEFAULT_MYSQL_PASSWORD, mysqlDb: DEFAULT_MYSQL_DB, defaultExternalPort: DEFAULT_MYSQL_PORT, externalPort: config.test.port, ...options, }; const {proc, externalPort, kill} = await startContainer({ ...rawOptions, internalPort: DEFAULT_MYSQL_PORT, environment: { MYSQL_ALLOW_EMPTY_PASSWORD: 'true', MYSQL_HOST: '127.0.0.1', MYSQL_ROOT_HOST: '%', ...environment, MYSQL_USER: mysqlUser, MYSQL_PASSWORD: mysqlPassword, MYSQL_DATABASE: mysqlDb, }, enableDebugInstructions: `To view logs, run with MYSQL_TEST_DEBUG=true environment variable.`, }); const databaseURL = `mysql://${mysqlUser}:${mysqlPassword}@localhost:${externalPort}/${mysqlDb}`; await waitForConnection(databaseURL, rawOptions.connectTimeoutSeconds); return { proc, databaseURL, kill, }; }