seed.mjs

import Database from 'better-sqlite3'
import { readFileSync } from 'node:fs'
import { resolve } from 'node:path'

const DB_PATH = resolve('chinook.db')
const SQL_PATH = resolve('seed.sql')

const db = new Database(DB_PATH)
const sql = readFileSync(SQL_PATH, 'utf8')

db.exec(sql)

const counts = db
  .prepare(
    `SELECT 'Artists' AS name, COUNT(*) AS rows FROM Artist
     UNION ALL SELECT 'Albums',       COUNT(*) FROM Album
     UNION ALL SELECT 'Tracks',       COUNT(*) FROM Track
     UNION ALL SELECT 'Customers',    COUNT(*) FROM Customer
     UNION ALL SELECT 'Invoices',     COUNT(*) FROM Invoice
     UNION ALL SELECT 'InvoiceLines', COUNT(*) FROM InvoiceLine`
  )
  .all()

console.table(counts)
db.close()