Page MenuHomeSoftware Heritage
Files F7450439

db-upgrade
No OneTemporary
Actions

db-upgrade
View Options

#!/bin/bash
# Compute a draft upgrade script for the DB schema, based on Git revisions.
# Depends: apgdiff
set -e
SQLS="swh-*.sql"
VERSION_SQL="swh-schema.sql"
UPGRADE_DIR="upgrades"
DB_NAME="softwareheritage-dev"
usage () {
echo "Usage: db-upgrade GIT_REV_FROM [GIT_REV_TO]"
echo "Example: db-upgrade HEAD^"
echo " db-upgrade HEAD~4 HEAD~2"
echo "See also: gitrevisions(7)"
exit 1
}
pg_dump_revision () {
rev="$1"
dump="$2"
echo "checking out revision $rev, and dumping DB at the time..."
if [ "$rev" != "HEAD" ] ; then
git checkout --quiet "$rev"
fi
make distclean filldb > /dev/null
pg_dump "$DB_NAME" > "$dump"
if [ "$rev" != "HEAD" ] ; then
git checkout --quiet -
fi
}
# argument parsing
if [ -z "$1" ] ; then
usage
fi
from_rev="$1"
shift 1
if [ -z "$1" ] ; then
to_rev="HEAD"
else
to_rev="$1"
shift 1
fi
old_dump=$(mktemp tmp.swh-db-upgrade.XXXXXXXXXX)
new_dump=$(mktemp tmp.swh-db-upgrade.XXXXXXXXXX)
trap "rm -f $old_dump $new_dump" EXIT
schema_version=$(grep -i -A 1 '^insert into dbversion' "$VERSION_SQL" | tail -n 1 \
| sed -e 's/.*values(//i' -e 's/,.*//')
upgrade_script=$(mktemp -p "$UPGRADE_DIR" $(printf '%.03d' ${schema_version}).XXXX.sql)
pg_dump_revision "$from_rev" "$old_dump"
pg_dump_revision "$to_rev" "$new_dump"
cat > "$upgrade_script" <<EOF
-- SWH DB schema upgrade
-- from_version: XXX TODO
-- to_version: ${schema_version}
-- description: XXX TODO
insert into dbversion(version, release, description)
values($schema_version, now(), 'Work In Progress');
EOF
echo "diffing dumps..."
apgdiff "$old_dump" "$new_dump" >> "$upgrade_script"
echo "all done."
echo "Draft upgrade script is at: ${upgrade_script}"

File Metadata

Mime Type
text/x-shellscript
Expires
Thu, Apr 17, 7:32 AM (5 d, 11 h ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3242475

Event Timeline

About · Developer information · Legal