History.md

2.13.1 / 2024-09-19

What's Changed

• docs: add search box by @cyjake in #424
• feat: bone.jsonMerge() & bone.jsonMergePreserve() by @cyjake in #425
• fix: reload attribute if instance updated with jsonMerge by @cyjake in #426

Full Changelog: https://github.com/cyjake/leoric/compare/v2.13.0...v2.13.1

2.13.0 / 2024-08-26

What's Changed

• refactor: move json_merge_patch() handling to the spell prepartion phase by @coinkits in #422
• chore: should not reload by default by @coinkits in #423

New Contributors

• @coinkits made their first contribution in #422

Full Changelog: https://github.com/cyjake/leoric/compare/v2.12.3...v2.13.0

2.12.3 / 2024-04-13

What's Changed

• upgrade: mysql2 >= 3.9.4 by @cyjake in #420
• feat: support mysql2 v3 for security update by @fengmk2 in #419

Full Changelog: https://github.com/cyjake/leoric/compare/v2.12.2...v2.12.3

2.12.2 / 2023-12-11

What's Changed

• chore: export { hookNames } by @cyjake in #416

Full Changelog: https://github.com/cyjake/leoric/compare/v2.12.1...v2.12.2

2.12.1 / 2023-12-07

What's Changed

• fix: export more ts type definitions by @JimmyDaddy in #411
• Update starter.md by @zhennann in #412
• fix: type error in validate when using min max by @chen201724 in #413
• feat: support JSON_VALUE(j, '$.a' RETURNING CHAR(50)) by @cyjake in #414

New Contributors

• @zhennann made their first contribution in #412
• @chen201724 made their first contribution in #413

Full Changelog: https://github.com/cyjake/leoric/compare/v2.12.0...v2.12.1

2.12.0 / 2023-11-21

What's Changed

• chore: export main entry point only by @cyjake in #404
• docs: more examples about typescript support by @cyjake in #405
• chore: improve test coverage after migrating ts project by @cyjake in #406
• feat: ignore json parse error if jsonType.ignoreError is positive by @cyjake in #409

Full Changelog: https://github.com/cyjake/leoric/compare/v2.11.5...v2.11.6

2.11.5 / 2023-11-05

What's Changed

• refactor: turn on compilerOptions.strict by @cyjake in #403

Full Changelog: https://github.com/cyjake/leoric/compare/v2.11.4...v2.11.5

2.11.4 / 2023-10-31

What's Changed

• fix: fix scope type definitions by @JimmyDaddy in #402

Full Changelog: https://github.com/cyjake/leoric/compare/v2.11.3...v2.11.4

2.11.3 / 2023-10-31

What's Changed

• chore: export { WhereConditions } by @cyjake in #400

Full Changelog: https://github.com/cyjake/leoric/compare/v2.11.2...v2.11.3

2.11.2 / 2023-08-31

What's Changed

• docs: introduce @midwayjs/leoric by @cyjake in #399
• fix: don't overwrite primaryKey with LAST_INSERT_ID() if exists by @cyjake in #398

Full Changelog: https://github.com/cyjake/leoric/compare/v2.11.1...v2.11.2

2.11.1 / 2023-06-10

What's Changed

• fix: typo DataType for AbstractDriver by @vagusX in #390
• fix: wrong export from sequelize by @vagusX in #391
• fix: typo in hooks.md by @vagusX in #392

Full Changelog: https://github.com/cyjake/leoric/compare/v2.11.0...v2.11.1

2.11.0 / 2023-05-17

What's Changed

• feat: support browser and support sql.js driver by @vagusX in #386
• fix: remove unscoped fn in src/adapters/sequelize.js by @vagusX in #387
• fix: join conditions containing fields of base model should be allowed by @cyjake in #388

Full Changelog: https://github.com/cyjake/leoric/compare/v2.10.3...v2.11.0

2.10.3 / 2023-04-25

What's Changed

• feat: try to use structuredClone first by @fengmk2 in #384
• fix: avoid ts type detect error by @fengmk2 in #385

Full Changelog: https://github.com/cyjake/leoric/compare/v2.10.2...v2.10.3

2.10.2 / 2023-04-23

What's Changed

• fix: order clause need be repeated on the main query by @cyjake in #383

Full Changelog: https://github.com/cyjake/leoric/compare/v2.10.1...v2.10.2

