Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @app.route('/signup',methods=['POST'])
- def makeNewUser():
- data = json.loads(request.data.decode())
- firstName = data['firstName']
- lastName = data['lastName']
- email = data['email']
- password = hashlib.md5((data['password']).encode()).hexdigest()
- street = data['street']
- houseNumber = data['houseNumber']
- zipCode = data['zipCode']
- city = data['city']
- province = data['province']
- id_state = State.query.with_entities(State.id_state).filter_by(name=province).first() or 0
- if id_state == 0:
- insertState = State(province)
- db_session.add(insertState)
- db_session.commit()
- id_state = State.query.with_entities(State.id_state).filter_by(name=province).first()
- if id_state != 0:
- insertCity = City(id_state,city)
- db_session.add(insertCity)
- db_session.commit()
- id_city = City.query.with_entities(City.id_city).filter_by(name = city).first() or 0
- if id_city != 0:
- insertAddress = Address(street, houseNumber, zipCode, id_city)
- db_session.add(insertAddress)
- db_session.commit()
- id_mail = Login_info.query.with_entities(Login_info.mail).filter_by(mail = email).first() or 0
- if id_mail == 0:
- insertLoginInfo = Login_info(email,password,'0')
- db_session.add(insertLoginInfo)
- db_session.commit()
- id_address = Address.query.with_entities(Address.id_address).filter_by(street = street).filter_by(number = houseNumber).filter_by(city_code = zipCode).first() or 0
- if id_address != 0:
- insertUser = User(firstName,lastName,email,id_address)
- db_session.add(insertUser)
- db_session.commit()
- msg = Message(
- 'Make account',
- sender='best.ever.music.shop@gmail.com',
- recipients=
- [email])
- msg.body = "Your account has been made. Enjoy our store"
- mail.send(msg)
- return jsonify({'result' : True})
- @app.route('/reset',methods=['POST'])
- def reset():
- data = json.loads(request.data.decode())
- email = data['email']
- hash = data['hash']
- password = hashlib.md5(data['password'].encode()).hexdigest()
- email_db = Login_info.query.with_entities(Login_info.mail).filter_by(mail = email).first() or 0
- hash_db = Login_info.query.with_entities(Login_info.reset_hash).filter_by(reset_hash = hash).first() or 0
- if email == email_db[0] and hash == hash_db[0]:
- insertPassword = Login_info.query.filter_by(mail = email).first() or 0
- if insertPassword !=0:
- insertPassword.password = password
- insertPassword.reset_hash = 0
- db_session.commit()
- msg = Message(
- 'Password reset status',
- sender='best.ever.music.shop@gmail.com',
- recipients=
- [email])
- msg.body = "Your password has been reset"
- mail.send(msg)
- return jsonify({'result': True})
- else:
- return jsonify({'result': False})
- @app.route('/updatestatus',methods=['POST','GET'])
- def updateStatus():
- data = json.loads(request.data.decode())
- email = data['email']
- id_order = data['id_order']
- status ='send'
- msg = Message(
- 'Order status',
- sender='best.ever.music.shop@gmail.com',
- recipients=
- [email])
- msg.body = "Your order has been " + status
- mail.send(msg)
- insertStatus = Order.query.filter(Order.id_order == id_order).first()
- insertStatus.status = status
- db_session.commit()
- return jsonify({'result': True})
- @app.route('/makeneworder',methods=['POST','GET'])
- def makeNewOrder():
- data = json.loads(request.data.decode())
- email = data['email']
- date = data['date']
- cost = data['cost']
- status = 'accepted'
- msg = Message(
- 'Order status',
- sender='best.ever.music.shop@gmail.com',
- recipients=
- [email])
- msg.body = "Your order has been " + status
- mail.send(msg)
- id_user = db_session.query(User).with_entities(User.id_user).filter(User.mail == email).first()
- insertOrder = Order(id_user,date,cost,status)
- db_session.add(insertOrder)
- db_session.commit()
- return jsonify({'result': True})
- TO PONIŻEJ MUSISZ DODAĆ DO MODELU I JAK NAZWA W BAZIE SIE ROZNI TO ZMIENIC TA NAZWE W CIAPKACH
- class Order(Base):
- __tablename__ = 'Orders'
- id_order = db.Column('id_orders',db.Integer, primary_key=True)
- id_user = db.Column('id_user',db.Integer,db.ForeignKey('Users.id_user'))
- date = db.Column('date',db.DateTime,nullable=False)
- cost = db.Column('cost',db.Float, nullable=False)
- status = db.Column('status',db.String(35))
- userr = relationship("User",back_populates = "orderr")
- bskt = relationship("Basket",back_populates = "ord")
- def __init__(self,user,date,cost,status):
- self.id_user = user
- self.date = date
- self.cost = cost
- self.status = status
- def toJson(self):
- return {'Order' : {'id_order' : self.id_order, 'id_user' : self.id_user, 'date' : self.date, 'cost': self.cost}}
- def get_id(self):
- return self.id_order
- def get_id_user(self):
- return self.id_user
- def get_date(self):
- return self.date
- def get_cost(self):
- return self.cost
- def __repr__(self):
- return '<Order %r>' % (self.id_order)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement