994 Commits

Author SHA1 Message Date
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
Daniel Teixeira
3f8f50425f add schema support for schema builder 2015-08-09 23:04:53 -03:00
Daniel Teixeira
402dbd9903 add schema support for postgres queries 2015-08-09 20:48:33 -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
Daniel Qin
c540d46c5d added test for rename columns reference by another table 2015-07-07 13:12:09 +08:00
Vincent Schoettke
285816ccdd default to timestamp with time zone for oracle 2015-06-24 10:15:51 +02:00
Tim Griesser
7b3d4bf96c Add test for postgres stream 2015-06-01 15:45:02 -04:00
Tim Griesser
1eed91ad6d Reference issue id in test 2015-06-01 09:14:45 -04:00
Tim Griesser
edefe53df9 Better fix for #852 2015-06-01 07:55:04 -04:00
Tim Griesser
90105e064f Fix #852, parse qs parameters for connection 2015-06-01 07:39:57 -04:00
Tim Griesser
cf757a5647 Fix #853, raw bindings should be optional 2015-06-01 07:30:38 -04:00
Tim Griesser
470428032d Fix #832, errors thrown in trx container trigger rejection 2015-05-20 11:19:12 -04:00
Tim Griesser
01bae6a598 Add disableTransactions option, #834 2015-05-20 11:08:27 -04:00
Tim Griesser
f54bb0f77e Fixing #823, regression from #822 2015-05-14 00:43:04 -04:00
Tim Griesser
054be46068 Fix #822, pool: {max: 0} should not init pooling 2015-05-13 15:20:01 -04:00
Tim Griesser
3482c650d4 Improvements to object value bindings 2015-05-06 10:48:05 -04:00
Tim Griesser
2ed591dc06 release 0.8.2 2015-05-01 14:55:53 -04:00
Tim Griesser
d4ddd2a91c Fix regression in connection query string in config object 2015-05-01 14:49:18 -04:00
Tim Griesser
6d93ba2c21 #805 - mysql2 doesn't include errno, sidorares/node-mysql2#168 2015-05-01 11:53:55 -04:00
Tim Griesser
bdd0efa60b Fix #804, reference seed config for migrator 2015-05-01 11:37:41 -04:00
Tim Griesser
12e6ada1a3 Fix for #805, warn for non-existent savepoints
In MySQL if a savepoint is missing, it means something
else (most likely DDL) triggered an implicit commit. In this
case rather than erroring, let's give a warning message
so it's possible to use the same codepath as a DB where
this actually works.
2015-05-01 11:26:29 -04:00
Tim Griesser
aa026613b1 Fix MariaDB Travis config 2015-04-30 21:19:52 -04:00
Tim Griesser
29cc223bb9 Test whether mocha 2.x is causing Travis to fail 2015-04-30 20:41:16 -04:00
Tim Griesser
3dfe1e6c94 Final cleanup for 0.8 2015-04-30 18:11:41 -04:00
Tim Griesser
3e1872731e Fix for #605, options preserved in standalone Raw query 2015-04-30 18:07:16 -04:00
Tim Griesser
e179634600 Switch to shell script for release, other tidying of config/directories 2015-04-29 19:13:50 -04:00
Tim Griesser
ff76297506 Normalize connection config, fix #789 2015-04-29 15:14:41 -04:00
Tim Griesser
c529358fcb Allow object syntax for join, #743 2015-04-29 15:13:15 -04:00
Tim Griesser
471b2bae8f Bump sqlite3 test dependency for 0.12 2015-04-28 23:32:41 -04:00
Tim Griesser
e011768124 Adding back debug 2015-04-28 19:34:11 -04:00
Tim Griesser
5047ab8d76 Cleanup transaction test noise 2015-04-28 19:11:43 -04:00
Tim Griesser
f0ea3a269d Add test for #785 2015-04-28 15:05:17 -04:00
Tim Griesser
2e47b9d2e8 Nicer query builder interface 2015-04-28 09:14:13 -04:00
Tim Griesser
17b04db6da Test for #647, chained update calls aggregate updates 2015-04-28 08:41:08 -04:00
Tim Griesser
7b17cc404a Oracle test suite up to date 2015-04-27 20:22:05 -04:00
Tim Griesser
f735dcb9c8 Raw identifiers and named parameters
Adds ?? for interpolating identifiers in raw
statements. Also adds raw(sql, obj) for
named :key syntax. Alternatively, 🔑
(trailing colon) may be used to specify an
identifier as a parameter.
2015-04-27 15:58:48 -04:00
Tim Griesser
f3c45a0b10 Test to ensure #625 is fixed 2015-04-24 15:20:35 -04:00