def put_websites(websites):
"""
adds Website records to DB from a list of xml website tags
Keyword arguments:
websites -- list of website xml tags
no return
"""
group_list = []
website_list = []
if websites is not None:
for website in websites:
url = get_text(website.find('url'))
group = get_text(website.find('group'))
group = Faculty4.addResearchGroup(group)
group_list.append(group)
authors = website.findall('author')
author_list = put_names(authors)
website_list.append(Faculty4.addWebsite(url, group, author_list))
for g in group_list:
db.put(g)
return website_list
def put_writings(person_handle, writings):
"""
makes DB Writing objects, associating them with their person
Keyword arguments:
person_handle -- person that owns these courses
writings -- list of writings to associate with person
no return
"""
for writing in writings:
title = get_text(writing.find('title'))
w_type = get_text(writing.find('writing'))
publish_info_list = []
publish_infos = writing.findall('publish_info')
for publish_info in publish_infos:
if publish_info is not None:
publisher = get_text(publish_info.find('publisher'))
publish_date = get_text(publish_info.find('publish_date'))
article = publish_info.find('article')
if article is not None:
journal = get_text(article.find('journal'))
edition = get_text(article.find('edition'))
article = Faculty4.addArticle(journal, edition)
isbn = publish_info.find('isbn')
if isbn is not None:
isbn = get_text(isbn)
publish_info_list.append(Faculty4.addPublishInfo(publisher, publish_date, isbn, article))
authors = writing.findall('author')
author_list = put_names(authors)
writing = Faculty4.addWriting(title, w_type, author_list, publish_info_list)
Faculty4.associatePersonWithWriting(person_handle, writing)
def put_person(person):
"""
pulls xml 'name', 'email', 'username', and 'title' or 'status'
from 'person', makes DB Faculty or Student Object
Keyword arguments:
person -- xml person tag
return reference to DB Faculty or Student object
"""
assert person.tag == 'faculty' or person.tag == 'student'
name = put_name(person.find('name'))
username = None
if person.find('username') is not None:
username = person.find('username').text
emails = person.findall('email')
emails = [email.text for email in emails]
if person.tag == 'faculty':
title = get_text(person.find('title'))
person_handle = Faculty4.addFaculty(name, emails, title, username)
elif person.tag == 'student':
status = get_text(person.find('status'))
person_handle = Faculty4.addStudent(name, emails, status, username)
return person_handle
def put_phone_numbers(phone_numbers):
"""
add a list of phone_numbers to the database, associating them with
a person
Keyword arguments:
phone_numbers -- list of phone number xml tags
no return
"""
l = []
if phone_numbers is not None:
for phone_number in phone_numbers:
phone_t = get_text(phone_number.find('phone_t'))
number = get_text(phone_number.find('number'))
country_code = phone_number.find('country_code')
if country_code is not None:
country_code = country_code.text
else:
country_code = '01'
area_code = phone_number.find('area_code')
if area_code is not None:
area_code = area_code.text
else:
area_code = '512'
l.append(Faculty4.addPhoneNumber(phone_t, number, country_code, area_code))
return l
def put_name(name):
"""
creates a name object in the database
Keyword arguments:
name -- the xml tag 'name' (of a person)
return reference to Name class db object
"""
#cannot be None since required
first_name = get_text(name.find('first_name'))
last_name = get_text(name.find('last_name'))
#can be None
middle_name = name.find('middle_name')
suffix = name.find('suffix')
if middle_name is not None:
middle_name = get_text(middle_name)
if suffix is not None:
suffix = get_text(suffix)
assert first_name is not None and last_name is not None
return Faculty4.addName(first_name, last_name, middle_name, suffix)
def put_courses(courses):
"""
makes DB Course objects, associating them with their person
Keyword arguments:
person_handle -- person that owns these courses
courses -- list of courses to associate with person
no return
"""
l = []
for course in courses:
unique = get_text(course.find('unique_number'))
course_name = get_text(course.find('name'))
description = get_text(course.find('description'))
course_number = course.find('course_number')
field_of_study = get_text(course_number.find('field_of_study'))
short_number = get_text(course_number.find('short_number'))
semester = get_text(course.find('semester'))
year = get_text(course.find('year'))
staff_members = course.findall('staff')
staff = []
for person in staff_members:
name = put_name(person.find('person'))
hours = person.find('hours')
if hours is not None:
hours = put_event(hours)
db.put(hours)
staff.append(Faculty4.addStaffMember(name, hours))
schedule = course.find('schedule')
schedule = put_event(schedule)
db.put(schedule)
course_number = Faculty4.addCourseNumber(field_of_study, short_number)
db.put(course_number)
l.append(Faculty4.addCourse(unique, course_name, description, course_number, semester, year, staff, schedule))
return l
def put_advisees(person_handle, advisees):
for advisee in advisees:
name = put_name(advisee.find('name'))
email = get_text(advisee.find('email'))
status = get_text(advisee.find('status'))
username = advisee.find('username')
if username is not None:
username = get_text(username)
advisee = Faculty4.addStudent(name, [email], status, username, advisors = person_handle)
def put_conferences(conferences):
"""
makes DB Conference objects, associating them with their person
Keyword arguments:
person_handle -- person that owns these courses
conferences -- list of courses to associate person with
no return
"""
l = []
for conference in conferences:
conf = conference.find('conference')
date = get_text(conf.find('date'))
name = get_text(conf.find('name'))
conf_location = get_text(conf.find('conf_location'))
presentation_title = get_text(conference.find('presentation_title'))
conference = Faculty4.addConference(name, date, conf_location)
l.append(Faculty4.addPresentation(presentation_title, conference))
return l
def put_offices(offices):
"""
makes DB Office objects, associating them with their person
Keyword arguments:
person_handle -- person that owns these offices
offices -- list of offices to associate with person
no return
"""
l = []
for office in offices:
building = put_building(office.find('building'))
floor = get_text(office.find('floor'))
room = get_text(office.find('room'))
location = Faculty4.addLocation(building, floor, room)
l.append(Faculty4.addOffice(location))
return l
def put_research_areas(research_areas): """ make DB ResearchArea objects, associate them with their person Keyword arguments: research_areas -- list of research_area xml tags Return: list of objects """ l = [] if research_areas is not None: for research_area in research_areas: l.append(Faculty4.addResearchArea(get_text(research_area))) return l
def put_office_hour(event):
"""
makes DB Event objects, associating them with their ... association
Keyword arguments:
association -- thing (person, staff, or class maybe?) to associate with
event -- one event xml tag
return event
"""
location = put_location(event.find('location'))
schedule = put_schedule(event.find('schedule'))
return Faculty4.addOfficeHour(schedule, location)
def put_location(location):
"""
pulls xml 'floor' and 'room' from xml tag 'location', makes
Building DB object via function, associates it all together
in a DB Location object
Keyword arguments:
location -- xml tag 'location'
return reference to DB Location object
"""
building = put_building(location.find('building'))
floor = get_text(location.find('floor'))
room = get_text(location.find('room'))
return Faculty4.addLocation(building, floor, room)
def put_research_groups(research_groups): """ makes DB ResearchGroup objects, associating them with their person Keyword arguments: research_groups -- list of research_area xml tags Return: list of objects """ l = [] if research_groups is not None: for research_group in research_groups: l.append(Faculty4.addResearchGroup(get_text(research_group))) return l
def put_event(event):
"""
makes DB Event objects, associating them with their ... association
Keyword arguments:
association -- thing (person, staff, or class maybe?) to associate with
event -- one event xml tag
return event
"""
event_type = get_text(event.find('event_type'))
location = put_location(event.find('location'))
schedule = put_schedule(event.find('schedule'))
return Faculty4.addEvent(event_type, schedule, location)
def put_building(building):
"""
pulls xml 'building_name' and 'building_abbr' from 'building, makes
DB Building object
Keyword arguments:
building -- xml building tag
return reference to DB Building object
"""
building_abbr = building.find('building_abbr')
if building_abbr is not None:
building_abbr = get_text(building_abbr)
building_name = get_text(building.find('building_name'))
return Faculty4.addBuilding(building_name, building_abbr)
def put_awards(awards):
"""
makes DB Award objects, associating them with their person
Keyword arguments:
awards -- list of award xml tags
Return:
list of awards that have not been put
"""
l = []
if awards is not None:
for award in awards:
name = get_text(award.find('name'))
date_awarded = get_text(award.find('date_awarded'))
l.append(Faculty4.addAward(name, date_awarded))
return l
def put_degrees(degrees):
"""
makes DB Degree objects, associating them with their person
Keyword arguments:
degrees -- list of degree xml tags
Return:
list of degrees that have not been put
"""
l = []
if degrees is not None:
for degree in degrees:
date_awarded = get_text(degree.find('date_awarded'))
institution = get_text(degree.find('institution'))
degree_t = get_text(degree.find('degree_t'))
specialization = get_text(degree.find('specialization'))
l.append(Faculty4.addDegree(date_awarded, institution, degree_t, specialization))
return l
def put_schedule(schedule):
"""
pulls xml schedule sub-things from schedule, makes DB Schedule object
Keyword arguments:
building -- xml schedule tag
return reference to DB Schedule object
"""
start_time = get_text(schedule.find('start_time'))
end_time = get_text(schedule.find('end_time'))
days = schedule.findall('day')
day_list = []
for day in days:
day_list.append(get_text(day))
start_date = get_text(schedule.find('start_date'))
end_date = schedule.find('end_date')
if end_date is not None:
end_date = get_text(end_date)
return Faculty4.addSchedule(start_date, start_time, day_list, end_time, end_date)