Skip to content

close cassandra session upon query execution #223

close cassandra session upon query execution

close cassandra session upon query execution #223

Workflow file for this run

name: Build branch
on:
push:
branches:
- "*"
pull_request:
branches:
- "*"
jobs:
build:
runs-on: ubuntu-latest
strategy:
fail-fast: false
services:
postgres:
image: postgres:11.1
env:
POSTGRES_DB: postgres-test
POSTGRES_USER: postgres-user
POSTGRES_PASSWORD: postgres-password
ports:
- 5432:5432
options: >-
--health-cmd "pg_isready"
--health-interval 10s
--health-timeout 5s
--health-retries 10
mssql:
image: mcr.microsoft.com/mssql/server:2019-CU27-ubuntu-20.04
env:
ACCEPT_EULA: Y
MSSQL_PID: Express
SA_PASSWORD: A_Str0ng_Required_Password
ports:
- 1433:1433
options: >-
--health-cmd "/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P "A_Str0ng_Required_Password" -Q 'SELECT 1' || exit 1"
--health-interval 10s
--health-timeout 5s
--health-retries 10
mysql:
image: mysql:8.0.21
env:
MYSQL_ROOT_PASSWORD: mysql-password
MYSQL_DATABASE: mysql-text
MYSQL_USER: mysql-user
MYSQL_PASSWORD: mysql-password
ports:
- 3306:3306
options: >-
--health-cmd "mysqladmin ping -h localhost -u mysql-user --password=mysql-password"
--health-interval 10s
--health-timeout 5s
--health-retries 10
mongodb:
image: mongo:3.6
ports:
- 27017:27017
options: >-
--health-cmd "echo 'db.runCommand({ ping: 1 })' | mongo localhost:27017/test --quiet"
--health-interval 10s
--health-timeout 5s
--health-retries 10
cassandra:
image: cassandra
ports:
- 9042:9042
env:
CASSANDRA_DC: local
CASSANDRA_ENDPOINT_SNITCH: GossipingPropertyFileSnitch
options:
--health-cmd "cqlsh localhost 9042 -u cassandra -p cassandra -e 'describe cluster'"
--health-interval 10s
--health-timeout 5s
--health-retries 10
steps:
- uses: actions/checkout@v4
- name: Init database data for PostgreSQL
run: PGPASSWORD=postgres-password psql -h localhost -p 5432 -U postgres-user -f docker/postgresql/setup.sql postgres-test
- name: Init database data for MySQL
run: |
mysql --host 127.0.0.1 --port 3306 -u root --password=mysql-password --database=mysql-text < docker/mysql/setup.sql
- name: Init database data for MSSQL
run: sqlcmd -S localhost -U sa -P A_Str0ng_Required_Password -d master -i docker/mssql/setup.sql
- name: Init database data for Cassandra
run: |
docker cp docker/cassandra/setup.cql ${{ job.services.cassandra.id }}:/setup.cql
docker exec ${{ job.services.cassandra.id }} cqlsh localhost 9042 -f setup.cql
- name: Setup java
uses: actions/setup-java@v4
with:
distribution: "temurin"
java-version: 11
cache: "gradle"
- name: Build
run: ./gradlew build