Skip to content

Latest commit

 

History

History
327 lines (232 loc) · 12.4 KB

CHANGELOG.md

File metadata and controls

327 lines (232 loc) · 12.4 KB
Raw

sequelize-auto change log

[0.8.7] - 2021-12-08

  • Don't write field comments for mssql, because it throws error in sequelize.sync() (#567)
  • Add --noIndexes option (#563)
  • Add --indentation command line option to control indent size (#561)
  • Append an underscore if model name is a reserved word (#562, #570)
  • Remove 'esmd' lang option and standardize 'useDefine' behavior
  • Remove dialect canAliasPK check for generating fieldnames. (#571) This was a workaround to a sequelize bug that has been fixed.
  • TypeScript: fix syntax for HasOneCreateAssociationMixin
  • TypeScript: make field optional if autoIncrement instead of primaryKey (#572)
  • Fix case-senstive column name when querying views in mysql (#579)
  • Fix field comparison casing (#576)
  • TypeScript: Make timestamp fields not required for creation (#577)
  • Support mysql 'year' type (#575)

[0.8.6] - 2021-12-01

  • Add useDefine option to use sequelize.define instead of init (#559, #573)

[0.8.5] - 2021-10-18

  • Add kebab-case for caseFile (#552) (thanks @Ray0427)
  • Add logic to skip fields while generating (#557) (thanks @dpomerantz-jci)
  • Make case of "alias" properties match other properties (#539) (thanks @Genaker)
  • Remove Model type import (#554) (thanks @leonardo)
  • Allow Primary Key suffixes to be passed in, to be trimmed when creating property names (#558) (thanks @dpomerantz-jci)
  • Fix handling of default value functions (#493, #548)
  • Use const instead of var in init-models for ES6 (#555)

[0.8.4] - 2021-08-06

  • Fix --noAlias option to never write aliases except for many-to-many relations (#515)
  • Add -l esmd for ES modules with "define" syntax instead of classes (#527) (thanks @retfah) (removed in 0.8.6 in favor of --useDefine)
  • Fix problem with paranoid not in output when additional.paranoid specified (#529)
  • Fix alias generation for column names that differ only by singular/plural (#533) (thanks @edwardmcarl)
  • Add Postgres types inet, cidr, macaddr and oid (#534)
  • Add TypeScript type for jsonb | json (#541) (thanks @HussainMehdi)
  • Fix TypeScript optional fields and CreationAttributes (#543 #546) (thanks @kurochin143)

[0.8.3] - 2021-05-15

  • Fix generation of alias in many-to-many (#521)
  • Add --noInitModels flag (#519)
  • Fix duplicate alias in many-to-many relationships (#520)
  • Fix erroneous many-to-many relationship with composite foreign keys (#525)
  • Add --noAlias option to avoid making alias for relationships (#515)
  • Add tests

[0.8.2] - 2021-03-31

  • TypeScript: fix imports when esModuleInterop is false (#498)
  • mssql: Make varchar(max) be DataTypes.TEXT (#508)
  • Fix name collision when plural and singular are the same (#509)
  • Fix missing associations (#510 and #512)
  • TypeScript: remove cast "as typeof Model" in belongsToMany, for compatibility with Sequelize 6.6.2 (#511)
  • mysql: Treat tinyint(1) as boolean (#514)
  • Update devDependencies

[0.8.1] - 2021-03-09

  • Allow password to be supplied from terminal (#503) (thanks @zypA13510)
  • Fix autoIncrement for SQLite (#504)
  • TypeScript: make field optional with "?" if it has a defaultValue (#505)
  • BREAKING CHANGE: command-line options always take precedence over config file options
  • BREAKING CHANGE: tables and skipTables options on command line are now space-separated (instead of comma-separated) lists
  • BREAKING CHANGE: drop support of node version less than 10

[0.8.0] - 2021-02-25

  • Add alias name to belongsToMany associations (#500)
  • Fix references to remove schema, seems unnecessary (#501)
  • Let host, database, username, and password be set via config file (#482) (thanks @twastvedt)
  • Update dependencies

[0.7.11] - 2021-02-09

  • Fix precision & scale for mssql DECIMAL types
  • Write mssql NUMERIC as DECIMAL instead of DOUBLE (#496)
  • Fix ENUM datatype for mysql
  • Sort relations by [parent, child] in init-models.ts
  • Update README to show alias in associations

[0.7.10] - 2021-02-03

  • Fix explicit NULL default values in mssql (#491) (thanks @md-shah)
  • Fix relation alias uniqueness (#489)
  • Add handling for Postgres range types (#490)
  • Make id field primaryKey if no other primaryKey exists (#480)

[0.7.9] - 2021-01-29

  • Fix schema handling and case errors in relations
  • Fix generation of relationships for mysql (#488)
  • Fix CRLF line breaks in bin/sequelize-auto (#487, #475, #462)

[0.7.8] - 2021-01-23

  • Make information_schema queries uppercase for mssql (#486)
  • Move meta queries from dialect-options to dialect-specific files
  • Create relations based on properties and alias instead of model names (#483, #466)

[0.7.7] - 2021-01-16

  • Escape special characters in default value (#476) (thanks @divinebovine)
  • Quote strings in Postgres array default values (#474)
  • Support both Postgres and Mysql enums (#479) (thanks @JonathanWolfe)
  • Use autoIncrementIdentity for Postgres identity columns (#485) (thanks @AdamAld)

[0.7.6] - 2020-12-17

  • Fix postgres array of enum (#463)
  • Fix init-models for ES6 modules (#464) (thanks @djake)
  • Fix examples in README (#465) (thanks @brandomeniconi)
  • Fix bug parsing comments as field type (#471)
  • TypeScript - add missing create/remove/has association methods (#467) (thanks @mat813)
  • TypeScript - don't lowercase the enum values (#468) (thanks @JonathanWolfe)
  • TypeScript - get/set DATE and TIME types as string instead of date (#469) (thanks @JonathanWolfe)

[0.7.5] - 2020-12-05

  • Add --singularize option, to singularize model and file names from plural table names
  • TypeScript - add association get/set/add/remove/has/count/create mixing methods to TypeScript models (#453) (thanks @mat813)
  • TypeScript - Add TableId and TablePk to model definitions (#453) (thanks @mat813)
  • Fix autoIncrement for generated keys in Postgres (#459 and #460) (thanks @divinebovine)
  • Cast through class to Model instead of any (#454) (thanks @mat813)
  • Fix postgres enum types broken in 0.7.2 (#455)

[0.7.4] - 2020-12-01

  • TypeScript - only declare properties optional (with ?) when field is nullable (#450) (thanks @mat813)
  • TypeScript - add the ModelCreationAttributes to the generated files (#451) (thanks @mat813)
  • TypeScript - add not-null assertions (with !) for fields
  • Put belongsToMany relationships first in init-models (#449)
  • Set noWrite = true when directory == false (#447)

[0.7.3] - 2020-11-29

  • Fix autoIncrement for non-key fields in Postgres (#446 and #448)
  • Remove obsolete dependencies async and graceful-fs-extra

[0.7.2] - 2020-11-19

  • Add enum support for TypeScript types (#443) (thanks @JonathanWolfe)
  • Make init-modules ts version compliant with --isolatedModules (#444) (thanks @JonathanWolfe). This is a BREAKING CHANGE because --lang ts output now requires TypeScript >= 3.8
  • Fix geometry/geography types in Postgres (#445)

[0.7.1] - 2020-11-05

  • Fix foreignKey property in belongsTo (#369)
  • Add belongsToMany when junction has 2 foreign keys that are also primary keys (#34)

[0.7.0] - 2020-11-03

  • Add belongsTo/hasOne/hasMany to initModels (#34) (#61) (#65) (#82) (#215) (#369)
  • Add precision to DECIMAL, DOUBLE, and FLOAT types
  • Add element type to Postgres ARRAY data types and TypeScript definitions (#151)

[0.6.7] - 2020-11-01

  • Fix "Assignment to constant" error introduced in 0.6.6 (#440) (thanks @xuezier)
  • Add support for generating models from views, --views option (#77)

[0.6.6] - 2020-10-30

  • Add indexes to table options (#162)
  • BREAKING CHANGE Change es6/esm/ts flags to lang option
  • Add JSDoc commments to type declarations
  • Add DataTypes.UUIDV4 default for postgres (#155) (thanks @roytz)

[0.6.5] - 2020-10-26

  • Escape special chars in table comments (#439)
  • Map mysql longtext/mediumtext/tinytext to DataTypes.TEXT
  • Export SequelizeAuto types in npm package (#140)

[0.6.4] - 2020-10-15

  • Export attributes interface for TypeScript files
  • Generate init-model.js file for loading models into sequelize
  • Add support for mysql date & time precision (thanks @locene)
  • Infer timestamps flag based on presence of createdAt/updatedAt field in tables
  • Change default indentation to 2 spaces
  • Add sample app; see sample directory
  • Fix quoting of table names in sqlite foreign keys query

[0.6.3] - 2020-10-05

  • Fix TypeScript generation (thanks @sschwenker)

[0.6.2] - 2020-09-28

  • Fix #TABLE# placeholder left in ES6 output, issue #432 (thanks @fprijate)
  • Fix command line config arguments, issue #434 (thanks @fprijate)
  • Fix schema comparison when filtering tables, issue #431

[0.6.1] - 2020-09-21

  • Fix default values for Postres Array types, issue #426
  • Fix multi-field unique constraints, issue #347 and #408
  • Fix tableResult properties, PR #429
  • Fix quotes in datatype names, issue #100
  • Catch promise rejections in auto-builder

[0.6.0] - 2020-09-17

  • BREAKING CHANGE Change API to Promises instead of callbacks
  • Rewrite source code in TypeScript, add build step
  • Fix default value for Postgres JSON types, issue #426
  • Omit sysdiagrams from mssql tables
  • Update dependencies

[0.5.4] - 2020-08-27

  • Fix handling case sensitive collation in MSSQL, issue #416 (thanks @karpikpl)
  • Fix missing autoIncrement attribute due to schema clash, issue #419 (thanks @marcelopc)
  • BREAKING CHANGE Separate options for controlling case of output objects: caseModel, caseFile, caseProp, issue #413
  • Remove eslint from model generation, move into generate test, issue #425
  • Remove test files from npm package, using "files" option instead of .npmignore, issue #418

[0.5.3] - 2020-07-21

  • Fix filtering by tables|skipTables broken in 0.5.1, issue #409
  • Improve validation of command-line arguments -c,-a, issue #146 #213 #241
  • Fix travis build

[0.5.2] - 2020-07-16

  • Fix quotes in comments, #190
  • Fix defaultValue for boolean and number types, #225 and #386
  • Fix default value for CURRENT_TIMESTAMP and mssql functions
  • Fix unique attribute, #169
  • Fix autoIncrement for sqlite, #209

[0.5.1] - 2020-07-10

  • Fix export default in esm output (thanks @vykuntaharsha)
  • Fix missing comma after autoIncrement
  • Don't output comment if empty
  • Add hasTrigger support #217 (thanks @joaoe)
  • Fix check constraints when gathering foreign key info for mssql (thanks @joaoe)
  • Fix mysql views generation #354 (thanks @joaoe)
  • Fix schema support, #348 #350 (thanks @joaoe and @dlredden)
  • Add tests for cross-schema foreign keys (thanks @dlredden)
  • Add tests for snake_case table names -> UpperCamelCase model names

[0.5.0] - 2020-07-03

  • Add UpperCamelCase option (thanks @marshalys)
  • Document existing camelCase option (thanks @murfett-au)
  • Fix postgres dialect foreign key query to support Postgres 12
  • Update compatibility to Sequelize v5 & v6 (thanks @createthis @mrbichel @naren7229)
  • Fix "c.extra" in mysql foreign keys query (thanks @bkolla-ft and @jeongjuwon)
  • Fix support for double type (thanks @wen911119)
  • Add support for closeConnectionAutomatically (thanks @allnulled)
  • Fix schema name join in mysql foreign keys query (thanks @yujunlong2000)
  • Add schema to generated files (thanks @THAlpha)
  • Add arg "l", output language, values es5|es6|esm|ts (thanks @threem0126)
  • Add HSTORE data type (thanks @roytz)
  • Fix tedious warnings for trustServerCertificate and enableArithAbort
  • Fix support for mssql: nchar, nvarchar, money, varbinary types

[0.4.29] - 2017-10-23

Fixed

  • Sets DATEONLY for DATE types
  • Fix typescript, add missing option for camelcase filenames...
  • Fixes JSONB support
  • Fixes TIMESTAMP support

[0.4.28] - 2017-04-22

Fixed

  • Fixes for timestamps fields
  • Fixes current_time code error

[0.4.27] - 2017-04-05

Fixed

  • Fixes schema support

[0.4.26] - 2017-04-05

Fixed

  • The defaultValue is now escape'd
  • Boolean/Bit columns are now fixed for MSSQL

Added

  • Adds schema support for postgres with the s flag.

[0.4.25] - 2017-03-20

Added

  • Adds unique support for postgres, mysql, and mariadb.

Fixed

  • Fixes foreign key and unique columns.

[0.4.24] - 2017-03-20

Added

  • Adds support for UNSIGNED and ZEROFILL MySQL columns.

[0.4.23] - 2017-03-20

Fixed

  • Adds schema support for postgres databases.
  • Directory output is now fixed for commands containing a config file as well.
  • Default port number has been added for postgres.
  • Mssql should now properly identify auto increment and foreign key columns.

[0.4.22] - 2017-03-20

Fixed

  • Sqlite will now properly set the storage option to the database value if no storage option is set.