def schools(request): """ Ajax: School autcomplete form field """ if request.is_ajax() and request.method == 'POST' and request.POST.has_key('q'): query = request.POST.get('q') schools = School.objects.filter(name__icontains=query).distinct() response = {} if len(schools) > 0: response['schools'] = [(school.pk, school.name) for school in schools] response['status'] = 'success' return HttpResponse(json.dumps(response), mimetype="application/json") elif request.method == 'POST': # for creating a new school from a form # create new school, hasn't been implemented yet new_school = School() a_school = UsdeSchool.objects.get(id=request.POST['school_id']) new_school.name = a_school.institution_name new_school.location = u"%s, %s" % (a_school.institution_city, a_school.institution_state) new_school.url = a_school.institution_web_address new_school.save() request.user.get_profile().school = new_school request.user.get_profile().save() response = {} return HttpResponse(json.dumps(response), mimetype="application/json") else: # render the browse-schools route response = {} response['schools'] = School.objects.order_by('-karma').all() return render(request, 'n_browse_schools.html', response) raise Http404
def create_school(): name = input('学校名字: ').strip() addr = input('学校地址: ').strip() school_list = [(obj.name, obj.addr) for obj in School.get_obj_list()] # 学校列表 if (name, addr) in school_list: print('\033[31;1m学校名 [%s], 学校地址[%s] 已存在\033[0m' % (name, addr)) else: school = School(name, addr) school.save() print('\033[33;1m学校[%s], 地址[%s] 创建成功\033[0m' % (name, addr))
def school2db(response): reader = csv.DictReader(StringIO(response.read().decode())) for row in reader: if row['LGA']: lga_name = ''.join(x.lower() for x in row['LGA'] if x.isalpha()) school_name = row['School_name'] post_code = str(row['Postcode']) latitude = str(row['Latitude']) longitude = str(row['Longitude']) school_type = str(row['Level_of_schooling']) school = School(lga_name, school_name, post_code, latitude, longitude, school_type) school.save()
def post(self, request): """ Create school record in database :param request: Key value pair data :return: status & respective message """ data = request.data try: school = School(**data) school.save() LOGGER.info("School created successfully") except Exception, error: LOGGER.error("Error:%s", str(error)) return Response({"status": "FAILED", "message": str(error)})
def create_school(): try: name = input('请输入学校名字:').strip() addr = input('请输入学校地址:').strip() school_name_list = [(obj.name, obj.addr) for obj in School.get_all_obj_list()] if (name, addr) in school_name_list: raise Exception( '\033[43;1m[%s] [%s]校区已经存在,不可重复创建,你有那么多学生吗?\033[0m' % (name, addr)) obj = School(name, addr) obj.save() status = True error = '' data = '\033[33;1m[%s] [%s]校区创建成功\033[0m' % (obj.name, obj.addr) except Exception as e: status = False error = str(e) data = '' return {'status': status, 'error': error, 'data': data}
def test_children_ask_for_leave_list(self): sch = School(school_name="_name1", classes_number=100) sch.save() twz = Classes(class_name="WeizhongTu", children_number=100,schoolkey=sch) twz.save() children = Children() children.Classeskey = twz children.nicename = "1" children.save() children2 = Children() children2.Classeskey = twz children2.nicename = "2" children2.stats= "路途中" children2.save() children3 = Children() children3.Classeskey = twz children3.nicename = "3" children3.stats= "已到达" children3.save() leave = Children_ask_for_leave() leave.begin_time = datetime.datetime.now() - datetime.timedelta(hours=10) leave.end_time = datetime.datetime.now() + datetime.timedelta(hours=10) leave.Childrenkey_id = 1 leave.save() print(leave.begin_time) print(datetime.datetime.now()) print(leave.end_time) classes = Classes.objects.get(pk=1) list = classes.children_ask_for_leave_list() list2 = classes.children_arrived_list() list3 = classes.children_road_list() count = list.count()+list2.count()+list3.count() self.assertEqual(list.count(), 1)
if r: return InvalidUrl(errorMsg) try: district = City.objects.filter(province__name = out['province']).filter(name=out['city']).filter(districts__name=out['district']) except DoesNotExist,e: errorMsg='无法在%s %s找到%s,%s' % (out['province'],out['city'],out['district'],e) return InvalidUrl(errorMsg) #检查是否是学校管理员电话 try: sa = SchoolAdministrator.objects.get(telephone = out[telephone]) except DoesNotExist,e: errorMsg='the current user is not a school administrator,only school administrators can create school' return InvalidUrl(errorMsg) school = School(address = out['address'],name = out['school_name'],status='EI') school.save() try: district.add(school) sa.add(school) except: errorMsg = 'can not add the current school to %s or %s' % (district.name,sa.name) return InvalidUrl(errorMsg) result = '成功注册学校:%s 责任人名字:%s 地区:%s,状态审核中,我们将尽快完成对该学校合法性的审核' % (out['school_name'],sa.name,district.name) #后台人员审核通过之后将学校状态置为审核通过 return RightResponse(result) def updateSchool(request): pass def querySchool(request):