search

eyeseast / geocode-sqlite

Geocode rows in a SQLite database table
Apache License 2.0
231 stars 6 forks source link

Error when updating rowid table #25

Closed eyeseast closed 2 years ago

eyeseast commented 2 years ago

Oops.

pipenv run geocode-sqlite nominatim quakes.db addresses \
        -l '{address}, San Francisco, CA' \
        --user-agent 'Chris Amico/chrisamico.com'
Using Nominatim geocoder at nominatim.openstreetmap.org
Geocoding table: addresses
30 rows  [------------------------------------]    0%
Traceback (most recent call last):
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/bin/geocode-sqlite", line 8, in <module>
    sys.exit(cli())
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/click/core.py", line 1128, in __call__
    return self.main(*args, **kwargs)
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/click/core.py", line 1053, in main
    rv = self.invoke(ctx)
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/click/core.py", line 1659, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/click/core.py", line 1628, in _process_result
    value = ctx.invoke(self._result_callback, value, **ctx.params)
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/click/core.py", line 754, in invoke
    return __callback(*args, **kwargs)
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/geocode_sqlite/cli.py", line 163, in geocode
    pks = [row[pk] for pk in table.pks]
  File "/Users/camico/.local/share/virtualenvs/seismic-analysis-2ZHhjXRg-python/lib/python3.10/site-packages/geocode_sqlite/cli.py", line 163, in <listcomp>
    pks = [row[pk] for pk in table.pks]
KeyError: 'rowid'

This is probably a better way: https://sqlite-utils.datasette.io/en/stable/python-api.html#listing-rows-with-their-primary-keys