public void Sample1()
{
var context = new BigQuery.Linq.BigQueryContext();
var query1 = context.From <Wikipedia>()
.Where(x => x.wp_namespace == 0)
.Select(x => new
{
x.title,
hash_value = BqFunc.Hash(x.title),
included_in_sample = (BqFunc.Abs(BqFunc.Hash(x.title)) % 2 == 1)
? "True"
: "False"
})
.Limit(5)
.ToString();
query1.Is(@"
SELECT
[title],
HASH([title]) AS [hash_value],
IF(((ABS(HASH([title])) % 2) = 1), 'True', 'False') AS [included_in_sample]
FROM
[publicdata:samples.wikipedia]
WHERE
([wp_namespace] = 0)
LIMIT 5".TrimStart());
}
public void Between()
{
var context = new BigQueryContext();
var x = 1000;
context.Select <bool>(() => BqFunc.Between(x, BqFunc.Abs(10), 100)).ToFlatSql()
.Is("SELECT (1000 BETWEEN ABS(10) AND 100)");
}
public void DirectSelect()
{
var context = new BigQuery.Linq.BigQueryContext();
var s = context.Select(() => new
{
A = "aaa",
B = BqFunc.Abs(-5),
FROM = 100,
}).ToString().TrimEnd();
s.Is(@"SELECT
'aaa' AS [A],
ABS(-5) AS [B],
100 AS [FROM]");
}
public void Abs()
{
Ctx.Select(() => BqFunc.Abs(-100L)).ToFlatSql().Is("SELECT ABS(-100)");
Ctx.Select(() => BqFunc.Abs(-100.5)).ToFlatSql().Is("SELECT ABS(-100.5)");
}
