Important: This documentation covers Yarn 1 (Classic).
For Yarn 2+ docs and migration guide, see yarnpkg.com.

Package detail

sails-mysql

balderdashy33.9kMIT3.0.1

MySQL adapter for Sails.js

mysql, orm, waterline, sails

readme

Sails-MySQL Adapter Powered by MySQL

MySQL adapter for the Sails framework and Waterline ORM. Allows you to use MySQL via your models to store and retrieve data. Also provides a query() method for a direct interface to execute raw SQL commands.

Installation

Install from NPM.

# In your app:
$ npm install sails-mysql

Help

If you have further questions or are having trouble, click here.

Bugs   NPM version

To report a bug, click here.

Contributing

Please observe the guidelines and conventions laid out in the Sails project contribution guide when opening issues or submitting pull requests.

NPM

Running the tests

To run the tests, point this adapter at your database by specifying a connection URL and run npm test:

WATERLINE_ADAPTER_TESTS_URL=mysql://root:myc00lP4ssw0rD@localhost/adapter_tests npm test

For more info, see Reference > Configuration > sails.config.datastores > The connection URL, or ask for help.

License

This adapter, like the Sails framework is free and open-source under the MIT License.

changelog

Sails MySQL Changelog

master

  • [NODE] Upgrades the underlying felixge/mysql dependency to work with Node v6. See #321 (Thanks @matuck!)

~0.12

0.12.2

  • [ENHANCEMENT] Adds support for case-insensitive queries using the wlNext.caseSensitive flag. See #304 for more details. Thanks @wulfsolter for the patch!

  • [ENHANCEMENT] Adds MariaDB to the automated test suite. See #276 for more details. Thanks to @grooverdan for the patch.

  • [ENHANCEMENT] Updates the dependencies to the latest versions which should remove any warning messages when installing.

  • [BUG] Fixes issues with backwards compatibility to Waterline 0.11.x and older.

0.12.1

  • [BUG] Fixes issue with populates due to changes in projections queries coming from Waterline-Sequel. Updated the waterline-sequel dependency to 0.6.2 to fix. See #297 for more details. Thanks @wulfsolter and @aradnom for helping debug and test.

0.12.0

  • [Enhancement] Upgrades the version of Waterline-Sequel being used to support using projections in join queries. See #294 for more details.

  • [Enhancement] Adds JSHint and tweaks code style slightly to better support community additions. See #295 for more details.

~0.11

0.11.5

  • [BUG] Updates Waterline-Sequel dependency to actually fix the previous dates bug.

  • [ENHANCEMENT] Changes the database url parsing to strip out query string values. See #280 for more details. Thanks @Bazze!

0.11.4

  • [BUG] Updates Waterline-Sequel dependency to gain support for querying dates when they are represented as a string in the criteria.

  • [ENHANCEMENT] Normalize the adapter errors some to be more in line with the Postgres driver. Now returns the originalError key as specified in Waterline-Adapter-Tests.

0.11.3

  • [BUG] Fixes issue with an outdated .stream() interface. See #264 for more details. Thanks @github1337 for the patch!

  • [ENHANCEMENT] Better error message in the case of a foreign key constraint violation. See #268 for more details. Thanks @trheming for the patch!

  • [ENHANCEMENT] Locked the dependency versions down to know working versions. Also added a shrinkwrap.json file. See #272 for more details.

  • [ENHANCEMENT] Updated the Travis config to run test on Node 4.0 and 5.0. See #273 for more details.

  • [PERFORMANCE] And the best for last, merged #274 which increases performance on populates ~15x. Thanks a million to @jianpingw for spending the time to track this down!