gistfile1.txt

Traceback (most recent call last):
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/query.py", line 405, in get_or_create
    return self.get(**lookup), False
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/query.py", line 334, in get
    self.model._meta.object_name
finder.models.DoesNotExist: Bill matching query does not exist.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
psycopg2.DataError: value too long for type character varying(255)


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "politics/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_line
    utility.execute()
  File "/app/.heroku/python/lib/python3.4/site-packages/django/core/management/__init__.py", line 330, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/core/management/base.py", line 390, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/core/management/base.py", line 441, in execute
    output = self.handle(*args, **options)
  File "/app/politics/finder/management/commands/vote_scraper.py", line 54, in handle
    'sponsor': bill.sponsor}
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/manager.py", line 127, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/query.py", line 407, in get_or_create
    return self._create_object_from_params(lookup, params)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/query.py", line 439, in _create_object_from_params
    obj = self.create(**params)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/query.py", line 348, in create
    obj.save(force_insert=True, using=self.db)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/base.py", line 710, in save
    force_update=force_update, update_fields=update_fields)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/base.py", line 738, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/base.py", line 822, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/base.py", line 861, in _do_insert
    using=using, raw=raw)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/manager.py", line 127, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/query.py", line 920, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql
    cursor.execute(sql, params)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/backends/utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/utils.py", line 97, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/utils/six.py", line 658, in reraise
    raise value.with_traceback(tb)
  File "/app/.heroku/python/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
django.db.utils.DataError: value too long for type character varying(255)

models.py

from django.db import models


VOTE_CHOICES = (
        ('Yea', 'Yea'),
        ('Nay', 'Nay'),
        ('Not Voting', 'Not Voting'),
        ('Not Present', 'Not Present'),
    )

CHAMBER_CHOICES = (
        ('h', 'House'),
        ('s', 'Senate'),
    )

# Create your models here.
class Legislator(models.Model):
    bioguide_id = models.CharField(max_length=10)
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)
    congress_image_url = models.URLField(max_length=200)

    def __str__(self):
        return "{} {}".format(self.first_name, self.last_name)

class Bill(models.Model):
    title = models.CharField(max_length=512)
    short_title = models.CharField(max_length=200, null=True)
    number = models.IntegerField()
    chamber = models.CharField(choices=CHAMBER_CHOICES, max_length=1)
    bill_type = models.CharField(max_length=16)
    bill_id = models.CharField(max_length=20, unique=True)
    opencongress_url = models.URLField()
    sponsor = models.ForeignKey('Legislator')

    def __str__(self):
        if self.short_title:
            return self.short_title
        else:
            return self.title


class Vote(models.Model):
    bill = models.ForeignKey('Bill')
    legislator = models.ForeignKey('Legislator')
    vote = models.CharField(choices=VOTE_CHOICES, max_length=12, default="Not Present")

    def __str__(self):
        return "{} votes {} on {}".format(self.legislator, self.vote, self.bill)