387 Commits

Author SHA1 Message Date
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
371815d7e6 made SCHEMA upper case for mssql 2015-12-14 09:56:53 -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
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
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
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
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
Mikael Lepistö
b9d9a99f80 Added \? escape sequence to postgres dialect to allow using ? operator. 2015-08-25 10:19:35 +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 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
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
ff76297506 Normalize connection config, fix #789 2015-04-29 15:14:41 -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
2e47b9d2e8 Nicer query builder interface 2015-04-28 09:14:13 -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
36ced91ed5 Testing transactions, beginning to use tape, adding query to error message 2015-04-24 10:10:34 -04:00
Tim Griesser
918f6056d1 Nested transactions, needs explicit tests 2015-04-23 16:04:48 -04:00
Tim Griesser
46e318d6da Cleaning up transactions, passing options arg to pipe 2015-04-23 14:51:33 -04:00
Tim Griesser
c8232d11d3 Merge with master, cleanup on mysql2/maria 2015-04-22 16:19:59 -04:00
Tim Griesser
34b6bd4076 Merge pull request #788 from zcei/feature/migrations-transaction
Wraps migrations in transations
2015-04-22 15:52:52 -04:00
Tim Griesser
e570c167c1 JSHint and formatting 2015-04-22 15:39:29 -04:00
Tim Griesser
f9aab9dc76 Major internal refactor
Beefed up transaction implementation, still needs tests
and cleanup of nested transaction queues.

Left todo:
- Fix commented out tests
- Fix oracle driver's transactions
2015-04-22 10:34:14 -04:00
Tim Griesser
eee4e9c005 Fixing the overall class dependency approach, lots of internal cleanup, WIP 2015-04-19 16:31:52 -04:00
Tim Griesser
27cd9f12c5 Cleanup pool implementation, preparing things for new release 2015-04-17 15:00:08 -04:00
Ben Drucker
7cdda834ef Remove FoundationDB
Reverts c199761c597c93136a6d38bc4ecf26a693560322 and #641

Foundation was acquired and shut down immediately
2015-03-24 17:48:14 -07:00
Tim Griesser
13995d6936 Fix #737, proper escaping for identifiers 2015-03-13 01:17:32 -04:00
Kris Reeves
1d1c6b9360 Supporting tests 2015-02-19 12:08:02 -05:00
Nathan Williams
2d6d2f28f7 Adapter for FoundationDB SQL Layer 2015-02-04 14:56:41 -05:00
Stephan Schneider
06d3383c11 Uses knex.client.dialect instead of hacky knex.toString() 2015-01-23 15:43:14 +01:00
Stephan Schneider
9159a4a5dc Makes transaction test MySQL comliant 2015-01-09 14:57:37 +01:00
Stephan Schneider
fa7ff8cd23 Adds tests for transaction-based migrations 2015-01-09 11:00:55 +01:00
Vincent Schoettke
5c7d106283 join columns now optional. Fixes #504 2014-09-29 10:05:53 +02:00
Vincent Schoettke
72cf342273 Fixes #319. Inserting multiple rows with default values 2014-09-08 16:10:43 +02:00
Tim Griesser
d77debbaa8 Properly remove seed test file to prevent jshint warning 2014-09-03 16:18:22 -04:00
Vincent Schoettke
4c43d69313 Enabled eqeqeq jshint restriction and fixed warnings 2014-09-03 11:04:10 +02:00
Vincent Schoettke
8b2084f892 Added jshint newcap and undef options and fixed warning 2014-09-02 23:07:46 +02:00
Vincent Schoettke
ef173db790 Changed jshint option unused to true and fixed warnings 2014-09-02 22:56:51 +02:00
Vincent Schoettke
b86f25b727 Removed jshint sub and fixed warnings 2014-09-02 22:25:02 +02:00