neuralib.sqlp.stat_start.create_table

neuralib.sqlp.stat_start.create_table(table, *, if_not_exists=True)

CREATE: https://www.sqlite.org/lang_createtable.html

>>> @named_tuple_table_class 
... class A(NamedTuple):
...     a: int
>>> create_table(A) 
CREATE TABLE IF NOT EXISTS A (a INT NOT NULL)

features supporting

• IF NOT EXISTS

• column constraint NOT NULL

• column constraint PRIMARY KEY

• column constraint UNIQUE

• column constraint CHECK

• column constraint DEFAULT value

• table constraint PRIMARY KEY

• table constraint UNIQUE

• table constraint CHECK

• table constraint FOREIGN KEY

features not supporting

• CREATE TEMP|TEMPORARY

• CREATE TEMP

• AS SELECT

• column constraint CONSTRAINT

• column constraint NOT NULL ON CONFLICT

• column constraint DEFAULT (EXPR)

• column constraint COLLATE

• column constraint REFERENCES

• column constraint [GENERATED ALWAYS] AS

• table constraint CONSTRAINT

• WITHOUT ROWID

• STRICT

Parameters:

table (type[T])

Returns:

Return type:

SqlStat[T]