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