node-mysql-query-utils - npm Package Versions

[1.0.4] - 2024-10-07

Added

• Support for increment and decrement operations in the update method of the SQLBuilder class.
  • Allows specifying { increment: number } or { decrement: number } for fields to increment or decrement their values.
  • Throws an error if both increment and decrement are provided for the same field.
• Enhanced LIKE and NOT LIKE operators handle in the SQLBuilder class.
  • Throws an error if more than one of contains, startsWith, or endsWith are provided for the same field.

[1.0.3] - 2024-10-01

Improved

• Enhanced parameter checking and error messages for TableModel class return methods.

Added

• Added NOT IN, NOT LIKE, and REGEXP operators to the where condition parameter in the SQLBuilder class.
• For LIKE and NOT LIKE operators, previously only accepted strings. Now added support for contains, startsWith, and endsWith for more flexible use cases.

[1.0.2] - 2024-09-30

Added

• Added options parameter to buildQuery method to support query formatting.
• Made queryParts private to prevent accidental exposure. queryParts is an internal structure used to build SQL queries and should not be accessed directly.

[1.0.1] - 2024-09-27

Fixed

• Fixed dist folder not aligned with the source code.

[1.0.0] - 2024-09-27

Added

• Initial release of node-mysql-query-utils.

Known Issues

• There was an issue with the dist folder not being aligned with the source code, causing discrepancies between the source and the built files.
• The patchSingleField function was not working as expected due to the misalignment between the dist folder and the source code.