예제 #1
0
def transform_to_triples(item):
    if isinstance(item, FacultyItem):
        return [
            Triple(item['code'], 'rdf:type', 'Faculty'),
            Triple(item['code'], 'name', item['name'])]
    elif isinstance(item, DepartmentItem):
        return [
            Triple(item['code'], 'rdf:type', 'Department'),
            Triple(item['code'], 'name', item['name']),
            Triple(item['code'], 'faculty', uri(item['faculty']['code']))]
    elif isinstance(item, CourseItem):
        return [
            Triple(item['code'], 'rdf:type', 'Course'),
            Triple(item['code'], 'name', item['name']),
            Triple(item['code'], 'department',
                   uri(item['department']['code']))]
    elif isinstance(item, CourseOverviewItem):
        subject = item['course']['code']
        return [
            Triple(subject, 'extent', item['extent']),
            Triple(subject, 'teaching_period', item['teaching_period']),
            Triple(subject, 'learning_outcomes',
                   item['learning_outcomes']),
            Triple(subject, 'content', item['content']),
            Triple(subject, 'prerequisites', item['prerequisites']),
            Triple(subject, 'study_materials', item['study_materials'])]
예제 #2
0
def get_all():
    """Return a list of user_ids of all users.

    """
    uids = []
    with pool.get_connection() as sc:
        triples = sc.query(Triple(None, 'rdf:type',
            uri('{0}#Person'.format(PEOPLE_BASE_URI))))
        for triple in triples:
            uid = triple.subject.split('#')[-1]
            uids.append(uid)
    return uids
예제 #3
0
 def test_get_friends_of_user_with_friends(self):
     self.sc.insert([
         Triple(
            uri('http://cos.alpha.sizl.org/people/ID#d-cfIOQH0r3RjGaaWPEYjL'),
            uri('http://cos.alpha.sizl.org/people#Friend'),
            uri('http://cos.alpha.sizl.org/people/ID#d8vrPqQH0r3QeEaaWPEYjL')),
        Triple(
            uri('http://cos.alpha.sizl.org/people/ID#d-cfIOQH0r3RjGaaWPEYjL'),
            uri('http://cos.alpha.sizl.org/people#Friend'),
            uri('http://cos.alpha.sizl.org/people/ID#d9JgtWQH0r3QBRaaWPEYjL')),
         Triple(
            uri('http://cos.alpha.sizl.org/people/ID#d-cfIOQH0r3RjGaaWPEYjL'),
            uri('http://cos.alpha.sizl.org/people#Friend'),
            uri('http://cos.alpha.sizl.org/people/ID#d81F3WQH0r3OK1aaWPEYjL'))
     ])
     friends = sorted(api.people.get_friends('d-cfIOQH0r3RjGaaWPEYjL'))
     expected = ['d81F3WQH0r3OK1aaWPEYjL', 'd8vrPqQH0r3QeEaaWPEYjL',
         'd9JgtWQH0r3QBRaaWPEYjL']
     self.assertEqual(expected, friends)
예제 #4
0
def get_courses_by_department(code):
    """Returns courses by given department as identified by department code.
    Department code is case sensitive

    """
    with pool.get_connection() as sc:
        triples = sc.query(Triple(None, "department", uri(code)))
        course_codes = [str(triple.subject) for triple in triples]

        courses = []
        for course_code in course_codes:
            course = get_course(course_code)
            courses.append(course)

        # Sort the list of courses by their code
        return sorted(courses, key=lambda course: course["code"])
예제 #5
0
 def transform_to_triples(self, item):
     if isinstance(item, CompletedCourseItem):
         subject = '{0}people/{1}/courses/completed/{2}'.format(
             CLOUDSIZZLE_RDF_NAMESPACE, self.asi_user_id, item['code'])
         user = '******'.format(
             ASI_PEOPLE_RDF_NAMESPACE, self.asi_user_id)
         return [
             Triple(subject, 'rdf:type', 'CompletedCourse'),
             Triple(subject, 'user', uri(user)),
             Triple(subject, 'code', item['code']),
             Triple(subject, 'name', item['name']),
             Triple(subject, 'cr', item['cr']),
             Triple(subject, 'ocr', item['ocr']),
             Triple(subject, 'grade', item['grade']),
             Triple(subject, 'date', item['date'].isoformat()),
             Triple(subject, 'teacher', item['teacher'])]
     elif isinstance(item, ModuleItem):
         raise DropItem("Modules are not needed in SIB: %s" % item)
