Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Change Plotly Graph for mobile
I have created a graoh that looks good in the web browser, but looks terrible in mobile. Is there any way with plotly or django to help it look better in mobile? I came across an article showing how to make a mobile view within plotly but it appears they took that option out since the article came out, as I could not find the option anywhere. I'm currently using an iframe to embed it into a blog post. Here is what it looks like on web page And here is what it looks like on mobile: And here is the iframe html im using to embed it into my blog post. <p><iframe height="525" id="igraph" scrolling="no" seamless="seamless" src="https://plotly.com/~JakeSpeers/13.embed?showlink=false" style="border:none;" width="100%"></iframe></p> There has to be a better way to make it look better on mobile. Thanks in advance -
How would I manage to upload al the rows with the django view?
I posted this question here and got a suggestion. I managed to go through it but wasn't able to implement it for the import part[I managed export]. I'm therefore back with the question. Could I have a way to loop through all the rows in the uploaded file and have all the data uploaded. Currently it uploads only one item, one row. def UploadTeachersView(request): message='' if request.method == 'POST': form = NewTeachersForm(request.POST, request.FILES) if form.is_valid(): excel_file = request.FILES['file'] fd, path = tempfile.mkstemp() try: with os.fdopen(fd, 'wb') as tmp: tmp.write(excel_file.read()) book = xlrd.open_workbook(path) sheet = book.sheet_by_index(0) obj=TeacherData( school_id = sheet.cell_value(rowx=1, colx=1), code = sheet.cell_value(rowx=1, colx=2), first_name = sheet.cell_value(rowx=1, colx=3), last_name = sheet.cell_value(rowx=1, colx=4), email = sheet.cell_value(rowx=1, colx=5), phone = sheet.cell_value(rowx=1, colx=6), ) obj.save() finally: os.remove(path) else: message='Invalid Entries' else: form = NewTeachersForm() return render(request,'upload_teacher.html', {'form':form,'message':message}) -
django ajax display nothing in for loop
i have to use for loop inside my ajax request , i used django inlineformset , when admin selects an item it has to return back the price , but it doesnt work in for loop class Item(models.Model): items = models.CharField(max_length=50) price = models.DecimalField(max_digits=10,decimal_places=3)#i have to return this price def __str__(self): return self.items class Invoice(models.Model): admin = models.ForeignKey(User,on_delete=models.CASCADE) customer = models.CharField(max_length=50) items = models.ManyToManyField(Item,through='ItemsInvoice') class ItemsInvoice(models.Model): invoice_no = models.ForeignKey(Invoice,on_delete=models.CASCADE) item = models.ForeignKey(Item,on_delete=models.CASCADE) quantity = models.IntegerField() price = models.DecimalField(max_digits=10,decimal_places=3)#when selecting an item , the price return back and write in the price field my views.py @login_required def check_price(request): item = request.GET.get('invoice-0-item',None) price = Item.objects.get(id=item).price print(price) data = { 'price':price, } return JsonResponse(data) and i dont know how to iterate through the number of forms to achieve this @login_required def check_price(request): for i in range(length of forms): item = request.GET.get('invoice-'+i+'-item',None) #etc <form method="POST">{% csrf_token %} {{items.management_form}} <div class="p-1 pr-2 pb-1 text-xs border border-black rounded-lg flex flex-wrap" style="direction: rtl;"> <div class="flex w-8/12 lg:w-9/12"> <div class=""> customer name : </div> <div class="w-10/12 ml-8 border-b border-gray-600 border-dotted"> {{form.customer | add_class:'bg-transparent w-full text-center focus:outline-none customer' }} {% if form.customer.errors %} <div class="redCOLOR pb-1 my-0 text-center rounded-lg w-full md:w-6/12 mx-auto">{{form.customer.errors}}</div> {% endif %} </div> </div> </div> <!-- … -
Django merge duplicate rows
I have a table like this. id|name |user_id |amount| --|---------------------|------------|------| 1|Name1 |1 | 4| 2|Name1 |1 | 7| 3|Name2 |1 | 5| I want to merge rows that have the same name and user_id and that should look like this: id|name |user_id |amount| --|---------------------|------------|------| 1|Name1 |1 | 11| 2|Name2 |1 | 5| Django ver = 3.1 -
Uncaught TypeError: Cannot read property 'style' of null when using data-SOMETHING attribute to pass parameter to JavaScript function
I'm new to coding and I'm trying to hide a paragraph using JavaScript. This is my HTML {% for post in posts %} <div class="container p-3 my-3"> <div class="card"> <div class="card-block px-1"> <h4 class="card-title"> <a href="{% url 'profile' post.user.id %}">{{ post.user }}</a> </h4> <p class="card-text" id="{{ post.id }}">{{ post.content }}</p> <textarea style="display: none;" id="edit-view">{{ post.content }}</textarea> <p class="card-text" id="time">Posted on: {{ post.timestamp }}</p> {% if post.user == request.user %} <button type="button" class="btn btn-primary" id="edit-btn" data-text="{{ post.id }}">Edit</button> {% endif %} <button type="button" class="btn btn-primary" id="save-btn" style="display:none;">Save</button> <p class="card-footer">{{ post.like }} Likes</p> </div> </div> </div> {% endfor %} Looking at the source code I could verify that the post.id context is correctly displayed in both the data-text attribute and the id of the paragraph I want to hide. This instead is my JavaScript function (which I have in a separate js file): function edit(text) { // hide content document.querySelector(`#${text}`).style.display = 'none'; } I'm calling the function after loading the DOM and applying and event listener to all buttons with id of edit-btn: document.addEventListener('DOMContentLoaded', function() { // Adding event listener document.querySelectorAll('#edit-btn').forEach(function(button) { button.onclick = function() { console.log('Button clicked!') edit(); } }); }); Nevertheless I get the above error, as if the parameter … -
How do I solve this error in my view? Local variable 'result' referenced before assignment
This view complains of the local variable result being referenced before being assigned, please help me arrange well. def UploadTeachersView(request): if request.method == 'POST': form = NewTeachersForm(request.POST, request.FILES) dataset = Dataset() new_persons = request.FILES['file'] imported_data = dataset.load(new_persons.read(), format='xls') result = ImportTeachersResource().import_data(dataset, dry_run=True) # Test the data import if result.has_errors(): messages.info(request,f"Errors experienced during import.") else: ImportTeachersResource().import_data(dataset, dry_run=False) # Actually import now messages.info(request,'Details uploaded successfully...') else: form = NewTeachersForm() return render(request, 'new_teacher.html',{'form':form, 'result':result}) -
HTTP 403 , running django with Nginx + Passenger + Django + Virtualenv
I just starting to learn how to use Pushion Passenger with nginx on my internal server. First, here is my passenger-memory-stats (penumpang:3.8) debian@debian-mon-lama ~/penumpang sudo /usr/sbin/passenger-memory-stats Version: 6.0.8 Date : 2021-04-07 14:41:42 +0700 ... ---------- Nginx processes ---------- PID PPID VMSize Private Name ------------------------------------- 24731 1 68.0 MB 0.4 MB nginx: master process /usr/sbin/nginx -g daemon on; master_process on; 24736 24731 68.2 MB 0.6 MB nginx: worker process 24737 24731 68.2 MB 0.7 MB nginx: worker process 24738 24731 68.2 MB 0.6 MB nginx: worker process 24739 24731 68.2 MB 0.6 MB nginx: worker process ### Processes: 5 ### Total private dirty RSS: 2.95 MB ----- Passenger processes ------ PID VMSize Private Name -------------------------------- 24717 298.3 MB 2.5 MB Passenger watchdog 24721 1190.6 MB 5.5 MB Passenger core ### Processes: 2 ### Total private dirty RSS: 8.05 MB Looks slight different than https://www.phusionpassenger.com/docs/advanced_guides/install_and_upgrade/nginx/install/oss/buster.html here is my nginx site-enabled (penumpang:3.8) debian@debian-mon-lama ~/penumpang cat /etc/nginx/sites-enabled/penumpang.site #FROM https://www.phusionpassenger.com/library/config/nginx/intro.html server { server_name debian-mon-lama; root /home/debian/penumpang; passenger_enabled on; passenger_python /home/debian/virtualenv/penumpang/3.8/bin/python; } venv created by debian@debian-mon-lama ~/penumpang virtualenv --prompt '(penumpang:3.8)' --python /usr/local/bin/python3.8 --system-site-packages /home/debian/virtualenv/penumpang/3.8/ here is my passenger_wsgi.py debian@debian-mon-lama ~/penumpang cat ./passenger_wsgi.py import sys, os #FROM https://help.dreamhost.com/hc/en-us/articles/360002341572-Creating-a-Django-project INTERP … -
i was creating a website using django and i got an error can anyone help me its a a typeerror
TypeError at /contact contact() got an unexpected keyword argument 'name' Request Method: POST def contact(request): global contact if request.method == "POST": name = request.POST.get('name') email = request.POST.get('email') phone = request.POST.get('phone') desc = request.POST.get('desc') contact =contact(name=name,email=email,phone=phone,desc=desc,date=datetime.today()) contact.save() return render(request,'contact.html') -
Django postgresql query stuck when searching on negavie condition
I have this class name: Maybe it is the class Follower(models.Model): language = models.ManyToManyField( "instagram_data.Language", verbose_name=_("language_code_name"), blank=True) class Language(models.Model): code_name = models.CharField(max_length=6, null=True, blank=True) def __str__(self): return self.code_name While searching for specific name it return values fast (few sec), (i.g language.code_name = "he"): he lang While adding the check for language.code_name != "ar", it can take few minutes ! Maybe design issue ? -
Ordered list with M2M for different models?
How can I create a List model that has many-to-many relationships with multiple different models in a specific order? E.g. models.py class ItemA(models.Model): ??? class ItemB(models.Model): ??? class List(models.Model): ??? Shell: a1 = ItemA.objects.create() a2 = ItemA.objects.create() b1 = ItemB.objects.create() b2 = ItemB.objects.create() list1 = List.objects.create() list2 = List.objects.create() # ??? Some code here that can associate # a1, a2, b1, b2 (in that order) with list1 and # a1, b1, a2, b2 (in that order) with list2 # so that list1.items can return a1, a2, b1, b2 (in that order) # and list2.items can return a1, b1, a2, b2 (in that order) Is this even possible? -
Django 3.2 AttributeError: 'TextField' object has no attribute 'db_collation'
I've an existing project on Django 3.1 and I upgraded my project to Django 3.2. I created an app called payment on my project. But When I make migrations. It trow an error AttributeError: 'TextField' object has no attribute 'db_collation' from django.db import models from django.conf import settings from django.utils.translation import gettext_lazy as _ # Create your models here. from simple_history.models import HistoricalRecords class TransactionType(models.TextChoices): CASH_IN = 'IN', _('Cash In') CASH_OUT = 'OUT', _('Cash Out') class TransactionMethod(models.TextChoices): STUDENT_TR = 'STT', _('Student Transaction') BANK_TR = 'BKT', _('Bank Transaction') SCHOOL_TR = 'SLT', _('School Transaction') Teacher_TR = 'TRT', _('Teacher Transaction') DONATE_TR = 'DET', _('Donate Transaction') class Payment(models.Model): id = models.AutoField(primary_key=True) created_by = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.PROTECT, related_name="created_by") updated_by = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.PROTECT, related_name="updated_by") transaction_amount = models.FloatField("Transaction amount") transaction_type = models.CharField(max_length=3, choices=TransactionType.choices, default=TransactionType.CASH_IN,) transaction_method = models.CharField(max_length=3, choices=TransactionMethod.choices, default=TransactionMethod.STUDENT_TR,) transaction_note = models.CharField(null=True, blank=True, max_length=200) is_approved = models.BooleanField(default=False) is_approved_by_user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.PROTECT, related_name="approved_by", null=True, blank=True) created_at = models.DateTimeField(auto_now=True, blank=True, null=True) updated_at = models.DateTimeField(auto_now_add=True, blank=True, null=True) history = HistoricalRecords() Full error message File "manage.py", line 22, in <module> main() File "manage.py", line 18, in main execute_from_command_line(sys.argv) File "/home/asad/PycharmProjects/amarschool/venv/lib/python3.6/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line utility.execute() File "/home/asad/PycharmProjects/amarschool/venv/lib/python3.6/site-packages/django/core/management/__init__.py", line 413, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/asad/PycharmProjects/amarschool/venv/lib/python3.6/site-packages/django/core/management/base.py", line 354, in run_from_argv self.execute(*args, **cmd_options) File "/home/asad/PycharmProjects/amarschool/venv/lib/python3.6/site-packages/django/core/management/base.py", … -
How to open and render and Excel file in django?
I am getting an error in Excel say: excel cannot open the file because the file format or file extension is not valid Hi I have a excel file that is being generated each morning. I want the user to be able to download the Excel file. def export_daily_report(request): output = pd.read_excel('crontab_files/daily.xlsx') response = HttpResponse(content_type='application/vnd.ms-excel') # tell the browser what the file is named response['Content-Disposition'] = 'attachment;filename="daiy_export.xlsx"' # put the spreadsheet data into the response response.write(output) # return the response return response I want to open the excel and then render the file so that the user can download it. -
Is there any API for value the vehicles in India [closed]
I'm a self-learning web developer. I'm working on an app that is for sells and buys used vehicles. Now I searching for an A API to value the vehicles as per the vehicle details that the user has given. So please help me for finding one. -
the time in DateTimeField is not correct
Hello I am creating a website and trying to save the clock in time to the database every time a person clicks the clock in button but the time saved in the database is off by 8 hours. How do I fix this? code where I use the DateTimeField: from django.db import models from datetime import datetime, date #Create your models here. class Name(models.Model): name = models.CharField(max_length=200) timeIn = models.DateTimeField(auto_now_add=True, auto_now=False, blank=True) def __str__(self): return self.name -
Django Template _set.all
I have this model: class CustomerAddresses(models.Model): ID = models.AutoField(primary_key=True) ... CustomerID = models.ForeignKey('Customers', on_delete=models.CASCADE) I render the Address Data in my Template: % for address in customer_default_shipping_address %} {% if address.Address_Company %} <h5>{{ address.Address_Company }}<br/> {{ address.Address_Firstname }} {{ address.Address_Lastname }}</h5> {% else %} <h5>{{ address.Address_Firstname }} {{ address.Address_Lastname }}</h5> {% endif %} <address class="mb-0 font-14 address-lg"> {{ address.Street}}<br> {{ address.Zip}} {{ address.City}}<br> {% for customer in customer_default_shipping_address.customers_set.all %} <abbr title="Telefon">P:</abbr> {{ customer.PhoneNumber }} <br/> <abbr title="E-Mail">M:</abbr> {{ customer.Email }} {% endfor %} </address> {% endfor %} but the E-Mail and Phone Field will not be rendered, are I'm doing something wrong? -
django - how to nested admin objects create?
I've got a set of models that look like this: class User(AbstractBaseUser, PermissionsMixin): user_nm = models.CharField(max_length=10) user_email = models.EmailField(unique=True) user_tel = models.CharField(max_length=11, validators=[validate_user_tel]) class GolferUser(User): class Meta: proxy = True verbose_name = "Golfer User" app_label = "users" class GolferProfile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE, null=True, blank=True) user_birth = models.DateField( null=True, blank=True) user_gender = models.CharField( max_length=8, null=True, blank=True) class GolferPhoto(models.Model): golfer_profile = models.ForeignKey( GolferProfile, on_delete=models.CASCADE, related_name="GolferPhoto", null=True ) photo = models.ImageField( null=True, blank=True) and an admin.py that looks like this: class GolferPhotoInline(NestedStackedInline): model = GolferPhoto extra = 1 class GolferProfileInline(NestedStackedInline): readonly_fields = ("user_gender",) model = GolferProfile extra = 1 inlines = (GolferPhotoInline,) @admin.register(GolferUser) class GolferUserAdmin(NestedModelAdmin): inlines = (GolferProfileInline,) fields = ["user_nm","user_email"] list_display = [ "id", "user_nm", "user_birth", "user_email", ] The problem is that when I add [golferphoto] on the Admin site, the image file is not entered into the DB. An object is created in the DB, but the image file column is empty. views.py class GolferPhotoViewSet( mixins.CreateModelMixin, mixins.RetrieveModelMixin, mixins.UpdateModelMixin, mixins.DestroyModelMixin, mixins.ListModelMixin, GenericViewSet, ): queryset = GolferPhoto.objects.all() serializer_class = GolferPhotoSerializer permission_classes = (permissions.IsAuthenticatedOrReadOnly, GolferPhotoPermission) def create(self, request, *args, **kwargs): golfer_photo = super().create(request, *args, **kwargs) golfer_photo_instance = GolferPhoto.objects.get(id=golfer_photo.data["id"]) if request.FILES: image_file = request.FILES["image"] resize_image( image_file, "GOLFER" + str(golfer_photo_instance.id), "/main_photo/", "MAIN", ) resize_image( image_file, … -
Use of Subquery on django's update
I'm currently getting this error Joined field references are not permitted in this query Any idea why it happens if I do this? (models recreated for a simpler view) class Foo(models.Model): bar = models.ForeignKey( Bar, related_name='foos', on_delete=models.CASCADE) baz = models.ForeignKey( Baz, related_name='foos', null=True, blank=True, on_delete=models.SET_NULL) class Bar(models.Model): name = models.CharField(max_length=255) class Baz(models.Model): name = models.CharField(max_length=255) Foo.objects.update( baz=Subquery( Baz.objects.filter( name=OuterRef('bar__name') ).values('pk')[:1] ) ) -
Show error message in HTTP response Django [closed]
I am using http response to handle exception in my website. I want to show proper message / validation during create and update data. But It shows HTTP responses like Bad Request , Internel server error. Here is my code: try: // Some code except Exception as e: logger.error(e) return http.HttpResponseBadRequest(content=e) In pop up message it shows ,"Bad Request" Instead of "Bad Request" in pop up message I want to show another message. -
Python manage.py runserver does not return anything
I am new to Python and trying to execute "python manage.py runserver" from the command line shell but nothing happens and it just goes to the next line without any error message. -
How to save created csv into cloudinary cloud?
I am developing a data science project, I scrape specific site data, created a dataframe and saved in csv format. Now, i want to save that file to my cloudinary account as a file storage. class NepseApi(APIView): authentication_classes = [] permission_classes = [] def get(self, request, format=None): level2=[] rng=get_range(request, 8) table_Datas=get_url(request) level1= pd.Series(table_Datas).drop_duplicates().tolist() for k in level1: if len(k)> 35: level2.append(k) else: pass d=[] for l in range(1, len(level2)): c= level2[l].split('\n') d.append(c) df= pd.DataFrame(d[1:], columns=d[0]) date= pd.Timestamp.today().strftime('%Y-%m-%d') df['date']= date df_csv = df.to_csv(date +'.csv', index=True) df.rename(columns={'Traded Companies': 'company_name','No. Of Transaction': 'no_of_transaction', 'Max Price':'max_price','Min Price':'min_price','Closing Price':'closing_price','Traded Shares':'traded_shares','Previous Closing':'previous_closing','Difference Rs.':'difference_rs'}, inplace=True) jsn = json.loads(df.to_json(orient='records')) return Response(jsn) df_csv = df.to_csv(date +'.csv', index=True) # How to create path to save file? -
CurrentUserDefault doesn't work using Django Rest
I'm working with Django / Django Rest Framework and I'm looking for a solution to insert the logged user id automatically. i tried to use, user = serializers.HiddenField(default=serializers.CurrentUserDefault()) : But i doesn't work This is my serializer class from rest_framework import serializers from contact.models import Contact class ContactSerializer(serializers.ModelSerializer): user = serializers.HiddenField(default=serializers.CurrentUserDefault()) class Meta: model = Contact fields = '__all__' -
How to Open/Edit/Save Ofifce files( Excel, Word) in browser using Python, Django?
I'm working on CMS project where I want to let users open excel sheets, word files to open in the browser, edit the file and after that save the file like this website : https://products.aspose.app/cells/editor. File would be saved to database. I have tried to find way by googling but unfortunately couldn't get one. Please help with the same. Thanks in advance. -
fetching data to return foreign key related fields django ajax
I have created a project and the project includes invoices , invoice items and items, sometimes during creating the invoice the admin doesn't remember the price of the item,we have inserted the price before, so I have decided to show the price when the admin selects an item (ForeignKey) in a drop down ! is it possible, please? my models.py class Item(models.Model): items = models.CharField(max_length=50) price = models.DecimalField(max_digits=10,decimal_places=3)#i have to return this price def __str__(self): return self.items class Invoice(models.Model): admin = models.ForeignKey(User,on_delete=models.CASCADE) customer = models.CharField(max_length=50) items = models.ManyToManyField(Item,through='ItemsInvoice') class ItemsInvoice(models.Model): invoice_no = models.ForeignKey(Invoice,on_delete=models.CASCADE) item = models.ForeignKey(Item,on_delete=models.CASCADE) quantity = models.IntegerField() price = models.DecimalField(max_digits=10,decimal_places=3)#when selecting an item , the price return back and write in the price field I have to display the price of the selects Item before submitting the form, then the admin know how much the price !? i returned back the price but i dont know how to give the returned value to the price field!? i have used inlineformset @login_required def check_price(request): item = request.GET.get('invoice-0-item',None) price = Item.objects.get(id=item).price print(price) data = { 'price':price, } return JsonResponse(data) and how to iterate through the number of dynamic forms ? in order to change make the 0 dynamic 'invoice-[0]-item' ! … -
How to verify the JWT using JWK without x5c?
I have a JWT security token that I need to verify via the jwks endpoint. Data in jwks looks like this: { "keys": [ { "alg": "RS256", "kty": "RSA", "use": "sig", "n": "xkAku1RWRycD0Fw49bIkdSy1O5rMTK4gyavBAxs9lkEPMCldrtBFWteXTw4bvdkDY62EOMjFN3QdqtJD9kRLcOxS9OwlLRBCVEEgPE3AyOazzovmVSVnrrwCcclU87iG8qMMx3ZK4qbaANpVETDRm-nU5L38la4i6yeNdJm0uX91003G07Ihq9LzWaIsT8pK1dirvq8d3ElUfZ-wBVz4imKnLrRgtTiZIa8eQvGVuWiBtp4I2rijDfzaYHKyAAh55UHNXCHde9yefQnSE_SHmunkCTLiQRbA7HorAOZBK0fiR9qidLMPwNBft01spufotp7UBseO7xusHezJ9VgIew", "e": "AQAB", "kid": "764edc29-9da0-43e0-97f3-2e140cc9152a", "x5t": "bisb-ais" } ] } I have tried one third party api but it looks like it is dependent on the x5c key which isn't present in my case. My code is: def verify_token(token): api_response = api_client(route='AUTH_KEY',query = {}) response = jwks_key(data=api_response) response.is_valid(raise_exception=True) public_keys = {} for jwk in response.data['keys']: kid = jwk['kid'] alg = jwk['alg'] public_keys[kid] = jwt.algorithms.RSAAlgorithm.from_jwk(json.dumps(jwk)) kid = jwt.get_unverified_header(token)['kid'] key = public_keys[kid] payload = jwt.decode(token, key=key, algorithms=alg,verify = True) How can I validate a JWT via jwks without x5c in python? -
Double Slash is Appearing in URL | Django Sitemap
Double slashes are appearing in Sitemap.xml enter image description here Code of models.py class Category(models.Model): name = models.CharField(max_length=100) class Meta: verbose_name = "Category" verbose_name_plural = "Categories" def __str__(self): return self.name def get_absolute_url(self): return reverse("category_items", kwargs={"category": self.name}) Code of urls.py from django.contrib.sitemaps.views import sitemap from core.sitemaps import BlogSitemap, CategorySitemap sitemaps = { "blogs": BlogSitemap(), "categories": CategorySitemap(), } urlpatterns = [ path('admin/', admin.site.urls), path('', include('core.urls')), path('sitemap.xml', sitemap, {'sitemaps': sitemaps}, name='django.contrib.sitemaps.views.sitemap'), ] Code of sitemap.py class CategorySitemap(Sitemap): changeFreq = "weekly" priority = 0.5 def items(self): return Category.objects.all() what is the possible soultion
