simonw/sqlite-utils

Misleading progress bar against utf-16-le CSV input

Ouverte

#439 ouverte le 27 mai 2022

 (12 commentaires) (0 réaction) (0 personne assignée)Python (145 forks)github user discovery
bughelp wanted

Métriques du dépôt

Stars
 (2 065 étoiles)
Métriques de merge PR
 (Merge moyen 9h 52m) (7 PRs mergées en 30 j)

Description

The program crashes without any error.

wget "https://artsdatabanken.no/Fab2018/api/export/csv"
sqlite-utils create-database test.db
sqlite-utils insert --csv --delimiter ";" --encoding "utf-16-le" test test.db csv 
  [------------------------------------]    0%
  [#################-------------------]   49%  00:00:01

I would like to highlight various issues:

  1. sqlite-utils catches exceptions without printing the stacktrace and/or reraising the exception, so there is no easy way to use pdb or similar to debug the program, solution: add a debug option
  2. Silent crash: this is related to (1.), and it happens when there is a catch-all mechanism; solution: let the program fail.

Guide contributeur