node.js - 麻烦看下这段sequelize(ORM)代码,有SQL?
大家讲道理
大家讲道理 2017-04-17 14:28:17
[Node.js讨论组]
这是ORM代码

models.User.findAndCountAll({
    include: [{
        model: models.Role,
        through: {
            attributes: ['id', ['name', 'rolename'], 'desc']
        }
    }],
    attributes: ['id', ['name', 'username']],
    raw: true,
    limit: 20,
    offset: 0
});

这是SQL

SELECT count(*) AS "count" FROM "User" AS "user";

SELECT "user".*, 
"roles"."id" AS "roles.id", 
"roles"."name" AS "roles.name", 
"roles"."desc" AS "roles.desc", 
"roles"."create_by" AS "roles.create_by", 
"roles"."createdAt" AS "roles.createdAt", 
"roles"."updatedAt" AS "roles.updatedAt", "roles.userRole"."createdAt" AS "roles.userRole.createdAt", "roles.userRole"."updatedAt" AS "roles.userRole.updatedAt", "roles.userRole"."userId" AS "roles.userRole.userId", "roles.userRole"."roleId" AS "roles.userRole.roleId" FROM (SELECT "user"."id", 
"user"."name" AS "username" FROM "User" AS "user" LIMIT 20 OFFSET 0) 
AS "user" LEFT OUTER JOIN 
("UserRole" AS "roles.userRole" INNER JOIN "Role" AS "roles" ON "roles"."id" = "roles.userRole"."roleId") 
ON "user"."id" = "roles.userRole"."userId"

查询role表后,却没有执行attributes里的过滤条件

大家讲道理
大家讲道理

光阴似箭催人老,日月如移越少年。

全部回复(0)
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新 English
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号