Bash shell script

Sualkin 9 Desember, 2025

# Convert semua MP3 → OGG (44100Hz) & Hapus semua metadata
for f in *.mp3; do
    ffmpeg -i "$f" \
    -vn -ar 44100 -ac 2 -b:a 128k \
    -map_metadata -1 \
    "${f%.mp3}.ogg"
done

# Output persis seperti format SQL INSERT
Contoh hasil:
INSERT INTO `radio_idle` (`id`, `file`, `count`) VALUES
(1, '/app/ogg/98º - Only Wanna Be with You.ogg', 0),
(2, '/app/ogg/Adina Howard - Freak like Me.ogg', 0),
(3, '/app/ogg/Alanis Morissette - Hand in My Pocket.ogg', 0),
(4, '/app/ogg/All-4-One - I Swear.ogg', 0),
(5, '/app/ogg/All Saints - Never Ever (Radio Edit).ogg', 0);

base="/app/ogg/$(basename "$PWD")"
echo "INSERT INTO \`radio_idle\` (\`id\`, \`file\`, \`count\`) VALUES"
mapfile -t files < <(find . -type f -name "*.ogg" | sort)
i=1
for f in "${files[@]}"; do
    filepath="$base/${f#./}"
    safe=$(printf "%s" "$filepath" | sed "s/'/\\\\'/g")
    if [[ $i -eq ${#files[@]} ]]; then
        echo "($i, '$safe', 0);"
    else
        echo "($i, '$safe', 0),"
    fi
    ((i++))
done

Sualkin Radio 24/7

https://radio.niklaus.web.id/live

Otnanidra Sualkin

Bash Shell Script

Sualkin 9 Desember, 2025

Sualkin Radio 24/7

@Links