addMovie(movie) {
return knex('movies')
.insert(movie)
.returning('*');

this returns only id

{
"status": "success",
"data": [
23
]
}

const user = await queries.addUser(ctx.request.body); // <- what we must do with this user?
return passport.authenticate('local', (err, user, info, status) => {

Pulling the branch v2 from the repo, I would expect all tests to run successfully, but in fact three fail:

• POST fails, because only the inserted id is returned, and not the object itself
• PUT fails, returns error code and no update made
• DELETE fails, also returns error and no delete made

const router = new Router();
const BASE_URL = `/api/v1/movies`;

You can use this:

const router = new Router({prefix:"/api/v1/movies"})

• Create knex mecanism to run tests in every other machine

knexjs Doc

var knex = require('knex')({
  client: 'mysql',
  connection: {
    host : '127.0.0.1',
    user : 'your_database_user',
    password : 'your_database_password',
    database : 'myapp_test'
  },
  migrations: {
    tableName: 'migrations'
  }
});

Solution

connection: {
      host: 'localhost',
      user : 'postgres',
      password : '****',
      database : 'koa_api_test'
    }