pretest.js

// Copyright IBM Corp. 2017,2018. All Rights Reserved.
// Node module: loopback-connector-mssql
// This file is licensed under the MIT License.
// License text available at https://opensource.org/licenses/MIT

'use strict';

require('./test/init');
var exec = require('child_process').exec;
var path = require('path');

var isWin = (process.platform === 'win32');
var sqlFileDir = path.resolve(__dirname, 'test', 'tables.sql');
var sqlDependencyDir = path.resolve(__dirname, 'node_modules', '.bin', 'sqlcmd');

if (!process.env.CI) {
  return console.log('not seeding DB with test db');
}

if (!process.env.MSSQL_HOST) process.env.MSSQL_HOST = global.getConfig().host;
if (!process.env.MSSQL_PORT) process.env.MSSQL_PORT = global.getConfig().port;
if (!process.env.MSSQL_USER) process.env.MSSQL_USER = global.getConfig().user;
if (!process.env.MSSQL_PASSWORD) process.env.MSSQL_PASSWORD = global.getConfig().password;
if (!process.env.MSSQL_DATABASE) process.env.MSSQL_DATABASE = global.getConfig().database;

var catFileCmd = (isWin ? 'type ' : 'cat ') + sqlFileDir;

var sqlcmd = catFileCmd + ' | ' + sqlDependencyDir + ' -s ' + process.env.MSSQL_HOST + ' -o ' + process.env.MSSQL_PORT +
' -u ' + process.env.MSSQL_USER + ' -p ' + process.env.MSSQL_PASSWORD + ' -d ' + process.env.MSSQL_DATABASE;

exec(sqlcmd, function(err, result) {
  if (err) return console.log('Database seeding failed.\n%s', err);
  return console.log('Database successfully seeded.');
});