发布于 2015-05-19 00:19:55 | 230 次阅读 | 评论: 0 | 来源: 网友投递
Sequelize Node.js的ORM 框架
Sequelize.js 提供对 MySQL，MariaDB，SQLite 和 PostgreSQL 数据库的简单访问，通过映射数据库条目到对象，或者对象到数据库条目。简而言之，就是 ORM（Object-Relational-Mapper）。Sequelize.js 完全是使用 JavaScript 编写，适用于 Node.js 的环境。
Sequelize.js 3.0.0 发布，此版本清理了废弃的代码，更好的维护和开发。
主要更新内容如下：
[ADDED] findById / findByPrimary takes a single value as argument representing the primary key to find.
[CHANGED] belongsToMany relations MUST now be given a through argument.
[CHANGED] findOne / findAll / findAndCount / findOrCreate now only takes a single options argument instead of a options and queryOptions argument. So set transaction, raw, etc on the first options argument.
[CHANGED] The accessor for belongsToMany relationships is now either the as argument or the target model name pluralized.
[REMOVED] N:M relationships can no longer be represented by 2 x hasMany
[REMOVED] Model.create / Model.bulkCreate / Instance.save no longer takes an array of fields as its second argument, use options.fields instead.
[REMOVED] Query Chainer has been removed
[REMOVED] Migrations have been removed, use umzug instead
[REMOVED] Model.findAllJoin has been removed
[REMOVED] sequelize.query now only takes sql and options as arguments, the second and fourth argument callee and replacements have been removed and should be set via options.instance / options.model and options.replacements instead.
[REMOVED] instance.isDirty has been removed, use instance.changed() instead
[REMOVED] instance.values has been removed, use instance.get() instead
[REMOVED] instance.primaryKeyValues has been removed.
[REMOVED] instance.identifiers has been removed, use instance.where() instead
[REMOVED] instance.isDeleted has been removed, simply check the timestamp with get('deletedAt') instead
[REMOVED] instance.increment/decrement now longer takes a number as it's second argument.
[REMOVED/SECURITY] findOne no longer takes a string / integer / binary argument to represent a primaryKey. Use findById instead
[REMOVED/SECURITY] where: "raw query" is no longer legal, you must now explicitely use where: ["raw query", [replacements]]
[BUG] Fix showIndexQuery so appropriate indexes are returned when a schema is used
[BUG] Fix addIndexQuery error when the model has a schema
[BUG] Fix app crash in sqlite while running in special unique constraint errors #3730
[BUG] Fix bulkCreate: do not insert NULL for undefined values #3729
[BUG] Fix trying to roll back a comitted transaction if an error occured while comitting resulting in an unhandled rejection #3726
[BUG] Fix regression in beforeUpdate hook where instance.changed() would always be false #3727
[BUG] Fix trying to roll back a comitted transaction if an error occured while comitting
Most of the changes in 3.0.0 are BC breaking, read the changelog for 3.0.0 carefully.
The error that is thrown when a column is declared to be an enum but without any values used to "Values for ENUM haven't been defined" and is now "Values for ENUM have not been defined".
此版本现已提供下载：https://github.com/sequelize/sequelize/archive/v3.0.0.zip。
Sequelize.js 提供对 MySQL，MariaDB，SQLite 和 PostgreSQL 数据库的简单访问，通过映射数据库条目到对象，或者对象到数据库条目。简而言之，就是 ORM（Object-Relational-Mapper）。Sequelize.js 完全是使用 JavaScript 编写，适用于 Node.js 的环境。