2.10.1 / 2023-03-24

What's Changed

• fix: retain where conditions when sharding key is necessary by @cyjake in #381
• fix: select everything when forming subspell by @cyjake in #382

Full Changelog: https://github.com/cyjake/leoric/compare/v2.10.0...v2.10.1

2.10.0 / 2023-03-24

What's Changed

• feat: add db pacakges to peerDependencies by @fengmk2 in #375
• feat: support manual rollback & commit for transaction, fix #371 by @JimmyDaddy in #376
• feat: optimize join query parsing fix #378 by @JimmyDaddy in #380

Full Changelog: https://github.com/cyjake/leoric/compare/v2.9.2...v2.10.0

2.9.2 / 2023-01-04

What's Changed

• fix: types for findAndCountAll by @vagusX in #372
• fix: adapt facebook hermes or metro bundler for loop by @JimmyDaddy in #374

Full Changelog: https://github.com/cyjake/leoric/compare/v2.9.1...v2.9.2

2.9.1 / 2022-11-21

What's Changed

• fix: fix Bone.create(values) params type definitions by @JimmyDaddy in #369
• chore: export Utility Type BoneInstanceValues by @JimmyDaddy in #370

Full Changelog: https://github.com/cyjake/leoric/compare/v2.9.0...v2.9.1

2.9.0 / 2022-11-09

What's Changed

• fix: tinytext type error by @JimmyDaddy in #364
• fix: date strings should be parsed with system time zone considered by @cyjake in #365
• feat: support multiple level inherent by @JimmyDaddy in #366
• fix: cast/uncast STRING and TEXT with non-string type value, and some type definitions by @JimmyDaddy in #368

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.8...v2.9.0

2.8.8 / 2022-10-25

What's Changed

• fix: join query with select columns should include order columns by @cyjake in #360
• docs: support switchable dark theme, at web app level by @cyjake in #359
• fix: @Column() should not tamper parent attributes directly by @cyjake in #362
• fix: bone.update({ deletedAt: null }) and likewise methods should work by @cyjake in #363

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.7...v2.8.8

2.8.7 / 2022-10-11

What's Changed

• fix: enable strictNullChecks by @cyjake in #357
• fix: declaration types of realm.query() and static update values by @cyjake in #358

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.6...v2.8.7

2.8.6 / 2022-10-11

What's Changed

• fix: new Realm({ sequelize: true }).Bone == Realm.SequelizeBone by @cyjake in #349
• fix: edge cases in attribute.equals() by @cyjake in #350
• fix: bone.attribute(name, value?) type infer with this[name] by @cyjake in #351
• fix: ts type definitions by @JimmyDaddy in #352
• fix: this.attribute(name) should fallback to Literal by @cyjake in #353
• fix: type definitions for columns constraint by @JimmyDaddy in #355

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.5...v2.8.6

2.8.5 / 2022-09-21

What's Changed

• fix: deletedAt should always be checked when associating models by @cyjake in #347
• fix: generic type for getDataValue by @vagusX in #346

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.4...v2.8.5

2.8.4 / 2022-09-20

What's Changed

• fix: Literal type should not contain object & ResultSet should be derived from instance values by @cyjake in #345

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.3...v2.8.4

2.8.3 / 2022-09-15

What's Changed

• fix: AssociationOptions.select? should be supported by @cyjake in #343
• fix: return type of realm.query, realm.transaction, and Bone.transation by @cyjake in #344

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.2...v2.8.3

2.8.2 / 2022-09-13

What's Changed

• fix: AssociateOptions in HasMany, BelongdsTo decorators by @cyjake in #341
• fix: invokable dataType in decorators should work and dts fix by @JimmyDaddy in #342

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.1...v2.8.2

2.8.1 / 2022-08-31

What's Changed

• fix: metro exports error by @JimmyDaddy in #339
• fix: Model.count(field) in sequelize adapter by @cyjake in #340

Full Changelog: https://github.com/cyjake/leoric/compare/v2.8.0...v2.8.1

2.8.0 / 2022-08-30

What's Changed

• feat: refactor type definitions to export SequelizeBone, complete spell type definitions and fix index hints logic by @JimmyDaddy in #337
• fix: throw error if token is not expected when parse expr by @cyjake in #338

Full Changelog: https://github.com/cyjake/leoric/compare/v2.7.3...v2.8.0

2.7.3 / 2022-08-25

