2024-10-05 03:22:19 +02:00
|
|
|
#!/usr/bin/env bash
|
|
|
|
|
|
2025-02-11 05:55:57 +01:00
|
|
|
if [ "$#" != 1 ]; then
|
|
|
|
|
echo "Usage: $0 <to>"
|
2024-10-05 03:22:19 +02:00
|
|
|
exit 1
|
|
|
|
|
fi
|
|
|
|
|
|
2025-02-11 05:55:57 +01:00
|
|
|
from=$SHIMMERING_DATA_DIR/db.sqlite
|
|
|
|
|
to=$1
|
2024-10-05 03:22:19 +02:00
|
|
|
|
|
|
|
|
echo "Creating destination..."
|
|
|
|
|
rm -rf "$to"
|
|
|
|
|
mkdir -p "$to"
|
|
|
|
|
|
|
|
|
|
echo "Exporting info..."
|
|
|
|
|
sqlite3 "$from" ".header on" ".mode csv" "select * from songs" \
|
|
|
|
|
> $to/songs.csv
|
|
|
|
|
sqlite3 "$from" ".header on" ".mode csv" "select * from charts" \
|
|
|
|
|
> $to/charts.csv
|
|
|
|
|
|
|
|
|
|
echo "All done :3"
|
