gen-table-schema.raku

'./championships.create.sql'.IO.spurt( q:to/END/ );
CREATE TABLE "championships" (
    "championship_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "champion_kind_id" INTEGER NULL,
    "name" TEXT NULL
);
END

'./championship_kinds.create.sql'.IO.spurt( q:to/END/ );
CREATE TABLE "championship_kinds" (
    "champion_kind_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "champion_kind_name" TEXT NULL
);
END

seed.sh

if [ -f ./fantasy.db ]; then
   rm -v ./fantasy.db
fi
sqlite3 ./fantasy.db < ./championship_kinds.create.sql
sqlite3 ./fantasy.db < ./championships.create.sql
sqlite3 ./fantasy.db < ./championship_kinds000.insert.sql
sqlite3 ./fantasy.db < ./championships000.insert.sql