'use strict';

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

const Knex      = require( 'knex' )( require('./config').database );
const Bookshelf = require('bookshelf')( Knex );


var Server = Bookshelf.Model.extend({
    tableName: 'servers',
    operating_system: function() {
        return this.hasOne( OS );
    },
    application: function(){
        return this.hasMany( Application ).through( AppServer );
    }
});

var OS = Bookshelf.Model.extend({
    tableName: 'operating_systems',
    server: function() {
        return this.belongsToMany( Server );
    }
});

var AppServer = Bookshelf.Model.extend({
    tableName: 'servers_applications',
    server: function() {
        return this.belongsTo( Server );
    },
    application: function(){
        return this.belongsTo( Application );
    }
});

var Application = Bookshelf.Model.extend({
    tableName: 'applications',
    appServer: function() {
        return this.belongsToMany( Server ).through( AppServer );
    }
});

new Server()
    //.where({id: 1})
    .fetch({
        withRelated: ['operating_system', 'application']
    })
    .then((result) => {
        console.log('SERVERs:', JSON.stringify(result));

        Knex.destroy(() => {
            console.log('Terminated Connection pool');
        });
    })
    .catch((err) => {
        console.log('Query Error:',err);

        Knex.destroy(() => {
            console.log('Terminated Connection pool');
        });
    });