// app.js

'use strict';

const Config        = require('./config');
const Bookshelf     = require('./bookshelf');

var Driver = Bookshelf.Model.extend({
    tableName: 'drivers',
    idAttribute: 'driver_id',
    cars: function() {
        return this.hasMany( Car );
    }
});

var Car = Bookshelf.Model.extend({
    tableName: 'cars',
    idAttribute: 'car_id',
    driver: function() {
        return this.belongsTo( Driver );
    }
});

new Driver()
    .where({
        driver_id: 2
    })
    .fetch({
        withRelated: ['cars.driver_id']
    })
    .then(function(driver) {
        console.log('RELATED CAR:', JSON.stringify(driver));

        console.log('DRIVER DATA', driver);
    });