SODA where子句 - 节点中的soda-js(SODA where clause - soda-js in node)
在soda-js包中 ,在src / soda-js.coffee中 ,我发现了以下内容:
# convenience functions for building where clauses, if so desired expr = and: (clauses...) -> ("(#{clause})" for clause in clauses).join(' and ') or: (clauses...) -> ("(#{clause})" for clause in clauses).join(' or ') gt: (column, literal) -> "#{column} > #{handleLiteral(literal)}" gte: (column, literal) -> "#{column} >= #{handleLiteral(literal)}" lt: (column, literal) -> "#{column} < #{handleLiteral(literal)}" lte: (column, literal) -> "#{column} <= #{handleLiteral(literal)}" eq: (column, literal) -> "#{column} = #{handleLiteral(literal)}"我有一个查询数据的功能:
function getData() { consumer.query() .withDataset('emea-ai2t') .limit(10000) .where() //what do I put here to query greater than x in a column? .getRows() .on('success', function(rows) { console.log(rows); }) .on('error', function(error) { console.error(error); }); }如何使用where便捷函数查询大于x?
仅供参考,我正在尝试查询大于某个值的浮动时间戳。
谢谢。
In the soda-js package, in src/soda-js.coffee, I found the following:
# convenience functions for building where clauses, if so desired expr = and: (clauses...) -> ("(#{clause})" for clause in clauses).join(' and ') or: (clauses...) -> ("(#{clause})" for clause in clauses).join(' or ') gt: (column, literal) -> "#{column} > #{handleLiteral(literal)}" gte: (column, literal) -> "#{column} >= #{handleLiteral(literal)}" lt: (column, literal) -> "#{column} < #{handleLiteral(literal)}" lte: (column, literal) -> "#{column} <= #{handleLiteral(literal)}" eq: (column, literal) -> "#{column} = #{handleLiteral(literal)}"I have a function to query data:
function getData() { consumer.query() .withDataset('emea-ai2t') .limit(10000) .where() //what do I put here to query greater than x in a column? .getRows() .on('success', function(rows) { console.log(rows); }) .on('error', function(error) { console.error(error); }); }How do I use the where convenience function to query for greater than x?
FYI, I'm trying to query for a floating timestamp greater than a certain value.
Thanks.
最满意答案
当然,我只是想通了。
var soda = require('soda-js'); function getData() { consumer.query() .withDataset('emea-ai2t') .limit(10000) .where(soda.expr.gt('inc_datetime', '2017-01-26T13:23:00.000')) .getRows() .on('success', function(rows) { console.log(rows); }) .on('error', function(error) { console.error(error); }); }Of course, I just figured it out.
var soda = require('soda-js'); function getData() { consumer.query() .withDataset('emea-ai2t') .limit(10000) .where(soda.expr.gt('inc_datetime', '2017-01-26T13:23:00.000')) .getRows() .on('success', function(rows) { console.log(rows); }) .on('error', function(error) { console.error(error); }); }更多推荐
发布评论