mysql - npm Package Compare versions
Comparing version 2.5.4 to 2.5.5
@@ -7,2 +7,8 @@ # Changes | ||
| ## v2.5.5 (2015-02-23) | ||
| * Store SSL presets in JS instead of JSON #959 | ||
| * Support Node.js 0.12 | ||
| * Update Amazon RDS SSL certificates #1001 | ||
| ## v2.5.4 (2014-12-16) | ||
@@ -9,0 +15,0 @@ |
@@ -127,3 +127,3 @@ var urlParse = require('url').parse; | ||
| if (!SSLProfiles) { | ||
| SSLProfiles = require('./../fixtures/ssl-profiles.json'); | ||
| SSLProfiles = require('./protocol/constants/ssl_profiles'); | ||
| } | ||
@@ -130,0 +130,0 @@ |
| { | ||
| "name": "mysql", | ||
| "description": "A node.js driver for mysql. It is written in JavaScript, does not require compiling, and is 100% MIT licensed.", | ||
| "version": "2.5.4", | ||
| "version": "2.5.5", | ||
| "license": "MIT", | ||
@@ -15,5 +15,5 @@ "author": "Felix Geisendörfer <felix@debuggable.com> (http://debuggable.com/)", | ||
| "dependencies": { | ||
| "bignumber.js": "1.4.1", | ||
| "bignumber.js": "2.0.0", | ||
| "readable-stream": "~1.1.13", | ||
| "require-all": "0.0.8" | ||
| "require-all": "~1.0.0" | ||
| }, | ||
@@ -32,5 +32,5 @@ "devDependencies": { | ||
| "test": "node test/run.js", | ||
| "test-cov": "node test/run-cov.js", | ||
| "test-travis": "node test/run-cov.js lcovonly" | ||
| "test-ci": "node test/run-cov.js lcovonly", | ||
| "test-cov": "node test/run-cov.js" | ||
| } | ||
| } |
102
Readme.md
@@ -6,5 +6,49 @@ # mysql | ||
| [![Node.js Version][node-version-image]][node-version-url] | ||
| [![Build Status][travis-image]][travis-url] | ||
| [![Linux Build][travis-image]][travis-url] | ||
| [![Windows Build][appveyor-image]][appveyor-url] | ||
| [![Test Coverage][coveralls-image]][coveralls-url] | ||
| ## Table of Contents | ||
| - [Install](#install) | ||
| - [Introduction](#introduction) | ||
| - [Contributors](#contributors) | ||
| - [Sponsors](#sponsors) | ||
| - [Community](#community) | ||
| - [Establishing connections](#establishing-connections) | ||
| - [Connection options](#connection-options) | ||
| - [SSL options](#ssl-options) | ||
| - [Terminating connections](#terminating-connections) | ||
| - [Pooling connections](#pooling-connections) | ||
| - [Pool options](#pool-options) | ||
| - [Pool events](#pool-events) | ||
| - [Closing all the connections in a pool](#closing-all-the-connections-in-a-pool) | ||
| - [PoolCluster](#poolcluster) | ||
| - [PoolCluster Option](#poolcluster-option) | ||
| - [Switching users and altering connection state](#switching-users-and-altering-connection-state) | ||
| - [Server disconnects](#server-disconnects) | ||
| - [Escaping query values](#escaping-query-values) | ||
| - [Escaping query identifiers](#escaping-query-identifiers) | ||
| - [Preparing Queries](#preparing-queries) | ||
| - [Custom format](#custom-format) | ||
| - [Getting the id of an inserted row](#getting-the-id-of-an-inserted-row) | ||
| - [Getting the number of affected rows](#getting-the-number-of-affected-rows) | ||
| - [Getting the number of changed rows](#getting-the-number-of-changed-rows) | ||
| - [Getting the connection ID](#getting-the-connection-id) | ||
| - [Executing queries in parallel](#executing-queries-in-parallel) | ||
| - [Streaming query rows](#streaming-query-rows) | ||
| - [Piping results with Streams2](#piping-results-with-streams2) | ||
| - [Multiple statement queries](#multiple-statement-queries) | ||
| - [Stored procedures](#stored-procedures) | ||
| - [Joins with overlapping column names](#joins-with-overlapping-column-names) | ||
| - [Transactions](#transactions) | ||
| - [Timeouts](#timeouts) | ||
| - [Error handling](#error-handling) | ||
| - [Exception Safety](#exception-safety) | ||
| - [Type casting](#type-casting) | ||
| - [Connection Flags](#connection-flags) | ||
| - [Debugging and reporting problems](#debugging-and-reporting-problems) | ||
| - [Running tests](#running-tests) | ||
| - [Todo](#todo) | ||
| ## Install | ||
@@ -202,3 +246,4 @@ | ||
| * `"Amazon RDS"`: this profile is for connecting to an Amazon RDS server and contains the | ||
| ca from https://rds.amazonaws.com/doc/rds-ssl-ca-cert.pem | ||
| certificates from https://rds.amazonaws.com/doc/rds-ssl-ca-cert.pem and | ||
| https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem | ||
@@ -446,3 +491,3 @@ When connecting to other servers, you will need to provide an object of options, in the | ||
| ## Switching users / altering connection state | ||
| ## Switching users and altering connection state | ||
@@ -489,3 +534,3 @@ MySQL offers a changeUser command that allows you to alter the current user and | ||
| provided data before using it inside a SQL query. You can do so using the | ||
| `connection.escape()` or `pool.escape()` methods: | ||
| `mysql.escape()`, `connection.escape()` or `pool.escape()` methods: | ||
@@ -525,4 +570,6 @@ ```js | ||
| 'b'], ['c', 'd']]` turns into `('a', 'b'), ('c', 'd')` | ||
| * Objects are turned into `key = 'val'` pairs. Nested objects are cast to | ||
| strings. | ||
| * Objects are turned into `key = 'val'` pairs for each enumerable property on | ||
| the object. If the property's value is a function, it is skipped; if the | ||
| property's value is an object, toString() is called on it and the returned | ||
| value is used. | ||
| * `undefined` / `null` are converted to `NULL` | ||
@@ -646,3 +693,3 @@ * `NaN` / `Infinity` are left as-is. MySQL does not support these, and trying | ||
| ## Getting the number of affected rows. | ||
| ## Getting the number of affected rows | ||
@@ -659,3 +706,3 @@ You can get the number of affected rows from an insert, update or delete statement. | ||
| ## Getting the number of changed rows. | ||
| ## Getting the number of changed rows | ||
@@ -736,12 +783,12 @@ You can get the number of changed rows from an update statement. | ||
| ### Piping results with [Streams2](http://blog.nodejs.org/2012/12/20/streams2/) | ||
| ### Piping results with Streams2 | ||
| The query object provides a convenience method `.stream([options])` that wraps | ||
| query events into a [Readable](http://nodejs.org/api/stream.html#stream_class_stream_readable) | ||
| Streams2 object. This stream can easily be piped downstream and provides | ||
| automatic pause/resume, based on downstream congestion and the optional | ||
| `highWaterMark`. The `objectMode` parameter of the stream is set to `true` | ||
| and cannot be changed (if you need a byte stream, you will need to use a | ||
| transform stream, like [objstream](https://www.npmjs.com/package/objstream) for | ||
| example). | ||
| Streams2[Streams2](http://blog.nodejs.org/2012/12/20/streams2/) object. This | ||
| stream can easily be piped downstream and provides automatic pause/resume, | ||
| based on downstream congestion and the optional `highWaterMark`. The | ||
| `objectMode` parameter of the stream is set to `true` and cannot be changed | ||
| (if you need a byte stream, you will need to use a transform stream, like | ||
| [objstream](https://www.npmjs.com/package/objstream) for example). | ||
@@ -892,2 +939,15 @@ For example, piping query results into another stream (with a max buffer of 5 | ||
| ## Ping | ||
| A ping packet can be sent over a connection using the `connection.ping` method. This | ||
| mehtod will send a ping packet to the server and when the server responds, the callback | ||
| will fire. If an error occurred, the callback will fire with an error argument. | ||
| ```js | ||
| connection.ping(function (err) { | ||
| if (err) throw err; | ||
| console.log('Server responded to ping'); | ||
| }) | ||
| ``` | ||
| ## Timeouts | ||
@@ -1205,11 +1265,13 @@ | ||
| [npm-image]: https://img.shields.io/npm/v/mysql.svg?style=flat | ||
| [npm-image]: https://img.shields.io/npm/v/mysql.svg | ||
| [npm-url]: https://npmjs.org/package/mysql | ||
| [node-version-image]: https://img.shields.io/badge/node.js-%3E%3D_0.6-brightgreen.svg?style=flat | ||
| [node-version-image]: http://img.shields.io/node/v/mysql.svg | ||
| [node-version-url]: http://nodejs.org/download/ | ||
| [travis-image]: https://img.shields.io/travis/felixge/node-mysql.svg?style=flat | ||
| [travis-image]: https://img.shields.io/travis/felixge/node-mysql/master.svg?label=linux | ||
| [travis-url]: https://travis-ci.org/felixge/node-mysql | ||
| [coveralls-image]: https://img.shields.io/coveralls/felixge/node-mysql.svg?style=flat | ||
| [appveyor-image]: https://img.shields.io/appveyor/ci/dougwilson/node-mysql/master.svg?label=windows | ||
| [appveyor-url]: https://ci.appveyor.com/project/dougwilson/node-mysql | ||
| [coveralls-image]: https://img.shields.io/coveralls/felixge/node-mysql/master.svg | ||
| [coveralls-url]: https://coveralls.io/r/felixge/node-mysql?branch=master | ||
| [downloads-image]: https://img.shields.io/npm/dm/mysql.svg?style=flat | ||
| [downloads-image]: https://img.shields.io/npm/dm/mysql.svg | ||
| [downloads-url]: https://npmjs.org/package/mysql |
New alerts
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Fixed alerts
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Improved metrics
- Total package byte prevSize
- increased by8.01%
331781
- Number of package files
- increased by1.82%
56
- Lines of code
- increased by7.06%
5887
- Number of lines in readme file
- increased by5.14%
1268
Dependency changes
+ Addedbignumber.js@2.0.0(transitive)
+ Addedrequire-all@1.0.0(transitive)
- Removedbignumber.js@1.4.1(transitive)
- Removedrequire-all@0.0.8(transitive)
Updatedbignumber.js@2.0.0
Updatedrequire-all@~1.0.0