def index(): if request.method == 'POST': name = request.form['name'] brand = request.form['brand'] price = request.form['price'] color = request.form['color'] quantity = request.form['quantity'] if request.form['propietario']: propietario = request.form['propietario'] db.session.add( Smartphone(name=name, brand=brand, price=price, color=color, quantity=quantity, propietario=propietario)) else: db.session.add( Smartphone(name=name, brand=brand, price=price, color=color, quantity=quantity)) db.session.commit() smartphones = Smartphone.query.all() personas = Persona.query.all() return render_template('index.html', smartphones=smartphones, personas=personas)
def seed_db(): """sembrando la base de datos""" db.session.add( Smartphone(name='IPhone5', brand="IPhone", price="950", quantity="5", color="white")) db.session.add( Smartphone(name='LG-g3', brand="LG", price="650", quantity="15", color="black")) db.session.commit()
def add_smartphone(): post_data = request.get_json() response_object = {'estado': 'falló', 'mensaje': 'Datos no validos.'} if not post_data: return jsonify(response_object), 400 name = post_data.get('name') brand = post_data.get('brand') price = post_data.get('price') quantity = post_data.get('quantity') color = post_data.get('color') try: smartphone = Smartphone.query.filter_by(brand=brand).first() if not smartphone: db.session.add( Smartphone(name=name, brand=brand, price=price, quantity=quantity, color=color)) db.session.commit() response_object['estado'] = 'satisfactorio' response_object['mensaje'] = f'{brand} fue agregado!!!' return jsonify(response_object), 201 else: response_object['mensaje'] = 'Disculpe, ese smartphone ya existe.' return jsonify(response_object), 400 except exc.IntegrityError as e: db.session.rollback() return jsonify(response_object), 400
def add_smartphone(name, brand, price, color, quantity): smartphone = Smartphone(name=name, brand=brand, price=price, color=color, quantity=quantity) db.session.add(smartphone) db.session.commit() return smartphone
def index(): if request.method == 'POST': name = request.form['name'] brand = request.form['brand'] price = request.form['price'] db.session.add(Smartphone(name=name, brand=brand, price=price)) db.session.commit() smartphones = Smartphone.query.all() return render_template('index.html', smartphones=smartphones)
def add_smartphone_with_propietario(name, brand, price, color, quantity, propietario): smartphone = Smartphone(name=name, brand=brand, price=price, color=color, quantity=quantity, propietario=propietario) db.session.add(smartphone) db.session.commit() return smartphone
def add_smartphones(): post_data = request.get_json() response_object = {'status': 'fail', 'message': 'carga invalida.'} if not post_data: return jsonify(response_object), 400 name = post_data.get('name') brand = post_data.get('brand') price = post_data.get('price') color = post_data.get('color') quantity = post_data.get('quantity') propietario = post_data.get('propietario') try: smartphone = Smartphone.query.filter_by(name=name, brand=brand).first() if not smartphone: if propietario: db.session.add( Smartphone(name=name, brand=brand, price=price, color=color, quantity=quantity, propietario=propietario)) response_object['message'] = f'{name}, marca {brand} a sido '\ 'agregado con propietario!!' else: db.session.add( Smartphone(name=name, brand=brand, price=price, color=color, quantity=quantity)) response_object['message'] = f'{name}, marca {brand} a sido '\ 'agregado sin propietario!!' db.session.commit() response_object['status'] = 'success' return jsonify(response_object), 201 else: response_object['message'] = 'Lo siento. '\ 'Este smartphone ya existe.' return jsonify(response_object), 400 except exc.IntegrityError as e: db.session.rollback() return jsonify(response_object), 400
def seed_db(): """Sembrando la base de datos.""" db.session.add( Persona(name='Yerman', lastname='Aguirre', age=22, gender='M')) db.session.add( Persona(name='Deyvis', lastname='Garcia', age=23, gender='M')) db.session.add( Smartphone(name='Samsung J2', brand='Samsung Galaxy', price=1200, color='Amarillo', quantity=10, propietario=1)) db.session.add( Smartphone(name='Nokia 360', brand='Nokia', price=300, color='Verde', quantity=10, propietario=1)) db.session.commit()
def seed_db(): """sembrando la base de datos""" db.session.add(Smartphone(name='Prueba01', brand="marca01", price=100)) db.session.add(Smartphone(name='Prueba02', brand="marca0", price=200)) db.session.commit()
def add_smartphone(name, brand, price): smartphone = Smartphone(name=name, brand=brand, price=price) db.session.add(smartphone) db.session.commit() return smartphone