SQLite exercise for MiniDBI

sqlite.pl

use v6;
use MiniDBI;
my $dbh = MiniDBI.connect('SQLite', :dbname<test.sqlite3>, :RaiseError);
$dbh.do('DROP TABLE IF EXISTS t');
$dbh.do('CREATE TABLE t(x INTEGER PRIMARY KEY ASC, y, z)');
my $sth = $dbh.prepare('INSERT INTO t (y, z) VALUES (?, ?)');

for <a b c d e f g h> -> $a, $b {
    $sth.execute($a, $b);
}
$sth.finish;

$sth = $dbh.prepare('SELECT x, y, z FROM t');
$sth.execute;

while my @row = $sth.fetchrow_array {
    say @row.join(', ');
}
$sth.finish;
# CONTROL {
#     default { say .backtrace.full }
# }