def create_school(): jsonData = request.get_json() with db.auto_commit(): school = School() school.school_name = jsonData['school_name'] school.school_address = jsonData['school_address'] db.session.add(school) return Success(msg='新增学校成功')
def csv_import(cls, reader): for row in csv.DictReader(reader): crypted_password = make_password(row['password']) school = School.key_for_sis_id(row['school_id']) student = cls.query(cls.sis_id == row['sis_id'], ancestor=school).get() if student is None: student = cls( parent=school, first_name=row['first_name'], last_name=row['last_name'], sis_id=row['sis_id'], grade_level=int(row['grade_level']), email=row['email'], crypted_password=crypted_password ) student.put() logging.info("inserted student: %s" % row) else: # cannot change student from one school to another? student.first_name = row['first_name'] student.last_name = row['last_name'] student.sis_id = row['sis_id'] student.grade_level = int(row['grade_level']) student.email = row['email'] student.crypted_password = crypted_password student.put() logging.info("updated student: %s" % row)
def csv_import(cls, reader): for row in csv.DictReader(reader): crypted_password = make_password(row['password']) school = School.key_for_sis_id(row['school_id']) student = cls.query(cls.sis_id == row['sis_id'], ancestor=school).get() if student is None: student = cls(parent=school, first_name=row['first_name'], last_name=row['last_name'], sis_id=row['sis_id'], grade_level=int(row['grade_level']), email=row['email'], crypted_password=crypted_password) student.put() logging.info("inserted student: %s" % row) else: # cannot change student from one school to another? student.first_name = row['first_name'] student.last_name = row['last_name'] student.sis_id = row['sis_id'] student.grade_level = int(row['grade_level']) student.email = row['email'] student.crypted_password = crypted_password student.put() logging.info("updated student: %s" % row)
def csv_import(cls, reader): for row in csv.DictReader(reader): school = School.key_for_sis_id(row['school_id']) teacher = cls.query(cls.sis_id == row['sis_id'], ancestor=school).get() if teacher is None: teacher = cls( parent=school, first_name=row['first_name'], last_name=row['last_name'], sis_id=row['sis_id'], location=row['location'], email=row['email'], is_admin=bool_from_string(row['admin']) ) teacher.put() logging.info("inserted teacher: %s" % row) else: # cannot change teacher from one school to another? teacher.first_name = row['first_name'] teacher.last_name = row['last_name'] teacher.sis_id = row['sis_id'] teacher.location = row['location'] teacher.email = row['email'] teacher.is_admin = bool(int(row['admin'])) teacher.put() logging.info("updated teacher: %s" % row)
def csv_import(cls, reader): for row in csv.DictReader(reader): school = School.key_for_sis_id(row['school_id']) teacher = cls.query(cls.sis_id == row['sis_id'], ancestor=school).get() if teacher is None: teacher = cls(parent=school, first_name=row['first_name'], last_name=row['last_name'], sis_id=row['sis_id'], location=row['location'], email=row['email'], is_admin=bool_from_string(row['admin'])) teacher.put() logging.info("inserted teacher: %s" % row) else: # cannot change teacher from one school to another? teacher.first_name = row['first_name'] teacher.last_name = row['last_name'] teacher.sis_id = row['sis_id'] teacher.location = row['location'] teacher.email = row['email'] teacher.is_admin = bool(int(row['admin'])) teacher.put() logging.info("updated teacher: %s" % row)
def csv_import(cls, reader): for row in csv.DictReader(reader): school = School.key_for_sis_id(row['school_id']) student_id = row['student_id'] if Student.query(Student.sis_id == student_id).count() == 0: logging.warn("no such student %s" % student_id) continue teacher_id = row['teacher_id'] if Teacher.query(Teacher.sis_id == teacher_id).count() == 0: logging.warn("no such teacher %s" % teacher_id) continue enrollment = cls( parent=school, student_id=student_id, teacher_id=teacher_id, course_id=row['course_id'], section_id=row['section_id'], period=row['period'], is_homeroom=bool_from_string(row['homeroom']), is_active=True ) enrollment.put() logging.info("inserted enrollment: %s" % row)