simonw/sqlite-utils

Misleading progress bar against utf-16-le CSV input

オープン

#439 opened on 2022/05/27

 (12 件のコメント) (0 件のリアクション) (0 人の担当者)Python (145 件のフォーク)github user discovery
bughelp wanted

Repository metrics

Stars
 (2,065 個のスター)
PR merge metrics
 (平均マージ 9h 52m) (30d で 7 merged PRs)

説明

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.

コントリビューターガイド