Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Can't connect to MySQL server on 'localhost:3306' in dockerised Django app using docker-compose
I'm trying to build a Dockerized Django application with a MySQl database, but am unable to connect to the database when running docker-compose up My Dockerfile is: # Use the official Python image as the base image FROM python:3.10 # Set environment variables ENV PYTHONUNBUFFERED 1 # Set the working directory inside the container WORKDIR /app # Copy the requirements file and install dependencies COPY requirements.txt /app/ RUN pip install -r requirements.txt CMD ["sh", "-c", "python manage.py migrate"] # Copy the project files into the container COPY . /app/ And docker-compose.yml looks like: version: '3' services: db: image: mysql:8 ports: - "3306:3306" environment: - MYSQL_DATABASE='model_db' - MYSQL_USER='root' - MYSQL_PASSWORD='password' - MYSQL_ROOT_PASSWORD='password' - MYSQL_HOST='localhost' volumes: - /tmp/app/mysqld:/var/run/mysqld - ./db:/var/lib/mysql web: build: . command: python manage.py runserver 0.0.0.0:8000 volumes: - .:/app ports: - "8000:8000" depends_on: - db env_file: - .env I'm using a .env file to define environment variables, and it is: MYSQL_DATABASE=model_db MYSQL_USER=root MYSQL_PASSWORD=password MYSQL_ROOT_PASSWORD=password MYSQL_HOST=localhost These are then loaded to the app settings.py like this: BASE_DIR = Path(__file__).resolve().parent.parent env = environ.Env() if READ_DOT_ENV_FILE := env.bool("DJANGO_READ_DOT_ENV_FILE", default=True): # OS environment variables take precedence over variables from .env env.read_env(env_file=os.path.join(BASE_DIR, '.env')) MYSQL_DATABASE = env('MYSQL_DATABASE', default=None) MYSQL_USER = env('MYSQL_USER', default=None) MYSQL_PASSWORD = env('MYSQL_PASSWORD', default=None) … -
Django rendering {% csrf_token %} as string when I set innerHTML
I have a page in which I have created a modal. Now I'm creating form in the modal that can be generated dynamically on the basis of which button is clicked. I have this JS function that sets the model content with form data. function openModal(askField, platformName) { const modal = document.getElementById("modal"); const modalContent = modal.querySelector('.modal-content'); modalContent.innerHTML = ` <h2 class="m-2 text-xl font-semibold text-center">${platformName} Authorization</h2> <form class="p-2" method="post" action="/authorize/${platformName.toLowerCase()}"> {% csrf_token %} <div class="p-3 border border-gray-500 rounded-lg"> <div class="m-2 flex justify-start space-x-2"> <label class="font-bold" for="ask_field">${titleCase(askField.replace("_", " "))}</label> <input class="border" id="ask_field" name="ask_field" required> </div> <div class="flex justify-between"> <button class="px-4 rounded-lg text-white transition ease-in-out delay-150 bg-red-600 hover:-translate-y-1 hover:scale-110 hover:bg-indigo-500 duration-300" onclick="closeModal()"> Close </button> <button class="px-4 rounded-lg text-white transition ease-in-out delay-150 bg-blue-500 hover:-translate-y-1 hover:scale-110 hover:bg-indigo-500 duration-300"> Authorize </button> </div> </div> </form> `; modal.classList.remove('hidden'); } This modal works successfully. The only problem is that when this {% csrf_token %} is not actually embedded into the page but it's rendering as a string. I know as I'm adding this piece of HTML after the page is already rendered by the Django. That's why this is happening. Is there any way that I can get this working? -
Getting data for multiple objects using django checkbox
I want to get data of all objects that are selected in django admin panel using the checkbox but i can't get it right: class SalesView(View): def get(self, request, sales): sales = SaleItem.objects.all() i know i need to turn this all() function to filter to get id but just won't work! -
refar a path in root of django project from a tamplate
I have this structure: Project common Application templates common index.html static ... app1 Application ... app2 Application ... ... node_modules swiper swiper-bundle.min.css I have write this code in index.html: <link rel="stylesheet" href="../../../node_modules/swiper/swiper-bundle.min.css"> But not working and the swiper-bundle.min.css file not found. So, if I use this path href="/static/swiper-bundle.min.css" and the swiper-bundle.min.css stores in root/common/static it will works truely. How can access the swiper-bundle.min.css has located in root/node_modules/swiper/swiper-bundle.min.css ? -
String comparision returning False even if they are the same in python , inside a html file in DJANGO
so there is this IF statement inside a html file , which is failing to return a TRUE when both the strings are the same , i dont know why , i copy pasted the same strings from database to another python compiler and it said TRUE but it is only failing here I will add a sscreenshot of a reverse case where i will print it if they are not equal so you can see the string and confirm enter image description here this is the printed ones , i currently have 2 comments in my database enter image description here here it prints for both case ,hence shows how both strings are not same for both cases im using django one of the fields is a CharField with max length of 500 and another (post_id = models.CharField(max_length=500)) another is a uuid field (id = models.UUIDField(primary_key=True, default=uuid.uuid4)) i tried is instead of == , still fails im expecting it to only return a TRUE if both strings are equal ( please ignore the != in screenshot as it is just to print out the strings) -
How to annotate django queryest using subquery where that subquery returns list of ids from related model records
I have one database model, let's say ModelA: class ModelA(models.Model): field_1 = models.ManyToManyField( "core.ModelB", blank=True ) user = models.ForeignKey("core.User", on_delete=models.CASCADE) type = models.CharField(choices=ModelATypes.choices) The field_1 of ModelA is a many to many field that references ModelB. class ModelB(models.Model): uid = models.UUIDField(unique=True, default=uuid.uuid4, editable=False) amount = models.IntegerField() Now, I want to annotate the queryset to show the list of uid's from field_1 based on some filter like get the list of ModelB uid's from field_1 where user in ModelA is in list of applicable user ids. Example: from django.db.models import Subquery user_ids = [1, 2, 3] result = ModelA.objects.filter(type="year").annotate( model_b_uids_list=Subquery( ModelA.objects.filter(user__id__in=user_ids).values_list("field_1__uid", flat=True) ) ) This gives error more than one row returned by a subquery used as an expression. I tried using ArrayAgg function but that does not seems to be working. I want the annotated field model_b_uids_list on ModelA to have a list of uid's from the field_1 from multiple applicable records on ModelA. Can anyone help me understand what's going wrong here? -
I get an error when making a blog project
Hello, I'm trying to make a blog site with django but I'm getting an error, the error is NoReverseMatch at / Reverse for 'blog_detail' with keyword arguments '{'slug': ''}' not found. 1 pattern(s) tried: ['blog\-detail/(?P[-a-zA-Z0-9_]+)\Z'] I tried different methods but it didn't work, can anyone help me? someone who can look at my project in detail? I have tried many different methods but could not resolve the error. -
Django JSON dumpdata bug
при дампе Json файлов кириллица отображается некорректно, подскажите что делать Json python manage.py dumpdata products.productCategory > categories.Json при работе с джанго для того что бы не восстанавливать все данные в SQLite3 вручную решил сделать дамп но кириллица в Json файлах отображается некорректно Json -
Ordering by the column which is connected with foreign key
I have classes like this, Drawing has the one CustomUser class CustomUser(AbstractUser): detail = models.JSONField(default=dict,null=True,blank=True) NAM = models.CharField(max_length=1024,null=True,blank=True,) class Drawing(SafeDeleteModel): detail = models.JSONField(default=dict,null=True, blank=True) update_user = models.ForeignKey(CustomUser,on_delete=models.CASCADE,related_name='update_user') Now I wan to get the list of Drawing by sorting Drawing.update_user.NAM then i made code like this, class DrawingViewSet(viewsets.ModelViewSet): queryset = m.Drawing.objects.all() serializer_class = s.DrawingSerializer pagination_class = DrawingResultsSetPagination filter_backends = [filters.OrderingFilter] ordering_fields = ['id','update_user.NAM'] ordering = ['-id'] then call with this url http://localhost/api/drawings/?ordering=-update_user.NAM http://localhost/api/drawings/?ordering=update_user.NAM However in vain. How can I call this ordering? -
React django file upload difference in content-length
I'm trying to upload a PDF file from my react client to my django server (both running locally on my laptop), but I'm observing a difference in the size of the file that is sent from my react client and the file received in the request receieved at my server. The file received in the request at the server does not seem to be a valid PDF file either. This seems to be happening for other file types as well. Attaching relevant screenshots and snippets below where I'm trying to upload a PDF file which is ~4.5 MB in size: React client snippet for uploading the file: const formData = new FormData(); formData.append('file', acceptedFiles[0]); // acceptedFiles comes from a form input const uploadFilesResponse = await axios.request({ method: 'POST', url: `/api/documents/upload/${pathToUpload}`, data: formData, headers: { 'Content-Type': 'multipart/form-data', }, }); The network tab indicating the request I've sent and the file in the request payload: Here's the corresponding request received at the server Even the on disk temporary file created by django for the upload highlighted above (/var/folders/tf/7xrq4m4j11dcfkngpz9j3rfm0000gn/T/tmpil4f5hsn.upload.pdf) seems to be an invalid file which is ~8.5 MB in size. The request object shared above is the request object received at my … -
How can I use only my custom models with social-auth-app-django?
How can I store people logged in or registered with social authentication only in the custom user model? By default, whenever I use social auths, they are registered in User social auths in PYTHON SOCIAL AUTH on the Admin page, but I would like to remove this duplication with the custom user model. This does not mean that I want those displays to disappear from the admin page, but rather that I want to optimize the database space. Libraries I use are DRF, socil-auth-django and Djoser. I want to keep only my custom user model. No other user model is needed. -
Is it possible to remove an item type from a lineitem.aggregate when making a different calculation?
The delivery cost should not include % on booking, but should include % of product price if below the set delivery threshold. Both can be added to an order and at checkout only the product should attract a delivery cost, as the booking relates to buying experiences. I am unable to figure this out, so if anyone can help me I would be most grateful. Below is my model code for checkout, which includes the Order Model where the delivery is being calculated, and Order Line Item Model from where the order total is being calculated using line item aggregate. def update_total(self): """ Updates grand total each time a line item is added, takes into account delivery costs """ self.order_total = self.lineitems.aggregate( Sum('lineitem_total'))['lineitem_total__sum'] or 0 if self.order_total < settings.FREE_DELIVERY_THRESHOLD: self.delivery_cost = self.order_total * \ settings.STANDARD_DELIVERY_PERCENTAGE / 100 else: self.delivery_cost = 0 self.grand_total = self.order_total + self.delivery_cost self.save() class OrderLineItem(models.Model): order = models.ForeignKey( Order, null=False, blank=False, on_delete=models.CASCADE, related_name='lineitems') product = models.ForeignKey(Product, null=True, blank=True, on_delete=models.CASCADE) experience = models.ForeignKey(Experiences, null=True, blank=True, on_delete=models.CASCADE) quantity = models.IntegerField(null=False, blank=False, default=0) lineitem_total = models.DecimalField( max_digits=6, decimal_places=2, null=False, blank=False, editable=False ) price = models.DecimalField( max_digits=6, decimal_places=2, null=False, blank=False,) def get_price(self, *args, **kwargs): if self.product and self.experience: return self.product.price … -
Manager's annotations don't show up when traversing ForeignKey
Suppose I have such classes: class UserManager(Manager): def get_queryset(self): return super().get_queryset().annotate( full_name=Concat( F('first_name'), Value(' '), F('last_name'), output_field=CharField() ) ) class User(Model): first_name = CharField(max_length=16) last_name = CharField(max_length=16) objects = UserManager() class Profile(Model): user = ForeignKey(User, CASCADE, related_name='profiles') And I want to include an annotated field in my query: Profile.objects.filter(GreaterThan(F('user__full_name'), Value(24))) But I got a FieldError: Cannot resolve keyword 'full_name' into field. Choices are: first_name, id, last_name, profiles It's clear that I could repeat my annotation in a current query: Profile.objects.filter(GreaterThan(Concat(F("user__first_name"), Value(" "), F("user__last_name"), output_field=CharField(),), Value(24))) But as soon as my annotations will become more complex, my code become mess. Is there any workaround? -
Cookies not being set in browser when making API request from React, but work with Django REST framework
When I use the Django REST framework to send a POST request to the login endpoint, the cookies are added to the response, and I can observe them in the browser. Additionally, I can confirm that I'm receiving the correct data (user ID and password) in both cases. However, when I use my React application to send the same POST request to the login endpoint, the cookies are not being added to the response, and consequently, they aren't stored in the browser. Again, I receive the correct data (user ID and password) in this scenario as well. My django rest code : @api_view(['POST']) def loginUser(request): print("request", request.data) id_Patient = int(request.data.get('id_Patient')) print("id_Patient", id_Patient) password = request.data.get('password') print("password", password) user = Patient.objects.filter(id_Patient=id_Patient).first() if user is None: print("user is None") return JsonResponse({"message": "User not found"}, status=404) if not user.check_password(password): print("not user.check_password(password)") return JsonResponse({"message": "Incorrect password"}, status=400) payload = { 'id_Patient': user.id_Patient, 'exp': datetime.datetime.utcnow() + datetime.timedelta(minutes=60), 'iat': datetime.datetime.utcnow() } secret_key = os.urandom(32).hex() token = jwt.encode(payload, secret_key, algorithm='HS256') response = JsonResponse({"token": token}) response.set_cookie('my_cookie', 'my_value', httponly=True) # Set the cookie return response What Actually Resulted: Surprisingly, the cookies are being set correctly when I test the API request using Django's REST framework, and I'm receiving the … -
How to resolve ImproperlyConfigured: Cannot import 'core'. Check that 'OutilSuivisEffectifs.apps.core.apps.CoreConfig.name' is correct
my work flow: OutilSuivisEffectifs apps core migrations static templates __init__.py admin.py apps.py forms.py models.py tests.py urls.py views.py __initi__.py settings.py urls.py wsgi.py manage.py my Installed apps in OutilSuivisEffectifs/settings.py: INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'crispy_forms', 'django_countries', 'bootstrap3_datetime', 'captcha', 'OutilSuivisEffectifs.apps.core', 'import_export' ] my OutilSuivisEffectifs/apps/core/apps.py: from django.apps import AppConfig class CoreConfig(AppConfig): name = 'core' the command I am running is Python manage.py makemigrations The error I get execute_from_command_line(sys.argv) File "C:\Users\c69961\Anaconda3\lib\site-packages\django\core\management\__init__.py", line 419, in execute_from_command_line utility.execute() File "C:\Users\c69961\Anaconda3\lib\site-packages\django\core\management\__init__.py", line 395, in execute django.setup() File "C:\Users\c69961\Anaconda3\lib\site-packages\django\__init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) File "C:\Users\c69961\Anaconda3\lib\site-packages\django\apps\registry.py", line 91, in populate app_config = AppConfig.create(entry) File "C:\Users\c69961\Anaconda3\lib\site-packages\django\apps\config.py", line 246, in create raise ImproperlyConfigured( django.core.exceptions.ImproperlyConfigured: Cannot import 'core'. Check that 'OutilSuivisEffectifs.apps.core.apps.CoreConfig.name' is correct.` I tried to change name : from django.apps import AppConfig class CoreConfig(AppConfig): name = 'OutilSuivisEffectifs.apps.core' But same error -
Return HTTP 404 response with no content-type?
Is there a way in Django to return a HTTP 404 response without a content-type? I tried return HttpResponseNotFound() from my view, but that sends a Content-Type: text/html; charset=utf-8 header. -
Wepback.js Module not Found - React & Django
frontend@1.0.0 build webpack --mode production 'React\music_controller\frontend\node_modules.bin' is not recognized as an internal or external command, operable program or batch file. node:internal/modules/cjs/loader:1080 throw err; ^ I am just starting out with react and Django and I'm having this error when I run the command 'npm run dev' . There are my scripts from my package.json file if this helps: "scripts": { "dev": "webpack --mode development --watch", "build": "webpack --mode production" }, I am just starting out with react and Django and I'm having this error when I run the command 'npm run dev' . There are my scripts from my package.json file if this helps: "scripts": { "dev": "webpack --mode development --watch", "build": "webpack --mode production" }, -
Why Django ORM filter lists all the users?
I like to make a filter where user can search based on last_name or a regio(region). I made the query but it filters well only if I using the last_name filter, but the regio gives all the users in the db. I'm used before Sqlite3 and raw queries but now I like to learn ORM with Postgres so I'm not experienced in ORM yet. What am I doing wrong? models.py class Profil(models.Model): def __str__(self): return str(self.user) def generate_uuid(): return uuid.uuid4().hex user = models.OneToOneField(User, on_delete=models.CASCADE) datetime = models.DateTimeField(auto_now_add=True, auto_now=False) coach_uuid = models.CharField(default=generate_uuid, editable=True, max_length=40) regio = models.ForeignKey('Regiok', blank=True, null=True, on_delete=models.CASCADE) class Regiok(models.Model): regio = models.CharField(max_length=80) def __str__(self): return str(self.regio) views.py def coachok(request): coach = Profil.objects.all() nev = request.GET.get('nev') regio = request.GET.get('regio') if nev != '' and nev is not None or regio != '' and regio is not None: coach = Profil.objects.filter(Q(user__last_name__icontains=nev) | Q(regio_id__regio=regio)).select_related('user', 'regio') context = { 'coach':coach, } return render(request, 'coachregiszter/coachok.html', context) html <div class="container"> <form method="GET"> <div class="bg-light p-2"> <div class="row my-3"> <h4>Szűrők</h4> <div class="col-md-3"> <h6>Név</h6> <input class="form-control" type="search" name="nev"></input> </div> <div class="col-md-3"> <h6>Vármegye</h6> <select class="form-select" name="regio"> <option value="" selected>Bármelyik</option> <option value="Dél-Dunántúl">Dél-Dunántúl</option> <option value="Közép-Dunántúl">Közép-Dunántúl</option> </select> </div> </div> <button type="submit" class="btn btn-outline-dark">Keresés</button> <a href="/coachok"><button type="submit" class="btn btn-outline-info">Szűrők törlése</button></a> </div> … -
Django- Static HTML pages not loading if DB server is down
In my Django web application, there are many static HTML pages and there is no DB interaction required for these HTML pages. The problem is whenever DB server goes down, the whole site goes down. User cannot even see the static HTML pages. Is there any way to resolve this? -
Problem in setting up Shopify RecurringApplicationCharge in Django App
I am following app structure with reference to https://github.com/Shopify/shopify_django_app repository. I am trying to set up billing for my app using shopify.RecurringApplicationCharge. @shop_login_required def buy_plan(request, id): plan = PlanTable.objects.get(id=id) charge = shopify.RecurringApplicationCharge() charge.name = plan.name charge.price = plan.price charge.test = True charge.return_url = reverse('accept') if charge.response_code == 201: confirmation_url = charge['recurring_application_charge']['confirmation_url'] return redirect(confirmation_url) else: return render(request, 'home/billing.html', context) I also tried the following as mentioned in https://github.com/Shopify/shopify_python_api#billing @shop_login_required def buy_plan(request, id): plan = PlanTable.objects.get(id=id) charge = shopify.RecurringApplicationCharge.create({'name' : plan.name,'price' : plan.price, 'test' : True,'return_url' : reverse('accept')}) if charge.response_code == 201: confirmation_url = charge['recurring_application_charge']['confirmation_url'] return redirect(confirmation_url) else: return render(request, 'home/billing.html', context) But both these methods returned the following error:- ForbiddenAccess at /buy_plan/1 Response(code=403, body="b''", headers={'Date': 'Fri, 18 Aug 2023 12:52:49 GMT', 'Content-Type': 'text/html', 'Transfer-Encoding': 'chunked', 'Connection': 'close', 'X-Sorting-Hat-PodId': '319', 'X-Sorting-Hat-ShopId': '72702755136', 'Vary': 'Accept-Encoding', 'Referrer-Policy': 'origin-when-cross-origin', 'X-Frame-Options': 'DENY', 'X-ShopId': '72702755136', 'X-ShardId': '319', 'X-Stats-UserId': '', 'X-Stats-ApiClientId': '54612525057', 'X-Stats-ApiPermissionId': '604913992000', 'X-Shopify-API-Version': 'unstable', 'HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT': '1/40', 'X-Shopify-Shop-Api-Call-Limit': '1/40', 'Strict-Transport-Security': 'max-age=7889238', 'Server-Timing': 'processing;dur=92', 'X-Shopify-Stage': 'production', 'Content-Security-Policy': "default-src 'self' data: blob: 'unsafe-inline' 'unsafe-eval' https://* shopify-pos://*; block-all-mixed-content; child-src 'self' https://* shopify-pos://*; connect-src 'self' wss://* https://*; frame-ancestors 'none'; img-src 'self' data: blob: https:; script-src https://cdn.shopify.com https://cdn.shopifycdn.net https://checkout.shopifycs.com https://api.stripe.com https://mpsnare.iesnare.com https://appcenter.intuit.com https://www.paypal.com https://js.braintreegateway.com https://c.paypal.com https://maps.googleapis.com https://www.google-analytics.com https://v.shopify.com 'self' 'unsafe-inline' 'unsafe-eval'; upgrade-insecure-requests; … -
django layout template tags with async view
I'm trying to access my template page.html from an async view. My question is very similar to the one asked here. Yet, the difference is that page.html extends a layout.html layout. The SynchronousOnlyOperation is triggered by the presence of {{request.user}} I'm using in the layout, not directly in page.html. layout.html <span class="d-flex flex-row dashboard-settings-icon mx-2"> <i class="bi bi-person-circle"></i> <ul> <li> <a class="dropdown-toggle" href="#" id="navbarDarkDropdownMenuLink" role="button" data-bs-toggle="dropdown" aria-expanded="false" > {{request.user}} </a> <ul class="dropdown-menu dropdown-menu-dark" aria-labelledby="navbarDarkDropdownMenuLink" > <li> <a class="dropdown-item" href="{% url 'logout_user' %}" ><i class="bi bi-box-arrow-left"></i> Logout</a > </li> </ul> </li> </ul> </span> page.html {% extends 'layouts/layout.html' %} {% block content %} {% load static %} <form action={% url 'account:upload' %} method="post" enctype="multipart/form-data"> {% csrf_token %} # form </form> {% endblock content %} The view async def upload(request): if request.POST: form = ModelFormClass(request.POST, request.FILES) if form.is_valid(): if request.FILES: # File handling results = await process_data() await form.save() return render(request, "pages/account/results.html", {"form":form, "results":results}) else: return render(request, "pages/account/page.html", {"form":form}) return render(request, "pages/account/page.html", {"form":ModelFormClass}) As there's no view for displaying the layout itself, I tried the following in the view responsible of page.html display: async def upload(request): if request.POST: form = ModelFormClass(request.POST, request.FILES) if form.is_valid(): if request.FILES: # File handling results = await process_data() … -
Annonate Data and group it by one Attribute
I have a Templatet that displays all Vulnerabilities grouped by Clients. I use this Query qs = client.objects.prefetch_related(Prefetch('clientvul_set', clientvul.objects.select_related('VID'))) to selcet all related Vulnerabilties to one Client. The clientvul Database also contains a product field. I also want to display how many vulnerabilities are in each product. If I try to prefetch_related first and then annonate the Data I get "attributeerror 'queryset' object has no attribute 'split'". I can count the Data but cannout group it by a Client. Models.py import datetime from django.db import models from django.contrib import admin class client(models.Model): client= models.CharField(max_length=50,primary_key=True) user= models.CharField(max_length=100) vuls = models.ManyToManyField( 'vul', through='clientvul', related_name='client' ) class vul(models.Model): vid=models.IntegerField(primary_key=True) cvelist=models.CharField(max_length=50) serverity=models.CharField(max_length=25) title=models.CharField(max_length=1000) summary=models.CharField(max_length=1000) class clientvul(models.Model): client= models.ForeignKey(client, on_delete=models.CASCADE) vid=models.ForeignKey(vul, on_delete=models.CASCADE) path=models.CharField(max_length=1000) product=models.CharField(max_length=1000) isActive=models.BooleanField(default=True) class Meta: constraints = [ models.UniqueConstraint( fields=['client', 'vid'], name='unique_migration_host_combination' # legt client und VID als Primarykey fest ) ] admin.site.register(client) admin.site.register(vul) admin.site.register(clientvul) view.py def index(request): if not request.user.is_authenticated: return redirect(login_user) else: qs = client.objects.prefetch_related(Prefetch('clientvul_set', clientvul.objects.select_related('vid'))) gProduct=(clientvul.objects .values('Product') .annotate(pcount=Count('Product')) .order_by('-pcount') ) querys={ 'data':qs, 'groupedProduct':gProduct } print(querys) return render(request, 'browseDB.html',querys) template.html {% for row in data %} <div class="card"> <div class="card-body"> <table class="table"> <thead class="table-dark"> <tr> <th scope="col"><h4>hostname</h4></th> <th scope="col"><h4>user</h4></th> <th class="text-right"> <div class="btn-group"> <button class="btn btn-secondary" data-toggle="collapse" data-target="#{{ row.client }}-vul" data-parent="#myGroup"> … -
TemplateDoesNotExist at /blog/createposts/ [No template names provided ]
I am newbie to django. I do not know how to fix this issue. What I have tried: DIR ['templates'] [TEMPLATE_DIR,] TEMPLATE_DIRS = ('os.path.join(BASE_DIR, "templates"),') amazonbackend/ amazonbackend/ settings.py urls.py manage.py Homepage/ migrations templates a.html b.html static Blog/ migrations templates blog_post.html rich_text_editor_component.html static -
Django CSRF failing with .env file for Docker
Hi I'm using Docker to build a Django web application via Docker-Compose and it uses the .env.dev file for the environmental variables. The problem is the CSRF_TRUSTED_ORIGINS variables : If i put variables inside the settings.py => Ok If i put variables inside the env.dev => KO ( AttributeError: 'NoneType' object has no attribute 'split') settings.py # CSRF_TRUSTED_ORIGINS=["https://www.site1.fr", "http://www.site1.fr"] CSRF_TRUSTED_ORIGINS= os.environ.get("DJANGO_CSRF").split(" ") env.dev DJANGO_CSRF=https://www.site1.fr http://www.site1.fr -
Django Migration - User ForeignKey - (errno: 150 "Foreign key constraint is incorrectly formed")
I can't perform a migration for a User foreign key and I've tried everything. This is the model: class Test(TimeStampedModel): key = models.ForeignKey("users.User", on_delete=models.CASCADE) And this is the migration part (settings.AUTH_USER_MODEL is generated by makemigrations): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("xxxxx", "xxxxx"), ] operations = [ migrations.CreateModel( name="Test", fields=[ ( "key", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, ), ), Note that I've tried to set my model variable like this: key = models.ForeignKey(User, on_delete=models.CASCADE) I've also tried to replace settings.AUTH_USER_MODEL by the user class name like: ( "key", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="users.User", ), ), Note also User have been created before the migration, I've checked it with this code: def check_table_exists(apps, schema_editor): if not schema_editor.table_exists('users_user'): raise RuntimeError('users_user must exist!') class Migration(migrations.Migration): dependencies = [...] operations = [ migrations.RunPython(check_table_exists), # Other operations ] Whatever the solution I'm trying I've always the same MySQLdb._exceptions.OperationalError: (1005, 'Can't create table mdc.alerts_alertchanges (errno: 150 "Foreign key constraint is incorrectly formed")')
