Results of 1 - 5 of about 5 for executemany (0.003 sec.)
- Python DB API 11545
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...t property holds the number of rows that the last INSERT , UPDATE or DELETE changed, counted over all parameter sets of an executemany() call. It is -1 after a query and after a statement with a RETURNING clause. Query Parameters Pass parameter values as th...BC" binds $abc , so do not pass two keys that differ only in case. Insert a row with ? placeholders, and several rows with executemany() , which runs the statement once for each list of values: con.execute("INSERT INTO items VALUES (?, ?, ?)", ["laptop", 20...00, 1]) con.executemany("INSERT INTO items VALUES (?, ?, ?)", [["chainsaw", 500, 10], ["iphone", 300, 2]]) con.execute("SELECT item FROM items WHE... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- Executing SQL in Python 11306
- 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
...ad changed. To run the same parameterized statement for many sets of values, for example when inserting multiple rows, use executemany : con.executemany("INSERT INTO integers VALUES (?)", [[1], [2], [3]]) Afterwards, con.rowcount holds the number of inserte... - https://man.mtool.work/duckdb/2.0/guides/python/execute_sql.html
- Appender 7997
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...olumns. append_row takes one value per column, and append_rows takes any iterable of rows. Values are converted exactly as executemany parameters are. To append to some of the columns, list them in columns . The other columns take their default value, per r... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- Conversion between DuckDB and Python 7537
- 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
...ct Conversion: Python Object to DuckDB Python objects are converted when they are passed as query parameters ( execute() , executemany() and sql(..., params=...) ), as rows of values() , as constants in expressions and as the value of a duckdb.Value . The r... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Python Client API 7537
- 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
...ers set. A query runs until its first rows are ready, so an error there raises here; every other statement runs to its end executemany ( self , query : object , parameters : object | None = None ) → _duckdb.DuckDBPyConnection Execute the given prepared stat...A query runs until its first rows are ready, so an error there raises here; every other statement runs to its end duckdb. executemany ( query : object , parameters : object | None = None , * , connection : _duckdb.DuckDBPyConnection | None = None ) → _duck... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work