Running powershell, bash, and EXEs from the dockerfile

Windocks supports the running of EXEs, Powershell scripts, Windows commands, Bash from the dockerfile. This is available in Enterprise edition. These commands can be run at image build time, container create time, or after container start. See the sample in windocks\samples\powershellOnDatabase

The dockerfile specifies WHEN to run the Powershell or EXEs. There are 4 choices on when to run the Powershell or EXEs.

  • Image build time
  • Image build time after the image databases are ready
  • When a container is created from this image
  • When a container is created from this image time after the container databases are ready

First create the dockerfile as follows (# is used for commenting lines):

dockerfile
FROM mssql-2016

SETUPCLONING FULL customers C:\windocks\dbbackups\customerdatafull.bak

# COPY powershellScriptAtCreate.ps1 .

# COPY custom.exe .

COPY mask.ps1 .

COPY deploy.ps1 .

# This Powershell runs at image build time but NOT on the image databases RUN somePowershell.ps1 # This Powershell runs on the database in the image at image build time
# Because the powershell is run on the image databases, all containers created from this image will have the effects of this script
# $ContainerDir and $ContainerPort are populated by Windocks automatically with the values of the container used to build the image.

RUN RUN_ON_IMAGE_DATABASES powershell.exe $ContainerDir\mask.ps1 -dest LAPTOP-DA9D6LTM\INSTANCE$ContainerPort

# Anything below this line runs after a container create is created from the image

ENV USE_DOCKERFILE_TO_CREATE_CONTAINER=1


# This Powershell runs at container create time. This container is the one being created by the user and NOT the container used to build the image
# $ContainerDir is populated by Windocks automatically with the actual values for the container created by the user

RUN powershell.exe $ContainerDir\powershellScriptAtCreate.ps1


# You may also run EXEs like Powershell # RUN .\custom.exe $ContainerPort


# This Powershell runs on container create after the container databases are ready
# $ContainerDir and $ContainerPort are populated by Windocks automatically. The instance name for the SQL container is INSTANCE$ContainerPort

RUN RUN_ON_CONTAINER_START powershell.exe $ContainerDir\deploy.ps1 -dest LAPTOP-DA9D6LTM\INSTANCE$ContainerPort


Build the image from the above dockerfile. This will create an image

In a command line on the Windocks server:
docker build -t yourimagename path\to\directory\containing\dockerfile

Alternatively, use the web application and click on Build in the top menu and click Browse. Select all the files in the directory (dockerfile, any script files) and then Open. Then click Build.

You may also use the REST API to build the image


Create a container / clone from the image with the powershell executed. This can be done using a command line (only on the Windocks machine), or the web application (from any machine) or from the REST API (any machine)

In a command line on the Windocks server:
docker run -d yourimagename

This will deliver a writeable database clone and the Powershell scripts run

You may use the web application at ServerIp:/index.html or the file windocks\ui\index.html in Chrome or Firefox

You may also use the REST API here