Repository  -  API  -  Source


December 7, 2017
  • Added support for INSERT IGNORE via the insertIgnore function.


October 28, 2016

    • Now only supports Node 4 and later
    • Removed query.emitted()
    • Removed alias for query.exec()
    • query.exec() now always uses the connection.query function instead of connection.execute.
    • New: Casting a query object to a string now produces a query with escaped values.

    • Fixed: query.clone() will now properly clone all attributes.

    • Dependencies:

      • Replaced lodash.assign with ES6 Object.assign
      • Replaced lodash.clone with lodash.clonedeep.
      • Updated lodash.mapvalues to 4.5.0
      • Updated proxmis to 1.0.0
      • Now using the sqlstring package to handle data escapement
    • Internal changes:

      • Tests are now built using node-tap instead of nodeunit
      • Library is now linted using eslint


October 10, 2015
  • Fixed a bug that would create a malformed query when inserting or updating a null value.


February 6, 2015
  • Date objects are now converted to MySQL DATETIME using the timezone on the date instead of always being UTC.


February 6, 2015
  • Fixed a bug where using a raw subquery as a join target could lose part of the subquery.


December 16, 2014
  • Added Multi-Insert Mode
    • Causes Queryize to create insert queries in the format of INSERT INTO table (columnA, columnB) VALUES (valueA, valueB), supporting multiple rows of data to be inserted.
    • Activated first time query.addRow is used.
      • Added support for REPLACE INTO queries via query.replace() as an alternative to query.insert()
      • Added support for passing raw query functions as query.set() values
    • Example: `query.set('dts', {raw:'NOW()'});
      • Added query.addColumn to append extra columns outside of the query.column full set.
      • Fixed query.set() not properly overwriting a previously defined key/value pair.
      • INTERNAL: Query builders can now return a fully formed query object instead of a string.


September 12, 2014
  • Added query.emitted() as an alternative to query.exec().
    • node-mysql does not return a row emitter if a callback is provided. Since a callback is always provided as part of the promise extension, this made it impossible to receive a row emitter when using node-mysql (node-mysql2 does not have this limitation). This new function works around that limitation.


September 13, 2014
  • Removed a console.log that slipped in.


September 12, 2014
  • Added ability to provide a queryize object as a compound where condition.


September 3, 2014
  • Added support for using queryize objects as subqueries in columns, joins and select from.
    • Use to define the name for the subquery. If omitted, queryize will create a random name.
      • Fixed bug in query.debug() that prevented it from enabling without passing true.
      • Added documentation examples for all possible ways you can use query.exec()


September 2, 2014
  • Major internal refactor to make the query object more externally extensible
    • Query state is now stored on this._attributes instead of in a local variable.
    • queryize.fn now contains the prototype of the queryize query object. See lib/mutators.js for the contents.
      • Added query.clone() to duplicate a query state inline
      • Changed query.deleet() to query.delete()
      • Switched to using lodash clone and assign functions instead of local versions.
      • Added query.disableBoundParameters and deprecated query.useBoundParameters
      • Fixed several V8 optimization killers
      • Fixed bugs in query.limit() and query.distinct()
      • Fixed edge case in query.where()
      • Increased test coverage
      • Improved documentation


August 22, 2014
  • Added support for node-mysql2 connection.execute() functions. Prefers over connection.query()
    • query.exec() now extends the node-mysql(2) query emitter object with .then() and .catch(), allowing use as a promise.
    • Lots and lots of new documentation in code
    • Switched to using a custom dox based documentation generator
    • Added Travis-CI testing
    • Launched


February 17, 2014
  • Added query.exec() and deprecated to be more consistent with other database libraries (eg, Mongoose)


February 17, 2014
  • Fixed showstopper bug in


February 3, 2014
  • Changed query builders into a function map so that attributes is storing a name instead of a function. This makes it serializable and easier to duplicate.
    • Added run() function as shortcut for node-mysql query command.
    • Started documenting


January 14, 2014
  • Initial release