@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)