Select Git revision
settings.php
-
Frode Petterson authored
HFJ-2184
Frode Petterson authoredHFJ-2184
remaining_library_ids 358 B
#!/bin/bash
REMAINNG = $(sudo -u postgres -- psql -qtAX -d hshinfo -c "select (maximum_value::bigint - (SELECT last_value FROM hshinfo.seq_raw_library_id)) from information_schema.sequences where sequence_schema = 'hshinfo' and sequence_name = 'seq_raw_library_id';")
echo "P remaining_library_ids=$REMAINING;400:;200: That many library IDs are available."