sql-fns

sql-fns.js

/* sql-tag
mysql2
minigrate */

// from redux
function compose(...funcs) {
  if (funcs.length === 0) {
    return arg => arg
  }

  if (funcs.length === 1) {
    return funcs[0]
  }

  return funcs.reduce((a, b) => (...args) => a(b(...args)))
}

const pipe = (...parts) => parts.join(' ')

const select = (...columns) =>
  next => pipe(
    `SELECT ${columns.join(', ')}`,
    next
  )

const from = table =>
  next => pipe(
    `FROM ${table}`,
    next
  )

const where = column =>
  predicate =>
    value =>
      next => pipe(
        `WHERE ${column} ${predicate} ${value}`,
        next
      )

console.log(
  compose(
    select('*'),
    from('users'),
    where('id')('=')(30)
  )()
)

/* console.log(
select(
  '*'
)(
  from(
    'users'
  )(
    where('id')('=')(30)()
  )
)
) */