grahamc/hydra2 - Change EE7WXXUDSIA6ZLLTGC6G6HUD6EKONQ7SVS34ZNWKHVQHW53GPSMAC

sql: Stop loading SQL if an error occurs

Otherwise we may go ahead and create DBIx classes for a half-loaded schema.

Created by Graham Christensen on January 25, 2021

EE7WXXUDSIA6ZLLTGC6G6HUD6EKONQ7SVS34ZNWKHVQHW53GPSMAC

Dependencies

In channels

main

Change contents

Insertion in src/sql/update-dbix-harness.sh at line 2 [3.8707]
[3.8728]
[3.8728]
```
set -eux
```

Replacement in src/sql/update-dbix-harness.sh at line 11 [3.8707]

B:BD[3.8873] → [3.8873:9000]

function finish {
    set +e
    pg_ctl -D "$data" \
           -o "-F -h '' -k \"$socket\"" \
           -w stop -m immediate

[3.8873]

[3.9000]

function finish() {
       set +e
       pg_ctl -D "$data" \
              -o "-F -h '' -k \"$socket\"" \
              -w stop -m immediate

Replacement in src/sql/update-dbix-harness.sh at line 17 [3.8707]

B:BD[3.9001] → [3.9001:9185]

    if [ -f "$data/postmaster.pid" ]; then
        pg_ctl -D "$data" \
               -o "-F -h '' -k \"$socket\"" \
               -w kill TERM "$(cat "$data/postmaster.pid")"
    fi

[3.9001]

[3.9185]

       if [ -f "$data/postmaster.pid" ]; then
              pg_ctl -D "$data" \
                     -o "-F -h '' -k \"$socket\"" \
                     -w kill TERM "$(cat "$data/postmaster.pid")"
       fi

Replacement in src/sql/update-dbix-harness.sh at line 23 [3.8707]
B:BD[3.9186] → [3.9186:9208]
```
    rm -rf "$scratch"
```
[3.9186]
[3.9208]
```
       rm -rf "$scratch"
```

Replacement in src/sql/update-dbix-harness.sh at line 38 [3.8707]

B:BD[3.9384] → [2.90:133]

psql -h "$socket" "$dbname" -f ./hydra.sql

[3.9384]

[3.9438]

psql --host "$socket" \
       --set ON_ERROR_STOP=1 \
       --file ./hydra.sql \
       "$dbname"

Replacement in src/sql/update-dbix-harness.sh at line 44 [3.8707]

B:BD[3.9456] → [3.9456:9584]

     -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:../lib \
     update-dbix.pl "dbi:Pg:dbname=$dbname;host=$socket"

[3.9456]

       -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:../lib \
       update-dbix.pl "dbi:Pg:dbname=$dbname;host=$socket"