Ozum Eldogan
e7e4f8d840
Fix: whereNot and orWhereNot for _objectWhere
...
_objectWhere is not generating correct sql when used with whereNot
and/or orWhereNot
2015-02-26 17:07:26 +02:00
Ozum Eldogan
ff9ede59e9
whereNot, orWhereNot
...
whereNot, orWhereNot methods added to single and wrapped wheres.
2015-02-26 16:31:30 +02:00
David H. Bronke
ea5c15f2aa
Added unit test for #704 .
2015-02-24 10:04:02 -06:00
Ben Drucker
c199761c59
Merge pull request #641 from gjvargas/fdbsql_adapter
...
FoundationDB SQL Layer Adapter
2015-02-10 18:28:08 -05:00
Nathan Williams
2d6d2f28f7
Adapter for FoundationDB SQL Layer
2015-02-04 14:56:41 -05:00
George Gensure
16b234c565
Adding multiple union tests for unwrapped/wrapped
...
Tests revealed some problems with argument and wrap interpretation,
corrected.
2015-02-03 21:11:42 -05:00
George Gensure
f6952c42b5
Respect union wrap parameter as last argument
...
union's wrap parameter was being ignored and misinterpreted when
building statements. Maintain the spirit of the original implementation
(variable number of callbacks) consistent with other instances of
variadic-like behavior (select/columns), including handling list of
callbacks in array, while still processing the wrap parameter.
2015-02-03 12:33:17 -05:00
Ben Drucker
9767fdce69
Merge pull request #628 from whitelynx/master
...
Fix bare subqueries in insert statements.
2015-01-15 17:18:28 -05:00
Ben Drucker
13f52ff219
Document and test use of literals in joins via knex.raw
...
Closes #626
2015-01-15 17:13:05 -05:00
David H. Bronke
ab4713d63f
Added unit test for #627 .
2015-01-15 16:05:34 -06:00
Ben Drucker
27810950ed
Properly handle limit 0
2014-11-30 19:47:50 -05:00
Philipp Waldmann
8866af423d
support for nested having
2014-11-20 20:52:18 +01:00
Ben Drucker
ffe736e4af
Use chai throw assertions instead of manual try catch
2014-11-14 12:25:44 -05:00
Ville Lahdenvuo
2961bb1ed4
Add POSIX operator support for Postgres
...
Closes #562 , Closes #561
2014-11-14 12:21:36 -05:00
Rune Halvorsen
fc0f9feaaa
Added sqlite3 dialect version of whereRaw/andWhereRaw
...
* SQLite uses integers, not booleans
* whereIn/whereNotIn with empty array uses a boolean
* Closes #477
2014-11-12 12:23:01 -05:00
Tim Griesser
2ff6323f39
Support for .join(table, raw) and join using
2014-10-01 19:18:25 -04:00
Tim Griesser
3d22ab2499
Add where(bool) test
2014-10-01 16:10:06 -04:00
Tim Griesser
5280e6e91c
Handle empty array case for whereIn, fix #477
2014-10-01 15:50:48 -04:00
Vincent Schoettke
72cf342273
Fixes #319 . Inserting multiple rows with default values
2014-09-08 16:10:43 +02:00
Vincent Schoettke
f3874ac651
Fixed several jshint warnings. Added strict mode
2014-09-01 17:19:34 +02:00
Vincent Schoettke
8f5ccc1e45
Fix #440 , orderBy with raw argument should use direction
2014-09-01 14:16:07 +02:00
Tim Griesser
4fffee9b73
Enable SQLite3 fixed tests
2014-08-31 14:10:23 -04:00
Tim Griesser
f965648225
Fix subquery insert for sqlite3
2014-08-31 14:07:58 -04:00
Tim Griesser
1bc6293353
JOINs should not work with update in sqlite
2014-08-31 14:01:53 -04:00
Tim Griesser
886634eb02
Fix #441 , raw in first argument of join
2014-08-31 12:20:31 -04:00
Vincent Schoettke
393769b80d
Merge pull request #445 from vschoettke/sqlite3-fix-raw-order-by
...
sqlite3 - fixed raw order bys
2014-08-28 21:45:07 +02:00
Vincent Schoettke
00a41a0bb2
Fixed offset without limit for mysql and sqlite3
2014-08-28 13:53:39 +02:00
Vincent Schoettke
d6e414721f
sqlite3 - fixed raw order bys
2014-08-28 11:52:05 +02:00
Vincent Schoettke
d0b8c717e4
oracle - fixed non-supported options
2014-08-27 10:10:20 +02:00
Vincent Schoettke
02eb8cbe5e
More thorough test of query builder
2014-08-26 23:05:39 +02:00
Tim Griesser
289c661152
Fix #427 , raw / subqueries on insert
2014-08-24 14:50:29 -04:00
Tim Griesser
cd4864e740
Merge branch 'master' of github.com:tgriesser/knex
...
* 'master' of github.com:tgriesser/knex:
oracle - fixed first and added more tests
Fix bad argument to builder.whereNull
don't throw away the postgres client's password
oracle - fixed SQL for dropping multiple columns
Do not attempt to release undefined connections from pool, #414
2014-08-24 14:26:56 -04:00
Vincent Schoettke
f545c86081
oracle - fixed first and added more tests
2014-08-22 01:13:15 +02:00
Tim Griesser
75be73c45e
Merge branch 'master' of github.com:tgriesser/knex
...
* 'master' of github.com:tgriesser/knex:
oracle - fix returning for non-integer types
oracle - fixed create if not exists
2014-08-20 14:20:47 -04:00
Vincent Schoettke
2eaedd0afa
oracle - fix returning for non-integer types
2014-08-20 09:34:32 +02:00
Tim Griesser
ac984b9e9b
Add .joinRaw and remove deprecated join notices
2014-08-14 18:02:50 -04:00
Tim Griesser
0330c33c43
Merge pull request #379 from SohumB/feature/nested-raw
...
Allow nested Raw queries
2014-08-14 15:14:41 -04:00
Vincent Schoettke
0ba6b49495
oracle - added support for multiple returning values
2014-08-13 21:53:42 +02:00
Vincent Schoettke
9ef99b5f92
Added oracle support
2014-08-13 21:53:42 +02:00
Oliver Schneider
0cffdc6c8c
Removed "collate nocase" in test order by.
2014-07-25 23:16:02 +02:00
Sohum Banerjea
c8b003aea3
Unit test for nested raws
2014-07-19 20:02:49 +10:00
Tim Griesser
570a551f41
Trim whitespace when escaping
2014-07-14 15:19:03 -04:00
Tim Griesser
8d54993fe3
Test for #350 , update with limit mysql
2014-07-08 07:06:39 -04:00
Calvin Metcalf
ef981aa566
chained not, or, and and
2014-07-03 14:19:36 -04:00
Tim Griesser
920d1ef16e
Fix #344 , case insensitive operators
2014-06-30 12:42:33 -04:00
Tim Griesser
295f57d296
Fix #282 , add raw support in groupBy / orderBy
...
Adds groupByRaw, orderByRaw as convenience methods
for groupBy(raw) / orderBy(raw)
2014-06-27 11:58:06 -04:00
Tim Griesser
e9dea0435d
Support alias subselect with 'as' method
2014-06-14 16:26:01 -04:00
Tim Griesser
215864ec70
.whereExists / .whereNotExists may also take knex builder
2014-06-14 09:58:38 -04:00
Tim Griesser
9d5fed20d1
Fix for multiple orderBy statements in sqlite3
2014-06-10 13:26:20 -04:00
Tim Griesser
ad3f9f6f5e
SQlite3 DDL fixes, more for #46
...
Don't throw when trying to add foreign key
Allow dropping a column in sqlite3
2014-06-09 15:28:22 -04:00