예제 #6
0
def friends_to_rdf(user, friends):
    """Convert user's friends to a list of RDF triples.

    Arguments:
    user -- A dictionary representing user.
    friends -- List of dictionaries representing user's friends.

    Both user and friend dictionaries should be similar to those returned by
    asilib or cloudsizzle.api.people.get()

    """
    triples = []
    for friend in friends:
        triples.append(Triple(
            '{0}/ID#{1}'.format(RDF_BASE_URI, user['id']),
            '{0}#Friend'.format(RDF_BASE_URI),
            uri('{0}/ID#{1}'.format(RDF_BASE_URI, friend['id']))
        ))
    return triples
예제 #7
0
def get_departments_by_faculty(faculty_code):
    """Returns departments by a faculty.

    Arguments:
    faculty_code -- The code of the faculty whose departments are returned.
                    Faculty code is case sensitive.

    """
    with pool.get_connection() as sc:
        triples = sc.query(Triple(None, "faculty", uri(faculty_code)))
        department_ids = [str(triple.subject) for triple in triples]

        departments = []
        for department_id in department_ids:
            department = get_department_info(department_id)
            departments.append(department)

        # Sort the list of departments by their code
        return sorted(departments, key=lambda department: department["code"])
예제 #8
0
def get_completed_courses(user_id):
    """Returns the completed courses for the given user sorted by most recent
    completion first.

    """
    user_uri = '{0}/ID#{1}'.format(PEOPLE_BASE_URI, user_id)

    with pool.get_connection() as sc:
        all_completed_course_uris = set(triple.subject
            for triple in sc.query(
                Triple(None, 'rdf:type', 'CompletedCourse')))
        all_user_uris = set(triple.subject
            for triple in sc.query(Triple(None, 'user', uri(user_uri))))
        completed_course_uris = all_completed_course_uris & all_user_uris

        completed_courses = []
        for subject in completed_course_uris:
            completed_course = fetch_rdf_graph(
                subject, dont_follow=['user'])
            del completed_course['user']
            completed_courses.append(completed_course)

        return sorted(completed_courses, key=lambda item: item['date'],
            reverse=True)
