def create_request(agency_name):
"""
returns unsaved!
"""
language, ntn, govt = get_defaults()
govt = get_or_create_us_govt(agency_name, 'city')
agency, created = Agency.objects.get_or_create(name=agency_name,
government=govt)
contact = Contact.objects.get_or_create(first_name='FOIA Officer',
last_name=agency_name)
# if a query returns, get contact out of response tuple
if type(contact) == tuple:
contact = contact[0]
agency.save()
request = Request.objects.create(author_id=me.id,
government_id=govt.id,
agency_id=agency.id,
text=req.text,
free_edit_body=req.free_edit_body,
title=req.title)
contact.agency_related_contacts.add(agency)
request.contacts.add(contact)
return request
def create_mdrange_contacts():
language, ntn, govt = get_defaults()
govt = get_or_create_us_govt('California', 'state')
agency, created = Agency.objects.get_or_create(name="California Department of Public Health", government=govt)
contact, created = Contact.objects.get_or_create(first_name='default', middle_name='', last_name='contact')
contact.save()
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='Ken', middle_name='', last_name='August')
contact.save()
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
def update_california_contacts(local=True):
wb = xlrd.open_workbook(filename=os.path.join(settings.SITE_ROOT, 'apps/contacts/data/ca-state-contacts.xlsx'))
sheet_names = [u'FOIA Contacts',]
language, ntn, govt = get_defaults()
govt = get_or_create_us_govt('California', 'state')
for sn in sheet_names:
sh = wb.sheet_by_name(sn)
num_rows = sh.nrows - 1
row = 0#header
while row < num_rows:
row += 1
create_ca_contact(sh, row, govt)
def create_test_contacts():
language, ntn, govt = get_defaults()
agency, created = Agency.objects.get_or_create(name='THE TEST AGENCY', government=govt)
contact, created = Contact.objects.get_or_create(first_name='shane', middle_name='allen',
last_name='shifflett')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='Another', middle_name='allen',
last_name='Shane')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='coulter', middle_name='x',
last_name='jones')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='mike', middle_name='x',
last_name='corey')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='Djordje', middle_name='x',
last_name='Padejski')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='David', middle_name='x',
last_name='Suriano')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
contact, created = Contact.objects.get_or_create(first_name='Steven', middle_name='x',
last_name='Melendez')
if created:
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
def update_federal_contacts(local=True):
'''
if not local:
obj = requests.get('http://www.foia.gov/full-foia-contacts.xls')
wb = xlrd.open_workbook(file_contents=obj.content)
'''
wb = xlrd.open_workbook(filename=os.path.join(settings.SITE_ROOT, 'apps/contacts/data/updated-federal.xls'))
sheet_names = [u'Agencies', 'Departments']
#lvl, created = GovernmentLevel.objects.get_or_create(name="Admin 0 (National)", hierarchy_level=4)
language, ntn, govt = get_defaults()
for sn in sheet_names:
sh = wb.sheet_by_name(sn)
num_rows = sh.nrows - 1
print 'numrows=%s' % num_rows
row = 0#header
while row < num_rows:
row += 1
create_contact(sh, row, govt)
print 'row=%s sheet=%s' % (row, sn)
def create_msmith_contacts():
language, ntn, govt = get_defaults()
govt = get_or_create_us_govt('The City and County of San Francisco', 'city')
agency, created = Agency.objects.get_or_create(name="Mayor's Office on Economic and Work Development", government=govt)
contact, created = Contact.objects.get_or_create(first_name='Myisha', middle_name='', last_name='Hervey')
contact.save()
contact.add_email('*****@*****.**')
contact.add_phone('415.554.6969')
agency.contacts.add(contact)
agency, created = Agency.objects.get_or_create(name="Office of Community Investment and Infrastructure", government=govt)
contact, created = Contact.objects.get_or_create(first_name='Natasha', middle_name='', last_name='Jones')
contact.save()
contact.add_email('*****@*****.**')
contact.add_phone('415.749.2458')
contact.add_phone('fax:415.749.2525')
agency.contacts.add(contact)
agency, created = Agency.objects.get_or_create(name="CEQA and Central Records Public Records Requests", government=govt)
contact, created = Contact.objects.get_or_create(first_name='Stanley', middle_name='', last_name='Muraoka')
contact.save()
contact.add_email('*****@*****.**')
contact.add_phone('415-749-2577')
agency.contacts.add(contact)
agency, created = Agency.objects.get_or_create(name="CEQA and Central Records Public Records Requests", government=govt)
contact, created = Contact.objects.get_or_create(first_name='Stanley', middle_name='', last_name='Muraoka')
contact.save()
contact.add_email('*****@*****.**')
contact.add_phone('415-749-2577')
agency.contacts.add(contact)
agency, created = Agency.objects.get_or_create(name="Mayor's Sunshine/FOIA Office", government=govt)
contact, created = Contact.objects.get_or_create(first_name='NA', middle_name='', last_name='NA')
contact.save()
contact.add_email('*****@*****.**')
agency.contacts.add(contact)
# IPython log file
import csv
from apps.government.utils import get_defaults, get_or_create_us_govt
from apps.agency.models import Agency
from apps.contacts.models import Contact
from apps.contacts.models import EmailAddress
from apps.users.models import User
from apps.requests.models import Request
from django.conf import settings
me = User.objects.get(username='******')
language, ntn, govt = get_defaults()
govt = get_or_create_us_govt('All Elementary/High School Employees', 'city')
agency, created = Agency.objects.get_or_create(
name='All Elementary/High School Employees', government=govt)
contact, created = Contact.objects.get_or_create(first_name='FOIA',
middle_name='',
last_name='Officer')
contact.add_email('NA')
agency.contacts.add(contact)
agency.creator_id = me.id
contact.save()
agency.save()
req = Request.objects.get(id=1)
request = Request.objects.create(author_id=me.id,
government_id=govt.id,
agency_id=agency.id,
text=req.text,
free_edit_body=req.free_edit_body,
title=req.title)
