Disable all database connections
Terminates all connections to the database except the current one
Function DisableAllDatabaseConnections(Val Base, Val Connection = "", Val Tls = "") Export
Parameter | CLI option | Type | Required | Description |
---|---|---|---|---|
Base | --base | String | ✔ | Database name |
Connection | --dbc | String, Arbitrary | ✖ | Connection or connection string |
Tls | --tls | Structure Of KeyAndValue | ✖ | TLS settings, if necessary. See GetTlsSettings |
Returns: Map Of KeyAndValue - Result of query execution
1C:Enterprise/OneScript code example
Address = "127.0.0.1";
Login = "bayselonarrend";
Password = "12we...";
Base = "testbase1";
TLS = True;
Port = 5432;
ConnectionString = OPI_PostgreSQL.GenerateConnectionString(Address, Base, Login, Password, Port);
If TLS Then
TLSSettings = OPI_PostgreSQL.GetTLSSettings(True);
Else
TLSSettings = Undefined;
EndIf;
// When using the connection string, a new connection is initialised,
// which will be closed after the function is executed.
// If several operations are performed, it is desirable to use one connection,
// previously created by the CreateConnection function()
Result = OPI_PostgreSQL.DisableAllDatabaseConnections(Base, ConnectionString, TLSSettings);
- Bash
- CMD/Bat
oint postgres DisableAllDatabaseConnections \
--base ""testbase2"" \
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" \
--tls ""/tmp/z2uqk4k3.qss.json""
oint postgres DisableAllDatabaseConnections ^
--base ""testbase2"" ^
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" ^
--tls ""/tmp/z2uqk4k3.qss.json""
Result
{
"data": [],
"result": true
}