Skip to content

feat: per-user secured Algolia API keys [BB-8083] #35

feat: per-user secured Algolia API keys [BB-8083]

feat: per-user secured Algolia API keys [BB-8083] #35

name: Migrations check on mysql8
on:
workflow_dispatch:
pull_request:
push:
branches:
- master
concurrency:
group: mysql8-migrations-${{ github.event.pull_request.number || github.ref }}
cancel-in-progress: true
jobs:
check_migrations:
name: check migrations
runs-on: ${{ matrix.os }}
strategy:
matrix:
os: [ ubuntu-20.04 ]
python-version: [ 3.8 ]
steps:
- name: Checkout repo
uses: actions/checkout@v2
- name: Setup Python ${{ matrix.python-version }}
uses: actions/setup-python@v2
with:
python-version: ${{ matrix.python-version }}
- name: Install system Packages
run: |
sudo apt-get update
sudo apt-get install -y libxmlsec1-dev
- name: Get pip cache dir
id: pip-cache-dir
run: |
echo "::set-output name=dir::$(pip cache dir)"
- name: Cache pip dependencies
id: cache-dependencies
uses: actions/cache@v2
with:
path: ${{ steps.pip-cache-dir.outputs.dir }}
key: ${{ runner.os }}-pip-${{ hashFiles('requirements/pip_tools.txt') }}
restore-keys: ${{ runner.os }}-pip-
- name: Downgrade pip to work around https://github.com/mitsuhiko/rye/issues/368
run: |
pip install --upgrade pip==23.1
- name: Ubuntu and sql Versions
run: |
lsb_release -a
mysql -V
- name: Install Python dependencies
run: |
pip install -qr requirements/dev.txt --exists-action w
pip-sync requirements/test-master.txt requirements/dev.txt requirements/private.* requirements/test.txt
pip uninstall -y mysqlclient
pip install --no-binary mysqlclient mysqlclient
pip uninstall -y xmlsec
pip install --no-binary xmlsec xmlsec
- name: Initiate Services
run: |
sudo /etc/init.d/mysql start
- name: Reset mysql password
run: |
cat <<EOF | mysql -h 127.0.0.1 -u root --password=root
UPDATE mysql.user SET authentication_string = null WHERE user = 'root';
FLUSH PRIVILEGES;
EOF
- name: Run migrations
env:
DB_ENGINE: django.db.backends.mysql
DB_NAME: enterprise
DB_USER: root
DB_PASSWORD:
DB_HOST: localhost
DB_PORT: 3306
run: |
echo "CREATE DATABASE IF NOT EXISTS enterprise;" | sudo mysql -u root
echo "Running the migrations."
python manage.py migrate --settings=enterprise.settings.test
echo "use mysql; select * from user;" | sudo mysql -u root