- 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
- 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)
- 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)
- 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)
- 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)
- 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 ofdate
(#469) (thanks @JonathanWolfe)
- 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 ofany
(#454) (thanks @mat813) - Fix postgres enum types broken in 0.7.2 (#455)
- 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)
- Fix autoIncrement for non-key fields in Postgres (#446 and #448)
- Remove obsolete dependencies
async
andgraceful-fs-extra
- 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)
- Fix
foreignKey
property inbelongsTo
(#369) - Add
belongsToMany
when junction has 2 foreign keys that are also primary keys (#34)
- 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)
- Fix "Assignment to constant" error introduced in 0.6.6 (#440) (thanks @xuezier)
- Add support for generating models from views,
--views
option (#77)
- 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)
- Escape special chars in table comments (#439)
- Map mysql longtext/mediumtext/tinytext to DataTypes.TEXT
- Export SequelizeAuto types in npm package (#140)
- 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
- Fix TypeScript generation (thanks @sschwenker)
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Sets DATEONLY for DATE types
- Fix typescript, add missing option for camelcase filenames...
- Fixes JSONB support
- Fixes TIMESTAMP support
- Fixes for timestamps fields
- Fixes current_time code error
- Fixes schema support
- The defaultValue is now escape'd
- Boolean/Bit columns are now fixed for MSSQL
- Adds schema support for
postgres
with thes
flag.
- Adds
unique
support forpostgres
,mysql
, andmariadb
.
- Fixes
foreign key
andunique
columns.
- Adds support for
UNSIGNED
andZEROFILL
MySQL columns.
- 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
andforeign key
columns.
- Sqlite will now properly set the
storage
option to thedatabase
value if nostorage
option is set.