Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Showing data in modal
Using Django 3 i developed a page where some tasks are showed like links. If task is not finished, than the user own can edit it, but if task is finished the user can only see. The tasks color are diferents from each task depends in the status: Atrasada, em dia, futura. The purpose is click in a task and open a modal with data from that task, but i dont know how to transfer data from main page to modal. I have no idea what to do. There is a way to make this using just django??? -
Django Rest Framework no read multiple records
I have tried everything on the blogs. I even consume the service with postman and multiple records are not inserted. Can you help me understand what is happening? There are no errors thrown by the code. Only one record is inserted. My code in DJANGO class ProviderListSerializer(serializers.ListSerializer): def do_stuff(data): return data def create(self, validated_data): some_data = self.do_stuff() return Provider.objects.bulk_create(some_data, ignore_conflicts=True) class ProviderSerializer(serializers.ModelSerializer): class Meta: model = Provider fields = '__all__' list_serializer_class = ProviderListSerializer class ProviderViewSet(viewsets.ModelViewSet): queryset = Provider.objects.all() serializer_class = ProviderSerializer def create(self, request, *args, **kwargs): many = isinstance(request.data, list) serializer = self.get_serializer(data=request.data, many=many) serializer.is_valid(raise_exception=True) self.perform_create(serializer) headers = self.get_success_headers(serializer.data) return Response(serializer.data, headers=headers) My code in POSTMAN: curl --location --request POST 'http://127.0.0.1:8000/api-auth/providers/' \ --header 'Authorization: Basic YRtaW46SklFTTkzMDYMQ==' \ --form 'name="Proveedor09"' \ --form 'representante="Proveedor09"' \ --form 'alias="Proveedor09"' \ --form 'ruc="isuioasuio92"' \ --form 'mobile="48489948"' \ --form 'address="shds"' \ --form 'telefono="45546546654"' \ --form 'email="Proveedor09@mail.com"' \ --form 'activo="true"' \ --form 'name="Proveedor091"' \ --form 'representante="Proveedor091"' \ --form 'alias="Proveedor091"' \ --form 'ruc="isuioasuio921"' \ --form 'mobile="48489948"' \ --form 'address="shds"' \ --form 'telefono="45546546654"' \ --form 'email="Proveedor109@mail.com"' \ --form 'activo="true"' I just expect to insert multiple records. As I said, I've tried everything I've seen on the web. Maybe I'm sending the form-data wrong, but I see that in many … -
Sync to Async Django ORM queryset foreign key property
Very simple question: Django. Model. Has foreign key: class Invite(models.Model): inviter = models.ForeignKey(User, on_delete=models.CASCADE, related_name='inviter') ... In async context, I do: # get invite with sync_to_async decorator, then print(invite.inviter) Get async favorite error: You cannot call this from an async context - use a thread or sync_to_async How do I handle this? -
Django retrieving data from m2m table
I am using Django default User model. I've made a relation m2m to it with model Books. Django made automaticly table in library app - library_books_user. How can I get acces to it? I want to be able to delete relations. Normally when I use not built in models i can do it like: models.BooksUsers.objects.get(book=book, user=user) importing models before. -
Not working Create Mutation in Graphql [django]
I use Django and graphql. Not working Create Mutation in Graphql. I can't understand why. Update and Delete works. But I can't create anything. class MovieCreateMutation(graphene.Mutation): class Arguments: title = graphene.String(required=True) year = graphene.Int(required=True) movie = graphene.Field(MovieType) def mutate(self, info, title, year): movie = Movie.objects.create(title=title, year=year) return MovieCreateMutation(movie=movie) and I have: class Query(api.schema.Query, graphene.ObjectType): pass class Mutation(api.schema.Mutation, graphene.ObjectType): pass schema = graphene.Schema(query=Query, mutation=Mutation) I'll say it again - Update and Delete mutations work. Only Create does not work. And I can't understand why. What I'm doing: mutation { createMovie(title: "TestMovie", year: 1981) { movie { title year } } } What do I always get: { "data": { "createMovie": { "movie": null } } } -
how to customize UserCreationForm in django
Hi I am trying to clean up my usercreation form using widgets but its not working. The class is not being passed 'form-control' It does however work for model form. Not sure what I am doing wrong? I am new. forms.py class ProfileForm(UserCreationForm): class Meta: model=User fields = ('email', 'avatar', 'password1', 'password2') def __init__(self, *args, **kwargs): super(ProfileForm, self).__init__(*args, **kwargs) self.fields['email'].widget.attrs['class'] = 'form-control' self.fields['password1'].widget.attrs['class'] = 'form-control' self.fields['password2'].widget.attrs['class'] = 'form-control' class CustomerForm(ModelForm): class Meta: model = Customer fields = ['name','email','phone_number' ] widgets={ 'name' :forms.TextInput(attrs={'class':'form-control'}), 'email' :forms.TextInput(attrs={'class':'form-control'}), 'phone_number' :forms.TextInput(attrs={'class':'form-control'}), } -
Django count records with aggregate
I have field like this I want all records count with all tags for example sale = Sale.objects.using('read_rep') \ .filter(tags__name__in=['Device','Mobile']) \ .aggregate( **{total: Count('pk', for status, _ in ['Device','Mobile']} ) Device - 2 Mobile-5 It is difficult to count records with all tags because tags are being store in only one field. Any help would be Appreciated. -
Group by field in serializer for DRF
I am trying to group all my articles by category for DRF. I have the following my serializers.py: class GroupPageSerializer(serializers.ModelSerializer): sound = serializers.FileField(required=False) image = Base64ImageField(max_length=None, use_url=True) category = serializers.PrimaryKeyRelatedField( many=True, queryset=Category.objects.all()) url = serializers.CharField(allow_null=True, required=False, default=None, allow_blank=True) english = serializers.CharField(source="base", required=False, allow_blank=True) per_language = PerLanguageCondensedSerializer(many=True, required=False, read_only=True) target = serializers.CharField(required=False, allow_null=True, allow_blank=True) base = serializers.CharField(required=False) class Meta: model = Page fields = ['per_language', 'base', 'target', 'english', 'date', "json", "id", "category", "title", "image", "sound", "url", "slug"] And this in my views.py: class GroupedArticleListView(generics.ListAPIView): queryset = Page.objects.select_related().all() serializer_class = GroupPageSerializer filter_backends = (filters.DjangoFilterBackend, OrderingFilter) pagination_class = LimitOffsetPagination ordering_fields = ['date'] filter_class = ArticleMultiValue I have been trying writing a list serializer class, I've been trying to write various "to_representation" functions, etc. All I want is so that all of my results are grouped by category, as such: "business": [ {article1...}, {article2...} ], "technology": [ {article3...}, {article8...}, ], etc How do I do this? -
How to change the docker and nginx config to support asgi WebSocket wss in Django?
I'm working on a small Django project related to a chat where I have to use WebSocket for real0time cominucation, I deployed my project using wsgi and it was working but when i reached the point of using websockt I found myself that I have to change the configuration to asgi or something, could you please help me out This is my project architecture: -myproject -docker(folder) -certbot(folder) -proxy(folder) -nginx (folder) -default-ssl.conf.tpl -uwsgi_params -Dockerfile (file2) -Dockerfile (file1) -Docker-compose-delpoy.yml This is my Dockerfile (file1) FROM python:3.10-alpine3.16 ENV PYTHONUNBUFFERED 1 COPY requirements.txt /requirements.txt RUN apk add --upgrade --no-cache build-base linux-headers && \ pip install --upgrade pip && \ pip install -r /requirements.txt COPY app/ /app WORKDIR /app RUN adduser --disabled-password --no-create-home django USER django CMD ["uwsgi", "--socket", ":9000", "--workers", "4", "--master", "--enable-threads", "--module", "myproject.wsgi"] This is my production Docker-compose-delpoy.yml version: '3.9' services: db: image: postgres volumes: - ./data/db:/var/lib/postgresql/data - ./init.sql:/docker-entrypoint-initdb.d/init.sql environment: - POSTGRES_DB=xxx - POSTGRES_USER=xxx - POSTGRES_PASSWORD=xx app: build: context: . restart: always volumes: - .:/app environment: - DJANGO_DEBUG=0 - POSTGRES_NAME=xxx - POSTGRES_USER=xxx - POSTGRES_PASSWORD=xxx - DJANGO_SECRET_KEY=${DJANGO_SECRET_KEY} - DJANGO_ALLOWED_HOSTS=${DOMAIN} depends_on: - db redis: image: redis:alpine proxy: build: context: ./docker/proxy restart: always depends_on: - app ports: - 80:80 - 443:443 volumes: - certbot-web:/vol/www - … -
How to get same search result if i filter a value with hyphen or without hyphen or with white spaces in queryset field?
I need to get the same result when i search a word with or without a hyphen as well as white space in django queryset field.What should i do to satisfy this. -
Logging incorrect translations in Django
I often run into the mistake of using gettext in a context where the actual language is not set yet - instead of using the appropriate gettext_lazy. Those errors can be difficult to catch - I would like to make them more visible appropriate logging, or possibly even throwing exceptions. Would it be correct, to write a wrapper function that logs an error in the case of get_language() is None? Then of course, one would need to enforce that this wrapper is always used - introducing another subtle easy to make mistake. In general, I suppose monkey-patching could be used, but I'd like to avoid that if possible. The whole dispatch behind django.util.translation seems already relatively complex. Is there a clean way too hook this functionality in there? -
Django REST Framework caching programmatically
From the official docs it looks like the only way of caching with DRF is to use decorators. As far as I know, there is also a more flexible way to use caching directly querying the cache, like in the example below (source): from django.core.cache import cache from django.conf import settings from django.core.cache.backends.base import DEFAULT_TIMEOUT CACHE_TTL = getattr(settings, 'CACHE_TTL', DEFAULT_TIMEOUT) def cached_sample(request): if 'sample' in cache: json = cache.get('sample') return JsonResponse(json, safe=False) else: objs = SampleModel.objects.all() json = serializers.serialize('json', objs) # store data in cache cache.set('sample', json, timeout=CACHE_TTL) return JsonResponse(json, safe=False) This approach gives use more control over what and how long we store in the cache. So, my question is the following: is there a way to adapt this way of caching to a simple view defined in DRF? Example: # MODEL class Item(models.Model): code = models.CharField(max_length=8, primary_key=True) name = models.CharField(max_length=32) # SERIALIZER class ItemSerializer(serializers.ModelSerializer): class Meta: model = Pair fields = '__all__' # VIEW class ItemsList(generics.ListAPIView): queryset = Item.objects.all() serializer_class = ItemSerializer def list(self, request): queryset = self.get_queryset() serializer = ItemSerializer(queryset, many=True) return Response(serializer.data) -
Django Rest Framework - overriding save in backend is not created custom id
I am working on a project. I have Django for my backend and Vue for my front end. When using the templates and saving in the Django project I have no issues. However, when I POST to my projects API the following save from my modal is not being created. models.py class DevProjects(models.Model): PROJECT_TYPE = [ ('New Application', 'New Application'), ('Update Application', 'Update Application'), ('Bug Fixes', 'Bug Fixes') ] PROJECT_STATUS = [ ('New', 'New'), ('In Progress', 'In Progress'), ('Complete', 'Complete'), ] project_id = models.CharField(max_length=15, editable=False, unique=True) project_title = models.CharField(max_length=100) project_desc = models.CharField(max_length=500) project_category = models.CharField(max_length=25, choices=PROJECT_TYPE, null=True, blank=True) project_status = models.CharField(max_length=25, choices=PROJECT_STATUS, default='New') created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateField(auto_now=True) created_by = models.ForeignKey(User, related_name='projects', on_delete=models.CASCADE) def save(self, *args, **kwargs): super(DevProjects, self).save(**kwargs) self.project_id = 'PROJ-' + str(self.id) super(DevProjects, self).save(**kwargs) def __str__(self): return self.project_title I have the project_id being created on save which gets the original ID but just adds 'PROJ-' in front. Whenever I submit the form from my frontend, that save definition is not being called, thus not creating the project_id. Project ID is what I use to send a GET request to get the projects. serailizer.py class DevProjectSerializer(serializers.ModelSerializer): class Meta: model = DevProjects fields = ("project_id", "project_title", "project_desc", "project_category", "project_status") … -
How do I use Django generic updateviews to update my model using individual form field values?
models.py: from django.db import models class Location(models.Model): name = models.CharField(max_length=20) is_source = models.BooleanField(default=False) is_destination = models.BooleanField(default=False) def __str__(self): return self.name views.py from django.shortcuts import render from django.urls import reverse_lazy from django.views import generic from .models import Location class LocationsListView(generic.ListView): model = Location template_name = 'locations/list.html' context_object_name = 'locations' class LocationUpdateView(generic.edit.UpdateView): model = Location fields = ['name', 'is_source', 'is_destination'] context_object_name = 'location' template_name = 'locations/update.html' success_url = reverse_lazy('locations:list') class LocationDeleteView (generic.edit.DeleteView): model = Location template_name = 'locations/confirm_delete.html' context_object_name = 'location' success_url = reverse_lazy('locations:list') locations/update.html {% extends 'base.html' %} {% block title %}Location Update{% endblock %} {% block content %} <section> <div class="container"> <h1>Location Update</h1> <div class="form-container"> <form method="post"> {% csrf_token %} {% if form.errors %} <div class="p-3 mb-3 border border-danger border-3 rounded">{{ form.errors }}</div> {% endif %} <div class="mb-3"> <label for="" class="form-label">Name</label> <input type="text" class="form-control" value="{{ form.name.value }}"> </div> <div class="mb-3"> <input type="checkbox" class="form-check-input" {% if form.is_source.value %} checked {% endif %}> <label for="">Source</label> </div> <div class="mb-3"> <input type="checkbox" class="form-check-input" {% if form.is_destination.value %} checked {% endif %}> <label for="">Destination</label> </div> <input type="submit" class="btn btn-success mb-3" value="Save"> </form> </div> </div> </section> {% endblock %} locations.urls.py from django.urls import path from . import views app_name = 'locations' urlpatterns = [ path('', views.LocationsListView.as_view(), … -
django app - django.core.exceptions.ImproperlyConfigured
So I'd like to overwrite some of the signals provided by django all auth. Therefore I overwrite the core/apps.py file like this: class CoreAppConfig(AppConfig): name = 'core.apps.CoreAppConfig' label = "core" def ready(self): from allauth.account.signals import email_confirmed from allauth.account.models import EmailAddress from .signals import profile # todo import not working email_confirmed.connect(profile, EmailAddress) And my init file: default_app_config = 'core.apps.CoreAppConfig' And my installed apps include: 'core.apps.CoreAppConfig', "profile" is a signal which just creates a new Profile object for the user in the request. This is not the problem here. The problem is that when I run the server, an error occurs; Error: django.core.exceptions.ImproperlyConfigured: Cannot import 'core.apps.CoreAppConfig'. Check that 'core.apps.CoreAppConfig.name' is correct. -
Issues importing Chart.js into django project via CDN
I have a simple django project that needs the use of the Chart.js library for one of the templates. My base.html where I imported the library is shown below is shown below: <!DOCTYPE html> <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> <!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> <!--[if gt IE 8]> <html class="no-js"> <!--<![endif]--> <html> <head> <style> body {font-family: Helvetica, Roboto, Georgia} div * {display:flex; justify-content:center} </style> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Switch Monitor</title> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href=""> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.1/jquery.min.js"></script> <script type="module" src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.0.1/chart.min.js" integrity="sha512-tQYZBKe34uzoeOjY9jr3MX7R/mo7n25vnqbnrkskGr4D6YOoPYSpyafUAzQVjV6xAozAqUFIEFsCO4z8mnVBXA==" crossorigin="anonymous" referrerpolicy="no-referrer"></script> </head> <body> <div id="dialog" style="display:grid;justify-content:center"> {% block title %} <h1>Switch Monitor</h1> {% endblock title %} {% block content %} {% endblock content %} </div> {% block script %} <script src="" async defer></script> {% endblock script %} </body> </html> My django settings.py is shown below, the server was restarted after the CORS settings were changed. from pathlib import Path # Build paths inside the project like this: BASE_DIR / 'subdir'. BASE_DIR = Path(__file__).resolve().parent.parent # Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/4.1/howto/deployment/checklist/ # SECURITY WARNING: keep the secret key used in production secret! SECRET_KEY = … -
Django REST: Set all Serializer fields as not required at once
Is there any way to set my serializer fields as not required by default? it'll take me hours to set every field of every serializer I have as not required so I wanted to know if there's any shortcut. One example: class ComputersSerializer(serializers.ModelSerializer): name = serializers.CharField(required=False) serial = serializers.CharField(required=False) otherserial = serializers.CharField(required=False) contact = serializers.CharField(required=False) contact_num = serializers.CharField(required=False) comment = serializers.CharField(required=False) date_mod = serializers.DateTimeField(required=False) is_template = serializers.IntegerField(default=0) template_name = serializers.CharField(required=False) is_deleted = serializers.IntegerField(default=0) is_dynamic = serializers.IntegerField(default=0) ticket_tco = serializers.DecimalField(max_digits=20, decimal_places=4, required=False) uuid = serializers.CharField(required=False) date_creation = serializers.DateTimeField(required=False) is_recursive = serializers.IntegerField(default=0) last_inventory_update = serializers.DateTimeField(required=False) computertypes = ComputertypesSerializer(required=False) computermodels = ComputermodelsSerializer(required=False) entities = EntitiesSerializer(required=False) networks = NetworksSerializer(required=False) locations = LocationsSerializer(required=False) autoupdatesystems = AutoupdatesystemsSerializer(required=False) users = assistanceSerializers.UsersSerializer(required=False) groups = assistanceSerializers.GroupsSerializer(required=False) states = StatesSerializer(required=False) users_tech = assistanceSerializers.UsersSerializer(required=False) groups_tech = assistanceSerializers.GroupsSerializer(required=False) manufacturers = ManufacturersSerializer(required=False) class Meta: model = Computers fields = '__all__' For the moment I had to set it for each field. I've been searching if someone had the same problem but it looks like I'm lazier than the rest of programmers. -
<embed> - src from proxy server
I am currently struggling with setting the src attribute of the <embed> element. I have my PDF documents stored in the cloud storage with limited access. My application has users, and each user has its own set of PDF contracts on the dedicated namespace. Since I do not want to expose any URL to the users nor call the storage from the front end, I prepared a proxy endpoint (with authorized access) that returns the application/pdf response to be displayed in a particular <embed> component. Does anyone know how to display the content with this paradigm? Thank you for any hint. -
use of gTTS in Django project
i want to use gTTS in my Django project. Accordingly i installed django-gtts(pip install Django-Gtts). It is installed successfully.. later i added 'gTTS' under INSTALLED-APPS of setting.py file. Then run the server and also tried makemigrations gTTS. in both the case got below errir. import_module(entry) File "C:\Users\LENOVO\AppData\Local\Programs\Python\Python39\lib\importlib\__init__.py", line 127, in imp ort_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 984, in _find_and_load_unlocked ModuleNotFoundError: No module named 'gTTS' please suggest what i should next.. i tried all possible way with my litte knowledge but unable to fix it.. please let me know if you need more information. -
Group by in serializer in Django Rest Framework
I am new to Django Rest Framework, I want to group my serializer data by date, How can I do that. How can I group this by Date? my model: mongo model with some more fields also but only uses these two fields class Activity(Document): """ mongo model """ candidate_id = StringField(required=True, db_field='c') timestamp = DateTimeField(required=True, db_field='d') ... ... more fields My Views: my views file class RecentActionView(generics.ListAPIView): serializer_class = RecentActionSerializer def get_queryset(self): recruiter_id = self.request.GET.get("recruiter_id") activity_list = Activity.objects.filter(recruiter_id=str(recruiter_id)).order_by('- timestamp') return activity_list my serializer: using serializermethod field to get data from other DB by using candidate id from activity model class RecentActionSerializer(serializers.Serializer): name = serializers.SerializerMethodField() designation = serializers.SerializerMethodField() age = serializers.SerializerMethodField() timestamp = serializers.DateTimeField(format="%H:%M") def get_name(self, obj): return something def get_designation(self, obj): return something def get_age(self, obj): return something I want to group my response by Date like : [ { "date": "2022-12-05", "candidates":[ { "name": "One", "designation": "Lead", "age": 30, "timestamp": "14:30" } ] }, { "date": "2022-12-04", "candidates":[ { "name": "Two", "designation": "Lead", "age": 30, "timestamp": "14:30", } ] } ] my actual response is like: [ { "name": "One", "designation": "Lead", "age": 30, "activity_timestamp": "13:12" }, { "name": "Two", "designation": "Lead", "age": 30, "activity_timestamp": "13:12" } ] -
Fetch Python Logger Formatter Variables in Code
I have a Django project and this is what the logger formatter configuration looks like. 'formatters': { 'simple': { 'format': '%(asctime)s SCORPIO [%(request_id)s] ' + os.environ['ENVIRONMENT'] + ': %(message)s', 'datefmt': '%Y-%m-%dT%H:%M:%S', }, }, How does Python pick the different variables (asctime, request_id) provided in the format? I need to fetch the request_id variable in case of a failure and display it on a page. I've mostly worked with Java in which these variables are picked from the ThreadContext so I tried looking for such an alternative in Python but couldn't find one. -
Unable to create new project in django
(zenv) PS C:\Users\heman\Dev\try-django> django-admin startproject zFirst_site EROOR: Traceback (most recent call last): File "<frozen runpy>", line 198, in _run_module_as_main File "<frozen runpy>", line 88, in _run_code . . . . . . . File "C:\Python311\Lib\site-packages\django\db\models\fields\__init__.py", line 155, in __init__ if isinstance(choices, collections.Iterator): ^^^^^^^^^^^^^^^^^^^^ AttributeError: module 'collections' has no attribute 'Iterator' * It was all okay till by mistake i uninstalled every pip packages* -
Inside a Django model class, is it possible to asssign an attribute with the value of another attribute's foreign key?
class Post(models.Model): item = models.ForeignKey(Item, related_name="posts", on_delete=models.CASCADE) post_by = models.TextField(max_length=50) # value= With the above django model, is it possible to assign to value such that I get item's foreign key object called Item and then with that I get Item's id and this is stored in the attribute value? -
Django User Logging In System | Views.py doesn't work
I am currently making a user authentication system. I have a login screen with a couple of input fields. I can log the values of the input fields to the console in my javascript. I send the data to my backend. Submitting doesn't work and in my views.py loggin the data to the console too. I can basically completely remove the views.py function and the Template is shown anyway! Is that because I am using the Django Authentication Urls, so the registration folder is the default for the django registration? How can I send that to my backend? I have my logging in template (https://pastebin.com/RKe5ECps) Views.py def login_user(request): if request.method == "POST": username = request.POST["username"] password = request.POST["password"] user = authenticate(request, username=username, password=password) if user is not None: login(request, user) return redirect('forum') else: messages.success(request, ("There was an error Loggin in, Try Again!")) return redirect('login') else: return render(request, 'login.html', {}) Urls.py path('', include('django.contrib.auth.urls')), Folder Structure: templates/registration/login.html templates/registration/signup.html I tried removing the authentication, but than i couldn't see anything, because at the login/ url there was nothing. -
Duplicate data after using update_or_create
In my project I retrieve data from an API that I save on my database created in parallel, the problem is that the initial data is duplicated each time I refresh the page that executes the API models.py class Empl(models.Model): code=models.CharField(max_length=10,blank=True,null=True) age=models.CharField(max_length=255,blank=True,null=True) service=models.CharField(max_length=255,blank=True,null=True) views.py url='http://myAPI/Empl/GetEmpl' x=requests.get(url) content=x.json() for data in content: emp , _ = Empl.objects.update_or_create(code=data['code'],age=data['age'],service=data['service']) emp.save() At the level of my project when I look for an employee on the search bar, several employees with the same data. And this every time I refresh the page that executes the API, the initial data is duplicated and so on. Oddly when I perform a filter on an employee through her code in Mysql Base I get a single tuple, I don't understand?
