external disk inventory to SQLite with nushell

README.md

Usage: catalog-disk <disk_name> <mount_path>

$ nu

> use lib.nu catalog-disk
> catalog-disk photo1 /Volumes/samsung-photo1

> sqlite3 catalog.db .schema
CREATE TABLE IF NOT EXISTS "files"(
"name" TEXT, "type" TEXT, "size" TEXT, "modified" TEXT,
 "disk" TEXT);

lib.nu

export def catalog-disk [disk_name: string, mount_path: string] {
  ls (($mount_path | path join "**/*") | into glob)
    | select name type size modified
    | insert disk $disk_name
    | to csv
    | save --force $"/tmp/($disk_name).csv"
  sqlite3 catalog.db ".mode csv" $".import /tmp/($disk_name).csv files"
}