/
route_tienda.py
42 lines (32 loc) · 1.28 KB
/
route_tienda.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
from flask import request, Response
from flask_restplus import Namespace, Resource, fields
from model_tienda import Tienda_Model
from db import Database
api = Namespace('user', description='user related operations')
bd = Database()
class Tienda(Resource):
#Seleccion de todas las filas
def get(self):
res = bd.selectRows("select * from tienda")
return Response(res, mimetype="application/json", status=200)
#Añade registro
@api.expect(Tienda_Model.a_tienda)
def post(self):
#Form request
name = request.form['name']
direccion = request.form['direccion']
telefono = request.form['telefono']
#Json request
# json_data = request.json
# name = json_data["name"]
# direccion = json_data["direccion"]
# telefono = json_data["telefono"]
insert_query = "INSERT INTO shop (name, direccion, telefono) VALUES (%s,%s,%s)"
record = (name, direccion, telefono)
res = bd.add(insert_query,record)
return Response(res, mimetype="application/json", status=200)
#Busqueda por ID
class TiendaById(Resource):
def get(self,id):
res = bd.selectRows("select * from tienda where id_tienda = {}".format(id))
return Response(res, mimetype="application/json", status=200)