diff --git a/bin/db-git-repo-meta.sh b/bin/db-git-repo-meta.sh index 754e062..eb7a8cb 100755 --- a/bin/db-git-repo-meta.sh +++ b/bin/db-git-repo-meta.sh @@ -1,28 +1,30 @@ #!/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=$(count $DB "select count(*) from directory_entry;") +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_REVISIONS=$(count $DB "select count(*) from revision;") NB_RELEASES=$(count $DB "select count(*) from release;") NB_PERSONS=$(count $DB "select count(*) from person;") cat<