track claude skills in pijul
tests for utils/mapping.go

╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌

╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌
# from README.md
**What's imported:**
- `segment` - time ranges with freq_low/freq_high from .data YES
- `label` - species, filter, certainty for each segment YES
- `label_subtype` - calltype if present in .data YES
- `label_metadata` - stores comments  YES XXXX Not `skraak_label_id`, writes this to .data file XXXX
- `file_metadata` - XXXX Not `skraak_hash, writes this to .data file` XXXX
**Skipped:** NO NO NO, imports the segment but ignores the bookmark:true metadata
- Segments with `bookmark: true` labels (navigation markers) NO NO NO, imports the segment but ignores the bookmark:true metadata
# from CHANGELOG.md
**Database writes:**
- `segment` table: id, file_id, dataset_id, start_time, end_time, freq_low, freq_high
- `label` table: id, segment_id, species_id, filter_id, certainty
- `label_metadata` table: `{ "comment": "..."}`XXX Not "skraak_label_id": "...", XXX
- `label_subtype` table: id, label_id, calltype_id, filter_id, certainty (if calltype present)
- XXX NO `file_metadata` table: `{"skraak_hash": "..."}` XXX
from @cmd/import.go 
fmt.Fprintf(os.Stderr, "  - Segments with bookmark=true labels are skipped\n") //WRONG

		fmt.Fprintf(os.Stderr, "  - Segments with bookmark=true labels are skipped\n")

		fmt.Fprintf(os.Stderr, "  - Segments with bookmark=true labels are skipped\n") //WRONG

		fmt.Fprintf(os.Stderr, "  skraak import segments --db ./db/skraak.duckdb --dataset abc123 --location loc456 --cluster clust789 --folder /path/to/data --mapping mapping.json\n")

		fmt.Fprintf(os.Stderr, "  skraak import segments --db ./db/skraak.duckdb --dataset dset_id123 --location loc_id456 --cluster clust_id789 --folder /path/to/data --mapping mapping.json\n")

5. Filters / Models must already exist in the database

**Mapping file** (`mapping.json`):

**Mapping file** (`mapping_2026-03-13.json`):
use claude skill to guide user through creation of species calltype mapping to db

**Import:**

**Import Segments:**

  --dataset abc123 \
  --location loc456 \
  --cluster clust789 \

  --dataset dataset_id \
  --location location_id \
  --cluster cluster_id \

- `label_metadata` - stores `skraak_label_id` and comments
- `file_metadata` - stores `skraak_hash`

- `label_metadata` - stores comments XXXX Not `skraak_label_id`, writes this to .data file XXXX
- `file_metadata` - XXXX Not `skraak_hash, writes this to .data file` XXXX

**Skipped:**
- Segments with `bookmark: true` labels (navigation markers)

**Skipped:** NO NO NO, WRONG
- Segments with `bookmark: true` labels (navigation markers) NO NO NO, imports the segment but ignores the bookmark:true metadata

- `label_metadata` table: `{"skraak_label_id": "...", "comment": "..."}`

- `label_metadata` table: `{ "comment": "..."}`XXX Not "skraak_label_id": "...", XXX

- `file_metadata` table: `{"skraak_hash": "..."}`

- XXX NO `file_metadata` table: `{"skraak_hash": "..."}` XXX