def add_cohort(self, idnumber, name): exists = self.get_rows_in_table('cohort', idnumber=idnumber) if exists: self.default_logger('Did NOT create cohort {} as it already exists!'.format(idnumber)) return now = time_now() with DBSession() as session: cohort = Cohort() cohort.idnumber = idnumber cohort.name = name cohort.descriptionformat = 0 cohort.description = '' cohort.contextid = self.SYSTEM_CONTEXT cohort.source="psmdlsyncer" cohort.timecreated = time_now() cohort.timemodified = time_now() session.add(cohort)
def add_mrbs_editor(self, user_idnumber): user = self.wrap_no_result(self.get_user_from_idnumber, user_idnumber) if not user: # no such user, don't do it! return now = time_now() self.insert_table( 'role_assignments', contextid=self.SYSTEM_CONTEXT, roleid=self.MRBS_EDITOR_ROLE, userid=user.id, modifierid=2, # TODO: Admin ID, right? component='psmdlsyncer', # Might as well use it for something? itemid=0, sortorder=0, timemodified=now)