blocks|key|3590847|text|我认为你可以，因为赛尔斯天生就有sequelize。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3590848|您可以阅读Mike+McNeil's+answer+here，也许可以直接问Mike是否会重新引入sequelize支持|offset|length|3590849|entityMap|0|LINK|mutability|MUTABLE|url|https://groups.google.com/forum/#!msg/sailsjs/jmR36bD-Zys/-F0ZFy1Q1IoJ^0|0|5|P|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I think you can as sails was born with sequelize.

You can read <a href="https://groups.google.com/forum/#!msg/sailsjs/jmR36bD-Zys/-F0ZFy1Q1IoJ" rel="nofollow">Mike McNeil's answer here</a> and maybe ask Mike directly if he will reintroduce sequelize support

blocks|key|5704810|text|最近有两个项目，我一直在努力重新引入对sequelize的全面支持，包括蓝图。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5704811|sails-hook-sequelize|5704812|船帆-钩子-续集-蓝图|5704813|See+my+answer|offset|length|5704814|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/31768186/3683121^0|0|0|0|0|D|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

There are two project that come out recently that i've have worked to reintroduce full support to sequelize, including blueprints.

sails-hook-sequelize

sails-hook-sequelize-blueprints

<a href="https://stackoverflow.com/a/31768186/3683121">See my answer</a>

blocks|key|2415703|text|$+npm+install+sails-hook-sequelize
$+npm+install+sails-hook-sequelize-blueprints
$+npm+install+sequelize
$+npm+install+pg+pg-hstore
$+npm+install+continuation-local-storage|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2415704|.sailsrc|unstyled|2415705|"hooks":+{
++++"blueprints":+false,
++++"orm":+false,
++++"pubsub":+false
}|2415706|在connections.js中|2415707|somePostgresqlServer:+{
++++user:+'postgres',
++++password:+'',
++++database:+'database',
++++options:+{
++++++++host+++:+'localhost',
++++++++port+++:+5432,
++++++++logging:+true
+++}
}|2415708|在模型文件夹中|2415709|//以userstable+->users.js为例|2415710|module.exports+=+{
++attributes:+{
++++firstname:+{
++++++type:+Sequelize.STRING,
++++++allowNull:+false
++++},
++++secondname:+{
++++++type:+Sequelize.STRING,
++++++allowNull:+false
++++},
++}

++}
};|2415711|或连接创建分离文件db.js的另一种方法|2415712|+++module.exports+=+{
+dbPath:+function+()+{
++return+("postgres://postgres:(user)@localhost:5432/(databasename)");
+}
}|2415713|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$B|C]]|$1|M|3|N|5|F|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$B|C]]|$1|S|3|T|5|F|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$B|C]]|$1|W|3|-4|5|F|7|18|8|@]|9|@]|A|$]]]|X|$]]

<pre><code>$ npm install sails-hook-sequelize
$ npm install sails-hook-sequelize-blueprints
$ npm install sequelize
$ npm install pg pg-hstore
$ npm install continuation-local-storage
</code></pre>

.sailsrc

<pre><code>"hooks": {
 "blueprints": false,
 "orm": false,
 "pubsub": false
}
</code></pre>

In connections.js

<pre><code>somePostgresqlServer: {
 user: 'postgres',
 password: '',
 database: 'database',
 options: {
 host : 'localhost',
 port : 5432,
 logging: true
 }
}
</code></pre>

In model folder 

// for example let take userstable ->users.js

<pre><code>module.exports = {
 attributes: {
 firstname: {
 type: Sequelize.STRING,
 allowNull: false
 },
 secondname: {
 type: Sequelize.STRING,
 allowNull: false
 },
 }

 }
};
</code></pre>

or another method for connection create seperate file db.js

<pre><code> module.exports = {
 dbPath: function () {
 return ("postgres://postgres:(user)@localhost:5432/(databasename)");
 }
}
</code></pre>

