<p>I have taken up the challenge of automating the deployment of my company's Django-based application that is done with AKS but I am very new to it. My initial idea is to accomplish it by upgrading the steps in a GitHub workflow that acts on the release of a new version.</p>
<p>I have structured it with three jobs. <code>build</code>, <code>migrate</code> and <code>deploy</code>:</p>
<ol>
<li><code>build</code>: Simply build the Docker image and push it to the container registry on DockerHub - this step is successfully done.</li>
<li><code>migrate</code>: Run the migrations in the production database from <code>python manage.py migrate</code> - here lies the problem.</li>
<li><code>deploy</code>: Deploy the image to the Kubernetes cluster - successfully done.</li>
</ol>
<p>Step 2 is the problem because we store the Postgres database credentials inside the Kubernetes cluster and to run the migrations I need those secrets to pass them as environment variables before I call the <code>migrate</code> command. So I am stuck on how I can pull those secrets from Kubernetes and use them to run a command in a step in GitHub action like this:</p>
<pre class="lang-yaml prettyprint-override"><code>migrate:
    needs: build
    runs-on: ubuntu-latest

    steps:
      - uses: actions/checkout@v2

      - name: Set up Python 3.8
        uses: actions/setup-python@v2
        with:
          python-version: 3.8

      - name: psycopg2 prerequisites
        run: sudo apt-get install python3-dev libpq-dev

      - name: Install dependencies
        run: |
          python3 -m pip install --upgrade pip
          python3 -m pip install -r requirements.txt
      
      - name: Run migrations
        run: |
          POSTGRES_HOST={{ secret_host }} POSTGRES_USER={{ secret_user }} POSTGRES_PASSWORD={{ secret_password }} python manage.py showmigrations --settings settings_production
          POSTGRES_HOST={{ secret_host }} POSTGRES_USER={{ secret_user }} POSTGRES_PASSWORD={{ secret_password }} python manage.py migrate --settings settings_production
</code></pre>
<p>Question is, is this even possible? If so, how can I do it? If not, what is another option to run the migrations in production before finishing the deployment?</p>

everspader
<p>You can rub db migrations from Kubernetes cluster itself.</p>
<ol>
<li>Create a Kubernetes Job, which basically runs db migration. and</li>
<li>Deploy an init container before main container(application), which periodically checks db migration job completion.</li>
</ol>
