v3.3.2

What's Changed

• #143 QueryRepository.insert() doesn't consider repo's idenifiedBy by @DrewImm in #144

Full Changelog: v3.3.1...v3.3.2

v3.3.1

Fixes

• #139 BigIntKeyColumn is typed as an int by @DrewImm in #140

Full Changelog: v3.3.0...v3.3.1

v3.3.0

Additions

• #117 Add support for indexes by @DrewImm in #137
• #135 Create pre-built columns following best practice types, lengths, etc by @DrewImm in #136
• #88 Add method(s) to disable/enable FK checks by @DrewImm in #134
• #124 Add shorthand for adding FK to a table column during createTable… by @DrewImm in #133

Full Changelog: v3.2.0...v3.3.0

v3.2.0

Additions

• #130 Add support for date() by @DrewImm in #132
• #125 Add support for offset in SelectQuery by @DrewImm in #126
• #111 Add support for UUID by @DrewImm in #115
• #106 Add support for raw sql expressions by @DrewImm in #107
• #51 Add support for year by @DrewImm in #131
• #48 Add support for CASE expression by @DrewImm in #122
• #46 Add support for HAVING by @DrewImm in #121
• #36, #40 Add support for count column, count distinct by @DrewImm in #113

Fixes

• #128 Linting & ts-config from latest typescript-template release by @DrewImm in #129
• #112 Column default functions sql error by @DrewImm in #116
• #108 Simplify join interfaces by @DrewImm in #114
• #84 Creating timestamp column with default current_timestamp and NOT … by @DrewImm in #120
• #76 QueryRepository::count() returns numeric string with some databases by @DrewImm in #119

Full Changelog: v3.1.0...v3.2.0

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