ColumnSet help

ColumnSet.js

'use strict'
const sql = require('../sql').elements
const helpers = require('pg-promise')().helpers

const cs = new helpers.ColumnSet([
  '?id',
  {
    name: 'animal_id'
  }, {
    name: 'species_id'
  }, {
    name: 'sex',
    def: 'unk'
  }
], {table: { table: 'elements' }})

class Elements {
  constructor (db, pgp) {
    this.db = db
    this.pgp = pgp
    this.cs = cs || pgp.helpers.ColumnSet([
      '?id',
      {
        name: 'animal_id'
      }, {
        name: 'species_id'
      }, {
        name: 'sex',
        def: 'unk'
      }
    ], {table: { table: 'elements' }})
  }

  all () {
    return this.db.many(sql.all)
  }
}

module.exports = Elements

'use strict'
const sql = require('../sql').elements

let cs;

class Elements {
  constructor (db, pgp) {
    this.db = db
    this.pgp = pgp
    cs = cs || pgp.helpers.ColumnSet([
      '?id', 'animal_id', 'species_id',
       {
        name: 'sex',
        def: 'unk'
      }
    ], {table: { table: 'elements' }})
  }

  all () {
    return this.db.many(sql.all)
  }
}

module.exports = Elements