John Fawcett comments

Results 40 comments of


                                            John Fawcett

Can't figure out how to do NOT LIKE

oh and if all else fails: ```javascript name: { $custom: ['name not like $1', '%test%'] } ```

Add better syntax for non-parameterized values in condition builder

Maaayyyybe something like: ``` javascript var query = { type: 'select' , table: ['users', 'groups'] , where: { 'users.id': mosql.$('groups.userId') , 'groups.name': 'admin' } }; ```

Conflict target's where should not have a table name

Hrmmm looking at the Postgres docs, it looks like the where clause for the conflict is for an _index_predicate_, not a proper conditional block. So, that would be a bug...

Conflict target's where should not have a table name

Ahhhh I see. You can always fallback to using the `$custom` helper in scenarios like this ```javascript { type: 'insert', table: 'entries', values: [ { orgId: '...', otherId: '...', amount:...

helper: 'order' object syntax won't guaranteed order

Agreed. I'll add a deprecation warning for the old object and string syntaxes.

helper: 'order' object syntax won't guaranteed order

Yeah, @LinusU I agree there. I'll work on getting this implemented soon

Create Index query type

Beautiful!

ES2016 is probably more appropriate

Oh I was excited to move this repo to use yarn 👍

Insert sub query

This is going to require a bit of re-working. Perhaps we should make it a bit more semantic. Currently, we only support simple inserts `("colA", "colB") values ($1, $2)`. The...

Insert sub query

Ok yeah I think I'm gonna go with the latter. But I'm gonna sleep on it