knexline.js

'use strict';

const knex = require('knex');

module.exports = {
  knexline,
}

function knexline(model, qb) {
  const modelTable = model.identity;
  qb = qb || knex(modelTable);

  const methods = {
    criteria,
    join,
    populate,
    queryBuilder: () => qb,
  };

  return methods;

  function populate() {
    // once it's necessary
  }

  function criteria(criteria) {
    /* already built */
    qb = qb

    return methods;
  }

  function join(property) {
    const [table, field] = property.split('.');

    qb = qb.join(
      table,
      `${modelTable}.id`,
      `${table}.id`
    );

    return methods;
  }

}

const columns = [{
  property: 'location.name',
  alias: 'Location',
}];

//playground

const model = {
  identity: 'machine',
};

const criteria = {}

const joins = ['location.name'];
const selects = ['name', 'id'];

const query = joins.reduce(
  (kl, join) => kl.join(join),
  knexline(model).criteria(criteria)
)
  .queryBuilder()
  .select(selects)