simple-query-builder v2.0.0
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