What's Changed

• fix: should skip loading models that is loaded before by @cyjake in #335

Full Changelog: https://github.com/cyjake/leoric/compare/v2.7.2...v2.7.3

2.7.2 / 2022-08-24

What's Changed

• Update associations.md by @dxhuii in #331
• refactor: refactor type definitions and fix unique not work in columnOptions by @JimmyDaddy in #332
• fix: declare more exported functions such as isBone and heresql by @cyjake in #333
• fix: INTEGER like data type and STRING extra options didn't work in polymorphism, fix decorators ColumnOptions.type to support invokable by @JimmyDaddy in #334

New Contributors

• @dxhuii made their first contribution in #331

Full Changelog: https://github.com/cyjake/leoric/compare/v2.7.1...v2.7.2

2.7.1 / 2022-08-24

What's Changed

• fix: projects might have strictPropertyInitialization set to true by @cyjake in #329
• fix: types for validate in Column decorator by @vagusX in #330

New Contributors

• @vagusX made their first contribution in #330

Full Changelog: https://github.com/cyjake/leoric/compare/v2.7.0...v2.7.1

2.7.0 / 2022-08-24

What's Changed

• fix: glue code for opts.dialectModulePath by @cyjake in #326
• fix: primaryKey in upsert values should be validate in sqlite and postgres by @JimmyDaddy in #328
• feat: change DataTypes to ts and complete decorators type definitions by @JimmyDaddy in #319

Full Changelog: https://github.com/cyjake/leoric/compare/v2.6.3...v2.7.0

2.6.3 / 2022-08-04

What's Changed

• fix: aggregator not parse null result by @killagu in #322
• test: switch the auth protocol of test mysql database by @cyjake in #323
• feat: add leoric_bone meta data to Bone by @JimmyDaddy in #324
• docs: fix declarations of findOne(primaryKey) & findOne({ $or }) by @cyjake in #325

Full Changelog: https://github.com/cyjake/leoric/compare/v2.6.2...v2.6.3

2.6.2 / 2022-07-12

What's Changed

• fix: format select with out * if use aggreator by @killagu in #320
• fix: fix transaction typing by @killagu in #321

New Contributors

• @killagu made their first contribution in #320

Full Changelog: https://github.com/cyjake/leoric/compare/v2.6.1...v2.6.2

2.6.1 / 2022-06-24

What's Changed

• build: switch to latest postgres by @cyjake in #316
• fix: fix [bug] init models with bone class should work #317 by @JimmyDaddy in #318

Full Changelog: https://github.com/cyjake/leoric/compare/v2.6.0...v2.6.1

2.6.0 / 2022-06-02

What's Changed

• feat: support export sql query template in logger by @JimmyDaddy in #314
• fix: fix uncast date string without milliseconds error by jsCore in Android/iOS by @JimmyDaddy in #315

Full Changelog: https://github.com/cyjake/leoric/compare/v2.5.0...v2.6.0

2.5.0 / 2022-05-13

What's Changed

• feat: support disconnect and fix timestamps init by @JimmyDaddy in #313

Full Changelog: https://github.com/cyjake/leoric/compare/v2.4.1...v2.5.0

2.4.1 / 2022-04-27

What's Changed

• fix: realm.Bone.DataTypes should be invokable, Invokable.TYPE.toSqlString() get wrong default length(1), DataType definitions by @JimmyDaddy in #307

Full Changelog: https://github.com/cyjake/leoric/compare/v2.4.0...v2.4.1

2.4.0 / 2022-04-24

What's Changed

• feat: support custom driver by @JimmyDaddy in #304
• chore: update build status badge by @snapre in #305
• feat: export more ts type definitions and use deep-equal module by @JimmyDaddy in #306

New Contributors

• @snapre made their first contribution in #305

Full Changelog: https://github.com/cyjake/leoric/compare/v2.3.2...v2.4.0

2.3.2 / 2022-04-15

What's Changed

• fix: order by raw with mix-type array in sequelize mode by @JimmyDaddy in #298
• docs: monthly updates and example about egg-orm usage with TypeScript by @cyjake in #299
• docs: monthly updates in en & docmentation about typescript support by @cyjake in #300
• fix: raw query should format replacements with extra blank by @JimmyDaddy in #301
• docs: elaborate on querying by @cyjake in #302
• feat: transaction should return result by @JimmyDaddy in #303

