search

datamade / illinois-sunshine

:sunny: Illinois Sunshine. Keep an eye on money in Illinois politics.
http://illinoissunshine.org/
MIT License
3 stars 1 forks source link

ETL loading error #97

Open evz opened 8 years ago

evz commented 8 years ago

Originally created by derekeder on 2016-02-22T17:34:29Z

This may have been introduced after #116

Stack trace:

Traceback (most recent call last):
  File "etl.py", line 59, in executeTransaction
    self.connection.execute(query, *args)
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 906, in execute
    return self._execute_text(object, multiparams, params)
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1054, in _execute_text
    statement, parameters
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 181, in reraise
    raise value.with_traceback(tb)
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/Users/derekeder/.virtualenvs/sunshine-database/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) type "committee_position" already exists
 [SQL: " \n            CREATE TYPE committee_position AS ENUM (\n              'support', \n              'oppose'\n            )\n        "]
(psycopg2.ProgrammingError) type "committee_position" already exists
 [SQL: " \n            CREATE TYPE committee_position AS ENUM (\n              'support', \n              'oppose'\n            )\n        "]
Traceback (most recent call last):
  File "etl.py", line 1311, in <module>
    committees.load()
  File "etl.py", line 277, in load
    self.insertNewRecords()
  File "etl.py", line 298, in insertNewRecords
    for row in self.transform():
  File "etl.py", line 383, in transform
    if 'Independent Expenditure' in row['TypeOfCommittee']:
TypeError: argument of type 'NoneType' is not iterable