Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django project file is empty on github
enter image description hereWhen I am committing my Django project on Github, each time my website (Django project file) is not pushing in my repository. Please help me how can I push it on my Github repository. -
Why am I keep getting an empty query set in shell when I use Django model managers?
Blockquote class PublishedManager(models.Manager): def get_queryset(self): return super(PublishedManager, self).get_queryset().filter(status='published') class Post(models.Model): ................... objects = models.Manager() published = PublishedManager() And when I try in the shell : Post.published.filter(title__startswith=“Who”) <QuerySet []> Blockquote -
Django Generate Custom ID base on Selected Fields
I want to generate a custom transaction ID when new record comes into database base on selected Forms fields. The format should be 2020/John-UK/1012/001, 2020/John-Uk/1012/002, Where 2020 is the season, John is the supplier name, UK is location, 1012 is the date, 001 is count for the day. The count should always start with 001 and increase base on supplier, location and date. Example if the same supplier brings goods the following day from same location the ID should be 2020/John-UK/1112/001 If from different location and same date the ID will be 2020/John-US/1112/001 models.py class Goods_Supply(BaseModel): transaction_id = models.CharField(max_length=50, default="_", blank=True) supplier_name = models.ForeignKey(adminModels.Supplier, on_delete=models.CASCADE, null=True, blank=True) season = models.ForeignKey( adminModels.Season, on_delete=models.CASCADE, blank=True, null=True) location = models.ForeignKey( adminModels.Location, on_delete=models.CASCADE, blank=True, null=True) transaction_date = models.DateField(auto_now=False, auto_now_add=False, null=True, blank=True) quantity = models.IntegerField(blank=True, default=0, null=True) def __str__(self): return self. transaction_id forms.py class GoodSupplyForms(ModelForm): class Meta: model = Models.Goods_Supply fields = ["transaction_id", "supplier_name", "season", " location", "transaction_date”, “quantity”] goods_supply.py from django.shortcuts import render from django.http import HttpResponse, HttpResponseRedirect from django.template import loader from django.core.paginator import Paginator import CMCADMIN.models as adminModels from SS.models import Goods_Supply from SS.forms import GoodSupplyForms from django.urls import reverse def get_post_handler(request): if request.method == 'GET': return get(request) else: return post(request) def … -
When deploying Django to Heroku: ModuleNotFoundError: No module named 'env'
When deploying Django to Heroku, I get a ModuleNotFoundError: No module named 'env' error. Anyone know why it is looking for that module? Here is my requirements.txt: asgiref==3.2.3 certifi==2020.12.5 chardet==3.0.4 dj-database-url==0.5.0 Django==1.11 django-forms-bootstrap==3.1.0 gunicorn==20.0.4 idna==2.10 Pillow==5.3.0 psycopg2==2.8.6 pytz==2020.4 requests==2.25.0 sqlparse==0.4.1 stripe==2.55.1 urllib3==1.26.2 whitenoise==5.2.0 -
i want to show discount price when a product has discount price
i have this Order model: class Order(models.Model): product = models.ForeignKey( Product, on_delete=models.CASCADE, related_name="product") customer = models.ForeignKey(Customer, on_delete=models.CASCADE) quantity = models.IntegerField(default=1) fname = models.CharField(max_length=100, null=True) address = models.CharField(max_length=1000, null=True) phone = models.CharField(max_length=12, null=True) price = models.IntegerField() disc_price = models.IntegerField(null=True, blank=True) date = models.DateField(datetime.datetime.today, null=True) status = models.CharField( max_length=100, blank=True, null=True, default="Unpaid", unique=True) order_status = models.CharField( max_length=100, choices=CHOICES, null=True, blank=True, default="In Review") payment_method = models.ForeignKey( PaymentMethod, on_delete=models.CASCADE, blank=True, null=True) total = models.IntegerField(null=True) def save(self, *args, **kwargs): order = Order.objects.all() if order.disc_price: self.total = self.quantity * self.disc_price else: self.total = self.quantity * self.price return super().save(self, *args, **kwargs) Here I have disc_price i want like this. Like if a product has disc_price the save function will be like this return self.disc_price * self.quantity I tried above but it is not working can someone help ! -
Django API keeps loading and throws timeout error when 'statsmodels.api' package is imported
In the urls.py from django.contrib import admin from django.urls import path import pandas as pd import statsmodels.api as sm urlpatterns = [path('admin/',admin.site.urls),] When I comment out the 'import statsmodels.api as sm' line, the API is working fine and shows the django home page but when I include the statsmodels package it keeps on loading and throws timeout error. Please suggests what is going wrong. The packages are installed properly in the django environment. Additional information: Deployed this django API (installed apache2 and mod_wsgi with this django) in the Ubuntu EC2 instance and calling the django API from the local computer using Public IPv4 DNS. (Followed this site to deploy the django and apache - https://studygyaan.com/django/how-to-setup-django-applications-with-apache-and-mod-wsgi-on-ubuntu) -
Why There is default values in Django admin ManyToManyField?
I have a model, named Tag that is defined like this: class Tag(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=300, null=True, blank=True) child_id = models.ManyToManyField('Tag',default=None, blank=True, null=True) def __str__(self): return str(self.id) When I want to add a new tag, there are default values child_id like this: Why ? -
Add dynamically form fields dependencies in js
I am developing an app in django. I would like to use http://emranahmed.github.io/Form-Field-Dependency/ in my forms. Let's say this is my example html: <div class="form-group"> <label for="exampleInput1">Text Box</label> <input type="email" name="checkEmpty" class="form-control" id="exampleInput1" placeholder=""> </div> <div class="form-group" id="divToHide" > <label for="exampleInput2">This will show if select yes in</label> <input type="email" class="form-control" id="exampleInput2" placeholder=""> </div> <div class="form-group"> <select name="cars" id="cars"> <option value="yes">yes</option> <option value="no">no</option> </select> </div> this is my css: [data-depends]{ display:none } an this is my js: <script src="{% static 'js/form-field-dependency.js' %}"></script> jQuery(function ($) { $('[data-depends]').formFieldDependency(); }); $.fn.formFieldDependency({ 'rules': { '#divToHide' : { '#exampleInput1' : {'type' : '!empty'}, '#cars' : {'type' : 'equal', 'value':['yes']}, } } }); Everything works as I expected. But I wonder if you can add dependencies dynamically. According to the documentation you can also add dependencies like that: <div class="form-group" id="change" data-depends="[{'#cars':{'type' : 'equal', 'value':['yes']}}]"> <label for="change">This will show if sth</label> <input type="email" class="form-control" placeholder="" > </div> So I thought that I can create a js function to add 'data-depends' attribute to a particular element. But it doesn't work. This is my code: var elem = document.getElementById("change"); elem.setAttribute('data-depends', "[{'#cars':{'type':'equal', 'value':['yes']}}]") Has anyone tried to do something similar? Best regards -
I am unable to update an item in Django
Individuals user of my appplication have their Bar Information created immediately after creating their Bars. I want to enable them to be able to update their bar information but It keeps returning the error "Select a valid choice. That choice is not one of the available choices." I am not sure of what that means and this kind of error is weird to me. views.py def UpdateUserBar(request): user = request.user.id user_email = request.user.email bar = Bar.objects.get(user_id=user) form = UpdateBar(request.FILES, instance=bar) if request.method == 'POST': form = UpdateBar(request.POST, request.FILES, instance=bar) if form.is_valid(): form.save() return redirect('/updatebar') messages.success(request, 'Bar Information Updated successfully') # else: # return redirect('/dashboard') # messages.error(request, 'Only Post method is accepted') else: try: pass except Exception as e: messages.error(request, "Unknown error"+ str(e)) return redirect(request.path) else: form = UpdateBar(instance=bar) context = {"form":form, "user_email":user_email, "bar":bar} return render(request, "dashboard/super/landlord/update_bar.html", context) Note: If i use the second else block code which was commented, it only redirects me to the dashboard and shows no error, so I am not able to know the cause of the error. models.py class Bar(models.Model): status = ( ("open", "open"), ("closed", "closed"), ("pending", "pending"), ) user_id = models.OneToOneField(User, on_delete=models.CASCADE) name = models.CharField(max_length=50) address = models.CharField(max_length=100) opening_time = models.TimeField() closing_time = … -
VSCode custom code formatting and auto indention for language(Django-Template indention)
I did a lot of search to find a away to create or override and existing extension of vscode to do indention for django-template but nothing is out there and no success in creation too. the best answer still using this settings: "files.associations": { "**/*.html": "html", "**/templates/**/*.html": "django-html", } "[django-html]": { "editor.defaultFormatter": "HookyQR.beautify", } "beautify.language": { "html": ["django-html"] }, and this extensions: Dajngo (Baptiste Darthenay) & beautify. but there is no indention for django-template language and only the HTML tags will be indented. I tried to override the Djagno extension to make it possible, and yeah it would insert some indention but after saving the code, Beautify will automatically format the code and delete that indention, so the result always is like this: <ul class="navbar-nav nav-flex-icons {% if LANGUAGE_BIDI %} mr-auto {% endif %}"> {% get_available_languages as languages %} {% for lang_code, lang_name in languages %} {% if lang_code != LANGUAGE_CODE %} {% language lang_code %} <li class="nav-item"> <a class="nav-link lang-setter" data-lang-code="{{ lang_code }}"> {{ lang_code|language_name_local }} </a> </li> {% endlanguage %} {% endif %} {% endfor %} </ul> the ugly template. -
How to row-reorder using server rendering in datatables.js?
I've stuck on this problem. I investigated datatables.js manuel too much but I cannot find a proper way for this problem. I am using datatables.js plugin with django. I want to use row-reordering in datatables.js with server rendering. I have codes as following: let table = $('#datatables').DataTable({ "aaSorting": [], "serverSide": true, "ajax": { "url": '/customers/drawDt', // "type": "GET" }, "columns": [ { "data": "id" }, { "data": "hesapKodu" }, { "data": "unvan" }, { "data": "ad" }, { "data": "soyad" }, { "data": "aktifPasif" }, ], rowReorder: { dataSrc: "id" }, }); def drawDatatable(request): draw = int(request.GET.get('draw')) length = int(request.GET.get('length')) start = int(request.GET.get('start')) customer_column_titles = [i.name for i in Customer._meta.get_fields()] queryset = Customer.objects.all() total = queryset.count() count = queryset.count() data = [i.to_dict_json() for i in queryset] response = { 'data':data, 'draw':draw, 'recordsTotal': total, 'recordsFiltered': count } return JsonResponse(response) I can use all datatable's attributes that I want, except row-reordering. When I try to use row-reorder using drag and drop, it send a request to server - get server datas and use them like there is no row-reordering. Can anyone help me, please? -
How do I assign a static file to an initial forms.FileField?
I'm trying to initialise a django form FileField with a file from my static directories. I am using a ClearableFleInput widget for the field data_file = forms.FileField( #validators=FileExtensionValidator(allowed_extensions=['xlsx','csv']), label = "Timeseries Data File", widget=forms.ClearableFileInput() ) Within the view I'm trying to set the initial form data as follows: initial_data['data_file'] = open(settings.STATIC_ROOT + '/path/to/data_file.csv','r+') ctx['form'] = EntryForm(initial=initial_data) return ctx All my other initial data items load but not the filefield. Can I do this and if so, how? -
mod_wsgi [wsgi:error] 500 Internal Server Error [ModuleNotFoundError: No module named 'lncRNA' ]
I am trying to deploy a very basic Django application (lncRNA) in our web server.Below is my system version information: [yxu@localhost lncRNA]$ httpd -v Server version: Apache/2.4.6 (CentOS) Server built: Nov 16 2020 16:18:20 [yxu@localhost lncRNA]$ cat /etc/redhat-release CentOS Linux release 7.4.1708 (Core) [yxu@localhost lncRNA]$ which python3 /usr/local/miniconda3/bin/python3 [yxu@localhost lncRNA]$ which mod_wsgi-express /usr/local/miniconda3/bin/mod_wsgi-express The root directory of my lncRNA webpage is /var/www/html/lncRNA I can start my django server directly with python manage.py runserver, and I can also get my page http://127.0.0.1:8000/. But when I use mod_wsgi-express start-server wsgi.py --port 8080 or configure Apache also gets theI get the 500 Internal Server Errorfollowing error Log: [Wed Dec 16 16:42:30.358252 2020] [mpm_prefork:notice] [pid 27037] AH00170: caught SIGWINCH, shutting down gracefully [Wed Dec 16 16:42:31.459802 2020] [core:notice] [pid 28101] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0 [Wed Dec 16 16:42:31.461239 2020] [suexec:notice] [pid 28101] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Wed Dec 16 16:42:31.496036 2020] [lbmethod_heartbeat:notice] [pid 28101] AH02282: No slotmem from mod_heartmonitor [Wed Dec 16 16:42:31.522556 2020] [mpm_prefork:notice] [pid 28101] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.4.16 mod_wsgi/4.7.1 Python/3.8 configured -- resuming normal operations [Wed Dec 16 16:42:31.522581 2020] [core:notice] [pid 28101] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND' [Wed Dec 16 16:42:51.869513 2020] … -
Issues with Django form select field that queries the ORM when there is no migrated database?
I have a Django form which can be simplified to: class QuestionAnswerForm(ModelForm): class Meta: model = QuestionAnswer exclude = [...] widgets = { "link": Select( choices=[(None, "[none]"), ("summary", "Summary")] + [ (question.question_no, question.question_no) for question in Question.objects.all() ] ), ... } The choices for the link field are retrieved from a database query. However, this does not work when building a new environment where the database has not yet been migrated. It would make sense to migrate the database, but running python manage.py migrate results in a stack trace ending in: django.db.utils.ProgrammingError: relation "decision_tree_question" does not exist LINE 1: ..._tree_question"."display_answers_vertically" FROM "decision_... It seems that running this causes Django to attempt to populate this form field with the results of a database query before migrating the database! Amending the form to not include the database query fixes this issue: class QuestionAnswerForm(ModelForm): class Meta: model = QuestionAnswer exclude = [...] widgets = { "link": Select( choices=[(None, "[none]"), ("summary", "Summary")] ), ... } but I obviously want this. Am I getting the choices from the database correctly? Is there a better way to achieve the same thing without causing this issue? -
When i add the order from AdminPanel in django i got this error
Error:AttributeError at /admin/store/order/add/ 'bool' object has no attribute 'utcoffset' This is my models.py class Order(models.Model): o_id=models.AutoField(primary_key=True) o_date=models.DateTimeField(default=True) o_address=models.CharField(max_length=250,null=True) o_amount=models.FloatField() user=models.ForeignKey(User, on_delete=models.SET_NULL,null=True,blank=True) -
save django model queryset into another model
I have two Django models class Invoice(models.Model): id = models.IntegerField() is_converted = models.BooleanField(default=False) this model keeps the information about invoices and quotations and another model containing items details of particular invoice/quotation class Items(models.Model): document = models.Foreignkey(Invoice, on_delete=models.CASCADE) price = models.DecimalField(max_digits=8, decimal_places=2) name = models.CharField(max_length=50) now I want to convert the quotation record from model Invoice to Sales Invoice I have copied the data from the Invoice model row into another row (as I want to keep the Quotation record also) My problem is copying items from the Item model of quotation record into a newly generated invoice record. I've tried this quotation_items = Items.objects.filter(document=id) this returns normal queryset <QuerySet [<items: items object (238)>, <items: items object (240)>, <items: items object (241)>]> Now I want to save these records into the Items model for the converted invoices. Is there any way of saving querysets into Django models? -
Trouble with send form (nginx+django+ajax), upstream prematurely closed connection
I have problems using the send form on my website. I am using nginx + django + ajax. The form worked fine for more than a year, but suddenly it stopped working and now when a try submit the form i get nothing. In the nginx error log i see "upstream prematurely closed connection while reading response header from upstream". Here is the code: Ajax: $('#send_form').submit(function (e) { e.preventDefault(); $.ajax({ type: 'get', url: '/send', data: $(this).serialize(), success: function () { alert('form was submitted'); } }); }); Django from django.views.generic import View from django.http import HttpResponse from django.core.mail import send_mail from django.template.loader import render_to_string from django.conf import settings class Send(View): def get(self, request, *args, **kwargs): print(request.GET) message = render_to_string('email.html', {'data': request.GET}) send_mail( 'New message on site xxxxx.ru, message, settings.DEFAULT_FROM_EMAIL, [settings.EMAIL_DEFAULT_TO], fail_silently=False, ) return HttpResponse(status=200) Nginx: events { worker_connections 1024; } http { log_format main '$remote_addr - $remote_user [$time_local] "$request" ' '$status $body_bytes_sent "$http_referer" ' '"$http_user_agent" "$http_x_forwarded_for"'; access_log /var/log/nginx/access.log main; sendfile on; tcp_nopush on; tcp_nodelay on; keepalive_timeout 150; types_hash_max_size 2048; include /etc/nginx/mime.types; default_type application/octet-stream; # Load modular configuration files from the /etc/nginx/conf.d directory. # See http://nginx.org/en/docs/ngx_core_module.html#include # for more information. include /etc/nginx/sites-enabled/*.conf; server_names_hash_bucket_size 64; server { listen 80; server_name xxxxx.ru; location /static/ … -
Compare data faster in Django
I have a model with phone_number and I'm comparing this phone number with phone_number column uploaded in csv file from user. I'm fetching all data from DB, converting Django-query to Pandas Dataframe and comparing. This works, but takes too much time - Especially fetching and conversion of data to the Dataframe takes a lot of time. Is there a way to make this processing faster? For example comparing without conversion or so? BTW.main_dataframe (user's csv) doesn't need to be strictly Dataframe. Or maybe finding values in DB instead of fetching all DB data? def process(self): main_dataframe = pd.read_csv(self.save_path + "/" + self.file_name, encoding='cp932', dtype={self.main_col: object}) # loading csv file main_dataframe = self.cleaner(main_dataframe) # cleaning data from errors all_hikanshou_db = pd.DataFrame(list(Hikanshou.objects.all().values())) # getting data from DB(postgress) and converting it to DF m1 = main_dataframe[self.main_col].isin(main_dataframe['phone_number']) # comapring main_dataframe['compared_phone_number'] = main_dataframe[self.main_col].where(m1) main_dataframe.to_csv("abc.csv", index=False, encoding="cp932") -
Django - Q lookup search is slow for over a million records in MySQL
I have a Django application which involves a search in the database table and filters out all the results and data. models.py class TableData(models.Model): field1 = models.CharField(max_length=254, unique=True, null=False) field2 = models.CharField(max_length=254) field3 = models.CharField(max_length=254) field4 = models.CharField(max_length=254) field5 = models.CharField(max_length=50) field6 = models.CharField(max_length=10) field7 = models.CharField(max_length=10, null=False, default='200') slug = models.SlugField(max_length = 254, unique=True) search_qs = models.CharField(max_length=254, default='N/A') views.py def search(request): searchquery = request.GET.get("q") if searchquery: all_queryset_list = TableData.objects.all() queryset_list = all_queryset_list.filter(Q(search_qs__icontains=searchquery)) paginator = Paginator(queryset_list, 25) page = request.GET.get('page') searchres = paginator.get_page(page) res_count = queryset_list.count() context = { 'searchres': searchres, 'res_count': res_count, } return render(request, 'results.html', context) Here everything works fine as expected, but the searched results takes too much of time for the table having over a million records. How can I optimize the query to get the results faster ? Really appreciate for anyone who can help me this. -
How to do filtering in DateTime as null in Django rest framework?
I just want to build the filtering API with Django rest framework. One field is datetime2. I want to filter the records that have NULL value as datetime2. Here is my models.py ruleend = models.DateTimeField(db_column='RuleEnd', blank=True, null=True) Here is my serializer.py class ProductPriceSerializer(serializers.ModelSerializer): class Meta: model = ProductPrice fields = ['pricingruleid', 'productkey', 'productcode', 'customerid', 'customerchain', 'productpriceusd', 'rulestart', 'ruleend', 'creatorupn', 'created', 'customername', 'productdescription'] Here is views.py class ProductPriceViewSet(viewsets.ModelViewSet): serializer_class = ProductPriceSerializer pagination_class = pagination.PageNumberPagination filter_backends = [DjangoFilterBackend, filters.OrderingFilter] filterset_fields = ['customerid', 'customername', 'productkey', 'productdescription', 'ruleend', 'rulestart'] ordering_fields = ['customerid', 'productkey', 'rulestart'] def get_queryset(self): self.pagination_class.page_size_query_param = 'page_size' return ProductPrice.objects.all() urls.py path('productprice/', ProductPriceViewSet.as_view({'get':'list','post':'create'}), name="product-price"), This makes me implement pagination, filtering and sorting very easy. But I have one problem. I need to filter the records that have the null value in ruleend. What is the valid date/time of null? Or should I add something to my backend? -
Finding available workers for each date
In my application I have to display how many workers are available on each day from the current date to a year in advance. I have trouble figuring out how to do 2 things 1. How to calculate how many people are available The way I set it up is I create a new model object each time a worker is assigned to work on a project. There are multiple projects going on at the same time and workers only assigned to one project at a time. Model looks like this -> class AssignedToProject(models.Model): worker = models.ForeignKey(Worker, on_delete=models.CASCADE) project = models.ForeignKey(Project, on_delete=models.CASCADE) start_date = models.DateField(auto_now=False, auto_now_add=False) end_date = models.DateField(auto_now=False, auto_now_add=False) def __str__(self): return str(self.worker) + " - " + str(self.project) I had a few ideas how to go about this but none of them seem quite right. To create a string with length 365 that consists of 1s and 0s depending on whether the worker is available that day. Then I would just get availability strings for all workers and add them up for each day and that would give me a number telling me how many people are available that day. Problem with this is I think I would … -
What is the django version of "flask.request.url"?
I was just converting a code from flask to django and I was wondering what should I use in django instead of flask.request.url. -
How to download a newly created csv file in django?
I have created a django application that converts txt to csv files. Now, I want to create a view function to download the newly converted csv files. Any suggestions will be highly appreciated. views.py def submit(request): # this function converts txt to csv files. For example abcd.txt is converted into abcd0000.csv and abcd0000.csv is stored in /main/temp/ folder. Now I have just created the download function which is wrong. def download(request): file_path = os.path.join(BASE_DIR, 'main/temp/??') if os.path.exists(file_path): with open(file_path, 'rb') as fh: response = HttpResponse(fh.read()) response['Content-Disposition'] = 'inline; filename=' + os.path.basename(file_path) return response raise Http404 What should be the correct way to write the newly created path for the csv file that it downloads the newly created csv file? And also please suggest what should I write in urls.py to route to download view? -
In wagtail, wanna show user profile. if already user created means wanna show profile data, otherwise wanna show profile form
I already created user profile table for storing. now how can I redirect from same option to user profile data if already user data exist in table. -
Models aren’t shown in django admin
I am currently working on a science django blog. I've finished coding it all and I realized that the models items overview and content don't appear in my django.admin. Here's an image so you can see. I know there are other threads related to it. However, I couldn't find the solution in those. Models.py: class Post(models.Model): title = models.CharField(max_length=100) overview = models.TextField() timestamp = models.DateTimeField(auto_now_add=True) content = HTMLField() author = models.ForeignKey(Author, on_delete=models.CASCADE) thumbnail = models.ImageField() categories = models.ManyToManyField(Category) featured = models.BooleanField() previous_post = models.ForeignKey( 'self', related_name='previous', on_delete=models.SET_NULL, blank=True, null=True) next_post = models.ForeignKey( 'self', related_name='next', on_delete=models.SET_NULL, blank=True, null=True) Admin.py: from django.contrib import admin from .models import Author, Category, Post, Comment, PostView # Register your models here. admin.site.register(Author) admin.site.register(Category) admin.site.register(Post) Settings.py: INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.sites', 'allauth', 'allauth.account', 'allauth.socialaccount', 'crispy_forms', 'tinymce', 'marketing', 'posts' ] And urls.py: urlpatterns = [ path('admin/', admin.site.urls), By the way, the models.py is in the app Posts. Just in case somebody needs this information. Also, the other models like author, category and featured are seen normally.
