turicas/rows

`--input-locale` not working on bleeding-edge

Offen

#228 geöffnet am 23.06.2017

 (0 Kommentare) (0 Reaktionen) (0 zugewiesene Personen)Python (136 Forks)github user discovery
bugclihelp wantedrows.fields

Repository-Metriken

Stars
 (886 Sterne)
PR-Merge-Metriken
 (Keine gemergten PRs in 30 T)

Beschreibung

The following command works on efa5def085196d7df35027c8191809608d937949 (current develop) but not on bleeding-edge (which is going to be the next develop after more tests/fixes):

URL="http://cidades.ibge.gov.br/comparamun/compara.php?idtema=1&codv=v01&coduf=33"
QUERY="SELECT * FROM table1 ORDER BY pessoas ASC LIMIT 10"
rows query --input-locale=pt_BR.UTF-8 "$QUERY" "$URL" 

The error is the following:

Traceback (most recent call last):
  File "/home/turicas/.virtualenvs/rows/bin/rows", line 11, in <module>
    load_entry_point('rows', 'console_scripts', 'rows')()
  File "/home/turicas/.virtualenvs/rows/lib/python3.6/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/home/turicas/.virtualenvs/rows/lib/python3.6/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/home/turicas/.virtualenvs/rows/lib/python3.6/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/turicas/.virtualenvs/rows/lib/python3.6/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/turicas/.virtualenvs/rows/lib/python3.6/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/home/turicas/projects/rows/rows/cli.py", line 336, in query
    table_name='table1')
  File "/home/turicas/projects/rows/rows/plugins/sqlite.py", line 168, in export_to_sqlite
    for batch in ipartition(prepared_table, batch_size):
  File "/home/turicas/projects/rows/rows/plugins/utils.py", line 74, in ipartition
    data.append(next(iterator))
  File "/home/turicas/projects/rows/rows/plugins/utils.py", line 245, in prepare_to_export
    for row in table:
  File "/home/turicas/projects/rows/rows/table.py", line 58, in __iter__
    zip(row, fields)])
  File "/home/turicas/projects/rows/rows/table.py", line 57, in <listcomp>
    for value, (field_name, field_type) in
  File "/home/turicas/projects/rows/rows/fields.py", line 182, in deserialize
    return int(value) if SHOULD_NOT_USE_LOCALE \
ValueError: invalid literal for int() with base 10: '169.511'

Contributor Guide