search

palewire / django-calaccess-raw-data

A Django app to download, extract and load campaign finance and lobbying activity data from the California Secretary of State's CAL-ACCESS database
http://django-calaccess.californiacivicdata.org/
MIT License
64 stars 143 forks source link

StopIteration on loading empty file #1510

Closed palewire closed 2 years ago

palewire commented 6 years ago 

Traceback (most recent call last):
  File "manage.py", line 9, in <module>
    execute_from_command_line(sys.argv)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
    utility.execute()
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/core/management/__init__.py", line 375, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/core/management/base.py", line 316, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/core/management/base.py", line 353, in execute
    output = self.handle(*args, **options)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/calaccess_raw/management/commands/updatecalaccessrawdata.py", line 282, in handle
    self.load()
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/calaccess_raw/management/commands/updatecalaccessrawdata.py", line 429, in load
    app_name=self.app_name,
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/core/management/__init__.py", line 148, in call_command
    return command.execute(*args, **defaults)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/core/management/base.py", line 353, in execute
    output = self.handle(*args, **options)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/calaccess_raw/management/commands/loadcalaccessrawfile.py", line 129, in handle
    self.load()
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/calaccess_raw/management/commands/loadcalaccessrawfile.py", line 171, in load
    self.load_postgresql()
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/calaccess_raw/management/commands/loadcalaccessrawfile.py", line 191, in load_postgresql
    self.model.objects.from_csv(self.csv, model_mapping, using=self.database)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/django/db/models/manager.py", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/postgres_copy/managers.py", line 134, in from_csv
    mapping = CopyMapping(self.model, csv_path, mapping, **kwargs)
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/postgres_copy/copy_from.py", line 83, in __init__
    self.headers = self.get_headers()
  File "/home/palewire/.virtualenvs/django-calaccess-processed-data/local/lib/python3.5/site-packages/postgres_copy/copy_from.py", line 156, in get_headers
    headers = next(csv_reader)
StopIteration```