simple-query-builder

This provides four simple functions for building parameterized queries that you can pass into pg.query

NOTE: Version 2.0 is not backwards compatible. It fixes orderBy and changes the parameters of the find function. The final parameter is now just an array of columns which should be queried with "LIKE". Also if orderBy is included in the "params" object, it should be an array of strings of the form "columnName.direction" where ".direction" is ".asc" or ".desc" or omitted.

find(tableName,params, columnsToSelect,likeColumns=[])

make a search parameterized query

parameters

| name | description | | --- | --- | | tableName | the name of the table | | params | a map of columns to values | | columnsToSelect | a list of columns to select | | likeColumns | if you have like queries, this would be a list of which columns should be queried with "like"

returns

an object with a text property containing the query string and a values property containing the values of the parameterized query

update(tableName,columnValueMap,primaryKeyName,primaryKeyVal)

make an update parameterized query

parameters

| name | description | | --- | --- | | tableName | the name of the table | | params | a map of columns to values | | primaryKeyName | the name of the primary key column | | primaryKeyVal | the value of the primary key of the thing you want to update |

returns

an object with a text property containing the query string and a values property containing the values of the parameterized query

del

make a delete parameterized query- notice it's not called delete because that's a reserved word in js

parameters

| name | description | | --- | --- | | tableName | the name of the table | | primaryKeyName | the name of the primary key column | | primaryKeyVal | the value of the primary key of the thing you want to update |

returns

an object with a text property containing the query string and a values property containing the values of the parameterized query

insert(tableName,primaryKeyName,columnValueMap)

make an insert parameterized query

parameters

| name | description | | --- | --- | | tableName | the name of the table | | primaryKeyName | the name of the primary key column | | columnValueMap | a map of columns to values |

returns

an object with a text property containing the query string and a values property containing the values of the parameterized query