neuralib.sqlp.stat.SqlSelectStat

class neuralib.sqlp.stat.SqlSelectStat[source]

Bases: SqlStat[T], SqlWhereStat, SqlLimitStat, Generic[T]

SELECT statement.

__init__(table)[source]

Methods

`__init__`(table)
`add`(stat)	Add SQL token.
`build`()	build a SQL statement.
`drop`()
`except_`(stat)	`EXCEPT` https://www.sqlite.org/lang_select.html#compound_select_statements
`fetch_polars`()	submit and fetch all as a polar dataframe.
`fetchall`()	submit and fetch all result.
`fetchone`()	submit and fetch the first result.
`group_by`(*by)	`GROUP BY` https://www.sqlite.org/lang_select.html#resultset
`having`(*exprs)	`HAVING` https://www.sqlite.org/lang_select.html#resultset
`intersect`(stat)	`INTERSECT` https://www.sqlite.org/lang_select.html#compound_select_statements
`join`()	`JOIN` https://www.sqlite.org/lang_select.html#strange_join_names
`limit`(*args)	`LIMIT`: https://www.sqlite.org/lang_select.html#limitoffset
`order_by`(*by)	`ORDER BY`: https://www.sqlite.org/lang_select.html#orderby
`submit`()	build the SQL statement and execute.
`union`(stat[, all])	`UNION` https://www.sqlite.org/lang_select.html#compound_select_statements
`where`(*expr)	`WHERE` clause: https://www.sqlite.org/lang_select.html#whereclause
`windows`(windows, *window_ks)	define windows.

Attributes

`BY`	alias of `Literal`['left', 'right', 'inner', 'full outer', 'cross']

__init__(table)[source]

submit and fetch all result.

submit and fetch the first result.

fetch_polars()[source]

submit and fetch all as a polar dataframe.

windows(*windows, **window_ks)[source]

define windows.

Parameters:

Return type:

Self

join(constraint: Callable | ForeignConstraint, *, by: BY = None) → SqlSelectStat[tuple][source]

join(table: type[S] | SqlAlias[S], constraint: Callable | ForeignConstraint, *, by: BY = None) → SqlSelectStat[tuple]

join(table: type[S] | SqlSelectStat[S] | SqlAlias[S] | SqlCteExpr, *field: bool | Any, by: BY = None) → SqlSelectStat[tuple]

join(*field: bool | Any, by: BY = None) → SqlSelectStat[tuple]

>>> select_from(A.a, B.b).join(A.a == B.a) 
SELECT A.a, B.b FROM A
JOIN B ON A.a = B.a

group_by(*by)[source]

having(*exprs)[source]

intersect(stat)[source]

union(stat, all=False)[source]

except_(stat)[source]