Full Changelog: https://github.com/cyjake/leoric/compare/v2.3.1...v2.3.2

2.3.1 / 2022-03-22

What's Changed

• fix: mysql2 Invalid Date compatible by @JimmyDaddy in #291
• fix: order by raw in sequelize mode by @JimmyDaddy in #292
• fix: bulk update query conditions duplicated in sequelize mode by @JimmyDaddy in #293
• fix: bulk destroy query conditions duplicated in sequelize mode by @JimmyDaddy in #295
• fix: drop column if not defined in attributes when alter table by @cyjake in #296

Full Changelog: https://github.com/cyjake/leoric/compare/v2.3.0...v2.3.1

2.3.0 / 2022-03-10

What's Changed

• feat: model declaration with decorators by @cyjake in #287
• feat: add VIRTUAL data type by @JimmyDaddy in #289
• fix: create instance dirty check rule fix by @JimmyDaddy in #290

Full Changelog: https://github.com/cyjake/leoric/compare/v2.2.3...v2.3.0 2.2.3 / 2022-03-01

What's Changed

• fix: normalize attribute defaultValue by @cyjake in #285
• fix: instance beforeUpdate hooks should not modify any Raw if there are no Raw assignment in them by @JimmyDaddy in #283

Full Changelog: https://github.com/cyjake/leoric/compare/v2.2.2...v2.2.3

2.2.2 / 2022-02-28

What's Changed

• fix: tddl gives misleading information_schema.columns.table_name by @cyjake in #284

Full Changelog: https://github.com/cyjake/leoric/compare/v2.2.1...v2.2.2

2.2.1 / 2022-02-24

What's Changed

• fix: realm.DataTypes should be invokable by @cyjake in #282

Full Changelog: https://github.com/cyjake/leoric/compare/v2.2.0...v2.2.1

2.2.0 / 2022-02-24

What's Changed

• fix: add missing password field for ConnectOptions by @luckydrq in #280
• feat: integer types (mostly mysql specific) by @cyjake in #281

Full Changelog: https://github.com/cyjake/leoric/compare/v2.1.1...v2.2.0

2.1.1 / 2022-02-23

What's Changed

• fix: fix #274 update with fields option by @JimmyDaddy in #275
• fix: upsert should set createdAt by default while createdAt not set by @JimmyDaddy in #277
• fix: previousChanges should check instance is new record or not while specific attributes' values were undefined by @JimmyDaddy in #276
• docs: add types for realm by @luckydrq in #278

New Contributors

• @luckydrq made their first contribution in #278

Full Changelog: https://github.com/cyjake/leoric/compare/v2.1.0...v2.1.1

2.1.0 / 2022-02-17

What's Changed

• feat: fix #270 sequelize mode bulkBuild by @JimmyDaddy in #273
• fix: mysql delete/remove/destroy with limit and orders by @JimmyDaddy in #272

Full Changelog: https://github.com/cyjake/leoric/compare/v2.0.4...v2.1.0

2.0.4 / 2022-02-16

What's Changed

• fix: fix unit test error by @LB4027221 in #269
• fix: attribute.defaultValue should be set when init attributes by @cyjake in #271

Full Changelog: https://github.com/cyjake/leoric/compare/v2.0.3...v2.0.4

2.0.3 / 2022-02-11

What's Changed

• fix: default updatedAt to new date if model has no createdAt by @LB4027221 in #268

New Contributors

• @LB4027221 made their first contribution in #268

Full Changelog: https://github.com/cyjake/leoric/compare/v2.0.2...v2.0.3

2.0.2 / 2022-02-10

What's Changed

• fix: order by alias should not throw by @cyjake in #255
• fix: fix #257 DataType.uncast should skip Raw type at type checking by @JimmyDaddy in #258
• docs: async function in transaction by @cyjake in #259
• fix: fixed #256 static create instance should check all default attri… by @JimmyDaddy in #262
• fix: fix #260 UPDATE with LIMIT and ORDER should be formatted(mysql only) by @JimmyDaddy in #261
• refactor: keep the UPDATE ... ORDER BY ... LIMIT to mysql driver by @cyjake in #264
• fix: fix #263 upsert attributes should use defaultValue while there i… by @JimmyDaddy in #265
• fix: fix restore Error Undefined attribute "deletedAt" by @JimmyDaddy in #267
• fix: type checking adaption by @JimmyDaddy in #266

