Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
"SELECT DISTINCT field_name from table" Django using raw sql
How can I run SELECT DISTINCT field_name from table; SQL query in Django as raw sql ? When I try to use Table.objects.raw("""SELECT DISTINCT field_name from table"""), I got an exception as InvalidQuery: Raw query must include the primary key -
Python - Converting XLSX to PDF
I have always used win32com module in my development server to easily convert from xlsx to pdf. However, I have deployed my Django app in production server where I don't have Excel application installed and it raises the following error: File "C:\virtualenvs\structuraldb\lib\site-packages\win32com\client\__init__.p y", line 95, in Dispatch dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,c lsctx) File "C:\virtualenvs\structuraldb\lib\site-packages\win32com\client\dynamic.py ", line 114, in _GetGoodDispatchAndUserName return (_GetGoodDispatch(IDispatch, clsctx), userName) File "C:\virtualenvs\structuraldb\lib\site-packages\win32com\client\dynamic.py ", line 91, in _GetGoodDispatch IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.II D_IDispatch) com_error: (-2147221005, 'Invalid class string', None, None) Is there any good alternative to convert from xlsx to PDF in Python? Thanks! -
while use .env got NameError: name 'config' is not defined
I'm following a tutorial to upload static file to amazon S3 to. I need to add two things in the settings.py AWS_ACCESS_KEY_ID = config'AWS_ACCESS_KEY_ID' AWS_SECRET_ACCESS_KEY = config'AWS_SECRET_ACCESS_KEY' For safety reasons I create a file named .env its form is .text directly through pycharm. After I added these code in the settings.py.I restarted nginx and gunicorn and then I activated virtual environment and run python manage.py collectstatic Then I got the error NameError: name 'config' is not defined Any friends could tell me what need I do? Thanks! -
Why does printing an IntegerField field does not give me a number? [Django]
Having following field declared in my model: info_number_of_views = models.IntegerField(blank=False, default=0, null=False) Whenever I am trying to print or log it with following command: print('queried_model_of_particular_user.info_number_of_views: ' + str(queried_model_of_particular_user.info_number_of_views)) Instead of a number, I do receive that kind of an output: queried_model_of_particular_user.info_number_of_views: (<django.db.models.fields.IntegerField>,) -
Calling a Django server function from PHP server
I Just hired as a junior python developer at a company (i'm the only python developer). Here they want to pass a heavy tasks (bulk mailing,Excel import,PDF export) from a PHP server to a django server(celery) to reduce work load. In my computer I managed to run them both locally (separately). My question is what is the best way to pass the data or trigger a function at django server from PHP server For example consider the code below : some_shit.php public function actionExportPdf() { $mPDF = Yii::app()->ePdf->mpdf(); $model = new Gulfuniversityapplication('search'); $dbcriteria = Yii::app()->session['criteria']; $model->setDbCriteria($dbcriteria); $row = Yii::app()->db->createCommand("select field_data from modules where table_name='".$model->tableName()."'")->queryRow(); $filteredData = CJSON::decode($row['field_data']); //$filteredData = $data[$model->tableName()]; $stylesheet = file_get_contents(getcwd().'/path/to/core/assets/css/social.css'); $mPDF->WriteHTML($stylesheet, 1); $mPDF->WriteHTML($this->renderPartial('_exportPdf',array( 'model' => $model, 'data' => $filteredData, ), true)); $mPDF->Output(); } This is their PHP I have no idea what's in it. Here is my Django celery code tasks.py @shared_task def export_task(arg1,arg2): my_cursor = my_db.cursor() my_cursor.execute("SELECT arg1 FROM arg2") out =[] for i in my_cursor.fetchall(): out.append(i) my_cursor.execute("DESCRIBE app_gulfuniversityapplication") column = [] for i in my_cursor.fetchall(): column.append(i[0]) df = pd.DataFrame(data=out,columns=column) writer = pd.ExcelWriter('output.xlsx') df.to_excel(writer,'Sheet1') writer.save() This is my first question here thanks in advance. -
Easiest method for mapping polygons in GeoDjango
I have a simple application with a PosGIS back end. I want to have a page per feature in the database. I have used a slug and a URL routing. The PostGIS features have a polygon stored in a geom column which is modelled as a MultiPolygonField using geodjango. What is the easiest way to parse this geom column in to geojson so that I can add it to a leaflet map? Below is my code which is attempting to use the geojson serializer though I receive this error code on my page. Views.py from django.shortcuts import render from Countries_App.models import Countries from django.core.serializers import serialize # Create your views here. def show_country(request, country_slug): # Create a context dictionary which we can pass # to the template rendering engine. context_dict = {} try: # Can we find a category name slug with the given name? # If we can't, the .get() method raises a DoesNotExist exception. # So the .get() method returns one model instance or raises an exception. country = Countries.objects.get(slug=country_slug) Country_geojson = serialize('geojson', Countries.objects.get(slug=country_slug)) # We also add the category object from # the database to the context dictionary. # We'll use this in the template to verify ... -
django xhtml2pdf table border issue
I'm using xhtml2pdf with Django to generate a PDF with a table that runs over multiple pages. I can't seem to get the table body <tbody> to generate a border. I am not trying to get a border around the whole table including header <thead>, just the main body. I've been able to generate left and right borders by adding style to <td>, and a bottom border to <thead> so that it appears that the tbody has borders on 3 sides, leaving only the <tbody> bottom. but i suspect this is really a hack and not the correct way to get a full border around <tbody>. In any event I'm left stuck with this part solution and no bottom border. I've tried applying lots of css via id's classes and elements. has anyone had any experience successfully implementing table borders with xhtml2pdf in Django and could kindly offer me some guidance? Any help is much appreciated! -
django celery chain task hang
I'm the newbie to celery task. I'd like to test celery chain tasked for workflow. I have tested the chained example code as below but it only execute first job (add.s(2,1) then hang (no response from second job). Do I miss setup anything for celery chain job ? Any advice will be appreciated. Thanks in advanced. By the way, I also want to know how to get the job id from job1(add.s(2,1) and job2(add.s(4)) . Hang: job2 = chain(add.s(2, 1),add.s(4)).apply_async (queue='test') OK: job2 = chain(group(add.s(2, 1)),add.si(4,4)).apply_async (queue='test') OK: parallel run 2 job. job2 = group(add.s(2, 1),add.si(4,4)).apply_async (queue='test') Thanks. ps: app = Celery('tasks',broker='amqp://xx.xx.xx.xx', backend='amqp://xx.xx.xx.xx') Celery 4.2.1 and RabbitMQ -
Send request to gunicorn directly
Can I send a http request to gunicorn directly. Like to the below url which nginx uses http://unix:/code/tanmay.garg/web/utrade/run/gunicorn.sock -
How to round integer 3 in Django template
I have one param in my Django model, the type is Float. Imagine that it is a weight of payload. But it is in kg. But I have to show in a template in ton. Ex. class car(models.Model): ...... weight = models.FloatField(default=0) 45234 kg => 45.2 t (in template) -
why i cant user category detailview ? if use it get 404 in django?
I want use category_slug or id_slug for detailview as productdetailview and show all of product that category there but i don't know how do that i used this views but i get errors 404. why is different between productdetailview and categorydetailview? could plz help me to solve this problem? models.py class Category(models.Model): name = models.CharField(max_length=120,unique=True) slug = models.SlugField(unique=True) def __str__(self): return self.name class Brand(models.Model): name = models.CharField(max_length=120,unique=True) class Product(models.Model): category = models.ManyToManyField(Category,blank=True) brand = models.ForeignKey(Brand,on_delete=models.CASCADE) car = models.ForeignKey(Car,on_delete=models.CASCADE) title = models.CharField(max_length=120,unique=True) slug = models.SlugField(unique=True) description = models.TextField(max_length=10000) price = models.DecimalField(max_digits=10,decimal_places=2) stock = models.PositiveIntegerField() active = models.BooleanField(default=True) timestamp = models.DateTimeField(auto_now_add=True,auto_now=False) updated = models.DateTimeField(auto_now=True,auto_now_add=False) defalut = models.ForeignKey(Category,related_name="defalut_category",blank=True,null=True,on_delete=models.CASCADE) class Meta: ordering = ['-timestamp'] def __str__(self): return self.title def get_absolute_url(self): return reverse('products:product_detail',kwargs={"slug":self.slug}) views.py def ProductDetail(request,slug): product = get_object_or_404(Product,slug=slug,active=True) context = { "product":product } template_name = "product_detail.html" return render (request,template_name,context) def CategoryDetail(request,category_slug): category = get_object_or_404(Category,slug = category_slug) product = Product.objects.filter(category=category) context = { 'category':category, 'product': product } template_name ="category_detail.html" return render(request,template_name,context) -
Run Django on Oracle Application Container
I have an existing django project which I am trying to deploy to Oracle's cloud service, Application Container. I followed Oracle's guide to do this however there are some details missing from this guide. Specifically the guide references an app.py file which seems to come from this guide. But I can't see how to use that in a django project. I've tried replacing the calls to app.py to use django's manage.py or wsgi.py files but Oracle servers still fail to launch. The server logs Oracle provide also don't help, only telling me the python packages are being installed. ACCS[web.1]: Content of APP_HOME [ /u01/app/ ] dir ACCS[web.1]: total 96 ACCS[web.1]: -rw-r----- 1 apaas apaas 28423 May 17 10:51 readme.html ACCS[web.1]: -rw-r----- 1 apaas apaas 40960 May 17 10:51 db.sqlite3 ACCS[web.1]: -rw-r----- 1 apaas apaas 355 Sep 10 13:26 manage.py ACCS[web.1]: -rw-r----- 1 apaas apaas 254 Sep 10 13:28 DjangoProject.pyproj.user ACCS[web.1]: -rw-r----- 1 apaas apaas 6990 Sep 10 13:28 DjangoProject.pyproj ACCS[web.1]: -rw-r----- 1 apaas apaas 186 Sep 12 11:24 manifest.json ACCS[web.1]: drwxr-x--- 1 apaas apaas 10 Sep 13 03:42 obj ACCS[web.1]: drwxr-x--- 1 apaas apaas 160 Sep 13 03:42 app ACCS[web.1]: drwxr-x--- 1 apaas apaas 94 Sep 13 03:42 DjangoProject ACCS[web.1]: ... -
Issue in configuring Django with Apache in Centos7
I am using CPANEL to maintain the server with CentOS7 and Apache2. I am trying to configure Apache(EasyApache) to support Python, I have an issue in installing mod_wsgi getting error Error: Package: mod_wsgi-3.4-12.el7_0.x86_64 (base) Requires: httpd-mmn = 20120211x8664 You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest -
obtain django dropdown menu item queryset
I am trying to make a calendar html page, that has a dropdown button to select the different months. How to get to this calendar page is via the nav bar that is created at base.html base.html - how to get to the calendar page. .... .... <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" data-toggle="dropdown" data-target="scheduler_dropdown" href="#"><i class="fas fa-calendar"></i>Scheduler</a> <div class="dropdown-menu" aria-labelledby="scheduler_dropdown"> <a class="dropdown-item" href="{% url 'view_schedule' %}"><i class="fas fa-calendar-alt"></i>View Schedule</a> </div> </li> what i've build so far: urls.py urlpatterns = [ path('schedule/view-schedule/', views.view_schedule, name='view_schedule'), path('schedule/view-schedule/?query=month<str:selected_month>', views.view_schedule, name='view_schedule_selected_month'), ] Views.py def view_schedule(request, selected_month=None): if request.method == 'POST': print('post') else: current_month = date.today().month current_year = date.today().year # a = request.GET # How to get query set from dropdown menu??? # print(a) args = { 'month_cal': monthcalendar(current_year, current_month), 'month_name': calendar.month_name[current_month], 'year_name': current_year, } return render(request, 'static/html/view_schedule.html', args) view_schedule.html <div class="card-header"> Schedule for {{ month_name }} {{ year_name }} <form class="date-selector" method="post"> {% csrf_token %} <div class="dropdown"> <button class="btn dropdown-toggle" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> <i class="far fa-caret-square-down"></i> </button> <div class="dropdown-menu" aria-labelledby="dropdownMenuButton"> <a class="dropdown-item" href={% url 'view_schedule_selected_month' selected_month=1 %}>Jan</a> <a class="dropdown-item" href={% url 'view_schedule_selected_month' selected_month=2 %}>Feb</a> <a class="dropdown-item" href={% url 'view_schedule_selected_month' selected_month=3 %}>Mar</a> </div> </div> </form> </div> My problem is that, when I click ... -
Django-Select2 Heavy
I am using Django-select2 I am trying to use the HeavySelect2Widget. THe widget is accessing the view; but is not able to display the response in the box. View: def autocomplete(request): qs = {'name':'Test'} return JsonResponse(qs) Forms.py class ReportForm1(forms.Form): auto = forms.ChoiceField(widget=HeavySelect2Widget( data_url='/autocomplete/'), ) -
complex sub-queries in MySQL
I have 3 tables as: First Table: (Purchase) date (mm-dd) quantity p_id 05-05 3 1 05-06 2 1 Second Table: (Sales) date (mm-dd) quantity p_id 05-07 1 1 Third Table: (Expired) date (mm-dd) quantity p_id 05-08 4 1 Now what I want is get details of products that have expired as: When the product that has expired was purchased (FIFO) Product that was purchased first, will expire/sell first. The Output shall be: purchase_date expired_date quantity p_id 05-05 05-08 2 1 05-06 05-08 2 1 Explanation, Store have total of 5 products by 05-06 with p_id: 1, then on 05-07 1 quantity was sold of p_id: 1 i.e. product that was received on 05-05 was sold first as per FIFO so now product we have are: (only for visualization) date (mm-dd) quantity p_id 05-05 2 1 -its 1 quantity is sold 05-06 2 1 Then Expiry is made on 05-08, expired products are: (by FIFO) purchase_date expired_date quantity p_id 05-05 05-08 2 1 05-06 05-08 2 1 i.e. 2 products of 05-05 have expired and 2 of 05-06 By now logic I am implementing is: All Appended transactions: date (mm-dd) quantity p_id expired 05-05 3 1 False 05-06 2 1 False ... -
How to sort and group an list of dictionaries in right way in Python
I have an list of dict in Python as follows: options = [ {'group_priority': 2, 'group': u'Comfort', 'name': u'Air conditioning'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Air suspension'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Cruise control'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Leather interior'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Parking assist system camera'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Parking assist system sensors rear'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Power steering'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Seat heating'}, {'group_priority': 2, 'group': u'Comfort', 'name': u'Sunroof'}, {'group_priority': 3, 'group': u'Entertainment', 'name': u'Bluetooth'}, {'group_priority': 3, 'group': u'Entertainment', 'name': u'MP3'}, {'group_priority': 3, 'group': u'Entertainment', 'name': u'Navigation system'}, {'group_priority': 4, 'group': u'Extra', 'name': u'Alloy wheels'}, {'group_priority': 4, 'group': u'Extra', 'name': u'Trailer hitch'}, {'group_priority': 4, 'group': u'Extra', 'name': u'Winter tyres'}, {'group_priority': 4, 'group': u'Security', 'name': u'Xenon headlights'}] I want to order it by group_priority and group it by group and show it in Django template/ What I have tried: options_grouped_dict = {} for item in options_grouped: options_grouped_dict.setdefault(item['group'], []).append(item['name']) And then in Django template: {% for key, values in car.options_grouped.items %} <div> <div><strong>{{key}}</strong></div> {% for option in values %} <div> {% if option|length > 31 %} {{ option|truncatechars:34 }} {% else %} {{ option }} {% endif %} </div> {% endfor ... -
Django's cache framework - auto deletion?
I have encountered the following problem and I have no clue why. I use Django's cache framework to cache part of my site. I have set the expires time as 15mins. Sometimes when I am checking with the database, there is no record in the cache table. At first, I suspect Django will remove the expired cache in the database. But later, I can find some expired caches still exist in the table. I want to ask how Django handles the cache in the database? Does Django auto-remove all the expired cache in the table? Thanks! -
How to redirect url in Django Template View?
I want to send Json data and then redirect back to home.Should i use success_url? class ApiLoginView(TemplateView): template_name = 'index.html' def post(self,request): email = request.POST.get('login-email') password = request.POST.get('login-password') API_KEY = GetAPIkey().api_key_token() API_URL = GetAPIurl().api_url_token() parameter = { 'authToken':API_KEY, 'email':email, 'password':password, } r = requests.post(url = API_URL, params=parameter) if email: request.session['email'] = email return HttpResponse(r) -
Django in edx and whant to solve
The following is the error code generated when the Django system operates a webpage exercise. After reading this bunch of error codes, I still don't know how to solve the problem. Does Django have a folder or file to store error information? How can I solve the problem after seeing such an error code? Can you give me a direction? Thank you The error code is as follows: Staff debug info: Traceback (most recent call last): File "/edx/app/edxapp/edx-platform/common/lib/xmodule/xmodule line 1151, in submit_problem correct_map = self.lcp.grade_answers(answers) File "/edx/app/edxapp/edx-platform/common/lib/capa/capa/capa_problem.py", line 400, in grade_answers return self._grade_answers(answers) File "/edx/app/edxapp/edx-platform/common/lib/capa/capa/capa_problem.py", line 462, in _grade_answers results = responder.evaluate_answers(self.student_answers, oldcmap) File "/edx/app/edxapp/edx-platform/common/lib/capa/capa/responsetypes.py", line 306, in evaluate_answers new_cmap = self.get_score(student_answers) File "/edx/app/edxapp/edx-platform/common/lib/capa/capa/responsetypes.py", line 2255, in get_score self.execute_check_function(idset, submission) File "/edx/app/edxapp/edx-platform/common/lib/capa/capa/responsetypes.py", line 2310, in execute_check_function self._handle_exec_exception(err) File "/edx/app/edxapp/edx-platform/common/lib/capa/capa/responsetypes.py", line 2512, in _handle_exec_exception raise ResponseError(err.message, traceback_obj) ResponseError: ('Couldn\'t execute jailed code: stdout: \'\', stderr: \'Traceback (most recent call last):\\n File "jailed_code", line 15, in <module>\\n exec code in g_dict\\n File "<string>", line 91, in <module>\\n File "<string>", line 76, in get_score\\n File "/usr/lib/python2.7/csv.py", line 8, in <module>\\n from _csv import Error, __version__, writer, reader, register_dialect, \\\\\\nImportError: /edx/app/edxapp/venvs/edxapp-sandbox/lib/python2.7/lib-dynload/_csv.x86_64-linux-gnu.so: failed to map segment from shared object\\n\' with status code: 1', <traceback object ... -
What are processes?
I am a french Django programmer and I wanted to see what options I had to host my servers. When I went to Django Europe's pricing, there was a limit of processes you can do per month. What are these? Is 50 a lot? Is it a scam? Please help me or tell me a french definition because I don't understand what they mean by process. 10GB SSD Starter Plan €5/month 10GB SSD Storage 0.5GB RAM 50 Processes 1 SSH User -
Django Nginx is not serving wagtail admin css/js files
I set up my django wagtail on a ubuntu server with a domain using NGINX and Gunicorn. My CSS and JS files located in the static folder in my directory are being served correctly, but I can't figure out why the Wagtail Admin CSS/JS files are not being served. I'm assuming it has something to do with the fact that the Wagtail admin files are not located in my static folder with my CSS/JS files. I ran CollectStatic and set Debug=False. Google chrome is reporting a 404 files not found on the admin CSS/JS Part of NGINX File server { listen 443 default_server; listen [::]:443 default_server; root /home/projects/stemletics/stemletics/mysite/mysite; index index.html index.htm; # Make site accessible from http://localhost/ server_name domain.com www.domain.com; location = /favicon.ico { access_log off; log_not_found off; } location /static/ { root /home/projects/stemletics/stemletics/mysite/mysite; } location / { include proxy_params; proxy_pass http://unix:/home/projects/stemletics/stemletics/mysite/mysite.sock; } -
Django2.1- error- everything was working fine but it started giving {% ur 'name' %}l error
enter image description here everything was working fine but it started giving {% ur 'name' %}l error, when i delete this works fine!Using to django-2.1, jinja2, python-3.6 -
Error saving custom model admin on Django
At first I'd would say this is my first time here and I also want for my English. I hope explain myself. Well, I'm developing a web with Django 2.0 and I have a curious (and annoying) problem wich didn't exist at development environment. I'm on myweb.com/admin, saving data and it has a ImageField and when I'm saving Django tells me: Page not found (404) Request Method: POST Request URL: http://www.myweb.com/admin/about/about/add/ Raised by: django.contrib.admin.options.add_view Using the URLconf defined in myweb.urls, Django tried these URL patterns, in this order: busqueda/ contacto/ sobre-mi/ admin/ [name='home'] <slug:categoria>/ [name='category'] <slug:category>/<slug:slug>/ [name='post'] ^media\/(?P<path>.*)$ The current path, about/about/add/, didn't match any of these. I've mentioned about ImageField because I had no problems with two models without this Field. This is myproject/urls.py: from django.contrib import admin from django.urls import path, include from django.conf import settings from django.conf.urls.static import static urlpatterns = [ path('busqueda/', include('search.urls')), path('contacto/', include('contact.urls')), path('sobre-mi/', include('about.urls')), path('admin/', admin.site.urls), path('', include('post.urls')), ] + static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT) And about/urls.py: from django.urls import path from .views import AboutView app_name = 'about' urlpatterns = [ path('', AboutView.as_view(), name='about-me'), ] Thanks mates. I suppose it's an stupid question, but I'm not able to resolve it myself. -
Cloned Django app on Ubuntu with Nginx and uwsgi
So recently I just cloned my instance in order to add it to a load balancer. Everything is set up fine but I can't help thinking that I am missing something. It has been a while and my friend set up my first server. Is there somewhere that I must add the new Public Ip of my Clone server? Perhaps the Allowed Host in settings.py? Heres exactly what I have done: Clone the server Git pull Add to loadbalancer Am I missing a step somewhere that I add the new IP? Sometimes I get a Django Invalid External IP message. Im guessing it's when clone server tries to make requests.
