如何从sequelize生成的查询中删除双引号 [英] How to remove double quotes from sequelize generated query

问题描述

Is it possible to remove double quotes from generated query in Sequelize from ranking column?

db.leaderboard.findAll({
            attributes: ['user_id', ['amt_agg', 'amount'], ['dist_agg', 'distance'],
            [sequelize.col('row_number() OVER (ORDER BY (dist_agg) DESC)'),'ranking' ]]
        })

Generated output of above code:-

SELECT "user_id","amt_agg" AS "amount","dist_agg" AS "distance", "row_number() OVER (ORDER BY (dist_agg) DESC)" AS "ranking" FROM "leaderboard" AS "leaderboard";

What I have tried:

Everything is working fine if I remove double quotes(") from ranking column in generated output.

推荐答案

使用Model.ranking



模型是模型的名称，例如

var Model = models.size

Use Model.ranking

Model is the name of model for example
var Model = models.size

这篇关于如何从sequelize生成的查询中删除双引号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！