Skip to main content

Create Connection

Creates a connection to the specified base

Function CreateConnection(Val ConnectionString = "", Val Tls = "") Export

ParameterCLI optionTypeRequiredDescription
ConnectionString-StringConnection string. See GenerateConnectionString
Tls-Structure Of KeyAndValueTLS settings, if necessary. See GetTlsSettings

Returns: Arbitrary - Connector object or structure with error information


caution

NOCLI: this method is not available in CLI version


1C:Enterprise/OneScript code example
    Address  = "127.0.0.1";
Login = "bayselonarrend";
Password = "12we...";
Base = "postgres";

ConnectionString = OPI_PostgreSQL.GenerateConnectionString(Address, Base, Login, Password);
Result = OPI_PostgreSQL.CreateConnection(ConnectionString);

OPI_PostgreSQL.CloseConnection(Result);

// With TLS

Address = "api.athenaeum.digital";
Port = "5433";

ConnectionString = OPI_PostgreSQL.GenerateConnectionString(Address, Base, Login, Password, Port);
TLSSettings = OPI_PostgreSQL.GetTlsSettings(False);

Result = OPI_PostgreSQL.CreateConnection(ConnectionString, TLSSettings);

OPI_PostgreSQL.CloseConnection(Result);
Result
NOT JSON: AddIn.OPI_PostgreSQL.Main