Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Supervisorctl add environment variables
Is there a way on how to put/add environment variables in the staging server? Because in my local server, I have my api key inside .bash_profileand retrieving the key with API_KEY = os.getenv('API_KEY') The program works fine in localhost but when in the staging server, it raises an ImproperlyConfigured error and says that my API_KEY in settings.py is missing. -
Django sitemap urls http to https
py file is; class PostSitemap(Sitemap): changefreq = "never" priority = 0.5 def items(self): return Post.objects.published() def lastmod(self, obj): return obj.created_date I'm using SSL Certificate but sitemap.xml urls are http like; <sitemap> <loc>http://www.name.com/sitemap-post.xml</loc> </sitemap> How can i change http to https? -
Create Project Structure Using Python and Djagno
I created a small project using python, django, Html, css, javascript. So I created one project folder and two applications like(django pro, account app, projectapp). i don't know where to write code signup, login, forget password and reset password. Can anyone suggest a good structure? -
Django render and redirect URL
Hello i'm a newbie to Django, i'm currently having problem figure out how to redirect and return value I have a url with 2 parameters that are month and year . After clicking on it , it should redirect to page with url like so "list-working-sessions/year/month" with year and month parameters base on the action. urls.py url(r'^list-working-sessions/(?P<year>\w+?)/(?P<month>\w+?)/$', views.list_working_sessions, name='list_working_sessions') base.html <ul class="treeview-menu"> <li id="list-daily-task"> <a href="{% url 'list_working_sessions' %}"> <i class="fa fa-circle-o"></i>List Working Session</a> </li> </ul> The page have a table and a form to search by month and year: list_working_sessions.html <div class="box"> <div class="box-header"> <center> <h3 class="box-title">List Working Sessions</h3> </center> </div> <!-- /.box-header --> <div class="box-body"> <form class="form-horizontal" action="/list-working-sessions" method="GET"> {% csrf_token %} <div class="table-responsive"> <table class="table table-borderless" id="dynamic_field"> <tr> <th style="width:20%; border-top:none">Month</th> <th style="width:20%; border-top:none">Year</th> <th style="width:20%; border-top:none"></th> <th style="border-top:none"></th> </tr> <tr> <td style="border-top:none"> <select name="month" class="form-control" id="month" required> <option value="1" selected>1</option> <option value="2" selected>2</option> <option value="3" selected>3</option> <option value="4" selected>4</option> <option value="5" selected>5</option> <option value="6" selected>6</option> <option value="7" selected>7</option> <option value="8" selected>8</option> <option value="9" selected>9</option> <option value="10" selected>10</option> <option value="11" selected>11</option> <option value="12" selected>12</option> </select> </td> <td style="border-top:none"> <select name="year" class="form-control" id="year" required> <option value="2019" selected>2019</option> <option value="2020" selected>2020</option> </select> </td> <td style="border-top:none"><button type="submit" id="submit" class="btn btn-info">Send</button></td> … -
How display the model in the use i put a permissions
i want to do is like the admin i created a model and i create a user and i assign the user a permission and it display the model when i login it. My problem is i create my own login page connected to the username and password from the admin and when i login they directed to the html file i created. how to display the model in the html file like in the admin page ? is it like in the login file i create ? Login.View ? path('', auth_views.LoginView.as_view(template_name='login/Login.html'), name="login"), -
How do I optionally add results generated in my view to database?
I honestly don't really know how to describe this problem so I'll list out the steps I want it to accomplish. Django displays web page with a single form User enters something into that form and presses Submit Django takes that input and generates something dynamic and that is then shown to the user. This is what I've accomplished so far, but I'm having trouble figuring out what to do for the steps below. The dynamically generated output has a button next to it called "Save", which will optionally save that output to the users database. Can someone give me hints on how to tackle this? -
SSR + CSR (?) can I add SSR to a vue-cli 3 project? (vue-cli 3 + django)
I'm using the Vue-CLI 3 and Django together. I think it might be a basic question, I can't sure that is right structure. Vue-CLI vue vue-router vuex Django (Django restframework) router (we have url.py for each page) API _base.html (_base.html included on every page, and main.js located in frontend/dist/static/main.js) <body> {{% static main.js %}} </body> It can be access every pages with SSR x CSR load vue component on routed in Vue-CLI without page loading(=CSR) when I click a link that defined router-link. Django return 404 when try to access not defined page url (e.g. GET http://localhost:8000/aaa). I would be great if you could give me some advice. thanks. -
pass serializer errors as a response in a list format
I am using graphene_django alongside rest_framework serializers. When i get validation issue, I am getting the error as follow "{'email': [ErrorDetail(string='user with this Email Address already exists.', code='unique')]}", How can I pass the error in a List way like I am passing when password do not match? here is how I am doing right now class Register(graphene.Mutation): class Arguments: email = graphene.String(required=True) password = graphene.String(required=True) password_repeat = graphene.String(required=True) user = graphene.Field(UserQuery) token = graphene.String() success = graphene.Boolean() errors = graphene.List(graphene.String) @staticmethod def mutate(self, info, email, password, password_repeat): if password == password_repeat: try: serializer = RegistrationSerializer(data={'email': email, 'password': password, 'is_confirmed': False}) print('#########Serializer########', serializer) if serializer.is_valid(raise_exception=True): print('serializer is valid') user = serializer.save() auth = authenticate(username=email, password=password) login(info.context, auth) return Register(success=True, user=user, token=get_token(auth)) print('############serializer errors##########', serializer.errors) return Register(success=False, token=None, errors=['email/password', 'Unable to login']) except ValidationError as e: print("validation error", e) return Register(success=False, errors=[e]) return Register(success=False, errors=['password', 'password is not matching']) -
High memcached connections after django upgradation
We recently upgraded our django site from 1.6 to 1.11 which is running on python2. Recently we have observed memcahed down and we have found in error log below message. [Thu Jul 25 12:56:58.342182 2019] [:error] [pid 32575:tid 140131889002240] ServerDown: error 47 from memcached_get(key): (140131092682816) SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY, host: localhost:11211 -> libmemcached/get.cc:314 I am using memcached default configurations and django default settings. Can any one suggest me fix for this? And best configurtation for django settings? Thanks -
CSRF token missing or incorrect - Django 2.2
I try to create an admin user in my application, but even I do not include any code, it gives the error 'CSRF token missing or incorrect'. I can't find what to do. Can anyone solve this problem? I tried all the suggestions from my friends, and Django documentation, but none of them could solve it. Actually, there is no need to paste my code, because as I mentioned before even without any HTML templates it is not possible to create an admin user. -
Django ORM leaks connections when using ThreadPoolExecutor
I'm using ThreadPoolExecutor to speed up data processing. The problem is that the thread pool creates new database connections and Django doesn't close them. I do have CONN_MAX_AGE in settings.py and I already tried to call django.db.close_old_connections(). Here is a code example: def compute(job): result = FooModel.objects.filter(...).aggregate(...) return BarModel.objects.create(result) def process(dataset): thread_pool = ThreadPoolExecutor(max_workers=20) futures = [] for job in dataset: futures += [thread_pool.submit(compute, job)] results = list(r.result() for r in wait(futures)[0]) return results for i in range(0, 100): process(['foo', 'bar', qux']) Is Django ORM able to terminate idle DB connections if they were started in another thread? -
How to get access to objects that have been deleted in Model in Django?
I am developing a parking management system in Django that records the 'Vehicle' object according to its time of entry, and calculates the value as it leaves, but I need to develop a reporting system that returns how many cars entered and how much total value of the day. How can I get access to vehicles that have left, because on my system, after the checkout, the object is deleted in the database to report in the report. # models.py class Vehicle(models.Model): brand = models.CharField(max_length=100, null=False) model = models.CharField(max_length=100, null=False) color = models.CharField(max_length=50, null=False) vehicle_plate = models.CharField(max_length=8, null=False) entry_time = models.DateTimeField(auto_now_add=True, null=False) def __str__(self): return self.vehicle_plate class Price(models.Model): morning = MoneyField(max_digits=14, decimal_places=2, default_currency='BRL', default='2') afternoon = MoneyField(max_digits=14, decimal_places=2, default_currency='BRL', default='3') weekend = MoneyField(max_digits=14, decimal_places=2, default_currency='BRL', default='2.5') def __str__(self): return "value table" I think need to create a template for registering vehicles that have left parking lot, but I don't know how to get access to deleted objects. -
UnboundLocalError at /products/search/ local variable 'query' referenced before assignment
I have this problem UnboundLocalError at /products/search local variable 'query' referenced before assignment /on this code help out, am searching a product using title and category def search(request): try: q = request.GET.get('q', '') except: q = False if q: query = q product_queryset = Product.objects.filter( Q(name__icontains=q)| Q(description__icontains=q) ) category_queryset = Category.objects.filter( Q(title__icontains=q)| Q(description__icontains=q) ) results = list(chain(product_queryset,category_queryset)) context = { 'query':query, 'product_queryset':product_queryset, 'category_queryset':category_queryset, 'results':results, } return render(request,"products/search.html", context) -
Accessing ImageField in clean()/save() at creation time and updates
I have a model in Django which has a lot of computed fields, it looks like this: class Media(models.Model): titel = models.CharField(max_length=128) datei = models.ImageField(upload_to='usermedia/%Y/') # automatically calculated fields width = models.PositiveIntegerField(editable=False) height = models.PositiveIntegerField(editable=False) imagetype = models.CharField(editable=False, max_length=32) thumbnail_b64 = models.CharField( editable=False, max_length=4096) def clean(self): self.width = self.datei.width self.height = self.datei.height self.imagetype = magic.from_buffer(self.datei.read(), mime=True) buffer = BytesIO() img = Image.open(self.datei) img.thumbnail((32, 32)) img.save(buffer, format="PNG") self.thumbnail_b64 = base64.b64encode( buffer.getvalue()).decode("utf-8") Everything is good at a first glance - the model does what is meant to, at least at adding new Instances. But as soon as I try to update one instance, then Django raises an error: Exception Type: ValueError Exception Value: read of closed file The problem seems to be self.imagetype = magic.from_buffer(self.datei.read(), mime=True). I think self.datei is no longer in the memory, right? I therefore changed the from_buffer thingy in both parts into: self.imagetype = magic.from_file(self.datei.path, mime=True) ... img = Image.open(self.datei.path) Now I can finally update my model instances, BUT now I am getting a FileNotFoundError error when adding new instances... How would a solution look like that works for both, adding new entries and updating old ones? -
How to make CORS POST requests using axios?
I can make a POST request from PostMan and successfully hit the backend. However, when I try in the react app I get: Access to XMLHttpRequest at 'http://XXX.ngrok.io/api/top_level_source_jobs/' from origin 'http://localhost:3000' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Axios post code: axios.post(url, data, { headers: { 'Access-Control-Allow-Credentials': true, 'Access-Control-Allow-Origin': '*', 'Access-Control-Allow-Methods': 'GET', 'Access-Control-Allow-Headers': 'application/json', } }) .then(res => { console.log(res) }) .catch(err => { console.log(err); }); For some reason, installing this app fixes it: https://chrome.google.com/webstore/detail/allow-control-allow-origi/nlfbmbojpeacfghkpbjhddihlkkiljbi?hl=en What does this app do that my headers aren't? Is axios not setting headers for some reason? -
Issues getting all users from my django models
I am trying to get all the user from my database to display all the username, goals and goals id using the related name, but I can't seem to do that. model class GoalStatus(models.Model): status_name = models.CharField(max_length=60) def __str__(self): return self.status_name class ScrumyGoals(models.Model): goal_status = models.ForeignKey(GoalStatus, on_delete=models.PROTECT, related_name='goalstatus') user = models.ForeignKey(User, related_name='scrumygoals', on_delete=models.PROTECT) goal_name = models.CharField(max_length=60) goal_id = models.IntegerField() created_by = models.CharField(max_length=60) moved_by = models.CharField(max_length=60) owner = models.CharField(max_length=60) view def home(request): user = User.objects.all() # User1 = ScrumyGoals.objects.filter(goal_name='Learn Django') context = {'User': User} return render(request, 'django/home.html', context) template {% for g in User.scrumygoals_set.all %} <td>g.User.User</td>> <td>g.goal_name</td>> <td>g.goal_id</td>> {% endfor %} the output is supposed to look like this User Weekly Goals Daily Goals Verify Goals Done Goals username Goalname Goalid Goalname Goalid -
Is there a way I can render the text present in a docx/doc(that I uploaded using file field) file to an HTML template in the exact same manner?
I want to upload a specific doc file using File field And view it as an HTML text with all the bold and italics and bullets and indents originally present in the doc file. Is it possible??? -
ModelAdmin ManyToManyField can be empty?
I have the class Tag with ManyToManyField: class Tag(models.Model): templates = ManyToManyField(Template, related_name='tags') And TagAdmin class in admin.py from django.contrib import admin from . import models @admin.register(models.Tag) class TagAdmin(admin.ModelAdmin): ... In django-admin require select at once value for field templates. But I don't want it! How I can use admin without required field templates. -
How to make choices with the columns?
class question(models.Model): q = models.CharField(max_length=500) choice1 = models.CharField(max_length=500) choice2 = models.CharField(max_length=500) choice3 = models.CharField(max_length=500) answer = models.CharField(max_length=500, choices=[choice1, choice2, choice3]) it's giving me this error: 'choices' must be an iterable containing (actual value, human readable name) tuples. but I don't know how to fix it? Thanks -
Django ModelChoiceField, label_from_instance object iteration
The method label_from_instance from CustomModelChoiceField, iterates one object at a time, but I need the method to receive all objects at once. This is due to a freight calculation call that waits for all objects at once for the calculation. Is it possible? from django import forms from django.utils.safestring import mark_safe class CustomModelChoiceField(forms.ModelChoiceField): def label_from_instance(self, obj): return mark_safe("My Object custom label <strong>%i</strong>" % obj.id) class MyForm(forms.ModelForm): my_field = CustomModelChoiceField(label=_('The form label'), queryset=MyModel.objects.filter(), widget=forms.RadioSelect, empty_label=None) class Meta: model = MyModel -
Delete query fields from model instance
I have a SAP Business One model called OHEM in my Django project but this ERP allow the custom fields creation for each company. Actually I have an admin for one of this company and the other would like to use them but when run the code in the company "B" database I have the next warning: The name of column 'U_INT_EMPLOYEE_CODE' don't exists. (207) The company "A" have a lot of user fields and the company "B" have another user different fields for the same model and want to use the same code for both Shared model class Ohem(models.Model): empid = models.IntegerField(db_column='empID', primary_key=True) # Field name made lowercase. lastname = models.CharField(db_column='lastName', max_length=50, blank=True, null=True) # Field name made lowercase. firstname = models.CharField(db_column='firstName', max_length=50, blank=True, null=True) # Field name made lowercase. middlename = models.CharField(db_column='middleName', max_length=50, blank=True, null=True) # Field name made lowercase. sex = models.CharField(max_length=1, blank=True, null=True) jobtitle = models.CharField(db_column='jobTitle', max_length=20, blank=True, null=True) # Field name made lowercase. type = models.IntegerField(blank=True, null=True) dept = models.SmallIntegerField(blank=True, null=True) branch = models.SmallIntegerField(blank=True, null=True) # Company A fields u_int_cod_empleado = models.IntegerField(db_column='U_INT_COD_EMPLEADO', blank=True, null=True) # Field name made lowercase. u_hbt_contrasena = models.CharField(db_column='U_HBT_Contrasena', max_length=100, blank=True, null=True) # Field name made lowercase. u_hbt_cardcode = models.CharField(db_column='U_HBT_CardCode', max_length=15, blank=True, … -
Django extending the User model in ECommerce application
I have a django ecommerce project that works fine till I decided to improve it. User place order and every time they place an order they have to always input their details (name, emil, address etc) , I decided to upgrade the application so if user had registered before no need to enter details again . orders/models.py from django.db import models from django.contrib.auth.models import User from shop.models import Product from decimal import Decimal from django.core.validators import MinValueValidator,MaxValueValidator from coupons.models import Coupons class order(models.Model): first_name = models.CharField(max_length=50) last_name = models.CharField(max_length=50) email = models.EmailField() address = models.CharField(max_length=250) postal_code = models.CharField(max_length=50) city = models.CharField(max_length=100) created = models.DateTimeField(auto_now_add=True) updated = models.DateTimeField(auto_now=True) paid = models.BooleanField(default=False) coupon = models.ForeignKey(Coupons,related_name='orders',on_delete=models.CASCADE ,null=True,blank=True) discount = models.IntegerField(default=0,validators=[MinValueValidator(0),MaxValueValidator(100)]) class Meta: ordering = ('-created',) verbose_name = "order" verbose_name_plural = "orders" def __str__(self): return 'Order {}'.format(self.id) def get_total_cost(self): return sum(item.get_cost() for item in self.items.all()) def get_total_cost_after_discount(self): total_cost = sum(item.get_cost() for item in self.items.all()) return total_cost - total_cost * (self.discount / Decimal('100')) class OrderItem(models.Model): order = models.ForeignKey(order,related_name='items',on_delete=models.CASCADE) product = models.ForeignKey(Product,related_name='order_items',on_delete=models.CASCADE) price = models.DecimalField(max_digits=10,decimal_places=2) quantity = models.PositiveIntegerField(default=1) class Meta: verbose_name = "OrderItem" verbose_name_plural = "OrderItems" def __str__(self): return '{}'.format(self.id) def get_cost(self): return self.price * self.quantity I create account app and extended django user so that … -
how can i add a variable that uses a view function into signals
i am trying to add a field into my Profile creation signals, this field is the ip of the user, i have a function view that when called returns the user ip, this function needs a request argument, i want this field to be added when a user registers a new account and when this happens the signals would be called and then the profile model would be created with the ip field. signals.py from django.db.models.signals import post_save from django.contrib.auth.models import User from django.dispatch import receiver from .models import Profile @receiver(post_save, sender=User) def create_profile(sender, instance, created, **kwargs): if created: Profile.objects.create(user=instance) @receiver(post_save, sender=User) def save_profile(sender, instance, **kwargs): instance.profile.save() views.py def register(request): form = UserReg(request.POST or None) if form.is_valid(): user = form.save() login(request, user) return redirect('shop-home') form = UserReg() context = { 'form' : form, 'login': 'Log in' } return render(request, 'users/register.html', context) models class Profile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) ip = models.CharField(max_length=45) -
django.core.exceptions.FieldError: Cannot resolve keyword 'redirect' into field. Choices are: added, edited, id, ip_address, name, notes
I am recieving a FieldError specifically the code not being able to resolve a keyword when attempting to run my server. I am currently upgrading my server from django 1.1 to django 2.2 and when trying to run the server the "django.core.exceptions.FieldError" is listed in the traceback telling me that the keyword "redirect" in line 326 cannot be resolved into a field. All other solutions online seem to be for a specific line of code and their resolutions have not worked in trying to resolve my issue. Here is the traceback: File "/var/www/guindev.sandiego.edu/html/Projects/usdpages/usdpages/services/urls.py", line 3, in <module> from usdpages.services.views import RedirectHostList, RedirectsFile, ImportFile File "/var/www/guindev.sandiego.edu/html/Projects/usdpages/usdpages/services/views.py", line 227, in <module> class ImportForm(forms.Form): File "/var/www/guindev.sandiego.edu/html/Projects/usdpages/usdpages/services/views.py", line 229, in ImportForm server = forms.ModelChoiceField(queryset=Host.objects.redirected(), initial=defaultHost) File "/var/www/guindev.sandiego.edu/html/Projects/usdpages/usdpages/services/models.py", line 329, in redirected return self.filter(host__isnull=False).distinct() File "/usr/local/lib64/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/local/lib64/python3.6/site-packages/django/db/models/query.py", line 892, in filter return self._filter_or_exclude(False, *args, **kwargs) File "/usr/local/lib64/python3.6/site-packages/django/db/models/query.py", line 910, in _filter_or_exclude clone.query.add_q(Q(*args, **kwargs)) File "/usr/local/lib64/python3.6/site-packages/django/db/models/sql/query.py", line 1290, in add_q clause, _ = self._add_q(q_object, self.used_aliases) File "/usr/local/lib64/python3.6/site-packages/django/db/models/sql/query.py", line 1318, in _add_q split_subq=split_subq, simple_col=simple_col, File "/usr/local/lib64/python3.6/site-packages/django/db/models/sql/query.py", line 1190, in build_filter lookups, parts, reffed_expression = self.solve_lookup_type(arg) File "/usr/local/lib64/python3.6/site-packages/django/db/models/sql/query.py", line 1049, in solve_lookup_type _, field, _, lookup_parts = self.names_to_path(lookup_splitted, self.get_meta()) … -
DJANGO - How to fix "Incomplete response received from application"
I must be going crazy... If I have my views.py file with 48 or less lines, when I POST data to it, I see Incomplete response received from application However, If I have 49 lines or more I get a NameError, 'request' is not defined thrown on line 31 and 49, even if line 31/49 is empty. Could someone please explain what is happening? Also btw Django Admin - "Incomplete response received from application" does not answer my question. veiws.py: from django.shortcuts import render from django.shortcuts import render from django.shortcuts import HttpResponse from django.core.exceptions import * from datetime import datetime def remove_xss(chat, request): return chat def find_urls(chat, request): new_chat = ' '.join([('<a href="{}">{}</a>'.format(word, word) if ('http://' in word or 'https://' in word) else word) for word in chat.split(' ')]) return new_chat def format_chat(chat, username, request): chat = remove_xss(chat, request) chat = find_urls(chat, request) request = request return "hi" def chat_index(request): return render(request, 'chatroom.html') def chat(request): if request.method == 'POST': chat = request.POST.get('textfield', None) if request.user.is_authenticated(): u = request.user.username f_chat = format_chat(chat, u, request) else: return HttpResponse('You must be signed in to continue') with open('chats.txt', 'a') as chats: chats.write(f_chat) return render(request, 'chatroom.html') urls.py: (Working (i think)) from chat import views from …
