Results of 1 - 4 of about 4 for bytearray (0.003 sec.)
- Types API 11705
- 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
...ilt-Ins The table below shows the mapping of Python Built-in types to DuckDB type. Built-in types DuckDB type bool BOOLEAN bytearray BLOB bytes BLOB float DOUBLE int BIGINT str VARCHAR NumPy Scalar Types The table below shows the mapping of NumPy scalar t...e provided types. import duckdb.sqltypes from typing import Union print(duckdb.sqltypes.DuckDBPyType(Union[int, str, bool, bytearray])) print(duckdb.sqltypes.DuckDBPyType(int | str)) UNION(u1 BIGINT, u2 VARCHAR, u3 BOOLEAN, u4 BLOB) UNION(u1 BIGINT, u2 VA... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Executing SQL in Python 10244
- SQL queries can be executed using the duckdb.sql function. import duckdb duckdb.sql("SELECT 42").show() By default this will create a relation object. The result can be converted to various formats using the result conversion functions. For
...ed, together with any list, tuple or dictionary inside it. Other values are converted each time the relation is read, so a bytearray changed in place afterwards is read changed. To run the same parameterized statement for many sets of values, for example... - https://man.mtool.work/duckdb/2.0/guides/python/execute_sql.html
- Conversion between DuckDB and Python 8044
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...ng of Python object types to DuckDB Logical Types : None → NULL bool → BOOLEAN datetime.timedelta → INTERVAL str → VARCHAR bytearray → BLOB memoryview → BLOB decimal.Decimal → DECIMAL / DOUBLE / FLOAT uuid.UUID → UUID The rest of the conversion rules are... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Relational API 6953
- 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
...ied at the call, as is any list, tuple or dict inside it; the values in it are converted each time the relation runs, so a bytearray changed in place afterwards is read changed. Example import duckdb duckdb_conn = duckdb.connect() rel = duckdb_conn.sql("S... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work