def tweet_a_bill_action(self):
# Tweet an interesting action on a bill.
from bill.models import Bill, BillStatus
from bill.status import get_bill_really_short_status_string
bills = list(
Bill.objects.filter(
current_status_date__gte=timezone.now().date() -
timedelta(days=1),
current_status_date__lt=timezone.now().date(),
).exclude(current_status=BillStatus.introduced, ))
if len(bills) == 0: return
# Choose bill with the most salient status, breaking ties with the highest proscore.
bills.sort(
key=lambda b:
(BillStatus.by_value(b.current_status).sort_order, b.proscore()),
reverse=True)
for bill in bills:
status = BillStatus.by_value(bill.current_status).xml_code
if "Providing for consideration" in bill.title: continue
text = get_bill_really_short_status_string(status)
if text == "": continue
bill_number = bill.display_number
if bill.sponsor and bill.sponsor.twitterid:
bill_number += " by @" + bill.sponsor.twitterid
text = text % (bill_number, u"yesterday")
text += " " + bill.title_no_number
self.post_tweet(
bill.current_status_date.isoformat() + ":bill:%s:status:%s" %
(bill.congressproject_id, status), text,
"https://www.govtrack.us" + bill.get_absolute_url())
def tweet_a_bill_action(self): # Tweet an interesting action on a bill. from bill.models import Bill, BillStatus from bill.status import get_bill_really_short_status_string bills = list(Bill.objects.filter( current_status_date__gte=timezone.now().date()-timedelta(days=1), current_status_date__lt=timezone.now().date(), ).exclude( current_status=BillStatus.introduced, )) if len(bills) == 0: return # Choose bill with the most salient status, breaking ties with the highest proscore. bills.sort(key = lambda b : (BillStatus.by_value(b.current_status).sort_order, b.proscore()), reverse=True) for bill in bills: status = BillStatus.by_value(bill.current_status).xml_code if "Providing for consideration" in bill.title: continue text = get_bill_really_short_status_string(status) if text == "": continue bill_number = bill.display_number if bill.sponsor and bill.sponsor.twitterid: bill_number += " by @" + bill.sponsor.twitterid text = text % (bill_number, "yesterday") text += " " + bill.title_no_number self.post_tweet( bill.current_status_date.isoformat() + ":bill:%s:status:%s" % (bill.congressproject_id, status), text, "https://www.govtrack.us" + bill.get_absolute_url())
def bill_search_manager():
sm = SearchManager(Bill, connection="bill")
sm.add_option('similar_to', type="text", label="similar to (enter bill number)", visible_if=lambda form : False, filter=similar_to)
sm.add_option('usc_cite', type="text", label="cites", visible_if=lambda form : False, orm_field_name='usc_citations_uptree', filter=usc_cite)
sm.add_option('text', label='search title & full text', type="text", choices="NONE")
sm.add_option('congress', type="select", formatter=format_congress_number, sort="KEY-REVERSE")
sm.add_option('sponsor', type="select", sort="LABEL", formatter=lambda p : p.sortname)
sm.add_option('current_status', label="current status", sort=lambda s : BillStatus.by_value(s).sort_order)
sm.add_option('cosponsors', label="cosponsor", type="select", sort="LABEL", formatter=lambda p : p.sortname)
sm.add_option('committees', label="committee", type="select", sort="LABEL", formatter=lambda c : c.shortname)
sm.add_option('terms', type="select", label="subject", choices=get_terms(BillTerm.objects.exclude(parents__id__gt=0)))
sm.add_option('terms2', type="select", label="subject 2", choices=sub_terms, visible_if=lambda post:"terms" in post, filter=sub_term_filter)
sm.add_option('sponsor_party', label="party of sponsor", type="select")
sm.add_option('bill_type', label="bill or resolution type")
#sm.add_sort("Popularity", "-total_bets", default=True)
sm.add_sort("Secret Sauce", "-proscore", default=True)
sm.add_sort("Introduced Date (Newest First)", "-introduced_date")
sm.add_sort("Introduced Date (Oldest First)", "introduced_date")
sm.add_sort("Last Major Action (Recent First)", "-current_status_date")
#def safe_strftime(date, format):
# return date.replace(year=3456).strftime(format).replace("3456", str(date.year)).replace(" 12:00AM", "")
sm.set_template("""
<a href="{{object.get_absolute_url}}" style="font-size: 15px">{{object|truncatewords_html:50}}</a>
{% if object.sponsor %}<div>Sponsor: {{object.sponsor}}</div>{% endif %}
{% if object.source != "statutesatlarge" %}<div>Introduced: {{object.introduced_date}}</div>{% endif %}
{% if object.source != "americanmemory" %}<div>{% if object.source != "statutesatlarge" %}{{object.get_current_status_display}}{% else %}Enacted/Agreed to{% endif %}: {{object.current_status_date}}</div>{% endif %}
""")
return sm
def bill_search_manager():
sm = SearchManager(Bill, connection="bill", bulk_loader=bill_bulk_loader)
sm.add_option('similar_to', type="text", label="similar to (enter bill number)", visible_if=lambda form : False, filter=similar_to)
sm.add_option('usc_cite', type="text", label="cites", visible_if=lambda form : False, orm_field_name='usc_citations_uptree', filter=usc_cite)
sm.add_option('text', label='search title & full text', type="text", choices="NONE")
sm.add_option('congress', type="select", formatter=format_congress_number, sort="KEY-REVERSE")
sm.add_option('sponsor', type="select", sort="LABEL", formatter=lambda p : p.sortname)
sm.add_option('current_status', label="current status", sort=lambda s : BillStatus.by_value(s).sort_order)
sm.add_option('enacted_ex', type="boolean", label="Enacted \u2014 Including by Incorporation into Other Bills")
sm.add_option('cosponsors', label="cosponsor", type="select", sort="LABEL", formatter=lambda p : p.sortname)
sm.add_option('committees', label="committee", type="select", sort="LABEL", formatter=lambda c : c.shortname)
sm.add_option('terms', type="select", label="subject", choices=get_terms(BillTerm.objects.exclude(parents__id__gt=0)))
sm.add_option('terms2', type="select", label="subject 2", choices=sub_terms, visible_if=lambda post:"terms" in post, filter=sub_term_filter)
sm.add_option('sponsor_party', label="party of sponsor", type="select")
sm.add_option('bill_type', label="bill or resolution type")
#sm.add_sort("Popularity", "-total_bets", default=True)
# default sort order is handled by the view
sm.add_sort("Relevance of Title/Text", "relevance", func=lambda x : x) # no-op to use Solr default
sm.add_sort("Secret Sauce", "-proscore")
sm.add_sort("Introduced Date (Newest First)", "-introduced_date")
sm.add_sort("Introduced Date (Oldest First)", "introduced_date")
sm.add_sort("Last Major Action (Recent First)", "-current_status_date")
sm.add_sort("Cosponsors (Most First)", "-cosponsor_count")
sm.add_sort("Cosponsors (Fewest First)", "cosponsor_count")
#def safe_strftime(date, format):
# return date.replace(year=3456).strftime(format).replace("3456", str(date.year)).replace(" 12:00AM", "")
sm.set_template("""
<div class="row">
<div class="col-xs-2 col-md-1" style="padding-right: 0">
<img src="{{object.get_absolute_url}}/thumbnail?aspect=1.2&width=125" class="img-responsive"/>
</div>
<div class="col-xs-10 col-md-11">
<div style="margin-bottom: 3px"><a href="{{object.get_absolute_url}}" style="font-size: 15px; line-height: 125%;">{{object|truncatewords_html:50}}</a></div>
<div style="font-size: 90%">
{% if object.sponsor %}<div style="margin-bottom: 3px">Sponsor: {{object.sponsor_name}}</div>{% endif %}
<table width="100%"><tr valign="top">
{% if object.source != "statutesatlarge" %}<td width="25%" style="padding-right: 1.5em">Introduced<br>{{object.introduced_date}}</td>{% else %}<td/>{% endif %}
{% if object.source != "americanmemory" and object.get_current_status_display_simple != "Introduced" %}<td width="25%" style="padding-right: 1.5em">{% if object.source != "statutesatlarge" %}{{object.get_current_status_display_simple}}{% else %}Enacted/Agreed to{% endif %}<br>{{object.current_status_date}}</td>{% else %}<td/>{% endif %}
{% if 1 %}<td width="25%" style="padding-right: 1.5em">Cosponsors<br>{{object.cosponsor_counts_summary}}</td>{% else %}<td/>{% endif %}
{% if object.is_alive and object.get_prognosis %}<td width="25%" style="padding-right: 1.5em">Prognosis<br>{{object.get_prognosis.prediction|floatformat:0}}%</td>{% else %}<td/>{% endif %}
</tr></table>
{% with b_list=object.was_enacted_ex %}
{% for b in b_list %}
{% if b and b != object %}
<div>Enacted via <a href="{{b.get_absolute_url}}" style="text-decoration: none">{{b.title}}</a></div>
{% endif %}
{% endfor %}
</div>
</div>
</div>
{% endwith %}
""")
return sm
def bill_search_manager():
sm = SearchManager(Bill, connection="bill", bulk_loader=bill_bulk_loader)
sm.add_option('similar_to', type="text", label="similar to (enter bill number)", visible_if=lambda form : False, filter=similar_to)
sm.add_option('usc_cite', type="text", label="cites", visible_if=lambda form : False, orm_field_name='usc_citations_uptree', filter=usc_cite)
sm.add_option('text', label='search title & full text', type="text", choices="NONE")
sm.add_option('congress', type="select", formatter=format_congress_number, sort="KEY-REVERSE")
sm.add_option('sponsor', type="select", sort="LABEL", formatter=lambda p : p.sortname)
sm.add_option('current_status', label="current status", sort=lambda s : BillStatus.by_value(s).sort_order)
sm.add_option('enacted_ex', type="boolean", label="Enacted \u2014 Including by Incorporation into Other Bills")
sm.add_option('cosponsors', label="cosponsor", type="select", sort="LABEL", formatter=lambda p : p.sortname)
sm.add_option('committees', label="committee", type="select", sort="LABEL", formatter=lambda c : c.shortname)
sm.add_option('terms', type="select", label="subject", choices=get_terms(BillTerm.objects.exclude(parents__id__gt=0)))
sm.add_option('terms2', type="select", label="subject 2", choices=sub_terms, visible_if=lambda post:"terms" in post, filter=sub_term_filter)
sm.add_option('sponsor_party', label="party of sponsor", type="select")
sm.add_option('bill_type', label="bill or resolution type")
#sm.add_sort("Popularity", "-total_bets", default=True)
# default sort order is handled by the view
sm.add_sort("Secret Sauce", "-proscore")
sm.add_sort("Introduced Date (Newest First)", "-introduced_date")
sm.add_sort("Introduced Date (Oldest First)", "introduced_date")
sm.add_sort("Last Major Action (Recent First)", "-current_status_date")
sm.add_sort("Cosponsors (Most First)", "-cosponsor_count")
sm.add_sort("Cosponsors (Fewest First)", "cosponsor_count")
#def safe_strftime(date, format):
# return date.replace(year=3456).strftime(format).replace("3456", str(date.year)).replace(" 12:00AM", "")
sm.set_template("""
<div class="row">
<div class="col-xs-2 col-md-1" style="padding-right: 0">
<img src="{{object.get_absolute_url}}/thumbnail?aspect=1.2&width=125" class="img-responsive"/>
</div>
<div class="col-xs-10 col-md-11">
<div style="margin-bottom: 3px"><a href="{{object.get_absolute_url}}" style="font-size: 15px; line-height: 125%;">{{object|truncatewords_html:50}}</a></div>
<div style="font-size: 90%">
{% if object.sponsor %}<div style="margin-bottom: 3px">Sponsor: {{object.sponsor_name}}</div>{% endif %}
<table width="100%"><tr valign="top">
{% if object.source != "statutesatlarge" %}<td width="25%" style="padding-right: 1.5em">Introduced<br>{{object.introduced_date}}</td>{% else %}<td/>{% endif %}
{% if object.source != "americanmemory" and object.get_current_status_display_simple != "Introduced" %}<td width="25%" style="padding-right: 1.5em">{% if object.source != "statutesatlarge" %}{{object.get_current_status_display_simple}}{% else %}Enacted/Agreed to{% endif %}<br>{{object.current_status_date}}</td>{% else %}<td/>{% endif %}
{% if 1 %}<td width="25%" style="padding-right: 1.5em">Cosponsors<br>{{object.cosponsor_counts_summary}}</td>{% else %}<td/>{% endif %}
{% if object.is_alive and object.get_prognosis %}<td width="25%" style="padding-right: 1.5em">Prognosis<br>{{object.get_prognosis.prediction|floatformat:0}}%</td>{% else %}<td/>{% endif %}
</tr></table>
{% with b_list=object.was_enacted_ex %}
{% for b in b_list %}
{% if b and b != object %}
<div>Enacted via <a href="{{b.get_absolute_url}}" style="text-decoration: none">{{b.title}}</a></div>
{% endif %}
{% endfor %}
</div>
</div>
</div>
{% endwith %}
""")
return sm
def bill_search_manager():
sm = SearchManager(Bill, connection="bill")
sm.add_option('similar_to',
type="text",
label="similar to (enter bill number)",
visible_if=lambda form: False,
filter=similar_to)
sm.add_option('usc_cite',
type="text",
label="cites",
visible_if=lambda form: False,
orm_field_name='usc_citations_uptree',
filter=usc_cite)
sm.add_option('text',
label='search title & full text',
type="text",
choices="NONE")
sm.add_option('congress',
type="select",
formatter=format_congress_number,
sort="KEY-REVERSE")
sm.add_option('sponsor',
type="select",
sort="LABEL",
formatter=lambda p: p.sortname)
sm.add_option('current_status',
label="current status",
sort=lambda s: BillStatus.by_value(s).sort_order)
sm.add_option(
'enacted_ex',
type="boolean",
label=u"Enacted \u2014 Including by Incorporation into Other Bills")
sm.add_option('cosponsors',
label="cosponsor",
type="select",
sort="LABEL",
formatter=lambda p: p.sortname)
sm.add_option('committees',
label="committee",
type="select",
sort="LABEL",
formatter=lambda c: c.shortname)
sm.add_option('terms',
type="select",
label="subject",
choices=get_terms(
BillTerm.objects.exclude(parents__id__gt=0)))
sm.add_option('terms2',
type="select",
label="subject 2",
choices=sub_terms,
visible_if=lambda post: "terms" in post,
filter=sub_term_filter)
sm.add_option('sponsor_party', label="party of sponsor", type="select")
sm.add_option('bill_type', label="bill or resolution type")
#sm.add_sort("Popularity", "-total_bets", default=True)
# default sort order is handled by the view
sm.add_sort("Secret Sauce", "-proscore")
sm.add_sort("Introduced Date (Newest First)", "-introduced_date")
sm.add_sort("Introduced Date (Oldest First)", "introduced_date")
sm.add_sort("Last Major Action (Recent First)", "-current_status_date")
#def safe_strftime(date, format):
# return date.replace(year=3456).strftime(format).replace("3456", str(date.year)).replace(" 12:00AM", "")
sm.set_template("""
<a href="{{object.get_absolute_url}}" style="font-size: 15px; line-height: 125%;">{{object|truncatewords_html:50}}</a>
{% if object.sponsor %}<div>Sponsor: {{object.sponsor}}</div>{% endif %}
{% if object.source != "statutesatlarge" %}<div>Introduced: {{object.introduced_date}}</div>{% endif %}
{% if object.source != "americanmemory" %}<div>{% if object.source != "statutesatlarge" %}{{object.get_current_status_display}}{% else %}Enacted/Agreed to{% endif %}: {{object.current_status_date}}</div>{% endif %}
{% with b_list=object.was_enacted_ex %}
{% for b in b_list %}
{% if b and b != object %}
<div>Enacted via <a href="{{b.get_absolute_url}}">{{b.title}}</a></div>
{% endif %}
{% endfor %}
{% endwith %}
""")
return sm
#!script
from django.db.models import Count
import sys, csv
from bill.models import Cosponsor, Bill, BillStatus
bills_most_cosponsored = \
Cosponsor.objects \
.filter(bill__congress=114) \
.filter(withdrawn=None) \
.values("bill") \
.annotate(count=Count('id')) \
.order_by("-count") #\
#[0:200]
w = csv.writer(sys.stdout)
for bill_and_count in bills_most_cosponsored:
bill = Bill.objects.get(id=bill_and_count["bill"])
w.writerow([
bill_and_count["count"],
unicode(bill).encode("utf8"),
BillStatus.by_value(bill.current_status).label.encode("utf8"),
"https://www.govtrack.us" + bill.get_absolute_url(),
])
#!script
from django.db.models import Count
import sys, csv
from bill.models import Cosponsor, Bill, BillStatus
bills_most_cosponsored = \
Cosponsor.objects \
.filter(bill__congress=114) \
.filter(withdrawn=None) \
.values("bill") \
.annotate(count=Count('id')) \
.order_by("-count") #\
#[0:200]
w = csv.writer(sys.stdout)
for bill_and_count in bills_most_cosponsored:
bill = Bill.objects.get(id=bill_and_count["bill"])
w.writerow([
bill_and_count["count"],
str(bill).encode("utf8"),
BillStatus.by_value(bill.current_status).label.encode("utf8"),
"https://www.govtrack.us" + bill.get_absolute_url(),
])
