Function setupMSSQL

packages/migrate/src/utils/setupMSSQL.ts:28–51

(options: SetupParams, databaseName: string)

}

export async function setupMSSQL(options: SetupParams, databaseName: string): Promise<void> {
  const { connectionString } = options
  const { dirname } = options
  const config = getMSSQLConfig(connectionString)
  const connectionPool = new mssql.ConnectionPool(config)
  const connection = await connectionPool.connect()

  try {
    await connection.query(`
CREATE DATABASE [${databaseName}-shadowdb]
CREATE DATABASE [${databaseName}]
`)
  } catch (e) {
    console.warn(e)
  }

  if (dirname !== '') {
    let schema = `USE [${databaseName}]\n`
    schema += fs.readFileSync(path.join(dirname, 'setup.sql'), 'utf-8')
    await connection.query(schema)
  }

  await connection.close()
}

export async function tearDownMSSQL(options: SetupParams, databaseName: string) {
  const { connectionString } = options