def load_data(): for planet in listplanets: new_planet = Planets() new_planet.name = planet["name"] new_planet.rotation_period = str(planet["rotation_period"]) new_planet.orbital_period = planet["orbital_period"] new_planet.diameter = planet["diameter"] new_planet.climate = planet["climate"] new_planet.gravity = planet["gravity"] new_planet.terrain = planet["terrain"] new_planet.surface_water = planet["surface_water"] new_planet.population = planet["population"] new_planet.url = planet["url"] db.session.add(new_planet) db.session.commit() for person in listpeople: new_person = People() new_person.name = person["name"] new_person.height = person["height"] new_person.hair_color = person["hair_color"] new_person.skin_color = person["skin_color"] new_person.eye_color = person["eye_color"] new_person.birth_year = person["birth_year"] new_person.gender = person["gender"] new_person.homeworld = person["homeworld"] new_person.url = person["url"] db.session.add(new_person) db.session.commit() response_body = {"msg": "loading... initial data to database... "} return jsonify(response_body), 200
def add_new_planet(): request_body = request.data new_planet = Planets() new_planet.name = request.json.get('name') new_planet.diameter = request.json.get('diameter') new_planet.rotation_period = request.json.get('rotation_period') new_planet.orbital_period = request.json.get('orbital_period') new_planet.gravity = request.json.get('gravity') new_planet.population = request.json.get('population') new_planet.climate = request.json.get('climate') new_planet.terrain = request.json.get('terrain') new_planet.surface_water = request.json.get('surface_water') new_planet.save() return jsonify(new_planet.serialize())