2646 Commits

Author SHA1 Message Date
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ö
ebaa79b973 Added information of replaceUndefinedWithDefault configuration parameter. 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
Mikael Lepistö
c8cdc1f91e Prevent \? from getting recognized when collecting array bindings 2015-11-14 10:49:37 +02:00
Mikael Lepistö
5e54d8aa68 Change \? back to ? and ignore them from binding replacement 2015-11-14 10:49:37 +02:00
Mikael Lepistö
95ca360c1d Pass correct client to raw instead of default 2015-11-14 10:49:37 +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
Diandra Ryan-Mas
30c4d47a2a removed comma 2015-11-13 10:58:51 -06: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ö
e2eacc7d6e Ran 'npm run build' since tape tests would not pass if build is not updated. 2015-11-10 23:27:26 +02: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ö
73c314c7ca Documentation of different ways to give parameters for knex.raw. 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
Mikael Lepistö
d1c9916682 Deprecated schema.json(true) 2015-11-07 16:16:50 +02:00
Rhys van der Waerden
24412a5ca6 Merge pull request #1051 from chuym/plain-object-verify
Checking for plain object instead object on raw queries
2015-11-07 13:50:46 +11: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
Rhys van der Waerden
360ffc77d3 release 0.9.0 0.9.0 2015-11-02 14:54:38 +11:00
Rhys van der Waerden
de5bfda2e4 Merge pull request #969 from tgriesser/feature/0.9-changelog
Add changelog for 0.9.
2015-11-02 14:42:44 +11:00
Rhys van der Waerden
0201ebfc15 Add changelog for 0.9 2015-11-02 14:41:40 +11:00
Rhys van der Waerden
6335b683ab Merge pull request #1042 from tgriesser/travis-node-v5.x
Add Travis testing for Node v5.x
2015-11-02 14:40:21 +11:00
blah238
c39c712a68 Add Travis testing for Node v5.x 2015-10-31 22:17:30 -05:00
blah238
4a5f223657 Simplify migrate.latest example, improve formatting 2015-10-29 19:43:38 -05:00
blah238
72b0cbc44a Merge pull request #1017 from sombriks/patch-1 2015-10-29 19:42:38 -05:00
blah238
05ffb457a8 Document TableCompiler#index indexType parameter and improve formatting 2015-10-29 19:00:13 -05:00
Emil Ong
350a307c53 Add docs for table index modification functions, index/dropIndex 2015-10-29 11:35:47 -07:00
blah238
aaf0739736 Merge pull request #1033 from blah238/travis-node-v4.x
Add Travis testing for Node v4.x
2015-10-28 18:23:11 -05:00
blah238
1ee32292d4 Add Travis testing for Node v4.x
- Update node-mariasql to 0.2.x
 - Closes #970
 - Closes #977
 - Closes #995
2015-10-27 17:38:56 -05:00
Rhys van der Waerden
3f0a8737ce Merge pull request #1029 from codydaig/patch-1
[doc] Update Examples of defaultTo in Docs  [closes #699]
2015-10-24 16:19:58 +11:00
Cody B. Daig
099c4bd3f9 Remove indentation in example 2015-10-22 17:54:24 -07:00
Cody B. Daig
e0bdbefd74 Update index.html 2015-10-22 16:22:05 -07:00
Cody B. Daig
11a6d6f3c2 [doc] Update Examples of defaultTo in Docs 2015-10-20 17:21:27 -07:00
Rhys van der Waerden
268b377a51 Merge pull request #1019 from blah238/npm-test-improvements
NPM test script improvements
2015-10-13 08:00:27 +11:00
blah238
39031c4006 NPM test script improvements
- Add 'npm run babel' command and run it on 'npm test' (supersedes PR #1011 - Ensure /lib is up to date during CI tests)
  - Fix 'npm test' command not working on Windows due to Istanbul config issue (see https://github.com/gotwarlost/istanbul/issues/90)
  - Update CONTRIBUTING.md
2015-10-12 15:32:59 -05:00
Sombriks
5c196706e0 how to chain migrate sample
Adding example on how to execute some code only when all migration files finished their execution
2015-10-10 00:42:04 -03:00
Rhys van der Waerden
4304e38115 Merge pull request #1005 from realtymaps/master
documentation for using JSON array values
2015-10-04 13:28:58 +11:00
Joe Ibershoff
f8735cb67e documentation for using JSON array values 2015-09-30 10:17:06 -04:00
wubzz
0d628ebf0f Fix typo tr === trx 2015-09-23 19:32:27 +02:00
Rhys van der Waerden
775d6c2af7 Merge pull request #986 from juanjoLenero/document-connectionless-use
Document connectionless use case
2015-09-22 14:17:27 +10:00
Juan Jose Lenero Lozano
f4139c34be Document connectionless use case 2015-09-20 20:57:24 -05:00
Rhys van der Waerden
3a5ae73112 Merge pull request #985 from maxcnunes/english-typos
Fix some english typos
2015-09-21 09:52:20 +10:00
Max Claus Nunes
58ae4d2455 Fix some english typos 2015-09-20 10:37:28 -03:00
wubzz
d60dd74f27 Attempt to add test for #855 2015-09-20 15:29:07 +02:00
wubzz
4cba0d963c Query Event is now proxied to the main client like in previous versions of knex. Fixes #855 2015-09-19 14:45:01 +02:00