mirror of
https://github.com/lightninglabs/lightning-terminal.git
synced 2026-08-13 12:33:36 +02:00
4efa6098f8
When the kvdb to sql migration is initially introduced, we will want to ensure that it is only run under dev builds during the testing phase. We therefore introduce the functionality to have separate dev migrations, which are only included in a separate migration stream that is used only in dev builds. Note that these dev migrations are currently not included in the `sqlc.yaml` file, to ensure that the main sqlc models doesn't include the dev migrations.
48 lines
1.6 KiB
Bash
Executable file
48 lines
1.6 KiB
Bash
Executable file
#!/bin/bash
|
|
|
|
set -e
|
|
|
|
# restore_files is a function to restore original schema files.
|
|
restore_files() {
|
|
echo "Restoring SQLite bigint patch..."
|
|
for file in db/sqlc/{migrations,migrations_dev}/*.up.sql.bak; do
|
|
mv "$file" "${file%.bak}"
|
|
done
|
|
}
|
|
|
|
# Set trap to call restore_files on script exit. This makes sure the old files
|
|
# are always restored.
|
|
trap restore_files EXIT
|
|
|
|
# Directory of the script file, independent of where it's called from.
|
|
DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
|
|
# Use the user's cache directories
|
|
GOCACHE=$(go env GOCACHE)
|
|
GOMODCACHE=$(go env GOMODCACHE)
|
|
|
|
# SQLite doesn't support "BIGINT PRIMARY KEY" for auto-incrementing primary
|
|
# keys, only "INTEGER PRIMARY KEY". Internally it uses 64-bit integers for
|
|
# numbers anyway, independent of the column type. So we can just use
|
|
# "INTEGER PRIMARY KEY" and it will work the same under the hood, giving us
|
|
# auto incrementing 64-bit integers.
|
|
# _BUT_, sqlc will generate Go code with int32 if we use "INTEGER PRIMARY KEY",
|
|
# even though we want int64. So before we run sqlc, we need to patch the
|
|
# source schema SQL files to use "BIGINT PRIMARY KEY" instead of "INTEGER
|
|
# PRIMARY KEY".
|
|
echo "Applying SQLite bigint patch..."
|
|
for file in db/sqlc/{migrations,migrations_dev}/*.up.sql; do
|
|
echo "Patching $file"
|
|
sed -i.bak -E 's/INTEGER PRIMARY KEY/BIGINT PRIMARY KEY/g' "$file"
|
|
done
|
|
|
|
echo "Generating sql models and queries in go..."
|
|
|
|
# Run the script to generate the new generated code. Once the script exits, we
|
|
# use `trap` to make sure all files are restored.
|
|
docker run \
|
|
--rm \
|
|
--user "$UID:$(id -g)" \
|
|
-e UID=$UID \
|
|
-v "$DIR/../:/build" \
|
|
-w /build \
|
|
sqlc/sqlc:1.25.0 generate
|