wubzz
02281ef91b
Fix valuesForUndefined actual query being executed. Fixes #1268
2016-03-15 21:47:58 +01:00
wubzz
c79453ac3a
Change _.pluck -> _.map in all tests
2016-03-15 18:12:40 +01:00
wubzz
f37824a11e
Fix indentation?
2016-03-15 18:12:36 +01:00
wubzz
1d27fb8550
Update lodash from 3.7.0 -> 4.6.0
2016-03-15 18:11:13 +01:00
wubzz
b614a2f81c
Update regex for named bindings
2016-03-11 20:41:19 +01:00
wubzz
7cc827f6cf
Merge pull request #1258 from jurko-gospodnetic/code-cleanup
...
Code cleanup (trimmed trailing spaces & removed tabs)
2016-03-08 13:13:48 +01:00
Jurko Gospodnetić
16a076c1a0
trim trailing spaces
...
Only left alone ones in `test/tape/transactions.js` which would just
cause unnecessary conflicts and get cleaned up by separate pull
request #1257 anyway.
2016-03-08 08:44:01 +01:00
Rod Calumpong
ab003ac7c9
Allow returning to be used with oracle update
2016-03-07 16:35:04 -08:00
Rhys van der Waerden
a42766afb1
Merge pull request #1164 from wubzz/bugfix/orWhere_with_object_should_be_and
...
Bugfix/or where with object should be and
2016-02-18 18:41:26 +11:00
wubzz
942877c0fe
OrWhere({..}) Treat as 'AND', not 'OR'. Fixes #1118
2016-02-18 06:28:14 +01:00
Mikael Lepistö
96aa4d8d91
Merge pull request #1147 from alexrsagen/master
...
Add collate for columns (MySQL)
2016-02-15 20:09:43 +02:00
Rhys van der Waerden
5ebbeb07b4
Merge branch 'bugfix/make_raw_backwards_compatible' of https://github.com/wubzz/knex into wubzz-bugfix/make_raw_backwards_compatible
2016-02-06 14:08:30 +11:00
wubzz
c75f8e25e8
Added test for JS Date
2016-02-04 16:58:35 +01:00
Alejandro Oviedo
a1e6dbb0f7
fixes bug when using dot in as identifier
2016-02-02 14:46:18 -03:00
Mikael Lepistö
79a77ac932
Removes object keys with value undefined from being added to DB in update. Clean version of pq #962 fixes issue #961 .
2016-02-01 11:51:02 +02:00
wubzz
0d20e5b534
.raw bindings should allow single Non-Array values.
2016-01-30 14:52:07 +01:00
wubzz
82b38740b7
Forgot to commit the updated Test for dropPrimary
2016-01-29 23:55:51 +01:00
Mikael Konutgan
aa142f20f7
Add option to timestamps to be not null and default to the current
...
timestamp
2016-01-25 16:35:58 +01:00
gmichael225
b130ad66e2
Merge remote-tracking branch 'root/master' into sqlite3-dialect-escaping
...
# Conflicts:
# lib/dialects/sqlite3/index.js
2016-01-25 07:43:03 +11:00
Alexander Sagen
2317279e8c
Add collate for columns (MySQL)
...
This had been requested in #599 a year ago, but a PR was never created.
I have included a test that passed when i ran it.
2016-01-19 23:06:25 +01:00
Ryan Fink
4985a65bfc
Add syntactic sugar - andWhereBetween and andWhereNotBetween
2016-01-09 07:35:12 -05:00
gmichael225
4b2c0efff1
SQL compliant escaping, removed dialect-specific escaping for now
2015-12-24 11:33:48 +11:00
Sky Morey
eed0004031
mssql: added top (?) back to fix that error. also removed loading of empty file
2015-12-15 16:48:19 -06:00
Sky Morey
ae256f2943
mssql limit and offset for sql2012
2015-12-15 14:56:56 -06:00
Sky Morey
f99d3952a1
changed mssql to compact create format. changed unique index to unique constraint
2015-12-14 16:20:45 -06:00
Sky Morey
aa8df07711
merge
2015-12-14 11:10:46 -06:00
Sky Morey
371815d7e6
made SCHEMA upper case for mssql
2015-12-14 09:56:53 -06:00
Michael G
91b159db2d
Added test for SQLite single-quote escaping as per http://www.sqlite.org/lang_expr.html
2015-12-14 18:38:56 +11:00
Sky Morey
afd6b66624
Final build of mssql provider, all tests pass
2015-12-09 17:53:53 -06:00
Sky Morey
7c1120e0e2
in progress
2015-12-08 11:37:31 -06:00
Brian Black
27b0a57823
do not escape doublequotes in postgres
2015-11-29 18:54:05 -05:00
Brian Black
332ed3b811
tests for escaping single-quotes
2015-11-29 18:44:12 -05:00
Rhys van der Waerden
51ef27bd4f
Merge pull request #1058 from elhigu/support-question-mark-escaping-for-knex-rendered-queries
...
Support question mark escaping for knex rendered queries
2015-11-28 13:47:53 +11:00
Mikael Lepistö
30d42ebab9
Replace undefined with DEFAULT by default and NULL with separate configuration option.
2015-11-14 19:46:34 +02:00
Mikael Lepistö
0c74f786a5
Optionally use DEFAULT instead of NULL when translating undefined to SQL value.
2015-11-14 19:46:34 +02:00
Mikael Lepistö
db7e7feb2f
Documentation and test
2015-11-14 11:07:43 +02:00
Rhys van der Waerden
3a8a6e8967
Merge pull request #1044 from elhigu/added-jsonbcolumn-type
...
Jsonb type to schema.
2015-11-12 08:49:33 +11:00
Rhys van der Waerden
bd97610940
Merge pull request #1046 from ErisDS/issue-1028
...
Distinct modifier support for aggregate functions
2015-11-10 00:06:02 +11:00
Hannah Wolfe
f72892b5b9
Distinct modifier support for aggregate functions
...
closes #1028
- add support for count(distinct *), avg(distinct *) and sum(distinct *)
- min and max don't really make sense with distinct, so didn't add those
2015-11-09 12:48:42 +00:00
Chuy Del Castillo
6e7049c8bd
checking for plain object instead object
2015-11-06 16:17:50 -07:00
Mikael Lepistö
0ac6152c7f
Jsonb type to schema.
2015-11-04 13:46:34 +02:00
harriha
5003b41dae
Add tests for a join with value 0
2015-08-30 23:21:11 +03:00
Daniel Teixeira
8e780a8115
rename .using to .withSchema
2015-08-14 19:17:06 -03:00
Daniel Teixeira
3f8f50425f
add schema support for schema builder
2015-08-09 23:04:53 -03:00
Daniel Teixeira
17df5c6542
add basic schema support on queries
2015-08-09 20:38:26 -03:00
Jani Evakallio
cb89930155
Add queryBuilder as first parameter to queryBuilder.modify
2015-07-16 15:49:30 +01:00
Jani Evakallio
299bbfa60b
Rename compose to modify
2015-07-16 15:15:04 +01:00
Jani Evakallio
4f833dae42
Unit test for queryBuilder.compose
2015-07-09 15:59:29 +01:00
Vincent Schoettke
285816ccdd
default to timestamp with time zone for oracle
2015-06-24 10:15:51 +02:00
Tim Griesser
0c0864761c
Test and fix for #749
2015-04-24 10:31:23 -04:00