Full Changelog: https://github.com/cyjake/leoric/compare/v2.0.1...v2.0.2

2.0.1 / 2022-01-05

What's Changed

• fix: format numeric result by @JimmyDaddy in #253
• fix: should still return number if value is '0.000' by @cyjake in #254

Full Changelog: https://github.com/cyjake/leoric/compare/v1.15.1...v2.0.1

2.0.0 / 2021-12-28

What's Changed

• breaking: model.sync add force/alter option by @SmartOrange in #224
• breaking: logQueryError(err, sql, duration, options) by @cyjake in #237
• test: add utf8mb4 test cases by @fengmk2 in #239
• Merge 1.x changes by @cyjake in #249

New Contributors

• @SmartOrange made their first contribution in #222

Full Changelog: https://github.com/cyjake/leoric/compare/v1.15.1...v2.0.0

1.15.1 / 2021-12-28

What's Changed

• fix: fix #242 date string format by @JimmyDaddy in #243
• fix: update with empty conditions by @JimmyDaddy in #241
• fix: silent option's priority should be lower than valueSet by @JimmyDaddy in #244
• fix: information_schema.columns.datetime_precision by @cyjake in #246
• fix: should not hoist subquery if query is ordered by external columns by @cyjake in #247

Full Changelog: https://github.com/cyjake/leoric/compare/v1.15.0...v1.15.1

1.15.0 / 2021-11-22

What's Changed

• feat: make duration in precise milliseconds by @fengmk2 in #236
• fix: spell.increment() & spell.decrement() @cyjake #234
• fix: bulkCreate should adapte empty data @JimmyDaddy #232

Full Changelog: https://github.com/cyjake/leoric/compare/v1.14.4...v1.14.5

1.14.4 / 2021-11-15

What's Changed

• test: PostgreSQL v14 test case compatibility by @cyjake #230
• fix: turn off subquery optimization if query criteria contains other column by @cyjake #229
• fix: bone.changed() return false | string[] type by @fengmk2 #231

Full Changelog: https://github.com/cyjake/leoric/compare/v1.14.3...v1.14.4

1.14.3 / 2021-11-12

What's Changed

• fix: logger.logQuery should be guarded in case of error by @SmartOrange in #222
• fix: findOne without result should return null by @JimmyDaddy in #225
• fix: Literal should support bigint type by @fengmk2 in #226
• fix: select((name: string) => boolean) by @cyjake in #227

Full Changelog: https://github.com/cyjake/leoric/compare/v1.14.2...v1.14.3

1.14.2 / 2021-11-01

What's Changed

• fix: accept timestamps in snake case by @cyjake in #221

Full Changelog: https://github.com/cyjake/leoric/compare/v1.14.1...v1.14.2

1.14.1 / 2021-11-01

What's Changed

• docs: export { Collection } by @cyjake in #220

Full Changelog: https://github.com/cyjake/leoric/compare/v1.14.0...v1.14.1

1.14.0 / 2021-11-01

Two options regarding Model.init() were added in this release:

class User extends Bone {}
User.init({ name: STRING }, {
  timestamps: true,  // which is the default
  paranoid: true,    // which default to `false`
});
assert.deepEqual(Object.keys(User.attributes), [
  'id',
  'name',
  'createdAt',
  'updatedAt',
  'deletedAt',
]);

What's Changed

• docs: update 'primayKey' typos by @freshgum-bubbles in #211
• docs: DataTypes definitions in d.ts by @cyjake in #210
• fix: fix#209 sequelize mode should update all changed fields in instance update method by @JimmyDaddy in #212
• fix: fix #213 findAndCountAll should ignore attributes by @JimmyDaddy in #214
• fix: opts.connectTimeout by @cyjake in #216
• fix: reload instance with sharding key should not throw by @cyjake in #217
• feat: timestamps should be defined by default by @cyjake in #218
• fix: instance.reload() should not rely on static findOne() by @cyjake in #219

New Contributors

• @freshgum-bubbles made their first contribution in #211

Full Changelog: https://github.com/cyjake/leoric/compare/v1.13.5...v1.14.0

1.13.5 / 2021-10-26

What's Changed

• docs: enhance aggregation query types & fix raw query result type by @cyjake in #208

Full Changelog: https://github.com/cyjake/leoric/compare/v1.13.4...v1.13.5

