994 Commits

Author SHA1 Message Date
Alejandro Oviedo
a1e6dbb0f7 fixes bug when using dot in as identifier 2016-02-02 14:46:18 -03:00
wubzz
57bac6cd58 Fix some indentation and test comment 2016-02-01 21:27:30 +01:00
wubzz
80ee5a8021 select version() => select 1 = 1 for test
version() doesn't exist in all dbs.
2016-02-01 20:54:14 +01:00
wubzz
eb80e008ae Merge remote-tracking branch 'refs/remotes/tgriesser/master' into bugfix/knex_hangs_when_pool_is_filled_with_trs 2016-02-01 20:40:07 +01:00
wubzz
eea94a8896 TimeoutError when acquiring con is not possible 2016-02-01 20:40:06 +01: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
03f4993642 Merge branch 'master' of github.com:tgriesser/knex 2015-12-15 14:57:14 -06:00
Sky Morey
ae256f2943 mssql limit and offset for sql2012 2015-12-15 14:56:56 -06:00
Mikael Lepistö
9236ca95e3 Fixed typo and moved LockError emitting to inside _getLock function 2015-12-15 21:47:59 +02:00
Mikael Lepistö
d510b2377f Made tests compatible with node 0.10 and 0.12 2015-12-15 21:37:01 +02:00
Mikael Lepistö
4ae8974a95 Command to migration client to allow freeing migration lock manually 2015-12-15 21:37:01 +02:00
Mikael Lepistö
8f8fe5979e Fixed error messages to be more descriptive and minor refactoring 2015-12-15 21:37:01 +02:00
Dustin Martin
b323013b20 Add migration locking so multiple services cannot try to run migrations
at same time
2015-12-15 21:37:01 +02:00
Sky Morey
fbbda0731b removed test sqlserver from test/knexfile.js 2015-12-14 16:21:27 -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
10b415ed7d turned off mssql from build test 2015-12-14 11:01:54 -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
Mikael Lepistö
c22a51e5ad Merge pull request #886 from bblack/dialect_escaping
Per-dialect escaping
2015-12-13 20:50:44 +02:00
Sky Morey
4f340d6096 Merge branch 'master' of github.com:tgriesser/knex 2015-12-10 15:16:23 -06:00
Sky Morey
1793f9ad45 first pass of build modifications 2015-12-10 15:14:43 -06:00
Sky Morey
198aa0db4b fixed lint issues, fixed mssql transaction 2015-12-10 13:35:37 -06:00
Rhys van der Waerden
84472e6e7e Merge pull request #1081 from tgriesser/fix/1080
Include `_debug` property in `QueryBuilder#clone`.
2015-12-10 15:31:14 +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
8ef5d5899d Include _debug property in QueryBuilder#clone.
Adds a test for `QueryBuilder#clone`. Changes `clone()` behaviour to transfer the debug flag (`QueryBuilder#_debug`) to the cloned instance.

Fixes #1080
2015-11-30 00:21:08 +11: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ö
68bf4dde08 Merge pull request #1066 from dustinmartin/add-status-method
Add migration status method
2015-11-25 13:52:29 +02:00
Mikael Lepistö
b3452c5158 Merge pull request #1043 from elhigu/allow-using-default-instead-of-null-when-translating-undefined-to-sql
Optionally use DEFAULT instead of NULL when translating undefined to SQL value.
2015-11-23 23:09:36 +02:00
Dustin Martin
d9ac2c1f8f Add status method
Returns 0 if all migrations are run and DB is up to date. Return negative number if DB is missing migrations. Return positive number if DB is ahead (rare case, e.g. if migrations were run then code is reverted)
2015-11-23 10:50:19 -06:00
Rhys van der Waerden
ebd361ffce Merge pull request #994 from wubzz/bugfix/query_event_when_using_transactions
Query event in Transaction should be proxied to the main client
2015-11-17 23:27:15 +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
e1973329c8 Merge pull request #1050 from elhigu/fix-knex-raw-indentifier-escaping-and-named-parameter-regexp-and-add-documentation
Fix knex raw indentifier escaping and named parameter regexp and add documentation
2015-11-14 14:51:52 +11: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
Mikael Lepistö
ca3c1d0a22 Allow named parameter to be at start of knex.raw() sql string 2015-11-10 23:26:19 +02:00
Mikael Lepistö
fdaba4705e Fix for #1003 2015-11-10 23:26:19 +02: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