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)