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