Commit Graph

620 Commits

Author SHA1 Message Date
ssh24 ab644d9fea Refactor migration methods
Fix timeout error on tests

Signed-off-by: Sakib Hasan <sshasan10@hotmail.com>

add showFields and showIndexes functions

Extract getTableStatus

Extract columnDataType to base connector
2017-03-02 15:49:30 -05:00
Loay 030f8f9dc1 Merge pull request #241 from strongloop/refactor-discovery
Refactor Discovery Methods
2017-02-28 16:18:23 -05:00
Loay 820bf03400 Refactor Discovery Methods 2017-02-28 16:06:51 -05:00
Sadman Sakib Hasan 692c07bd51 Merge pull request #193 from matthewdickinson/foreign_key_migration
Foreign key migration
2017-02-20 16:19:00 -08:00
Matthew Dickinson 6848b72e22 Remove old TODO and commented out code 2017-02-18 21:10:04 -05:00
Matthew Dickinson 5ba6687c7c Fix autoupdate to create foreign keys after tables
Updated the autoupdate function so that it collects foreign key
statements and runs them once all tables have been updated.
This prevents foreign keys being created before referenced tables.
2017-02-17 11:25:19 -05:00
Matthew Dickinson 24c6b77a6f Add logging for errors encountered in discovery 2017-02-17 11:25:19 -05:00
Matthew Dickinson 0b04d461e4 Update signature for alterTable
Since alterTable is semi-public, the method now checks the arugments to
make sure that it still supports the old signature that doesn't include
actualFks
2017-02-17 11:25:19 -05:00
Matthew Dickinson d461d07f34 Limit foreign key creation current connector
Updated fk generation to make sure that it doesn't try to create
foreign keys linking to another DB/connector
2017-02-17 11:25:19 -05:00
Matthew Dickinson 4d20fa7746 Fix linting error 2017-02-17 11:25:19 -05:00
Matthew Dickinson 04287f6a77 Added test to validate foreign key handling 2017-02-17 11:25:19 -05:00
Matthew Dickinson 940032f4dd Update foreign key creation table name handling 2017-02-17 11:25:19 -05:00
Matthew Dickinson 782959cf20 Update alterTable to actually drop constraints 2017-02-17 11:25:19 -05:00
Matthew Dickinson 1324333ffd Add rough handling for automatic foreign keys
This handles basic creating/dropping of FKs based on model relations
2017-02-17 11:25:19 -05:00
ivy ho 39d67fa1f9 remove line not needed (#237)
remove the line that does not look good in github but okay for loopack.io
confirming with rand that that can be removed
2017-02-09 09:37:45 -08:00
Loay d27ab084a6 Merge pull request #235 from strongloop/lc-version3
Update LB-connector version
2017-01-26 11:13:04 -05:00
Loay da0807faf6 Update LB-connector version 2017-01-26 10:48:36 -05:00
Miroslav Bajtoš 0fe22653e3 3.0.0
* Follow mysql recommendations for handling booleans (Carl Fürstenberg)
 * Fix readme glitch (#231) (Rand McKinney)
 * Update readme w info from docs (#229) (Rand McKinney)
 * Fix expected column name when autoupdate (muhammad hasan)
 * Update paid support URL (Siddhi Pai)
 * Fix CI Failures (Loay Gewily)
 * Drop support for Node v0.10 and v0.12 (Siddhi Pai)
 * Start the development of the next major version (Siddhi Pai)
 * Update README with correct doc links, etc (Amir Jafarian)
2017-01-13 15:46:04 +01:00
Simon Ho 6ac3a56062 Merge pull request #232 from strongloop/azatoth-change_discovery_boolean
Follow mysql recommendations for handling booleans
2017-01-11 21:00:31 -08:00
Carl Fürstenberg 5383c4c0ff Follow mysql recommendations for handling booleans
Per http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html
`BOOL` and `BOOLEAN` is alias for `TINYINT(1)` thus we should make
sure discover can handle as such.

Introducing three flags:

* treatCHAR1AsString
  default false - treats CHAR(1) as a String instead of a Boolean
* treatBIT1AsBit
  default true - treats BIT(1) as a Boolean instead of a Binary
* treatTINYINT1AsTinyInt
  default true - treats TINYINT(1) as a Boolean instead of a Number

The default handling for CHAR(1) is legacy backward compability due to
custom to use a CHAR(1) to store 'Y', 'N', '0', '1', etc...
2017-01-11 19:44:50 -08:00
Rand McKinney 160e8dae72 Fix readme glitch (#231)
* Update README.md

* Update README.md
2017-01-11 16:06:55 -08:00
Rand McKinney 9fab8ba795 Update readme w info from docs (#229)
* Update readme w info from docs

* Update README.md

* Update README.md

Fix problems, clarify.
2017-01-10 16:13:45 -08:00
Janny 529eebbc60 Merge pull request #226 from hasanlussa/fix/column-name-in-discovery
Fix expected column name when autoupdate
2016-12-12 10:15:08 -05:00
muhammad hasan 0f1b14b158 Fix expected column name when autoupdate
Fix mysql column name being ignored on dataType change or new column
being added
Fix mysql column name ignored if index changed

Add column name case on autoupdate test

Fix test case scheme error

Fix describe test
2016-12-12 10:06:18 -05:00
siddhipai 333fa21024 Merge pull request #219 from strongloop/update-support-URL
Replicate .github from loopback repo
2016-12-09 09:14:36 -08:00
Siddhi Pai 3eab2cb16a Update paid support URL 2016-12-09 09:01:23 -08:00
Loay 37bb679f6e Merge pull request #211 from strongloop/Fix/CI
Fix CI Failures
2016-12-08 00:04:17 -05:00
Loay Gewily fce2207da3 Fix CI Failures 2016-12-07 23:53:46 -05:00
Simon Ho 6a3fc7f2aa Merge pull request #215 from strongloop/next-major-drop-old-node
Start 3.x + drop support for Node v0.10/v0.12
2016-11-21 13:09:46 -08:00
Siddhi Pai 0acd9ef15a Drop support for Node v0.10 and v0.12 2016-11-19 01:02:44 -08:00
Siddhi Pai 1a6e51a4a6 Start the development of the next major version 2016-11-19 00:55:50 -08:00
Rand McKinney 46d5e957a9 Merge pull request #212 from strongloop/edit_readme
Update README with correct doc links, etc
2016-10-31 15:25:14 -07:00
Amir Jafarian 499a1c30f8 Update README with correct doc links, etc 2016-10-31 17:02:14 -04:00
Miroslav Bajtoš 746ee48601 2.4.0
* Add connectorCapabilities global object (#201) (Nicholas Duffy)
 * Remove unused prefix for test env vars (#203) (Simon Ho)
 * Update translation files - round#2 (#199) (Candy)
 * Add CI fixes (#197) (Loay)
 * Add translated files (gunjpan)
 * Update deps to loopback 3.0.0 RC (Miroslav Bajtoš)
 * Remove Makefile in favour of NPM test scripts (Simon Ho)
 * Fixing lint errors (Ron Lloyd)
 * Autoupdate mysql.columnName bug fix (Ron Lloyd)
 * Tests for autoupdate mysql.columnName bug fix (Ron Lloyd)
 * Use juggler@3 for running the tests (Miroslav Bajtoš)
 * Explictly set forceId:false in test model (Miroslav Bajtoš)
 * Fix pretest and init test configs (Simon Ho)
 * Fix to configure model index in keys field (deepakrkris)
 * Update eslint infrastructure (Loay)
 * test: use dump of original test DB as seed (Ryan Graham)
 * test: skip cardinality, update sub_part (Ryan Graham)
 * test: accept alternate test db credentials (Ryan Graham)
 * test: use should for easier debugging (Ryan Graham)
 * test: account for mysql version differences (Ryan Graham)
 * test: match case with example/table.sql (Ryan Graham)
 * test: separate assertions from test flow control (Ryan Graham)
 * test: update tests to use example DB (Ryan Graham)
 * test: seed test DB with example (Ryan Graham)
 * test: fix undefined password (Ryan Graham)
 * Add special handling of zero date/time entries (Carl Fürstenberg)
 * Add globalization (Candy)
 * Update URLs in CONTRIBUTING.md (#176) (Ryan Graham)
2016-10-17 13:20:42 +02:00
Nicholas Duffy 18cffb98ab Add connectorCapabilities global object (#201) 2016-10-11 23:13:20 -07:00
Simon Ho 8ed53f6cfa Remove unused prefix for test env vars (#203)
* TEST_ prefix is not used by CI anymore and there for serve no purpose

* Part of overall goal to standardize env var injection to
  MODULE_VARNAME (ie. MYSQL_HOST for example) convention
2016-10-07 17:36:43 -07:00
Candy bbd4369308 Update translation files - round#2 (#199) 2016-09-28 14:15:16 -07:00
Loay 6100a62461 Add CI fixes (#197) 2016-09-28 13:32:38 -07:00
Candy 3f0360498c Merge pull request #192 from strongloop/add-translatedFiles
Add translated files
2016-09-23 14:51:22 -04:00
gunjpan e445ab56c6 Add translated files 2016-09-22 15:22:35 -04:00
Miroslav Bajtoš 706f36a88c Merge pull request #195 from strongloop/update-lb-3-rc
Update deps to loopback 3.0.0 RC
2016-09-22 13:28:42 +02:00
Miroslav Bajtoš 97bf933fc9 Update deps to loopback 3.0.0 RC 2016-09-22 13:17:06 +02:00
Simon Ho 15c3307755 Merge pull request #194 from strongloop/remove-makefile
Remove Makefile in favour of NPM scripts
2016-09-20 19:00:59 -07:00
Simon Ho c01cd26417 Remove Makefile in favour of NPM test scripts 2016-09-20 16:18:09 -07:00
Simon Ho 955f5dc084 Merge pull request #190 from rlloyd2001/mysqlPropFix
Fixes issues where autoupdate ignores mysql.columnName and deletes columns
2016-09-14 13:01:01 -07:00
Ron Lloyd 980151d0a8 Fixing lint errors 2016-09-13 22:21:11 -06:00
Ron Lloyd a96d61fa9f Autoupdate mysql.columnName bug fix 2016-09-13 22:21:11 -06:00
Ron Lloyd 0de8dc7c97 Tests for autoupdate mysql.columnName bug fix 2016-09-13 22:21:11 -06:00
Miroslav Bajtoš 89766587b3 Merge pull request #191 from strongloop/update/juggler3
Use juggler@3 for running the tests
2016-09-05 16:11:00 +02:00
Miroslav Bajtoš b13f501ef6 Use juggler@3 for running the tests 2016-09-05 16:01:45 +02:00