about summary refs log tree commit diff stats
path: root/scripts/mkdb.sh
blob: 6bcebaf499e28ec5b7cb6bacaf02e2a8778366a6 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
#!/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