def removeChild(self,**kw): id = int(kw['id']) try: Child.get(id).removeUser(identity.current.user) except: pass if identity.current.user.childList.count() == 0: cherrypy.status = 500 return dict()
def test_child_bulk_save_objects(): parent1, parent2 = Parent.objects.all() children1 = [Child(parent_id=parent1.id) for _ in range(5)] children2 = [Child(parent_id=parent2.id) for _ in range(16)] Child.bulk_save_objects(children1 + children2, return_defaults=True) assert Child.objects.filter(Child.parent_id == parent1.id).count() == 5 assert Child.objects.filter(Child.parent_id == parent2.id).count() == 16
def create_child(fname, lname, zipcode, school_id, grade_id, household_id, gender=None, school_program=None, distance_willing_to_travel=None, preferred_days_per_week=None, preferred_total_hours_per_day=None, prefer_paid_teacher=None, prefer_same_school_program_only=None, prefer_same_school_only=None, prefer_same_grade_only=None, prefer_outdoors_only=None, prefer_periodic_covid_testing=None, max_budget_per_hour=None): """Add a new child to the children table and return the child.""" child = Child(fname=fname, lname=lname, gender=gender, zipcode=zipcode, school_id=school_id, school_program=school_program, grade_id=grade_id, household_id=household_id, distance_willing_to_travel=distance_willing_to_travel, preferred_days_per_week=preferred_days_per_week, preferred_total_hours_per_day=preferred_total_hours_per_day, prefer_paid_teacher=prefer_paid_teacher, prefer_same_school_program_only=prefer_same_school_program_only, prefer_same_school_only=prefer_same_school_only, prefer_same_grade_only=prefer_same_grade_only, prefer_outdoors_only=prefer_outdoors_only, prefer_periodic_covid_testing=prefer_periodic_covid_testing, max_budget_per_hour=max_budget_per_hour) db.session.add(child) db.session.commit() return child
def get(self): mail = self.request.get("mail") name = self.request.get("name") child_id = self.request.get("child_id") if child_id: child = Child.get_by_id(child_id) else: child = None if mail: parent = Parent.get_by_id(mail) if parent: parent.parent_id = mail parent.name = name if child_id: parent.child = child parent.put() ret = parent.to_dict() else: ret = {"status": "no record"} else: ret = {"status": "no key"} json_string = json.dumps(ret, ensure_ascii=False) self.response.content_type = "application/json" self.response.out.write(json_string)
def create_child(parent_id): """Create a child""" # Check parent parent = Parent.query.get(parent_id) if not parent: return {"error": "Parent not found"}, 404 # Handle input data try: json_data = request.get_json() except: return {"error": "Invalid input data"}, 400 if not json_data: return {"error": "No input data provided"}, 400 # Validate input data try: data = child_schema.load(json_data) except ValidationError as err: return err.messages, 422 first_name = data["first_name"] last_name = data["last_name"] child = Child(first_name, last_name, parent_id) db.session.add(child) db.session.commit() return child_schema.dump(child), 201
def deleteAssessment(self, **kw): id = int(kw['id']) try: scores = Assessment.get(id).scores for s in scores: Score.delete(s.id) Assessment.delete(id) except SQLObjectNotFound: pass if len(Child.get(cherrypy.session['current_child']).assessments) == 0: print "*****" print len(Child.get(cherrypy.session['current_child']).assessments) cherrypy.response.status = 500 return dict()
def get(self): child_id = self.request.get("child_id") name = self.request.get("name") if child_id: child = Child.get_by_id(child_id) if child: ret = {"status": "record already exists"} else: key = Child(id=child_id, child_id=child_id, name=name).put() child = key.get() ret = child.to_dict() else: ret = {"status": "no key"} json_string = json.dumps(ret, ensure_ascii=False) self.response.content_type = "application/json" self.response.out.write(json_string)
def create_child(child_name, birthdate, gender, photo): """Create and return a new user.""" child = Child(child_name=child_name, birthdate=birthdate, gender=gender, photo=photo) db.session.add(child) db.session.commit() return child
def childUpdate(self, **kw): field = str(kw['field']) type = kw['type'] id = cherrypy.session['current_child'] if type == 'string': value = str(kw['value']) elif type == 'int': value = int(kw['value']) elif type == 'date': value = str(kw['value']) display = value if field == 'ssid': if not value.isdigit(): cherrypy.response.status = 412 return "SSID must be all digits" if len(value) < 8 or len(value) > 10: cherrypy.response.status = 412 return "SSID must be between 8 and 10 digits" if Child.selectBy(ssid=value).count() > 0: cherrypy.response.status = 412 return "SSID already exists" if field == 'bdate': try: value = util.valiDate(value) except: cherrypy.response.status = 412 return "Invalid date entered" if value is None: cherrypy.response.status = 412 return "Invalid date entered" display = value.strftime("%m/%d/%y") Child.get(id).__setattr__(field, value) return display
def get(self): child_id = self.request.get("child_id") name = self.request.get("name") ret = [] if child_id: child = Child.get_by_id(child_id) if child: ret.append(child.to_dict()) elif name: query = Child.query(Child.name == name) for c in query: ret.append(c.to_dict()) else: query = Child.query() for c in query: ret.append(c.to_dict()) json_string = json.dumps(ret, ensure_ascii=False) self.response.content_type = "application/json" self.response.out.write(json_string)
def index(self, id=None): id = util.session('current_child', 0, id) if id == 0: # no id given raise redirect("/") try: current_child = Child.get(id) except SQLObjectNotFound: # Child with given id does not exist raise redirect("/") return dict(child=current_child, shaded=util.shaded)
def get(self): child_id = self.request.get("child_id") if child_id: child = Child.get_by_id(child_id) if child: ret = child.to_dict() else: ret = {"status": "no record"} else: ret = {"status": "no key"} json_string = json.dumps(ret, ensure_ascii=False) self.response.content_type = "application/json" self.response.out.write(json_string)
def add_child(): if request.method == "POST": childs_name = request.form.get('childs_name') childs_age = request.form.get('childs_age') zipcode = request.form.get('zipcode') #parent_id = Child.query.filter_by(parents.parent_id==parent_id).first() new_child = Child(childs_name=childs_name, childs_age=childs_age, zipcode=zipcode) db.session.add(new_child) db.session.commit() childs_id = new_child.childs_id session["childs_id"] = childs_id return redirect(f'/children/{new_child.childs_id}')
def create_child(child_fname, child_lname, grade, school_id, parent_id): """Create and return a new CHILD """ print("In crud.py - create child ", child_fname, child_lname, grade, school_id, parent_id) child = Child(child_fname = child_fname, child_lname = child_lname, grade = grade, school_id = school_id, parent_id = parent_id ) db.session.add(child) db.session.commit() return child
def test_update(): parent = Parent() parent.save() assert parent.id != None assert Parent.objects.count() == 4 # Update child = Child() child.save() assert child.parent_id is None child.parent_id = parent.id child.save() assert Child.objects.count() == 22 assert child.parent_id == parent.id
def create_child(fname, lname, ethnicity, date_missing, missing_age, age_2021): # """Create and return a new child. # e.g. # >>>create_child(fname='Alex', lname='Jones', ethnicity='Hispanic', missing_age=2, age_2021=18) # <Child name=Alex Jones missing_age=2> # """ new_child = Child(fname=fname, lname=lname, ethnicity=ethnicity, date_missing=date_missing, missing_age=missing_age, age_2021=age_2021) db.session.add(new_child) db.session.commit() return new_child
def load_children(): """Load chidlren from c.user into database.""" print("Children") # Delete all rows in table, so if we need to run this a second time, # Read u.user file and insert data for row in open("data/c.user"): row = row.rstrip() childs_id, childs_name, childs_age, zipcode, parent_id = row.split("|") child = Child(childs_id=childs_id, childs_name=childs_name, childs_age=childs_age, zipcode=zipcode) # We need to add to the session or it won't ever be stored db.session.add(child) # commiting work db.session.commit()
def test_type_error_bulk_save_objects(): with pytest.raises(TypeError): Child.bulk_save_objects([Parent(), Child()])