예제 #9
0
    def setUp(self):
        self.trace_tracker = TraceTracker()
        self.sc = MockSIBConnection()
        mock('pool.POOL')
        mock('pool.POOL.acquire', tracker=self.trace_tracker, returns=self.sc)
        mock('pool.POOL.release', tracker=self.trace_tracker)

        # Basic ontology
        self.sc.insert([
            Triple(
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#Property')),
            Triple(
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#Property'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://www.w3.org/2000/01/rdf-schema#Class')),
            Triple(
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#Property'),
                uri('http://www.w3.org/2000/01/rdf-schema#subClassOf'),
                uri('http://www.w3.org/2000/01/rdf-schema#Resource')),
            Triple(
                uri('http://www.w3.org/2000/01/rdf-schema#Resource'),
                uri('http://www.w3.org/2000/01/rdf-schema#subClassOf'),
                uri('http://www.w3.org/2000/01/rdf-schema#Resource')),
            Triple(
                uri('http://www.w3.org/2000/01/rdf-schema#Class'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://www.w3.org/2000/01/rdf-schema#Class')),
            Triple(
                uri('http://www.w3.org/2000/01/rdf-schema#Class'),
                uri('http://www.w3.org/2000/01/rdf-schema#subClassOf'),
                uri('http://www.w3.org/2000/01/rdf-schema#Resource')),
            Triple(
                uri('http://www.w3.org/2000/01/rdf-schema#subClassOf'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#Property')),
            Triple(
                uri('http://www.w3.org/2000/01/rdf-schema#label'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#Property')),
        ])

        # People triples
        self.sc.insert([
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Person')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#website'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#username'),
                literal('testijannu15')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#updated_at'),
                literal('2009-08-14T15:04:46Z')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#status'),
                uri('http://cos.alpha.sizl.org/people#cb286efb-05ed-435a-87bf-3ac3263fd51d')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#cb286efb-05ed-435a-87bf-3ac3263fd51d'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Status')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#cb286efb-05ed-435a-87bf-3ac3263fd51d'),
                uri('http://cos.alpha.sizl.org/people#message'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people#cb286efb-05ed-435a-87bf-3ac3263fd51d'),
                uri('http://cos.alpha.sizl.org/people#changed'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#role'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#phone_number'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#name'),
                uri('http://cos.alpha.sizl.org/people#c811c0dd-2400-4bea-a89e-cc4d91af9380')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c811c0dd-2400-4bea-a89e-cc4d91af9380'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Name')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c811c0dd-2400-4bea-a89e-cc4d91af9380'),
                uri('http://cos.alpha.sizl.org/people#unstructured'),
                literal('Testi Jannu15')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c811c0dd-2400-4bea-a89e-cc4d91af9380'),
                uri('http://cos.alpha.sizl.org/people#given_name'),
                literal('Testi')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c811c0dd-2400-4bea-a89e-cc4d91af9380'),
                uri('http://cos.alpha.sizl.org/people#family_name'),
                literal('Jannu15')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#msn_nick'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#is_association'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#irc_nick'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#gender'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#description'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#birthdate'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#avatar'),
                uri('http://cos.alpha.sizl.org/people#d0b74e12-08df-4f2d-95c7-fef24a24d55e')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#d0b74e12-08df-4f2d-95c7-fef24a24d55e'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Avatar')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#d0b74e12-08df-4f2d-95c7-fef24a24d55e'),
                uri('http://cos.alpha.sizl.org/people#status'),
                literal('not_set')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#d0b74e12-08df-4f2d-95c7-fef24a24d55e'),
                uri('http://cos.alpha.sizl.org/people#link'),
                uri('http://cos.alpha.sizl.org/people#7502776b-5e2b-4b23-8851-1a1c8e402bb7')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#7502776b-5e2b-4b23-8851-1a1c8e402bb7'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Link')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#7502776b-5e2b-4b23-8851-1a1c8e402bb7'),
                uri('http://cos.alpha.sizl.org/people#rel'),
                literal('self')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#7502776b-5e2b-4b23-8851-1a1c8e402bb7'),
                uri('http://cos.alpha.sizl.org/people#href'),
                literal('/people/dn3FNGIomr3OicaaWPEYjL/@avatar')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#dn3FNGIomr3OicaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#address'),
                None),
        ])

        self.sc.insert([
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Person')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#website'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#username'),
                literal('aaatest4ivid')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#updated_at'),
                literal('2009-11-13T13:55:53Z')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#status'),
                uri('http://cos.alpha.sizl.org/people#fd3f5275-e946-4d4d-b46a-bd87af0f9c64')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#fd3f5275-e946-4d4d-b46a-bd87af0f9c64'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Status')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#fd3f5275-e946-4d4d-b46a-bd87af0f9c64'),
                uri('http://cos.alpha.sizl.org/people#message'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people#fd3f5275-e946-4d4d-b46a-bd87af0f9c64'),
                uri('http://cos.alpha.sizl.org/people#changed'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#role'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#phone_number'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#name'),
                uri('http://cos.alpha.sizl.org/people#e1a92c6a-9566-4385-800b-8e1f59155b56')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#e1a92c6a-9566-4385-800b-8e1f59155b56'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Name')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#e1a92c6a-9566-4385-800b-8e1f59155b56'),
                uri('http://cos.alpha.sizl.org/people#unstructured'),
                literal('testi hemmo')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#e1a92c6a-9566-4385-800b-8e1f59155b56'),
                uri('http://cos.alpha.sizl.org/people#given_name'),
                literal('testi')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#e1a92c6a-9566-4385-800b-8e1f59155b56'),
                uri('http://cos.alpha.sizl.org/people#family_name'),
                literal('hemmo')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#msn_nick'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#is_association'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#irc_nick'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#gender'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#description'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#birthdate'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#avatar'),
                uri('http://cos.alpha.sizl.org/people#c1939e3f-c9da-45b1-abc7-0a5536e199ac')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c1939e3f-c9da-45b1-abc7-0a5536e199ac'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Avatar')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c1939e3f-c9da-45b1-abc7-0a5536e199ac'),
                uri('http://cos.alpha.sizl.org/people#status'),
                literal('not_set')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#c1939e3f-c9da-45b1-abc7-0a5536e199ac'),
                uri('http://cos.alpha.sizl.org/people#link'),
                uri('http://cos.alpha.sizl.org/people#ee8cc93a-6c09-4b3a-b5ca-b2e200c7780f')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#ee8cc93a-6c09-4b3a-b5ca-b2e200c7780f'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Link')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#ee8cc93a-6c09-4b3a-b5ca-b2e200c7780f'),
                uri('http://cos.alpha.sizl.org/people#rel'),
                literal('self')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#ee8cc93a-6c09-4b3a-b5ca-b2e200c7780f'),
                uri('http://cos.alpha.sizl.org/people#href'),
                literal('/people/bbYJ_80fWr3Om4aaWPEYjL/@avatar')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#bbYJ_80fWr3Om4aaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#address'),
                None)
        ])
        self.sc.insert([
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#c0OzVoMZ0r3yhJaaWPEYjL'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Person')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#c0OzVoMZ0r3yhJaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#username'),
                literal('lassi')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#c0OzVoMZ0r3yhJaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#updated_at'),
                literal('2010-01-08T08:57:54Z')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#c0OzVoMZ0r3yhJaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#role'),
                None),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#c0OzVoMZ0r3yhJaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#name'),
                uri('http://cos.alpha.sizl.org/people#5aa1b375-c422-4829-96f9-14ad2a04544f')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#5aa1b375-c422-4829-96f9-14ad2a04544f'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                uri('http://cos.alpha.sizl.org/people#Name')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#5aa1b375-c422-4829-96f9-14ad2a04544f'),
                uri('http://cos.alpha.sizl.org/people#unstructured'),
                literal('Lassi Seppälä')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#5aa1b375-c422-4829-96f9-14ad2a04544f'),
                uri('http://cos.alpha.sizl.org/people#given_name'),
                literal('Lassi')),
            Triple(
                uri('http://cos.alpha.sizl.org/people#5aa1b375-c422-4829-96f9-14ad2a04544f'),
                uri('http://cos.alpha.sizl.org/people#family_name'),
                literal('Seppälä')),
            Triple(
                uri('http://cos.alpha.sizl.org/people/ID#c0OzVoMZ0r3yhJaaWPEYjL'),
                uri('http://cos.alpha.sizl.org/people#is_association'),
                None),
            ])

        # Course information
        self.sc.insert([
            Triple(
                uri('eri'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Faculty')),
            Triple(
                uri('eri'),
                uri('name'),
                literal('Other separate courses')),
            Triple(
                uri('eta'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Faculty')),
            Triple(
                uri('eta'),
                uri('name'),
                literal('Faculty of Electronics, Communications and Automation')),
            Triple(
                uri('ia'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Faculty')),
            Triple(
                uri('ia'),
                uri('name'),
                literal('Faculty of Engineering and Architecture')),
            Triple(
                uri('il'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Faculty')),
            Triple(
                uri('il'),
                uri('name'),
                literal('Faculty of Information and Natural Sciences')),
            Triple(
                uri('km'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Faculty')),
            Triple(
                uri('km'),
                uri('name'),
                literal('Faculty of Chemistry and Materials Sciences')),

            Triple(
                uri('IL-0'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('IL-0'),
                uri('name'),
                literal('Common courses for the faculty')),
            Triple(
                uri('IL-0'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3010'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3010'),
                uri('name'),
                literal('Department of Biomedical Engineering and Computational Science')),
            Triple(
                uri('T3010'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3020'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3020'),
                uri('name'),
                literal('Department of Mathematics and Systems Analysis')),
            Triple(
                uri('T3020'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3030'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3030'),
                uri('name'),
                literal('Department of Media Technology')),
            Triple(
                uri('T3030'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3040'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3040'),
                uri('name'),
                literal('Department of Engineering Physics')),
            Triple(
                uri('T3040'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3050'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3050'),
                uri('name'),
                literal('Department of Computer Science and Engineering')),
            Triple(
                uri('T3050'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3060'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3060'),
                uri('name'),
                literal('Department of Information and Computer Science')),
            Triple(
                uri('T3060'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3070'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3070'),
                uri('name'),
                literal('Department of Industrial Engineering and Management')),
            Triple(
                uri('T3070'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3080'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3080'),
                uri('name'),
                literal('BIT Research Centre')),
            Triple(
                uri('T3080'),
                uri('faculty'),
                uri('il')),
            Triple(
                uri('T3090'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Department')),
            Triple(
                uri('T3090'),
                uri('name'),
                literal('Language Centre')),
            Triple(
                uri('T3090'),
                uri('faculty'),
                uri('il')),

            Triple(
                uri('T-0.7050'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Course')),
            Triple(
                uri('T-0.7050'),
                uri('name'),
                literal('Introduction to Postgraduate Studies in Computer Science P')),
            Triple(
                uri('T-0.7050'),
                uri('department'),
                uri('T3050')),
            Triple(
                uri('T-0.7050'),
                uri('content'),
                literal('Basic research skills. The publishing process. Scientific presentations. Research areas in computer science.')),
            Triple(
                uri('T-0.7050'),
                uri('teaching_period'),
                literal('III-IV')),
            Triple(
                uri('T-0.7050'),
                uri('extent'),
                literal('2')),
            Triple(
                uri('T-0.7050'),
                uri('learning_outcomes'),
                literal('PProvide a basic understanding of the scientific process and of the research paradigms relevant to research. Provide guidelines and support for planning the Ph.D. work. Provide an understanding and experience of the publishing and peer-review process in the field.')),
            Triple(
                uri('T-106.1003'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Course')),
            Triple(
                uri('T-106.1003'),
                uri('name'),
                literal('IT Services at TKK')),
            Triple(
                uri('T-106.1003'),
                uri('department'),
                uri('T3050')),
            Triple(
                uri('T-106.1003'),
                uri('study_materials'),
                literal('Lecture notes, manuals.')),
            Triple(
                uri('T-106.1003'),
                uri('content'),
                literal('Basic computer terminology. Use of common applications in Unix, WWW and MS Windows environments.')),
            Triple(
                uri('T-106.1003'),
                uri('teaching_period'),
                literal('I (Autumn)')),
            Triple(
                uri('T-106.1003'),
                uri('extent'),
                literal('2')),
            Triple(
                uri('T-106.1003'),
                uri('learning_outcomes'),
                literal('Having completed this course you are familiar with the use of information systems at Helsinki University of Technology.')),
            Triple(
                uri('T-106.1003'),
                uri('prerequisites'),
                literal('None.')),
            Triple(
                uri('T-106.1041'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Course')),
            Triple(
                uri('T-106.1041'),
                uri('name'),
                literal('Tietotekniikan peruskurssi')),
            Triple(
                uri('T-106.1041'),
                uri('department'),
                uri('T3050')),
            Triple(
                uri('T-106.1041'),
                uri('study_materials'),
                literal('Luentomateriaali, nopassa jaettava materiaali')),
            Triple(
                uri('T-106.1041'),
                uri('content'),
                literal('Yleissivistävä katsaus tietotekniikan eri aihealueisiin.')),
            Triple(
                uri('T-106.1041'),
                uri('teaching_period'),
                literal('I - II')),
            Triple(
                uri('T-106.1041'),
                uri('extent'),
                literal('3')),
            Triple(
                uri('T-106.1041'),
                uri('learning_outcomes'),
                literal('Tietotekniikan keskeisten osa-alueiden tuntemus.')),
            Triple(
                uri('T-106.1041'),
                uri('prerequisites'),
                literal('Ei vaadita.')),
            Triple(
                uri('T-106.1043'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Course')),
            Triple(
                uri('T-106.1043'),
                uri('name'),
                literal('Information Technology - Basic Course')),
            Triple(
                uri('T-106.1043'),
                uri('department'),
                uri('T3050')),
            Triple(
                uri('T-106.1043'),
                uri('study_materials'),
                literal('Reed, David: "A Balanced Introduction to Computer Science" (2nd edition). Pearson Education, Upper Saddle River (NJ), Pearson Prentice Hall, ISBN 0-13-601722-3')),
            Triple(
                uri('T-106.1043'),
                uri('content'),
                literal('Computer science basics.')),
            Triple(
                uri('T-106.1043'),
                uri('teaching_period'),
                literal('I - II (Autumn)')),
            Triple(
                uri('T-106.1043'),
                uri('extent'),
                literal('3')),
            Triple(
                uri('T-106.1043'),
                uri('learning_outcomes'),
                literal('Having completed this course you are familiar with essential fields of computer science.')),
            Triple(
                uri('T-106.1043'),
                uri('prerequisites'),
                None),
            Triple(
                uri('T-106.1061'),
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('Course')),
            Triple(
                uri('T-106.1061'),
                uri('name'),
                literal('Tietotekniikan työkurssi')),
            Triple(
                uri('T-106.1061'),
                uri('department'),
                uri('T3050')),
            Triple(
                uri('T-106.1061'),
                uri('study_materials'),
                literal('Ilmoitetaan kurssin Noppa-sivulla: https://noppa.tkk.fi/noppa/kurssi/t-1... .')),
            Triple(
                uri('T-106.1061'),
                uri('content'),
                literal('Opiskelussa ja työelämässä yleisesti käytetyt toimistotyökalut, WWW-sivujen laatiminen ja ohjelmoinnin alkeet.')),
            Triple(
                uri('T-106.1061'),
                uri('teaching_period'),
                literal('III - IV')),
            Triple(
                uri('T-106.1061'),
                uri('extent'),
                literal('3')),
            Triple(
                uri('T-106.1061'),
                uri('learning_outcomes'),
                literal('Osaat käyttää monipuolisesti ja tehokkaasti opiskelu- ja työelämässä yleisesti käytettyjä toimistotyökaluja. Hallitset WWW-sivujen laatimisen sekä ohjelmoinnin alkeet.')),
            Triple(
                uri('T-106.1061'),
                uri('prerequisites'),
                literal('Ei vaadita.')),
        ])

        # Completed courses
        subject = uri('http://cloudsizzle.cs.hut.fi/ontology/people/d7TllUbOar34UjaaWPEYjL/courses/completed/T-106.5600')
        self.sc.insert([
            Triple(
                subject,
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('CompletedCourse')),
            Triple(
                subject,
                uri('name'),
                literal('Concurrent Programming P')),
            Triple(
                subject,
                uri('teacher'),
                literal('Heikki Saikkonen')),
            Triple(
                subject,
                uri('date'),
                literal('2009-12-21')),
            Triple(
                subject,
                uri('grade'),
                literal('5')),
            Triple(
                subject,
                uri('cr'),
                literal('5')),
            Triple(
                subject,
                uri('code'),
                literal('T-106.5600')),
            Triple(
                subject,
                uri('user'),
                uri('http://cos.alpha.sizl.org/people/ID#d7TllUbOar34UjaaWPEYjL')),
        ])
        subject = uri('http://cloudsizzle.cs.hut.fi/ontology/people/d7TllUbOar34UjaaWPEYjL/courses/completed/Mat-1.401')
        self.sc.insert([
            Triple(
                subject,
                uri('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'),
                literal('CompletedCourse')),
            Triple(
                subject,
                uri('name'),
                literal('Basic Course in Mathematics L 1')),
            Triple(
                subject,
                uri('teacher'),
                literal('Juhani Pitkäranta')),
            Triple(
                subject,
                uri('date'),
                literal('2004-12-14')),
            Triple(
                subject,
                uri('grade'),
                literal('2')),
            Triple(
                subject,
                uri('code'),
                literal('Mat-1.401')),
            Triple(
                subject,
                uri('ocr'),
                literal('6')),
            Triple(
                subject,
                uri('user'),
                uri('http://cos.alpha.sizl.org/people/ID#d7TllUbOar34UjaaWPEYjL'))
        ])