#!/usr/bin/env sh

# yt - A fully featured command line YouTube client
#
# Copyright (C) 2024 Benedikt Peetz <benedikt.peetz@b-peetz.de>
# SPDX-License-Identifier: GPL-3.0-or-later
#
# This file is part of Yt.
#
# You should have received a copy of the License along with this program.
# If not, see <https://www.gnu.org/licenses/gpl-3.0.txt>.

root="$(dirname "$0")/.."
db="$root/target/database.sqlx"

[ -f "$db" ] && rm "$db"
[ -d "$root/target" ] || mkdir "$root/target"

fd . "$root/yt/src/storage/migrate/sql" | while read -r sql_file; do
    echo "Applying sql migration file: $(basename "$sql_file").."
    sqlite3 "$db" <"$sql_file"
done

# vim: ft=sh