diff --git a/bin/db-git-repo-meta.sh b/bin/db-git-repo-meta.sh index eb7a8cb..ca83c99 100755 --- a/bin/db-git-repo-meta.sh +++ b/bin/db-git-repo-meta.sh @@ -1,30 +1,32 @@ #!/usr/bin/env bash # Use: $0 # will compute the number of revision, directory, content from db respectively. DB=$1 count() { DB=$1 QUERY=$2 psql -d $1 --command "$QUERY;" | tail -3 | head -1 } NB_CONTENTS=$(count $DB "select count(*) from content;") NB_DIRECTORIES=$(count $DB "select count(*) from directory;") NB_DIRECTORY_ENTRIES_DIR=$(count $DB "select count(*) from directory_entry_dir;") NB_DIRECTORY_ENTRIES_FILE=$(count $DB "select count(*) from directory_entry_file;") +NB_DIRECTORY_ENTRIES_REV=$(count $DB "select count(*) from directory_entry_rev;") NB_REVISIONS=$(count $DB "select count(*) from revision;") NB_RELEASES=$(count $DB "select count(*) from release;") NB_PERSONS=$(count $DB "select count(*) from person;") cat<