Skip to content
Snippets Groups Projects
persondao.test.js 784 B
Newer Older
nilstes's avatar
nilstes committed
var mysql = require("mysql");

var pool = mysql.createPool({
nilstes's avatar
nilstes committed
  connectionLimit: 1,
nilstes's avatar
nilstes committed
  host: "mysql",
  user: "root",
  password: "secret",
nilstes's avatar
nilstes committed
  database: "supertestdb",
nilstes's avatar
nilstes committed
  debug: false
});

nilstes's avatar
nilstes committed
test("query db", done => {
nilstes's avatar
nilstes committed
  console.log("Connecting to database");
nilstes's avatar
nilstes committed
  
  function callback(data) {
    console.log("Callback: " + data);
    expect(data).toBe("SUCCESS");
    done();
  }

  pool.getConnection((err, connection) => {
nilstes's avatar
nilstes committed
    console.log("Connected to database");
    if (err) {
nilstes's avatar
nilstes committed
      callback("Feil ved kobling til databasen");
nilstes's avatar
nilstes committed
    } else {
      connection.query(
nilstes's avatar
nilstes committed
        "select 1",
nilstes's avatar
nilstes committed
        (err, rows) => {
          connection.release();
          if (err) {
nilstes's avatar
nilstes committed
            callback(err);
nilstes's avatar
nilstes committed
          } else {
nilstes's avatar
nilstes committed
            callback("SUCCESS");
nilstes's avatar
nilstes committed
          }
        }
      );
    }
nilstes's avatar
nilstes committed
  });
nilstes's avatar
nilstes committed
});