zrhoffman commented on PR #6802:
URL: https://github.com/apache/trafficcontrol/pull/6802#issuecomment-1133448159
<details>
<summary>To reference in another comment, this is the test I use to compare
DB dumps from master and #6802 (click to expand)</summary>
```shell
import_and_dump_schema() {
output_file="$1";
<<'DOCKER_COMMANDS' docker run --rm -i \
-v "$(pwd)/traffic_ops/app":/app \
-w /app \
-e POSTGRES_USER=traffic_ops \
-e POSTGRES_PASSWORD=twelve \
-e PGUSER=traffic_ops \
-e PGPASSWORD=twelve \
-e POSTGRES_DB=traffic_ops \
postgres:13.6-alpine bash |
set -o errexit
(trap 'echo "Error on line ${LINENO} of Docker stdin"; exit 1' ERR
docker-entrypoint.sh postgres &
echo 'Waiting for Postgres to start...'
sleep 10
db/admin -env=production load_schema
db/admin -env=production upgrade) >/dev/stderr
pg_dump
DOCKER_COMMANDS
sed -E 's/[0-9]{4}-[0-9]{2}-[0-9]{2}
[0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]+\+[0-9]{2}/A_TIMESTAMP/g' >"$output_file"
};
CGO_ENABLED=0 go build -o traffic_ops/app/db/ traffic_ops/app/db/admin.go
git fetch apache
git checkout apache/master
import_and_dump_tv_schema apache.sql
# (commented out until f1d8332901 is reverted)
#git checkout apache/pull/6802/merge
git checkout 7b3b8004cd
import_and_dump_tv_schema 6802.sql
diff -u apache.sql 6802.sql
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
