aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoriceyrazor <iceyrazor@mailfence.com>2025-07-30 19:06:42 -0500
committericeyrazor <iceyrazor@mailfence.com>2025-07-30 19:06:42 -0500
commit43032288d9d09b2f76af39bd408d26a888253ff9 (patch)
tree983aa575fa990e4eede4a16f04fe9c81ee08972e
parent1b308fed30853c41fe89be84eabe2683275804c2 (diff)
fixed printf on insert to db
-rwxr-xr-xfetch.sh2
1 files changed, 1 insertions, 1 deletions
diff --git a/fetch.sh b/fetch.sh
index 3cb76c7..3f9c6db 100755
--- a/fetch.sh
+++ b/fetch.sh
@@ -18,7 +18,7 @@ if [ "$1" ]; then
i=1
max=$(( $(wc -l "$file" | sed 's/ .*//g') ))
while :; do
- printf "insert into ytlist values('$(head -n $i $file | tail -n 1 | sed "s/'/''/g" | sed "s/----/','/g" )','$2','')" | sqlite3 ./youtube_stuffs.db
+ printf -- "insert into ytlist values('%s','%s','')" "$(head -n $i $file | tail -n 1 | sed "s/'/''/g" | sed "s/----/','/g" )" "$2" | sqlite3 ./youtube_stuffs.db
printf "insert: $i\n"
((i=$i+1))
if (( $i >= $max + 1 )); then