ableton_collections.sh

#!/bin/bash
IFS=$';'

for i in {3,5,9,17,33,65,129}
do
    
    query=$(sqlite3 "/Users/jackboyce/Library/Application Support/Ableton/Live Database/Live-files-32.db" "SELECT _rowid_,* FROM main.files WHERE colors = $i")
    
    copyFile () {
        while read data; do
            mkdir -p $i
            find /Users/jackboyce/Samples -name $data -type f -exec cp {} ./$i \;
            
        done
    }
    
    echo $query | xargs -L 1 bash -c 'echo "$0 $1 $2 $3 $4 $5" | cut -d "|" -f9' | copyFile
done