1.13.4 / 2021-10-25

What's Changed

• docs: spell & model methods should be generic by @cyjake in #206
• docs: enhance query options, instance type, and toJSON() result type by @cyjake in #207

This version brings correct (and hopefully better) typescript definitions, with the dts checked continuously at test/types tests. With this version, users that have model types correctly pinned at Bone will get code completion including class fields. Such as:

Full Changelog: https://github.com/cyjake/leoric/compare/v1.13.3...v1.13.4

1.13.3 / 2021-10-21

What's Changed

• refactor: persist edge cases of type casting in integration tests by @cyjake in #202
• docs: renaming attributes by @cyjake in #203
• fix: JSON.uncast(string) should not serialize twice by @cyjake in #205

Full Changelog: https://github.com/cyjake/leoric/compare/v1.13.2...v1.13.3

1.13.2 / 2021-10-18

What's Changed

• fix: attribute.uncast([]) and realm.connect with synchronized models by @cyjake in #201

Full Changelog: https://github.com/cyjake/leoric/compare/v1.13.1...v1.13.2

1.13.1 / 2021-10-18

What's Changed

• fix: skip connecting if models are synchronized already by @cyjake in #200

Full Changelog: https://github.com/cyjake/leoric/compare/v1.13.0...v1.13.1

1.13.0 / 2021-10-18

What's Changed

• docs: monthly updates of 2021.09; support dark mode by @cyjake in #196
• feat: coerce literal values into accurate attribute type by @cyjake in #197
• fix: dispatched result should be in attribute names by @cyjake in #198

Full Changelog: https://github.com/cyjake/leoric/compare/v1.12.0...v1.13.0

1.12.0 / 2021-10-12

