Skip to content

Latest commit

 

History

History
196 lines (142 loc) · 6.39 KB

CHANGELOG.md

File metadata and controls

196 lines (142 loc) · 6.39 KB
Raw

Changelog

Unreleased

3.0.0-alpha.3 - 2024-08-31

  • Update eslint to 9.x and prettier with configs
  • Add node.js 22 to CI

3.0.0-alpha.2 - 2023-08-17

  • Implement sql templates
  • Fix Modify.then for compatibility with Query.then
  • Auto returnung * as a quick patch

3.0.0-alpha.1 - 2023-05-27

  • Update metadomain to 2.0.0-alpha.1
  • Change core schema generation

2.1.5 - 2023-05-01

  • Drop node.js 14 support, add node.js 20
  • Convert package_lock.json to lockfileVersion 2
  • Update dependencies

2.1.4 - 2023-03-14

  • Update dependencies and package maintenance

2.1.3 - 2023-02-19

  • Update dependencies
  • Add node: prefix in require for built-in modules

2.1.2 - 2022-12-14

  • Add empty line separator in SQL create script
  • Add empty line separator in SQL create script
  • Run CI for node.js 14, 16, 18, 19 with postgres

2.1.0 - 2022-08-18

  • Using optional chaining operator
  • Update crud plugin to work wit the impress application sandbox

2.0.5 - 2022-07-11

  • Update metaschema to 2.1.0

2.0.4 - 2022-06-25

  • Allow interval field type
  • Allow falsy values in update
  • Capture relevant error stack trace
  • Add catch function to query execution
  • Make query execution properly then-able
  • Fix undefined use in insert/update/conditions, keys with undefined value will no longer result in null and will just be ignored
  • Fix working with nested schemas for databases

2.0.2 - 2021-10-14

  • Support null as value for update
  • Fixed thenable chain in db.select

2.0.1 - 2021-09-10

  • Update dependencies

2.0.0 - 2021-08-19

  • Change plugin interface (wrap plugin to function). This changes in plugins are not backward compatible, so major version will be incremented.
  • Update dependencies

1.5.0 - 2021-08-10

  • Generating SQL Query and Modify method toString()
  • Fix SQL generation for index and unique fields

1.4.0 - 2021-08-09

  • New API methods for Database async count(table, condition): number
  • Added support for functions in select (min, avg, count...)

1.3.0 - 2021-08-07

  • Use options.logger and global console if no options.console for backward compatibility, fallback will be better than crash
  • Add { delete: 'cascade' } to generate ON DELETE CASCADE for { many }
  • Implement .returning(fields) for Query
  • Methods insert, delete and update of Database returns instance of Modify class with chain methods .returning and .then

1.2.0 - 2021-08-04

  • Add typings for Database and Query classes
  • Move types to package root
  • Generated always as identity just for Registry
  • Support DEFAULT CURRENT_TIMESTAMP for datetime
  • Generate SQL for bootstrapping db data
  • Pass Model to Database to access schemas
  • Use common Console interface for logging
  • Generate ids for Registry tables

1.1.5 - 2021-07-04

  • Implement CRUD plugin
  • Save Query to declarative format
  • Create Query from declarative format

1.1.4 - 2021-06-30

  • Support OR in queries
  • Database will be generated only from Schema.KIND_STORED schemas

1.1.3 - 2021-05-25

  • Remove debug output
  • Package meintenance

1.1.2 - 2021-05-24

  • Update index generation according to new metadata
  • Query.limit(count: number)
  • Query.offset(count: number)
  • Query.order(fields: string | Array)
  • Query.desc(fields: string | Array)
  • Support permissions for categories, catalogs, fields
  • Support unique alternative keys
  • Generate nullable fields

1.1.1 - 2021-05-08

  • Field group name concatenation with field name
  • Support optional shorthand and nested json schema

1.1.0 - 2021-05-07

  • Use metaschema Model and Schema classes
  • Support script generation with field groups
  • Update metaschema to v1.1.0
  • New API methods for Database:
    • async row(table, fields, conditions): Object
    • async scalar(table, field, conditions): ScalarValue
    • async col(table, field, conditions): Array
    • async dict(table, fields, conditions): Object

1.0.1 - 2021-04-04

  • Fixed field names quotation
  • Update dependencies

1.0.0 - 2021-03-06

  • Simple query builder instead of SQL clause generator
  • Only PostgreSQL support instead of universal
  • Use metaschema and metavm for schema loading
  • Database model loader
  • PostgreSQL DDL script generator
  • TypeScript typings generator
  • Calculate changec and generate up and down migrations

metarhia-sql - 2020-09-06

Code before fork from https://github.com/metarhia/sql