1#!/usr/bin/env bash
2
3# Squawk is a linter for database migrations. It helps identify dangerous patterns, and suggests alternatives.
4# Squawk flagging an error does not mean that you need to take a different approach, but it does indicate you need to think about what you're doing.
5# See also: https://squawkhq.com
6
7set -e
8
9SQUAWK_VERSION=0.26.0
10SQUAWK_BIN="./target/squawk-$SQUAWK_VERSION"
11SQUAWK_ARGS="--assume-in-transaction"
12
13
14if [ ! -f "$SQUAWK_BIN" ]; then
15 curl -L -o "$SQUAWK_BIN" "https://github.com/sbdchd/squawk/releases/download/v$SQUAWK_VERSION/squawk-darwin-x86_64"
16 chmod +x "$SQUAWK_BIN"
17fi
18
19if [ -n "$SQUAWK_GITHUB_TOKEN" ]; then
20 export SQUAWK_GITHUB_REPO_OWNER=$(echo $GITHUB_REPOSITORY | awk -F/ '{print $1}')
21 export SQUAWK_GITHUB_REPO_NAME=$(echo $GITHUB_REPOSITORY | awk -F/ '{print $2}')
22 export SQUAWK_GITHUB_PR_NUMBER=$(echo $GITHUB_REF | awk 'BEGIN { FS = "/" } ; { print $3 }')
23
24 $SQUAWK_BIN $SQUAWK_ARGS upload-to-github $(git diff --name-only origin/$GITHUB_BASE_REF...origin/$GITHUB_HEAD_REF 'crates/collab/migrations/*.sql')
25else
26 $SQUAWK_BIN $SQUAWK_ARGS $(git ls-files --others crates/collab/migrations/*.sql) $(git diff --name-only main crates/collab/migrations/*.sql)
27fi