SODA where子句

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); }); }