add "piccolo user list" command (#921) #1870

Workflow file for this run

	name: Test Suite

	on:
	push:
	branches: ["master", "v1"]
	paths-ignore:
	- "docs/**"
	pull_request:
	branches: ["master", "v1"]
	paths-ignore:
	- "docs/**"

	jobs:
	linters:
	runs-on: ubuntu-latest
	timeout-minutes: 30
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11", "3.12"]

	steps:
	- uses: actions/checkout@v3
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements/requirements.txt
	pip install -r requirements/dev-requirements.txt
	pip install -r requirements/test-requirements.txt
	- name: Lint
	run: ./scripts/lint.sh

	integration:
	runs-on: ubuntu-latest
	timeout-minutes: 30
	strategy:
	matrix:
	# These tests are slow, so we only run on the latest Python
	# version.
	python-version: ["3.10"]
	postgres-version: [14]
	services:
	postgres:
	image: postgres:${{ matrix.postgres-version }}
	env:
	POSTGRES_PASSWORD: postgres
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432
	steps:
	- uses: actions/checkout@v3
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements/requirements.txt
	pip install -r requirements/test-requirements.txt
	pip install -r requirements/extras/postgres.txt
	- name: Setup postgres
	run: \|
	export PGPASSWORD=postgres
	psql -h localhost -c 'CREATE DATABASE piccolo;' -U postgres
	psql -h localhost -c "CREATE USER piccolo PASSWORD 'piccolo';" -U postgres
	psql -h localhost -c "GRANT ALL PRIVILEGES ON DATABASE piccolo TO piccolo;" -U postgres
	psql -h localhost -c "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" -d piccolo -U postgres
	- name: Run integration tests
	run: ./scripts/test-integration.sh
	env:
	PG_HOST: localhost
	PG_DATABASE: piccolo
	PG_PASSWORD: postgres

	postgres:
	runs-on: ubuntu-latest
	timeout-minutes: 30
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11", "3.12"]
	postgres-version: [11, 12, 13, 14, 15, 16]

	# Service containers to run with `container-job`
	services:
	# Label used to access the service container
	postgres:
	# Docker Hub image
	image: postgres:${{ matrix.postgres-version }}
	# Provide the password for postgres
	env:
	POSTGRES_PASSWORD: postgres
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- uses: actions/checkout@v3
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements/requirements.txt
	pip install -r requirements/test-requirements.txt
	pip install -r requirements/extras/postgres.txt
	- name: Setup postgres
	run: \|
	export PGPASSWORD=postgres
	psql -h localhost -c 'CREATE DATABASE piccolo;' -U postgres
	psql -h localhost -c "CREATE USER piccolo PASSWORD 'piccolo';" -U postgres
	psql -h localhost -c "GRANT ALL PRIVILEGES ON DATABASE piccolo TO piccolo;" -U postgres
	psql -h localhost -c "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" -d piccolo -U postgres

	- name: Test with pytest, Postgres
	run: ./scripts/test-postgres.sh
	env:
	PG_HOST: localhost
	PG_DATABASE: piccolo
	PG_PASSWORD: postgres
	- name: Upload coverage
	uses: codecov/codecov-action@v1
	if: matrix.python-version == '3.12'

	cockroach:
	runs-on: ubuntu-latest
	timeout-minutes: 30
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11", "3.12"]
	cockroachdb-version: ["v22.2.0"]
	steps:
	- uses: actions/checkout@v3
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements/requirements.txt
	pip install -r requirements/test-requirements.txt
	pip install -r requirements/extras/postgres.txt
	- name: Setup CockroachDB
	run: \|
	wget -qO- https://binaries.cockroachdb.com/cockroach-${{ matrix.cockroachdb-version }}.linux-amd64.tgz \| tar xz
	./cockroach-${{ matrix.cockroachdb-version }}.linux-amd64/cockroach start-single-node --insecure --background
	./cockroach-${{ matrix.cockroachdb-version }}.linux-amd64/cockroach sql --insecure -e 'create database piccolo;'

	- name: Test with pytest, CockroachDB
	run: ./scripts/test-cockroach.sh
	env:
	PG_HOST: localhost
	PG_DATABASE: piccolo
	- name: Upload coverage
	uses: codecov/codecov-action@v1
	if: matrix.python-version == '3.12'

	sqlite:
	runs-on: ubuntu-latest
	timeout-minutes: 30
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11", "3.12"]

	steps:
	- uses: actions/checkout@v3
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements/requirements.txt
	pip install -r requirements/test-requirements.txt
	pip install -r requirements/extras/sqlite.txt
	- name: Test with pytest, SQLite
	run: ./scripts/test-sqlite.sh
	- name: Upload coverage
	uses: codecov/codecov-action@v1
	if: matrix.python-version == '3.12'

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

add "piccolo user list" command (#921) #1870

Workflow file

add "piccolo user list" command (#921) #1870

Jobs

Run details

Workflow file for this run