DuckDB v0.10.1 for Pascal

The Pascal API structure aligns with C++ DuckDB v0.10.1.

Record Connection

Description
Hierarchy
Fields
Methods
Properties

Unit

ddb

Declaration

type Connection = record

Description

Class: Connection of ddb

Overview

Fields

Public o: Pduckdb_Connection;

Methods

Public constructor FromNativePointer(ptr : Pduckdb_Connection);
Public class operator Explicit(const r: Connection): Boolean;
Public procedure AutoRelease();
Public procedure Init(arg1: DuckDB); overload;
Public procedure Init(arg1: DatabaseInstance); overload;
Public function context(): std_shared_ptr_duckdb_ClientContext; overload;
Public function GetProfilingInformation(arg2: Integer): str; overload;
Public function GetProfilingInformation(): str; overload;
Public procedure Interrupt(); overload;
Public procedure EnableProfiling(); overload;
Public procedure DisableProfiling(); overload;
Public procedure EnableQueryVerification(); overload;
Public procedure DisableQueryVerification(); overload;
Public procedure ForceParallelism(); overload;
Public function SendQuery(arg2: str): QueryResult; overload;
Public function Query(arg2: str): MaterializedQueryResult; overload;
Public function Query(arg2: SQLStatement): MaterializedQueryResult; overload;
Public function PendingQuery(arg2: str; arg3: Boolean): PendingQueryResult; overload;
Public function PendingQuery(arg2: str): PendingQueryResult; overload;
Public function PendingQuery(arg2: SQLStatement; arg3: Boolean): PendingQueryResult; overload;
Public function PendingQuery(arg2: SQLStatement): PendingQueryResult; overload;
Public function Prepare(arg2: str): PreparedStatement; overload;
Public function Prepare(arg2: SQLStatement): PreparedStatement; overload;
Public function TableInfo(arg2: str): TableDescription; overload;
Public function TableInfo(arg2: str; arg3: str): TableDescription; overload;
Public function ExtractStatements(arg2: str): duckdb_vector_duckdb_unique_ptr_duckdb_SQLStatement; overload;
Public function ExtractPlan(arg2: str): LogicalOperator; overload;
Public procedure Append(arg2: TableDescription; arg3: DataChunk); overload;
Public procedure Append(arg2: TableDescription; arg3: ColumnDataCollection); overload;
Public function Table(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function Table(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function View(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function View(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function Values(arg2: vector_vector_Value): std_shared_ptr_duckdb_Relation; overload;
Public function Values(arg2: vector_vector_Value; arg3: vector_str; arg4: str): std_shared_ptr_duckdb_Relation; overload;
Public function Values(arg2: vector_vector_Value; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Values(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function Values(arg2: str; arg3: vector_str; arg4: str): std_shared_ptr_duckdb_Relation; overload;
Public function Values(arg2: str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function ReadParquet(arg2: str; arg3: Boolean): std_shared_ptr_duckdb_Relation; overload;
Public function RelationFromQuery(arg2: str; arg3: str; arg4: str): std_shared_ptr_duckdb_Relation; overload;
Public function RelationFromQuery(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function RelationFromQuery(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function RelationFromQuery(arg2: SelectStatement; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function RelationFromQuery(arg2: SelectStatement): std_shared_ptr_duckdb_Relation; overload;
Public function GetSubstrait(arg2: str): str; overload;
Public function FromSubstrait(arg2: str): QueryResult; overload;
Public function GetSubstraitJSON(arg2: str): str; overload;
Public function FromSubstraitJSON(arg2: str): QueryResult; overload;
Public procedure BeginTransaction(); overload;
Public procedure Commit(); overload;
Public procedure Rollback(); overload;
Public procedure SetAutoCommit(arg2: Boolean); overload;
Public function IsAutoCommit(): Boolean; overload;
Public function HasActiveTransaction(): Boolean; overload;
Public function GetTableNames(arg2: str): std_unordered_set_std_string; overload;

Description

Fields

Public o: Pduckdb_Connection;

This item has no description.

Methods

Public constructor FromNativePointer(ptr : Pduckdb_Connection);

This item has no description.

Public class operator Explicit(const r: Connection): Boolean;

This item has no description.

Public procedure AutoRelease();

This item has no description.

Public procedure Init(arg1: DuckDB); overload;

This item has no description.

Public procedure Init(arg1: DatabaseInstance); overload;

This item has no description.

Public function context(): std_shared_ptr_duckdb_ClientContext; overload;

This item has no description.

Public function GetProfilingInformation(arg2: Integer): str; overload;

This item has no description.

Public function GetProfilingInformation(): str; overload;

This item has no description.

Public procedure Interrupt(); overload;

This item has no description.

Public procedure EnableProfiling(); overload;

This item has no description.

Public procedure DisableProfiling(); overload;

This item has no description.

Public procedure EnableQueryVerification(); overload;

This item has no description.

Public procedure DisableQueryVerification(); overload;

This item has no description.

Public procedure ForceParallelism(); overload;

This item has no description.

Public function SendQuery(arg2: str): QueryResult; overload;

This item has no description.

Public function Query(arg2: str): MaterializedQueryResult; overload;

This item has no description.

Public function Query(arg2: SQLStatement): MaterializedQueryResult; overload;

This item has no description.

Public function PendingQuery(arg2: str; arg3: Boolean): PendingQueryResult; overload;

This item has no description.

Public function PendingQuery(arg2: str): PendingQueryResult; overload;

This item has no description.

Public function PendingQuery(arg2: SQLStatement; arg3: Boolean): PendingQueryResult; overload;

This item has no description.

Public function PendingQuery(arg2: SQLStatement): PendingQueryResult; overload;

This item has no description.

Public function Prepare(arg2: str): PreparedStatement; overload;

This item has no description.

Public function Prepare(arg2: SQLStatement): PreparedStatement; overload;

This item has no description.

Public function TableInfo(arg2: str): TableDescription; overload;

This item has no description.

Public function TableInfo(arg2: str; arg3: str): TableDescription; overload;

This item has no description.

Public function ExtractStatements(arg2: str): duckdb_vector_duckdb_unique_ptr_duckdb_SQLStatement; overload;

This item has no description.

Public function ExtractPlan(arg2: str): LogicalOperator; overload;

This item has no description.

Public procedure Append(arg2: TableDescription; arg3: DataChunk); overload;

This item has no description.

Public procedure Append(arg2: TableDescription; arg3: ColumnDataCollection); overload;

This item has no description.

Public function Table(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Table(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function View(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function View(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Values(arg2: vector_vector_Value): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Values(arg2: vector_vector_Value; arg3: vector_str; arg4: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Values(arg2: vector_vector_Value; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Values(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Values(arg2: str; arg3: vector_str; arg4: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Values(arg2: str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function ReadParquet(arg2: str; arg3: Boolean): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function RelationFromQuery(arg2: str; arg3: str; arg4: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function RelationFromQuery(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function RelationFromQuery(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function RelationFromQuery(arg2: SelectStatement; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function RelationFromQuery(arg2: SelectStatement): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function GetSubstrait(arg2: str): str; overload;

This item has no description.

Public function FromSubstrait(arg2: str): QueryResult; overload;

This item has no description.

Public function GetSubstraitJSON(arg2: str): str; overload;

This item has no description.

Public function FromSubstraitJSON(arg2: str): QueryResult; overload;

This item has no description.

Public procedure BeginTransaction(); overload;

This item has no description.

Public procedure Commit(); overload;

This item has no description.

Public procedure Rollback(); overload;

This item has no description.

Public procedure SetAutoCommit(arg2: Boolean); overload;

This item has no description.

Public function IsAutoCommit(): Boolean; overload;

This item has no description.

Public function HasActiveTransaction(): Boolean; overload;

This item has no description.

Public function GetTableNames(arg2: str): std_unordered_set_std_string; overload;

This item has no description.

Error Message