# std/parsesql

Dark Mode

- Manual
- Standard library
- Index
- Compiler docs
- Fusion docs
- devel, stable

Search:
Source Edit

The `parsesql` module implements a high performance SQL file parser. It parses PostgreSQL syntax and the SQL ANSI standard.

Unstable API.

# Imports

strutils, lexbase, decode_helpers, streams

# Types

    SqlLexer = object of BaseLexer
      filename: string

  the parser object. Source Edit

    SqlNode = ref SqlNodeObj

  an SQL abstract syntax tree node Source Edit

    SqlNodeKind = enum
      nkNone, nkIdent, nkQuotedIdent, nkStringLit, nkBitStringLit, nkHexStringLit,
      nkIntegerLit, nkNumericLit, nkPrimaryKey, nkForeignKey, nkNotNull, nkNull,
      nkStmtList, nkDot, nkDotDot, nkPrefix, nkInfix, nkCall, nkPrGroup,
      nkColumnReference, nkReferences, nkDefault, nkCheck, nkConstraint, nkUnique,
      nkIdentity, nkColumnDef,  ## name, datatype, constraints
      nkInsert, nkUpdate, nkDelete, nkSelect, nkSelectDistinct, nkSelectColumns,
      nkSelectPair, nkAsgn, nkFrom, nkFromItemPair, nkGroup, nkLimit, nkHaving,
      nkOrder, nkJoin, nkDesc, nkUnion, nkIntersect, nkExcept, nkColumnList,
      nkValueList, nkWhere, nkCreateTable, nkCreateTableIfNotExists, nkCreateType,
      nkCreateTypeIfNotExists, nkCreateIndex, nkCreateIndexIfNotExists, nkEnumDef

  kind of SQL abstract syntax tree Source Edit

    SqlNodeObj = object
      case kind*: SqlNodeKind    ## kind of syntax tree
      of LiteralNodes:
          strVal*: string        ## AST leaf: the identifier, numeric literal
                                 ## string literal, etc.

      else:
          sons*: seq[SqlNode]    ## the node's children

  an SQL abstract syntax tree node Source Edit

    SqlParseError = object of ValueError

  Invalid SQL encountered Source Edit

    SqlParser = object of SqlLexer
      tok: Token

  SQL parser object Source Edit

# Procs

    proc `$`(n: SqlNode): string {....raises: [Exception], tags: [RootEffect].}

  an alias for `renderSql`. Source Edit

    proc `[]`(n: SqlNode; i: BackwardsIndex): SqlNode {....raises: [], tags: [].}

  Source Edit

    proc `[]`(n: SqlNode; i: int): SqlNode {....raises: [], tags: [].}

  Source Edit

    proc add(father, n: SqlNode) {....raises: [], tags: [].}

  Source Edit

    proc len(n: SqlNode): int {....raises: [], tags: [].}

  Source Edit

    proc newNode(k: SqlNodeKind): SqlNode {....raises: [], tags: [].}

  Source Edit

    proc newNode(k: SqlNodeKind; s: string): SqlNode {....raises: [], tags: [].}

  Source Edit

    proc newNode(k: SqlNodeKind; sons: seq[SqlNode]): SqlNode {....raises: [], tags: [].}

  Source Edit

    proc parseSql(input: Stream; filename: string): SqlNode {....raises: [IOError,
        OSError, IOError, OSError, ValueError, SqlParseError, Exception],
        tags: [ReadIOEffect, RootEffect, WriteIOEffect].}

  parses the SQL from `input` into an AST and returns the AST. `filename` is only used for error messages. Syntax errors raise an `SqlParseError` exception. Source Edit

    proc parseSql(input: string; filename = ""): SqlNode {.
        ...raises: [IOError, OSError, ValueError, SqlParseError, Exception],
        tags: [ReadIOEffect, RootEffect, WriteIOEffect].}

  parses the SQL from `input` into an AST and returns the AST. `filename` is only used for error messages. Syntax errors raise an `SqlParseError` exception. Source Edit

    proc renderSql(n: SqlNode; upperCase = false): string {....raises: [Exception],
        tags: [RootEffect].}

  Converts an SQL abstract syntax tree to its string representation. Source Edit

    proc treeRepr(s: SqlNode): string {....raises: [], tags: [].}

  Source Edit