v3.1.0

Blog Post

What's Changed

Additions

• #38 Add support for min() by @DrewImm in #96
• #39 Add support for max() by @DrewImm in #97
• #41 Add support for sum() by @DrewImm in #98
• #42 Add support for avg() by @DrewImm in #99
• #77 Add way to view sql/params generated by repository functions by @DrewImm in #103
• #102 Add support for math operators by @DrewImm in #104

Fixes

• #100 Fix between - error: syntax error at or near ")" by @DrewImm in #101

Full Changelog: v3.0.1...v3.1.0

v3.0.1

Fixes

• #94 Cannot find module 'src/comparison' by @DrewImm in #95

Full Changelog: v3.0.0...v3.0.1

v3.0.0

Breaking Changes

• #87 Misleading Behavior in insertOne Method with Multiple Records
  • insertOne() records key has changes to record
• #89 Refactor expression/placeholder logic
  • Imports to @riao/dbal/conditions have moved to:
    • and, or, not: @riao/dbal/expression
    • comparisons (less than, equals, not equal, etc.): @riao/dbal/comparison
  • Subqueries must now be wrapped in new Subquery()
  • columnName() is now identifier(), although the former has been left in for backwards compatibility
  • 'and' and 'or' strings are no longer allowed in expressions, and must be replaced with and and or imported from @riao/dbal/expression

New Features

• #45 Group By
• #89 Join on expression
• #89 Select column from expression
• #89 Select where expression
• #89 Select where KV expression
• #89 Insert record w/ expression
• #89 Update record w/ expression
• #89 Delete record w/ expression
• #89 Default column value from function/expression/etc.

Fixes

• #89 Refactor expression/placeholder logic by @DrewImm in #90
• #80 Running findOne before database init complains about unknown PK i… by @DrewImm in #93

All Changes

• #89 Refactor expression/placeholder logic by @DrewImm in #90
• #87 Misleading Behavior in insertOne Method with Multiple Records by @DrewImm in #91
• #45 Add support for group-by by @DrewImm in #92
• #80 Running findOne before database init complains about unknown PK i… by @DrewImm in #93

Full Changelog: v2.0.0...v3.0.0

v2.0.0

Breaking Changes

• QueryRepository insert() now returns void instead of an array. Use insertOne() if you need the ID returned #62
• QueryRepository insertOne() will now throw an exception if the primaryKey option is not passed and one cannot be inferred from the schema (i.e. if the schema is out-of-date or empty) #4
• db.functions has been replaced by the global DatabaseFunctions class. Replace db.functions.* with DatabaseFunctions.* and import from @riao/dbal #58
• Drivers must be upgraded to the dbal-2x compatible version
  • (Drivers only) - Driver builders should be updated to use the new this.sql object instead of this.sql string and this.params array #60

All Changes

• #43 Add support for table alias
• #24 Add "identified by" attribute to model repositories to allow dynamic or DRY primary key refs
• #25 Add accessor method/property to access a repository's table name
• #63 Add "not null" query condition
• #26 Add count method to QueryRepository by @DrewImm in #55
• #37 Add support for between to select query by @DrewImm in #56
• #35 Add support for select DISTINCT by @DrewImm in #57
• #66 Add DDL Builder access method for getting column types by @DrewImm in #69
• #58 Token usage/implementations are inconsistent by @DrewImm in #59
• #60 SQL builder should be separated from query/ddl/schema builders by @DrewImm in #61
• #62 Only insertOne() should return ID; insert in bulk should not by @DrewImm in #65
• Issue 62 by @DrewImm in #68
• #67 SQLite Prep - Add DDLBuilder::createTablePrimaryKeys() to allow override by @DrewImm in #72
• #70 SQLite Prep - Queries may return no results by @DrewImm in #71
• #64 SQL Syntax Error - Order By with Limit by @DrewImm in #73
• #4 Running query.insert with an empty schema returns undefined id by @DrewImm in #74

Full Changelog: v1.1.3...v2.0.0

v1.1.3

What's Changed

• [Issue #27] Table names should be enclosed in backticks by @DrewImm in #31
• [Issue #28] Column names should be enclosed by @DrewImm in #32
• [Issue #29] Database functions should be overridable per driver by @DrewImm in #33
• v1.1.3 by @DrewImm in #34

Full Changelog: v1.1.2...v1.1.3

v1.1.2

What's Changed

• [Issue #21] Repositories are using builders from the dbal instead of … by @DrewImm in #22
• V1.1.2 by @DrewImm in #23

Full Changelog: v1.1.1...v1.1.2

v1.1.1

What's Changed

• [Issue #18] Repositories defined in file scope aren't initialized pro… by @DrewImm in #19
• V1.1.1 by @DrewImm in #20

Full Changelog: v1.1.0...v1.1.1

v1.1.0

What's Changed

• [Issue #15] Add transaction support by @DrewImm in #16
• v1.1.0 by @DrewImm in #17

Full Changelog: v1.0.2...v1.1.0

[1.0.2]

What's Changed

• [Issue #1] Update readme for v1.0.1 by @DrewImm in #7
• [Issue #2] Update package.json github links by @DrewImm in #8
• [Issue #3] Running migrations generates empty schema by @DrewImm in #9
• [Issue #6] Inserting objects with null values by @DrewImm in #10
• [Issue #3] Running migrations generates empty schema - Unit test update by @DrewImm in #11
• [Issue #5] Inserting objects with different shapes fails by @DrewImm in #12
• [Issue #1] Update readme for release by @DrewImm in #13
• V1.0.2 by @DrewImm in #14

New Contributors

• @DrewImm made their first contribution in #7

Full Changelog: v1.0.1...v1.0.2

[1.0.1] Initial Release

Initial release!

Full Changelog: https://github.com/riao-project/riao-dbal/commits/v1.0.1