def test_create_child(self):
"""Does parent creation product the correct result?"""
testchild = create_child(fname="Johnny",
lname="Williams",
zipcode="94010",
household_id=2,
school_id=1,
grade_id=2)
self.assertEqual(testchild.fname, "Johnny")
self.assertEqual(type(testchild), Child)
def get_children():
"""Load children from dataset into database."""
with open("data/finaldata.csv", encoding='utf-8-sig') as children_data:
for r in enumerate(children_data):
data = r[1].split(',')
child_id, age_2021, date_missing, lname, fname, missing_age, city, county, state, gender, ethnicity, latitude, longitude = data
child_instance = crud.create_child(fname=fname, lname=lname, ethnicity=ethnicity, date_missing=date_missing, missing_age=int(missing_age), age_2021=int(age_2021))
location_instance = crud.create_location(child_id=child_instance.child_id, state=state, city=city, county=county)
def create_child():
print("In server.py create childfunction")
query_str_data = request.get_json()
print("In server.py - create child ", query_str_data)
child_fname = query_str_data['childFname'],
child_lname = query_str_data['childLname'],
grade = query_str_data['grade'],
school_id = query_str_data['schoolId'],
parent_id = query_str_data['parentId'],
try:
result = crud.create_child(child_fname, child_lname, grade, school_id,
parent_id)
return jsonify([result.id, child_fname])
except:
result = "Error inserting child"
return result
def add_child():
if 'loggedin' in session:
user = crud.get_user_by_id(session['id'])
if request.method == 'GET':
interests = Interest.query.all()
return render_template('add_child.html',
user=user,
interests=interests,
name=session['name'])
if request.method == 'POST':
child_name = request.form['child_name']
birthdate = request.form['birthdate']
gender = request.form['gender']
interests = request.form.getlist('interests[]')
photo = request.form.get('child_photo')
add_child = crud.create_child(child_name, birthdate, gender, photo)
db.session.add(add_child)
for i in interests:
interest = db.session.query(Interest).filter_by(
interest_id=i).first()
add_child.interests.append(interest)
user.children.append(add_child)
db.session.commit()
flash("Child added")
return redirect(url_for('profile'))
flash('Please login')
return redirect('/login')
for user in user_data:
first_name, last_name, email, username, password, zipcode, photo = (user['first_name'], user['last_name'],
user['email'], user['username'], user['password'], user['zipcode'], user['photo'])
db_user = crud.create_user(first_name, last_name, email, username, password, zipcode, photo)
users_in_db.append(db_user)
with open('data/child_data.json') as d:
child_data = json.loads(d.read())
child_in_db = []
for child in child_data:
child_name, birthdate, gender, photo = (child['child_name'], child['birthdate'], child['gender'], child['photo'])
db_child = crud.create_child(child_name, birthdate, gender, photo)
child_in_db.append(db_child)
with open('data/materials_info.json') as c:
materials = json.loads(c.read())
materials_in_db = []
for material in materials:
material_name, material_cost, material_url = (material['material_name'], material['material_cost'], material['material_url'])
db_material = crud.create_material(material_name, material_cost, material_url)
materials_in_db.append(db_material)
with open('data/time_period.json') as z:
prefer_same_school_only = fake.boolean(chance_of_getting_true=50)
prefer_same_grade_only = fake.boolean(chance_of_getting_true=50)
prefer_outdoors_only = fake.boolean(chance_of_getting_true=50)
prefer_periodic_covid_testing = fake.boolean(chance_of_getting_true=50)
max_budget_per_hour = randrange(0, 5)
if k < 12:
new_child = crud.create_child(
fname=fname,
lname=lname,
zipcode=zipcode,
gender="Female",
school_id=school_id,
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)
else:
new_child = crud.create_child(
fname=fname,
lname=lname,
zipcode='94010',
gender="Male",
school_id=school_id,
parent[10],
parent[11],
)
# Call create_parent function from crud.py
db_parent = crud.create_parent(parent_fname, parent_lname, \
email, phone, address1, address2, \
city, state, zipcode, last_login, \
created_on, password)
########### CHILDREN DATA
# Load children data from JSON file generated using Faker
with open('data/children.json') as f:
children_info = json.loads(f.read())
# Create & load child
for child in children_info:
# Unpack the values & send as a list to create a record in the backend db
child_fname, child_lname, grade, \
school_id, parent_id = (child[0],
child[1],
child[2],
child[3],
child[4]
)
# Call create_child function from crud.py
db_child = crud.create_child(child_fname, child_lname, \
grade, school_id, parent_id)