blocks|key|504680|text|首先你必须安装所有的pakage+sails-hook-sequelize：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|504681|npm+install+sails-hook-sequelize+--save|code-block|syntax|javascript|504682|秒编辑文件.sailsrc|504683|+"hooks":+{
++"orm":+false,
++"pubsub":+false
}|504684|文件./config/models.js|504685|module.exports.models+=+{
++++schema:+true,
++++connection:+'mysql',
++++migrate:+'safe'
};|504686|文件./config/connections.js|504687|module.exports.connections+=+{
+++mysql:+{
++++++++adapter:+'sails-mysql',
++++++++port:+3306,
++++++++user:+'root',
++++++++password:+'123456',
++++++++database:+'TestDataBase',
++++++++charset:+'utf8',
++++++++collation:+'utf8-general_ci',
++++++++options:+{
++++++++++++host:+'localhost'
++++++++}
++++}
};|504688|在./api/model/UserAccount.js中定义模型|504689|module.exports+=+{
++++attributes:+{
++++++++ID:+{
++++++++++++type:+Sequelize.BIGINT(20),
++++++++++++autoIncrement:+true,
++++++++++++allowNull:+false,
++++++++++++primaryKey:+true
++++++++},
++++++++UID:+{
++++++++++++type:+Sequelize.STRING(255),
++++++++++++allowNull:+false,
++++++++++++defaultValue:+Sequelize.UUIDV4,
++++++++},
++++++++UserName:+{
++++++++++++type:+Sequelize.STRING(50),
++++++++++++allowNull:+true
++++++++}
++++},
++++associations:+function()+{},
++++options:+{
++++++++tableName:+'UserAccount',
++++++++createdAt:+'CreatedDate',
++++++++updatedAt:+'ModifiedDate',
++++++++hooks:+{}
}
};|504690|最后，使用模型：|504691|UserAccount.findAll({}).then(function(success){},+function(err){
})|504692|祝你好运%5E%5E。|504693|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1D|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1F|8|@]|9|@]|A|$E|F]]|$1|10|3|11|5|6|7|1G|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|13|$]]

First you must intsall pakage sails-hook-sequelize:

<pre><code>npm install sails-hook-sequelize --save
</code></pre>

Seconds edit file .sailsrc

<pre><code> "hooks": {
 "orm": false,
 "pubsub": false
}
</code></pre>

file ./config/models.js

<pre><code>module.exports.models = {
 schema: true,
 connection: 'mysql',
 migrate: 'safe'
};
</code></pre>

file ./config/connections.js

<pre><code>module.exports.connections = {
 mysql: {
 adapter: 'sails-mysql',
 port: 3306,
 user: 'root',
 password: '123456',
 database: 'TestDataBase',
 charset: 'utf8',
 collation: 'utf8-general_ci',
 options: {
 host: 'localhost'
 }
 }
};
</code></pre>

define models in ./api/models/UserAccount.js

<pre><code>module.exports = {
 attributes: {
 ID: {
 type: Sequelize.BIGINT(20),
 autoIncrement: true,
 allowNull: false,
 primaryKey: true
 },
 UID: {
 type: Sequelize.STRING(255),
 allowNull: false,
 defaultValue: Sequelize.UUIDV4,
 },
 UserName: {
 type: Sequelize.STRING(50),
 allowNull: true
 }
 },
 associations: function() {},
 options: {
 tableName: 'UserAccount',
 createdAt: 'CreatedDate',
 updatedAt: 'ModifiedDate',
 hooks: {}
}
};
</code></pre>

Final, use model: 

<pre><code>UserAccount.findAll({}).then(function(success){}, function(err){
})
</code></pre>

Good luck ^^.

I'm learning Node.js and Sails is my framework of choice.
I want to use it in a project with MySql db and I think that Sequelize Orm is more complete.
How can I use Sequelize Orm in Sails instead of Waterline?

Thanks

Sails js and Sequelize

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在学习Node.js和Sails是我选择的框架。我想在一个带有Orm数据库的项目中使用它，我认为Sequelize MySql更完整。如何在Sails而不是Waterline中使用Sequelize Orm？谢谢

问Sails js和Sequelize
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Sails js和SequelizeEN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Sails js和Sequelize
EN