Skip to content

Releases: Okanjo/okanjo-app-mysql

v5.0.1

29 Mar 17:17

Choose a tag to compare

Use registerServiceConnector instead of directly pushing service connectors

v5.0.0

22 Mar 22:06

Choose a tag to compare

  • MySQL 5.7 not supported using MySQL's driver
  • Port numbers must be numeric values
  • getAffectedRowsCount is now getAffectedItemsCount
  • MariaDB returns BigInt for count fields
  • MySQLService.js:
    • query.getRawStatement is now query.getSQL
    • column.getColumnLabel is now a thing, and needs to be used in conjunction with column.getColumnName
    • column.type is now column.getType(), and returns a string enum instead of numeric mysql binary types
  • Updated all dependencies to latest

v4.3.0

25 Jun 18:18

Choose a tag to compare

Added debug module for query level diagnostics on MySQL and MariaDB services

v4.2.0

13 Apr 00:49

Choose a tag to compare

Added support for MariaDB!

  • Added MariaDBService, MariaDBCrudService classes
  • Added tests for new services
  • Added example-mariadb-app to docs
  • Fixed typos in other example docs
  • Updated travis build spec
  • Updated docs

v4.1.0

11 Apr 17:31

Choose a tag to compare

  • Fixed both crud services not using the correct default service schema
  • Added constructor validation of required options to both crud services
  • Updated docs

v4.0.0

11 Apr 04:30

Choose a tag to compare

Adds new CollectionCrudService!

Breaking Changes

  • CrudService:
    • Renamed service.database to service.schema for consistency
    • Removed _ prefix from crud service functions

Other Changes

  • Added new CollectionCrudService for working with MySQL document collections.
  • Added init() system to CrudService
  • Added two example applications, demonstrating usage of the CrudService and CollectionCrudService
  • Added new unit tests for CollectionCrudService
  • Updated unit tests file names to match their respective components
  • Added dependency on base-id, for ID generation support (e.g. MySQL 5.7)
  • Updated travis build to test both MySQL 5.7 and MySQL 8
  • Added cover_noclean package script to prevent nyc from clearing coverage files (to combine results from unit test runs against 5.7 and 8)
  • Updated docs

v3.0.0

09 Apr 07:50

Choose a tag to compare

Breaking Changes:

  • Node v10+ only (unless you polyfill Promise.prototype.finally support yourself)
  • Changed MySQL driver from mysqljs/mysql to mysql/mysql-connector-nodejs
  • MySQLService:
       * config argument has changed. See README.md for options.
       * pool property has been removed. A new property client basically replaces the pool.
       * query signature has changed from (query, options, callback) to (sql, args, callback, options)
       * wrapQuery has been removed
       * getConnection has been replaced with getSession
  • CrudService:
       * connection option in crud methods has been replaced with session.
       * CrudService.MAX_VALUE constant class has been replaced with a simple string version.

Other Changes:

  • Updated example app to work with v3 and demonstrated fields too
  • Tests: Updated tests to validate v3 changes
  • Updated dependencies and configurations
  • Updated docs
  • Updated travis-ci build to test both MySQL 5.7 and MySQL 8

v2.0.0

09 Apr 07:49

Choose a tag to compare

Breaking Changes:

  • MySQLService:
       * query callback now returns a single parameter response object with properties: results and fields for compatibility with promises
  • CrudService:
       * _create arguments have changed to data, options, callback, suppressCollisionError has moved into options
       * _createWithRetry arguments have changed to data, objectClosure, options, callback (recursive attempt has been removed)
       * All crud methods return a Promise for async compatibility. Callback is an optional param. Fields have been removed as a response argument.
       * _update is now an async function

Other Changes:

  • Updated example app to work with v2 and demonstrated fields too
  • Tests: Updated tests to validate v2 changes
  • Updated dependencies and configurations
  • Updated docs
  • Removed yarn

v1.2.0

14 Dec 02:17

Choose a tag to compare

  • Added options to crud functions that did not previously have them
  • Added: All crud functions will use options.connection to execute queries if given (supports transactions)

v1.1.0

02 Dec 07:21

Choose a tag to compare

  • Added CrudService for MySQL that works just like our MongoService/CrudService
  • MySQLService#query now returns the underlying query object