Results of 1 - 5 of about 5 for DuckDBPyType (0.005 sec.)
- Types API 12373
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...ting a data value such as 5 follows different rules; see Python Object Conversion . Converting from Other Types Wherever a DuckDBPyType is expected, any of the options listed below can be given instead. Python Built-Ins The table below shows the mapping of P...calar Types The table below shows the mapping of NumPy scalar types to DuckDB type. A NumPy dtype object does not convert: DuckDBPyType(numpy.dtype("int32")) raises a NotImplementedException . Type DuckDB type numpy.bool_ BOOLEAN numpy.float32 FLOAT numpy.fl...ype name, such as "INTEGER" , "INT[]" , "STRUCT(a INT)" or "MAP(INT, VARCHAR)" : import duckdb from duckdb.sqltypes import DuckDBPyType print(DuckDBPyType("MAP(INT, VARCHAR)")) MAP(INTEGER, VARCHAR) A type created with CREATE TYPE exists only in its database... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Python Client API 10166
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...nd inserts, upserts, updates or deletes them in the named table at each flush array_type ( self , type : _duckdb._sqltypes.DuckDBPyType , size : int ) → _duckdb._sqltypes.DuckDBPyType Create an array type object of ‘type' begin ( self ) → _duckdb.DuckDBPyCon...nection Create a duplicate of the current connection decimal_type ( self , width : int , scale : int ) → _duckdb._sqltypes.DuckDBPyType Create a decimal type with ‘width' and ‘scale' property description Get result set attributes, mainly column names df ( se...ble_profiling ( self ) → None Disable profiling for subsequent queries dtype ( self , type_str : str ) → _duckdb._sqltypes.DuckDBPyType Create a type object by parsing the ‘type_str' string duplicate ( self ) → _duckdb.DuckDBPyConnection Create a duplicate o... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Python Function API 7831
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...pe Annotation When the function has type annotation it's often possible to leave out all of the optional parameters. Using DuckDBPyType we can implicitly convert many known types to DuckDB's type system. For example: import duckdb def my_function(x: int) ->... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- Expression API 7795
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
....alias(name: str) Applies an alias to the expression .cast(type) Applies a cast to the provided type on the expression: a DuckDBPyType , a Python type or a SQL type name such as "VARCHAR" .try_cast(type) Like .cast , but gives NULL where the cast fails .isi... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Relational API 7758
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...y, default: None Column types, as a dict of column name to type or a list of types by position; a type is a type name or a DuckDBPyType . * na_values : str, list[str], keyword-only, default: None Strings that are read as NULL . * skiprows : int, keyword-only...filtering based on type(s). Aliases : select_dtypes Parameters types : list The types of the columns to keep, as a list of DuckDBPyType values or type names such as 'VARCHAR' . Example import duckdb duckdb_conn = duckdb.connect() rel = duckdb_conn.sql(""" SE... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work