222 Commits

Author SHA1 Message Date
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