IamADav

echo Start code coverage

cd %2

IF EXIST .\TestResult.xml (
	del .\TestResult.xml
)
 
IF NOT EXIST .\CoverageReport (
	md .\CoverageReport

IamADav

delete                   => HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\ModernSleep\EnabledActions 
set CsEnabled to zero    => HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power

IamADav

net stop docker
net stop com.docker.service
taskkill /IM "dockerd.exe" /F
taskkill /IM "Docker for Windows.exe" /F
net start docker
net start com.docker.service
start "" "c:\program files\docker\docker\Docker for Windows.exe"

IamADav

#it in docker
docker exec -it 980733335feb /bin/bash

#create dump
PGSSLMODE=allow 
pg_dump -h xx.postgres.azure.com -p 5432 --username user@xx --table table --dbname db_name --file ./file.sql

#restore dump
psql -U username -d database_name -1 -f ./file.sql

IamADav

USE [master];

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE database_id  = db_id('ifrs17_database')

EXEC(@kill);

 drop database ifrs17_database;

IamADav

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database'
  AND pid <> pg_backend_pid();
  
 
 drop database database;
 create database database;

IamADav

docker ps --format {{.ID}}\t{{.Names}}