}
sales[id] = payload
return sales, 201
class Product(Resource):
'''Endpoint that allows a user to view a single product'''
def get(self, id):
'''view a single product'''
if id in products:
return products[AdminProducts.id], 200
return 404
class Sale(Resource):
'''Endpoint for viewing a single sale'''
def get(self):
'''views single sale'''
if id not in sales:
return 404
else:
return sales[id], 200
api.add_resourse(AdminProducts, '/admin/products')
api.add_resourse(AdminProducts, '/attendant/products')
api.add_resourse(AttendantSales, '/attendant/sales')
api.add_resourse(Sale, '/admin/sales/<int:id>')
api.add_resource(Product, '/products/<int:id>')
conn = mysql.connect() # подключаемся к базе данных
print(request.json)
id = request.json['id']
username = request.json['username']
name = request.json['name']
surname = request.json['surname']
password_hash = request.json['password_hash']
access_token = request.json['access_token']
auth_key = request.json['auth_key']
created_at = request.json['created_at ']
query = conn.execute("Insert into values(null,'{0}','{1}','{2}','{3}','{4}','{5}','{6}')".format(id,username, name, surname,
password_hash, access_token, auth_key, created_at))
return {'status': 'success'}
class users_id(Resource):
def get(self):
conn = mysql.connect() # подключаемся к базе данных
query = conn.execute('select * from id') # Выполняем запрос и возвращаем результат json
result = {'users_id': [i[0] for i in query.cursor.fetchall()]} # выбираем первый столбец, который является индификатором пользователя
return jsonify(result)
api.add_resourse(users, '/users')
api.add_resourse(users_id, '/users/<:id>')
if __name__ == '__main__':
app.run(port='5002')
