Class With.Default

java.lang.Object
org.huiche.core.ast.Segment.Default
org.huiche.ast.statement.clause.With.Default
All Implemented Interfaces:
Serializable, WithAsOperable, WithOperable, With, Segment
Enclosing interface:
With
public static class With.Default extends Segment.Default implements With, WithAsOperable
With默认实现
Author:
Maning
See Also:

  • Method Details

    • as

      public With as(QueryExpr queryExpr)
      Description copied from interface: WithAsOperable
      cte as操作
      Specified by:
      as in interface WithAsOperable
      Parameters:
      queryExpr - 查询
      Returns:
      CTE

    • columns

      public List<String[]> columns()
      Description copied from interface: With
      CTE列别名
      Specified by:
      columns in interface With
      Returns:
      列别名

    • delete

      public Delete delete(Table table)
      Description copied from interface: With
      根据CTE创建删除语句
      Specified by:
      delete in interface With
      Parameters:
      table - 表
      Returns:
      删除语句

    • insert

      public Insert insert(Table table)
      Description copied from interface: With
      根据CTE创建插入语句
      Specified by:
      insert in interface With
      Parameters:
      table - 表
      Returns:
      插入语句

    • names

      public List<String> names()
      Description copied from interface: With
      CTE 名称
      Specified by:
      names in interface With
      Returns:
      名称

    • queries

      public List<QueryExpr> queries()
      Description copied from interface: With
      CTE查询
      Specified by:
      queries in interface With
      Returns:
      CTE查询

    • recursive

      public boolean recursive()
      Description copied from interface: With
      是否递归
      Specified by:
      recursive in interface With
      Returns:
      是否递归

    • select

      public Select select(List<?> selects)
      Description copied from interface: With
      根据CTE创建查询语句
      Specified by:
      select in interface With
      Parameters:
      selects - 查询列
      Returns:
      查询语句

    • select

      public Select select(Object... selects)
      Description copied from interface: With
      根据CTE创建查询语句
      Specified by:
      select in interface With
      Parameters:
      selects - 查询列
      Returns:
      查询语句

    • update

      public Update update(Table table)
      Description copied from interface: With
      根据CTE创建更新语句
      Specified by:
      update in interface With
      Parameters:
      table - 表
      Returns:
      更新语句

    • pseudoSql

      public String pseudoSql()
      Description copied from interface: Segment
      伪SQL,用于直接toString时显示
      Specified by:
      pseudoSql in interface Segment
      Returns:
      伪SQL

    • with

      public WithAsOperable with(String name, String... columns)
      Description copied from interface: WithOperable
      CTE表达式
      Specified by:
      with in interface WithOperable
      Parameters:
      name - 名称
      columns - 列别名
      Returns:
      CTE as 操作