Connect extension

Connects the SQLite extension for the specified connection

Function ConnectExtension(Val Extension, Val EntryPoint = "", Val Connection = "") Export

Parameter	CLI option	Type	Required	Description
Extension	-	String, BinaryData	✔	Extension data or filepath
EntryPoint	-	String	✖	Expansion entry point, if required
Connection	-	String, Arbitrary	✖	Existing connection or path to the base. In memory, if not filled

Returns: Map Of KeyAndValue - Result of extension connecting

tip

The extension is active only for the current connection. You must reconnect it each time a new connection is established

Similar to using the Extensions parameter (exts in CLI) of the ExecuteSQLQuery function

Parameters with Binary data type can also accept file paths on disk and URLs

caution

NOCLI: this method is not available in CLI version

1C:Enterprise/OneScript code example

    If OPI_Tools.IsWindows() Then
        Extension = "https://hut.openintegrations.dev/test_data/uuid.dll"; // URL, Path or Binary Data
    Else
        Extension = "https://hut.openintegrations.dev/test_data/uuid.so"; // URL, Path or Binary Data
    EndIf;

    Base       = "C:\Users\bayse\AppData\Local\Temp\v8_2B38_2c.sqlite";
    EntryPoint = "sqlite3_uuid_init";

    Connection = OPI_SQLite.CreateConnection(Base);
    Result     = OPI_SQLite.ConnectExtension(Extension, EntryPoint, Connection);

Result

{
 "result": true
}