pelican: content: 1 row where category = "technology" and published

1 row where category = "technology" and published_date = "2021-03-14"

descending

slug ▼	author	category	content	published_date	summary	title	url
enhancements-using-github-actions-to-deploy	ryan	technology	Integrating a version control system into your development cycle is just kind of one of those things that you do, right? I use GutHub for my version control, and it’s GitHub Actions to help with my deployment process. There are 3 `yaml` files I have to get my local code deployed to my production server: * django.yaml * dev.yaml * prod.yaml Each one serving it’s own purpose ## django.yaml The `django.yaml` file is used to run my tests and other actions on a GitHub runner. It does this in 9 distinct steps and one Postgres service. The steps are: 1. Set up Python 3.8 - setting up Python 3.8 on the docker image provided by GitHub 2. psycopg2 prerequisites - setting up `psycopg2` to use the Postgres service created 3. graphviz prerequisites - setting up the requirements for graphviz which creates an image of the relationships between the various models 4. Install dependencies - installs all of my Python package requirements via pip 5. Run migrations - runs the migrations for the Django App 6. Load Fixtures - loads data into the database 7. Lint - runs `black` on my code 8. Flake8 - runs `flake8` on my code 9. Run Tests - runs all of the tests to ensure they pass name: Django CI on: push: branches-ignore: - main - dev jobs: build: runs-on: ubuntu-18.04 services: postgres: image: postgres:12.2 env: POSTGRES_USER: postgres POSTGRES_PASSWORD: postgres POSTGRES_DB: github_actions ports: - 5432:5432 # needed because the postgres container does not provide a healthcheck options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 steps: - uses: actions/checkout@v1 - name: Set up Python 3.8 uses: actions/setup-python@v1 with: python-version: 3.8 - uses: actions/cache@v1 …	2021-03-14	Integrating a version control system into your development cycle is just kind of one of those things that you do, right? I use GutHub for my version control, and it’s GitHub Actions to help with my deployment process. There are 3 `yaml` files I have to get my local …	Enhancements: Using GitHub Actions to Deploy	https://www.ryancheley.com/2021/03/14/enhancements-using-github-actions-to-deploy/

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [content] (
   [author] TEXT,
   [category] TEXT,
   [content] TEXT,
   [published_date] TEXT,
   [slug] TEXT PRIMARY KEY,
   [summary] TEXT,
   [title] TEXT,
   [url] TEXT
);