NeuraLib

Atlas

  • Atlas

Imaging

  • Imaging

Other

  • Other

Utility

  • Utility

API Reference

  • neuralib core module
  • neuralib utility module
    • neuralib.argp
    • neuralib.persistence
    • neuralib.sqlp
      • neuralib.sqlp.annotation
      • neuralib.sqlp.cli
      • neuralib.sqlp.connection
      • neuralib.sqlp.dot
      • neuralib.sqlp.expr
      • neuralib.sqlp.func
      • neuralib.sqlp.func_date
      • neuralib.sqlp.func_dec
      • neuralib.sqlp.func_stat
        • neuralib.sqlp.func_stat.TRUE
        • neuralib.sqlp.func_stat.FALSE
        • neuralib.sqlp.func_stat.NULL
        • neuralib.sqlp.func_stat.ROWID
        • neuralib.sqlp.func_stat.literal
        • neuralib.sqlp.func_stat.wrap
        • neuralib.sqlp.func_stat.alias
        • neuralib.sqlp.func_stat.cast
        • neuralib.sqlp.func_stat.case
        • neuralib.sqlp.func_stat.exists
        • neuralib.sqlp.func_stat.asc
        • neuralib.sqlp.func_stat.desc
        • neuralib.sqlp.func_stat.nulls_first
        • neuralib.sqlp.func_stat.nulls_last
        • neuralib.sqlp.func_stat.concat
        • neuralib.sqlp.func_stat.and_
        • neuralib.sqlp.func_stat.or_
        • neuralib.sqlp.func_stat.like
        • neuralib.sqlp.func_stat.not_like
        • neuralib.sqlp.func_stat.glob
        • neuralib.sqlp.func_stat.contains
        • neuralib.sqlp.func_stat.not_contains
        • neuralib.sqlp.func_stat.between
        • neuralib.sqlp.func_stat.not_between
        • neuralib.sqlp.func_stat.is_null
        • neuralib.sqlp.func_stat.is_not_null
        • neuralib.sqlp.func_stat.excluded
        • neuralib.sqlp.func_stat.with_common_table
        • neuralib.sqlp.func_stat.fields
      • neuralib.sqlp.func_win
      • neuralib.sqlp.literal
      • neuralib.sqlp.stat
      • neuralib.sqlp.stat_start
      • neuralib.sqlp.table
      • neuralib.sqlp.table_nt
      • neuralib.sqlp.util
    • neuralib.dashboard
    • neuralib.plot
    • neuralib.imglib
    • neuralib.io
    • neuralib.tools
    • neuralib.typing
    • neuralib.util

Roadmap

  • Roadmap
NeuraLib
  • neuralib core module
  • neuralib.sqlp
  • neuralib.sqlp.func_stat
  • Edit on GitHub

neuralib.sqlp.func_stat

TRUE

FALSE

NULL

ROWID

literal

wrap

wrap x as an SQL expression.

alias

cast

case

https://www.sqlite.org/lang_expr.html#the_case_expression

exists

https://www.sqlite.org/lang_expr.html#the_exists_operator

asc

ascending ordering Used by ORDER BY.

desc

descending ordering used by ORDER BY.

nulls_first

order null first used by ORDER BY.

nulls_last

order null last used by ORDER BY.

concat

concatenate strings.

and_

"AND" SQL expressions.

or_

"OR" SQL expressions.

like

not_like

glob

contains

not_contains

between

https://www.sqlite.org/lang_expr.html#the_between_operator

not_between

https://www.sqlite.org/lang_expr.html#the_between_operator

is_null

is_not_null

excluded

https://www.sqlite.org/lang_upsert.html

with_common_table

fields

Previous Next

© Copyright 2024, Yu-Ting Wei.

Built with Sphinx using a theme provided by Read the Docs.