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
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
wubzz
0d628ebf0f
Fix typo tr === trx
2015-09-23 19:32:27 +02:00
wubzz
d60dd74f27
Attempt to add test for #855
2015-09-20 15:29:07 +02:00
harriha
3d85822a28
Add integration tests for per-migration transactions
...
Since per-migration config is defined in the migration files
themselves, new test migration files are needed.
2015-09-08 13:59:27 +10:00
harriha
a095feee21
Add a test for checking migrations with all transactions disabled
2015-09-08 13:59:27 +10:00
harriha
e614e89d22
Add missing return
2015-09-08 13:59:26 +10:00
harriha
5003b41dae
Add tests for a join with value 0
2015-08-30 23:21:11 +03:00
Mikael Lepistö
b9d9a99f80
Added \? escape sequence to postgres dialect to allow using ? operator.
2015-08-25 10:19:35 +03:00
Daniel Teixeira
8e780a8115
rename .using to .withSchema
2015-08-14 19:17:06 -03:00