• feat: support custom fields query and sequelize mode export rawAttributes (#192)
• refactor: collection format query result (#194)
• refactor: object condition parsing and expression formatting (#191)

1.11.1 / 2021-09-28

This version fixes lots of issues regarding logical operator in object conditions.

• fix: logical operator with multiple conditions such as (#190)
• fix: sequelize mode support HAVING, and select fields raw sql support (#187)
• fix: support len validator (#188)
• fix: normalize logical operator conditions before formatting with spellbook (#186)

1.11.0 / 2021-09-24

• feat: support BINARY(length), VARBINARY(length), and BLOB (#169)
• fix: logic operate should adapt one argument (#183)
• fix: Bone.load() should be idempotent, make sure associations is intact (#184)
• fix: selected instance isNewRecord is false (#182)
• fix: set options.busyTimeout to mitigate SQLITE_BUSY (#176)
• fix: turn on long stack trace of sqlite driver (#175)
• docs: how to contribute (#180)

1.10.0 / 2021-09-14

• feat: SQLite driver should emit "connection" event when new connection is created (#168)
• fix: bulkCreate(...records) should recognize custom setters (#168)
• fix: attribute.equals() check should ignore defaultValue (#172)

1.9.0 / 2021-09-04

should've been a major release but since existing users have all migrated to the new api...

• breaking: drop the deprecated Model.describe() (#167)

1.8.0 / 2021-08-30

• feat: silent option fix #164 (#165)
• feat: binary type (#166)

1.7.1 / 2021-08-17

• revert: drop Driver#recycleConnections due to poor interoperability (#162)
• fix: validator call array arguments (#160)

1.7.0 / 2021-08-17

• feat: close connections that exceeds opts.idleTimeout (#159)
• feat: opts.connectionLimit support for SQLite (#159)
• feat: raw query relpacements, closes #149 (#155)
• fix: upsert created_at default (#154)
• test: validator unit test (#157)
• test: setup_hooks unit test (#158)

1.6.7 / 2021-08-05

• fix: prevent from calling Date.prototype.toJSON (#153)

1.6.6 / 2021-07-22

• fix: subclassing data type in dialects (#145)
• fix: where('width / height >= 16 / 9') (#144)
• docs: logging and sequelzie adapter (zh) (#142)
• test: include test/unit/utils (#143)
• test: more tests cases about sequelize adapter (#141)

1.6.5 / 2021-07-16

• fix: define assign Bone.models #140

1.6.4 / 2021-07-16

• refactor: connect({ Bone }) still necessary (#139)
• fix: formatting select join with subqueries should not tamper the subquery itself (#138)
• fix: describe table with more compatible syntax (#137)

1.6.3 / 2021-07-14

• fix: transaction option passing in sequelize adapter (#136)
• fix: this.Model and proper Model.describe() (#135)

1.6.2 / 2021-07-09

• fix: convert datetime in seconds/milliseconds back to Date (#134)
• fix: renamed attribute should remain enumerable (#133)

1.6.1 / 2021-07-07

• fix: collection convert should handle tddl results as well (#132)

1.6.0 / 2021-07-06

• feat: support class static attributes and hooks (#131)
• fix: names defined in Bone.attributes should always be enumerable (#128)
• chore: add quality badge to readme (#129)

1.5.2 / 2021-07-02

• fix: leave the getter properties defined in class syntax as is (#127)

1.5.1 / 2021-06-30

• fix: export Logger and Spell to let users intercept lower level api calls (#126)

1.5.0 / 2021-06-30

• feat: provide Bone.pool to be backward compatible with v0.x (#124)
• feat: complete bone/spine.restore and Bone API type definitions (#125)
• feat: support more data types (mediumtext, mediumint, char, date...) (#123)

1.4.1 / 2021-06-25

• refactor: simplify legacy timestamps support (#120)
• refactor: do not subclass Bone unless asked specifically (#120)

1.4.0 / 2021-06-24

• feat: realm.raw('SELECT ...') and Model.raw('SELECT ...') (#94)
• feat: support multiple order rules in one single string or one-dimensional array (#92)
• feat: Model.truncate() now uses TRUNCATE if possible
• feat: Model.find().optimizerHints('SET_VAR(foreign_key_checks=OFF)')
• fix: Bone.bulkCreate() should not throw when called with non attribute (#117)
• fix: batch upsert (#108)
• fix: make sure connection is passed around in all queries carried out within transaction (#105)
• fix: update, sequelize mode get API, destroy compitable (#104)
• fix: setDataValue in sequelize adapter should not check prop name strictly
• refactor: spell_insert (#118)
• docs: about egg-orm & migrations (#119)
• docs: revise instructions for installing Jekyll (#111)
• docs: migrations, validations, hooks, and sequelize adapter (#103)
• docs: contributing guides

1.3.0 / 2021-03-01

• feat: hook support
• feat: dirty check (changes() & previousChanges())
• feat: compatible with mysql longtext conversion
• feat: NOT condition

1.2.0 / 2020-12-10

• feat: Realm.prototype.transaction() with async function support
• feat: Realm.prototype.query() for raw queries
• feat: logger.logQuery(sql, duration, { Model, command })
• feat: logger.logQueryError(sql, err, duration, { Model, command })

1.1.0 / 2020-11-23

• feat: JSON and JSONB data types
• feat: support stringifyObjects option for mysql client
• feat: aggregate functions for sequelize adapter
• feat: Spell.prototype.nodeify()

1.0.3 / 2020-03-16

• fix: replace deep-equal (which is bloated) with util.isDeepStrictEqual

1.0.2 / 2020-03-04

• fix: driver.alterTable() with multiple columns to add in SQLite

1.0.1 / 2020-02-25

• fix: bulkCreate in sequelize shim

1.0.0 / 2020-02-24

First major release. Let's get serious with semver.

• feat: logger.logQuery(sql, duration) & logger.logQueryError(sql, err)

0.5.3 / 2020-02-22

• fix: connect({ sequelize, dialect, client }) to allow mandatory sqlite client
• fix: prevent queries being performed unless model is correctly connected

0.5.2 / 2020-02-21

• fix: drop the default and unused require('sqlite3')

0.5.1 / 2020-02-21

• fix: connect({ client: '@journeyapps/sqlcipher' })

0.5.0 / 2020-02-19

• feat: Bone.sync() to synchronize model with database
• feat: Bone.createMigrationFile() to create migration file
• feat: Bone.migrate() to run migrations
• feat: Bone.bulkCreate() to bulk insert records
• feat: require('leoric') now exports Realm to connect with multiple databases
• feat: realm.define() to define models in an old fashioned way
• feat: realm.connect() to connect with database
• feat: SQLite support without hacking node-sqlite3
• feat: Bone.DataTypes for type references
• feat: Bone.init() to initialize models
• feat: an adaptor to use Leoric in (partially) Sequelize complaint API
• refactor: a complete re-write of JOIN queries
• refactor: added Bone.driver to better encapsulate and planish database nuances

0.4.5 / 2019-12-14

• fix: prevent primary key from being overridden with incorrect LAST_INSERT_ID()

0.4.4 / 2019-07-15

• fix: append default scope when declaring relations, fixes #10

0.4.3 / 2019-05-09

• fix: prevent Bone.dispatch from creating duplicated records of main table

0.4.2 / 2019-04-26

• feat: Spell#orWhere() and Spell#orHaving()
• feat: arithmetic operators
• feat: unary operators such as unary minus - and bit invertion ~
• fix: unset attribute should be overwritable
• fix: attributeChanged() should be false if attribute is unset and not overwritten
• fix: subclass with incomplete getter/setter should be complemented
• fix: sharding key validation on Bone.update() and Bone.save()
• fix: sharding key should be along with primary key on bone.remove()
• fix: Bone.cast() should leave null as is
• fix: INSERT ... UPDATE with id = LAST_INSERT_ID(id) in MySQL
• fix: Model.find({ name: { $op1, $op2 } }) object conditions with multiple operators
• fix: prefixing result set with qualifiers if query contains join relations and is not dispatchable
• fix: Spell#$get(index) with LIMIT
• doc: Model.transaction()
• doc: definition types with index.d.ts

0.4.1 / 2019-03-21

• feat: premature sharding key validation
• fix: output complete SQL instead of parameterized query with values.
• fix: both connect({ model }) and connect({ models }) are allowed.
• doc: no more .findOrCreate(), just .upsert()
• doc: table of contents with kramdown's {:toc}
• chore: droped experimental sqlite3 support

0.4.0 / 2018-11-05

• feat: PostgreSQL support
• feat: Transaction support
• upgrade: (forked) SQLite client updated to SQLite 3.24

0.3.0 / 2018-10-31

• feat: SQLite support with a forked sqlite3
• feat: mysql2 support (which is trivial since both mysql and mysql2 share the same API)
• refactor: Spell now formats SQL with the literals separated, which gets escaped by the corresponding client itself later on.

0.2.0 / 2018-01-03

• breaking: renaming

0.1.8 / 2017-12-31

• fix: implement query.batch() as async iterator
• fix: NOT (expr)
• fix: IFNULL(foo, default)
• fix: support .select(name[]), .select(name => {}), and .select("...name")
• doc: Model => className in association options
• doc: use jsdoc to generate docs/api
• doc: .include()

0.1.7 / 2017-12-22

• refactor: { type: 'op', name: 'as' } renamed to { type: 'alias' }
• feat: { type: 'mod' } for modifier, currently only DISTINCT is recognized
• feat: unary operators like ! and NOT
• feat: IS and IS NOT
• fix: logic operator precendences
• fix: polymorphic hasMany({ through }) relations
• fix: dispatching multiple results with joins correctly

0.1.6 / 2017-12-21

• feat: proper .first, .last, .all, and .get(index)
• fix: accept Date, boolean, and Set values
• fix: Model.unscoped
• fix: Model.remove({}, true) should be unscoped

0.1.5 / 2017-12-20

• refactor: encapsulate column names. Keep them from the users even if the query results can not be dispatched.
• fix: complicated groups with joins should discard the use of subquery.
• fix: camelCase should replace globally
• fix: avoid missing attribtue exception when toJSON/toObject

0.1.4 / 2017-12-18

• fix: should format condition arrays by hand instead of hand it over to formatExpr
• fix: whereConditions of subquery should retain the order of the whereConditions in major query
• fix: calculated columns should be kept in the final columns when sorting out the attributes
• fix: doesn't depend on co anymore

0.1.3 / 2017-12-17

• fix: select distict foo from table;
• fix: where (a = 1 or a = 2) and b = 3;
• doc: a syntax table to provide a better glance over the querying ability.

0.1.2 / 2017-12-14

• fix: copy left table's orders into subquery to make order/limit work when combined.
• fix: errors should be thrown when accessing attributes that weren't selected at the first place.

0.1.1 / 2017-12-13

• refactor: automatic versioning on spells. When client calls query methods with chaining, new versions of spell gets duplicated. Makes reuse of spells possible.
• doc: english verion is almost complete http://cyj.me/leoric.

0.1.0 / 2017-12-09

• Initial version, covers basic usage such as model authoring, database connection, query interface, and association.