zapatos

zapatos copied to clipboard

column name camel case conversion

27

Hey, it's me again :) Would it be possible to add camel case conversion for column names? E.g. the column name is `foo_bar`, but in TS/JS, it is more common...

moltar

Make Insertable and Updatable interfaces for updatable view (using trigger instead of insert/update) writable

2

As the docs say, "[...] `Updatable` and `Insertable` interfaces for tables and views that aren’t writable are now `{ [key: string]: never }` instead of `{}`. I have a view...

jcassee

Currently in order to set config you need to call `setConfig`, which will affect all queries. I currently use `queryListener`, `resultListener` and `transactionListener` in order to log requests, but I...

kalda341

Fix transactions returning bad connections to the pool

2

Currently, errors in transactions do not get propagated to the pool. This means failed connections will get returned to the pool, effectively poisoning the well. This change simply passes exceptions...

jfrconley

Type error when using `SELECT FOR UPDATE` with schemas outside the default search path

3

Currently, the `of` parameter of the `lock` option accepts a `Table` string. This doesn't type check properly when using a schema outside the default search path, as the Zapatos type...

codetheweb

v6 schema generation dislikes empty schemas

4

If you have a schema that is empty, global aggregate types are set to `any`. This can easily be resolved by removing it from the config but zapatos should handle...

purge

Feature requests: Pass multiple `Whereable` to `select` shortcuts for easy `OR` queries

1

Trying to do something like this: ```ts const conditions = [] // dynamic if (something) { conditions.push({email: "[email protected]"}) } if (somethingElse) { conditions.push({phone: "+12345678910"}) } db.selectOne("person", conditions) ``` Unless I'm...

andybarron

Numeric and money Postgres types should be typed as strings

7

They are [returned as a `string` by node-postgres](https://github.com/brianc/node-postgres/issues/811#issuecomment-116644535) because `number` will lose precision for certain decimal values and integers above `Number.MAX_SAFE_INTEGER`.

jgonera

Improve the way library deals with objects in WHERE queries (WIP)

5

Changes: - Allow setting NULL-s via object. Query builder will now use "IS" operator instead of the (incorrect) "=". - Allow `undefined` properties in objects you provide to WHERE queries....

panta82

Anyone tried Zapatos with Deno?

13

This is a fantastic idea and excellent library. Any chance that it might work in Deno scripts?

shah