diff options
| -rwxr-xr-x | shell/ftag_tag_all.sh | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/shell/ftag_tag_all.sh b/shell/ftag_tag_all.sh new file mode 100755 index 0000000..10a0ebc --- /dev/null +++ b/shell/ftag_tag_all.sh @@ -0,0 +1,38 @@ +#!/bin/sh + +# This script shows what the steps for initializing files' tags in the database +# are. Performing the same action in a more elegant and flexible way will be +# done in the future. + +database='./ftag_cache/ftag.sqlite3' +ftag_bin='./ftag' + +# Use the development database by default, use the "real" one if any +# command-line argument is given +if [ $# -ge 1 ] +then + database="$HOME/.cache/ftag/ftag.sqlite3" + ftag_bin='ftag' +fi + +files=$(sqlite3 -list "$database" 'SELECT canonical_name FROM files;') + +echo "Available tags" +"$ftag_bin" tag list + +for file in $files +do + echo "Enter the space-separated list of tags to give ${file}" + file_id=$(sqlite3 "$database" "SELECT id FROM files where canonical_name = '${file}'") + + echo "Id is ${file_id}" + file_tags=$(sqlite3 -list "$database" "SELECT name FROM (SELECT * FROM file_tags WHERE file = ${file_id}) JOIN tags ON tag = id;") + + echo "File already has tags ${file_tags}" + read tags + for tag in $tags + do + echo "Tag $tag" + "$ftag_bin" file tag "$file" "$tag" + done +done |