Home / Questions / 26660
Accepted
Nestor Moran
Asked: 2020-10-09 10:36:37 +0800 CST 2020-10-09 10:36:37 +0800 CST

Selective data request query from a json api?

  • 772

More than a question, it is a query, I am currently with an api serving data, and I have reached the following situation, I have a user preferences table, where the configuration options of each user are stored, with json, I do a get and it returns all the data from that table, and then I have to filter that data with the user id that is logged in, my point is, there is another way to do this, that is, with mysql in the query I put the user id and only It returned the data of that user, here it loads the data of all the users and then I have to filter. As I am inexperienced, I fear that if I have a record with more than a thousand data, and in the end I only need 1 of those data, I have to load all that, and in the end it would affect the performance of my page.

It's already too late to go back with the api, I would like to know if there is a solution, or maybe I'm exaggerating and this does not affect performance.

Thanks in advance.

json

1 Answers

  1. Best Answer

    Just as you do it in MySQL so it is done in . It's much easier if you use models in your ViewSets

    If you have a ViewSet for your model Usuario:

    class UsuarioViewSet(viewsets.ModelViewSet):
    queryset = Usuario.objects.all()
    serializer_class = UsuarioSerializer
    permission_classes = [IsUsuarioAdminOrReadOnly]

    You just have to add this to your routes:

    from rest_framework import routers

router = routers.SimpleRouter()
router.register(r'usuarios', UsuariosViewSet)
urlpatterns = router.urls

    And the routes are automatically generated:

    • User list: ^accounts/$, is called'usuarios-list'
    • User details: ^accounts/{pk}/$and it is called'usuarios-retail'

    And it has the most common verbs, POST, GET, PUT, UPDATE, DELETEand PATCH, depending on what you have configured.

    I recommend that you consult the documentation of the project, which is very complete, and that you follow the rules of the How to make a complete, minimal and verifiable example guide when asking your questions.

    • 1