yumemi - v0.11.2

framework/query

Query shape. Entity-specific From, Field, Arrow, phase and key words are generated.

Types

Agg

</> 
pub type Agg(field) {
  Count
  Sum(field)
  Min(field)
  Max(field)
  Avg(field)
}

Constructors 

  • Count
  • Sum(field)
  • Min(field)
  • Max(field)
  • Avg(field)

Along

</> 
pub type Along(aggregate, group) {
  Distance
  Rank(per: option.Option(group))
  Running(aggregate, per: option.Option(group))
}

Constructors

Cond

</> 
pub type Cond(field, arrow, operand) {
  CurrentVersion(field, field)
  Eq(field, operand)
  Ne(field, operand)
  Lt(field, operand)
  Le(field, operand)
  Gt(field, operand)
  Ge(field, operand)
  In(field, operand)
  Contains(field, operand)
  IsNull(field)
  NotNull(field)
  IsTrue(field)
  EqOrNull(field, operand)
  Has(arrow, List(Cond(field, arrow, operand)))
  HasNone(arrow, List(Cond(field, arrow, operand)))
}

Constructors 

  • CurrentVersion(field, field)
  • Eq(field, operand)
  • Ne(field, operand)
  • Lt(field, operand)
  • Le(field, operand)
  • Gt(field, operand)
  • Ge(field, operand)
  • In(field, operand)
  • Contains(field, operand)
  • IsNull(field)
  • NotNull(field)
  • IsTrue(field)

    真偽の列。Operand に真偽の構成子が無いので、これが唯一の綴り。

  • EqOrNull(field, operand)

    穴が NULL のときは「NULL と一致」。Eq では NULL に当たらない。

  • Has(arrow, List(Cond(field, arrow, operand)))
  • HasNone(arrow, List(Cond(field, arrow, operand)))

CondAgg

</> 
pub type CondAgg(aggregate, operand) {
  AggGt(aggregate, operand)
  AggGe(aggregate, operand)
  AggLt(aggregate, operand)
  AggLe(aggregate, operand)
  AggEq(aggregate, operand)
}

Constructors 

  • AggGt(aggregate, operand)
  • AggGe(aggregate, operand)
  • AggLt(aggregate, operand)
  • AggLe(aggregate, operand)
  • AggEq(aggregate, operand)

Group

</> 
pub type Group(field, arrow) {
  ByField(field)
  Bucket(field, Unit)
  Via(arrow)
}

Constructors 

  • ByField(field)
  • Bucket(field, Unit)
  • Via(arrow)

Limit

</> 
pub type Limit(operand, group) {
  NoLimit
  Paged(size: operand, after: operand)
  First(Int)
  FirstPerGroup(Int, group)
}

Constructors 

  • NoLimit
  • Paged(size: operand, after: operand)
  • First(Int)
  • FirstPerGroup(Int, group)

Operand

</> 
pub type Operand(parameter, field, value) {
  Param(parameter)
  Num(Int)
  Str(String)
  At(value)
  Col(field)
}

Constructors 

  • Param(parameter)
  • Num(Int)
  • Str(String)
  • At(value)
  • Col(field)

Order

</> 
pub type Order(field, aggregate, operand) {
  Nearest(field, operand)
  Asc(field)
  Desc(field)
  AscAgg(aggregate)
  DescAgg(aggregate)
}

Constructors 

  • Nearest(field, operand)
  • Asc(field)
  • Desc(field)
  • AscAgg(aggregate)
  • DescAgg(aggregate)

Select

</>

Pick は返す列を選ぶ口。select は Select を直に書き、行は選んだ列の record になる。 columns に with の子の列を混ぜると、その子も選んだ列だけの record になる。 書かなければ(Select のまま)従来どおり全列。

pub type Select(from, field, arrow, cond, group, cond_agg, agg, along, order, limit) {
  Select(
    from: from,
    join: List(arrow),
    where: List(cond),
    group: List(group),
    having: List(cond_agg),
    agg: List(agg),
    along: List(along),
    with: List(arrow),
    order: List(order),
    limit: limit,
  )
  Pick(
    columns: List(field),
    select: Select(
      from,
      field,
      arrow,
      cond,
      group,
      cond_agg,
      agg,
      along,
      order,
      limit,
    ),
  )
}

Constructors 

  • Select(
  from: from,
  join: List(arrow),
  where: List(cond),
  group: List(group),
  having: List(cond_agg),
  agg: List(agg),
  along: List(along),
  with: List(arrow),
  order: List(order),
  limit: limit,
)
  • Pick(
  columns: List(field),
  select: Select(
    from,
    field,
    arrow,
    cond,
    group,
    cond_agg,
    agg,
    along,
    order,
    limit,
  ),
)

Unit

</> 
pub type Unit {
  Day
  Week
  Month
}

Constructors 

  • Day
  • Week
  • Month
✨ Search Document