Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Error Using Ajax when I load from a differente file with Django
Im using JaxaScript(Jquery with Ajax) and my HTML Page all in the same file, but when I tried to code my JS and HTML in different files, I get an error when trying to ajax with Django. JS: $(document).on('click', '#add-button', function (e) { e.preventDefault(); value = $(this).data("forloopcounter"); value = value - 1 let variation_id = document.getElementsByClassName("select-variations")[value].attributes[2].nodeValue console.log(variation_id) $.ajax({ type: "POST", url: '{% url "cart:add" %}', data: { variationid: variation_id, productquantity: 1, csrfmiddlewaretoken: "{{csrf_token}}", action: 'post' }, success: function (json) { document.getElementById("cart-quantity").innerHTML = json.quantity }, error: function (xhr, errmsg, err) { console.log(xhr) } }); }) Note: I have a guess it's because of this url: '{% url "cart:add" %}', but I don't know how to fix. Note: when I ajax with all in the same page it works. Note it's not an importation error, when i execute console.log it works Error I get in the web: jquery.min.js:4 POST http://127.0.0.1:8000/%7B%%20url%20%22cart:add%22%20%%7D 404 (Not Found) -
Can I use "-" in django project name
While I am trying to create a new project in Django I got this error command used : django-admin startproject test-service 'test-service' is not a valid project name. Please make sure the name is a valid identifier. Then I tried with django-admin startproject test_service and it is working. Can you please confirm whether i can use dash in project name. I am planning to do a uniq naming convention for upcoming projects also. -
Django : stop access to my web app from being accessed on port 8000 and access only using the IP
I have deployed my Django web app on a digital ocean droplet. The python server is running on port 8000. python manage.py runserver 0.0.0.0:8000 I have configured apache web server to serve the requests. /etc/apache2/sites-available/000-default.conf <VirtualHost *:80> ServerAdmin webmaster@localhost DocumentRoot /etc/myproject ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined #Serving static files Alias /static/ /etc/myproject/static/ <Directory /etc/myproject/static> Require all granted </Directory> <Directory /etc/myproject/myproject> <Files wsgi.py> Require all granted </Files> </Directory> WSGIDaemonProcess myproject python-path=/etc/myproject python-home=/etc/myprojectenv WSGIProcessGroup myproject WSGIScriptAlias / /etc/myproject/myproject/wsgi.py </VirtualHost> Now when I am accessing my web app using the IP address X.X.X.X, I am able to see my app, however the app is also accessible on port 8000, X.X.X.X:8000. I want to prevent my app from being accessed on any other port except being accessed ousing IP. How can I do that? -
How Can I Search One Model and get Related Fields from Another Model in Django
I am working on a project in Django where I have two Models; Profile and submitted_apps. How do I efficiently relate these Models such that I would be able to get applicant's profile details like username, nation, state, upon search of submited_app Model. Is it good to use a OneToOneFields where as I did here on all Models. Understand that the submitted_apps Model is recording those applicants who successfully submitted their application form. I also have a ModelForm form named Applicant_Search_Form. Profile Model Code below class Profile(models.Model): applicant = models.OneToOneField(User, on_delete=models.CASCADE, null = True) surname = models.CharField(max_length=10, null=True) othernames = models.CharField(max_length=30, null=True) gender = models.CharField(max_length=6, choices=GENDER, blank=True, null=True) nation = models.CharField(max_length=10, choices=NATION, blank=True, null=True) state = models.CharField(max_length=20, null=True) address = models.CharField(max_length=200, null=True) phone = models.CharField(max_length=11, null=True) image = models.ImageField(default='avatar.jpg', upload_to ='profile_images') Submitted Model Code below" class submited_apps(models.Model): applicant = models.OneToOneField(User, on_delete=models.CASCADE, null=True) application = models.UUIDField(primary_key = True, editable = False, default=uuid.uuid4) confirm = models.BooleanField() date = models.DateTimeField(auto_now_add=True) def save(self, *args, **kwargs): self.application == str(uuid.uuid4()) super().save(*args, **kwargs) def __unicode__(self): return self.applicant def __str__(self): return f'Application Number: {self.application}-{self.applicant}' Here is my code for the ModelForm class Applicant_Search_Form(forms.ModelForm): class Meta: model = submited_apps fields = ['applicant'] Here is my view for the search … -
How to set Password Protected Pages on WeasyPrint PDF Builder?
I want to set Password Protected Pages onWeasyPrint PDF Builder. I am generated PDF using Weasyprint in Django and I want password encrypted after download PDF File. ** Here is code for generate PDF file.** def build_pdf(request,html_content, header_html=None, footer_html=None): def get_page_body(boxes): for box in boxes: if box.element_tag == "body": return box return get_page_body(box.all_children()) def get_page_and_body(html, css): if html is None: return None html = weasyprint.HTML( string=html, base_url=getattr(settings, "WEASYPRINT_BASEURL", None), url_fetcher=django_url_fetcher, ) css += "@page { margin 0 !important; }" document = html.render(stylesheets=[weasyprint.CSS(string=css)]) document_page = document.pages[0] document_body = get_page_body(document_page._page_box.all_children()) return ( document_page, document_body.copy_with_children(document_body.all_children()), ) def preprocess_html(html, context): for key, value in context.items(): html = html.replace(f"{{{{ {key} }}}}", str(value)) return html document = weasyprint.HTML( string=html_content, base_url=request.build_absolute_uri(), # base_url=getattr(settings, "WEASYPRINT_BASEURL", None), url_fetcher=django_url_fetcher, ).render() return document.write_pdf() can anyone help me? -
Get user posts using Class-based views?
Creating a blog project, how do I get the specific user's posts using Class-based views? What I have so far works, but it's incomplete. I am able to sort any user posts, but if I try to get the current logged-in user's posts, this happens to my side navbar. Here's what I have so far views.py class UserIssueListView(ListView): model = Issue template_name = 'issues/user_issues.html' context_object_name = 'issues' paginate_by = 5 def get_queryset(self): user = get_object_or_404(User, username=self.kwargs.get('username')) return Issue.objects.filter(author=user).order_by('-date_posted') nav.html <div id="nav-menu"> <ul class="nav-menu-items"> <div id="navbar-toggle"> <a href="#" class="menu-bars" id="hide-menu"> <i class="fas fa-bars nav-icon"></i> </a> <a href="#"><h3 class="text-white">Bug Tracker</h3> </a> </div> <hr /> <div class="nav-section"> <li class="nav-text"><a href="{% url 'dashboard' %}"><i class="fas fa-home nav-icon"></i>Dashboard</a></li> <li class="nav-text"><a href="{% url 'issues-home' %}"><i class="fas fa-fire nav-icon"></i>Recent Issues</a></li> <li class="nav-text"><a href=""><i class="fab fa-youtube nav-icon"></i>My Projects</a></li> </div> <hr /> <div class="nav-section"> {% for issue in issues %} <li class="nav-text"><a href="{% url 'user-issues' issue.author.username %}"><i class="fas fa-play-circle nav-icon"></i>My Posts</a></li> {% endfor %} <li class="nav-text"><a href=""><i class="fas fa-history nav-icon"></i>User Profile</a></li> <!-- <li class="nav-text"><a href=""><i class="fas fa-clock nav-icon"></i>Subscriptions</a></li> --> </div> </ul> </div> I suspect it's because of the for loop, but I'm stuck on how to proceed. How do I get only the current logged-in user's posts? -
How to add field to Django queryset
I'm learning DRF and trying to make website, where users can leave reviews for some products and also rate (like or dislike) this reviews. So now I'm stuck in like system. For example I have these models: class Review(models.Model): author = models.ForeignKey(User) text = models.TextField() created_at = models.DateTimeField(auto_now_add=True) class Reaction(models.Model): author = models.ForeignKey(User) review = models.ForeignKey(Review, related_name='reactions') like = models.BooleanField() # True = like, False = dislike And I want to show list of posts with like and dislike counters and also somehow mark that logged user already liked or disliked a post. I made view to list posts with counters, but don't know how to include information about post was rated by user. class ListReviews(generics.ListAPIView): serializer_class = ProductReviewSerializer def get_queryset(self): product_slug = self.kwargs['product_slug'] queryset = Review.objects.filter(product__slug=product_slug).annotate( likes_count=Count('reactions', filter=Q(reactions__like=True)), dislikes_count=Count('reactions', filter=Q(reactions__like=False)), user_reaction=... ) return queryset Is it possible at all? Or it's better to just make another endpoint to get user reactions for current page? -
Django password change view
I am trying to implement password changing in my django app, with my own template and form. So i decided to create my own view function instead of using django's. The problem Im having is the change password page doesn't change the password. I can't figure out what my problem is and could really use some help, thanks. chgpwd.html template {%extends 'auth_base.html'%} {%load static%} {%block title%} CX Labs SOC LogIn {% endblock%} {%block content%} <div class="wrapper" style="max-width:450px"> {%if form.errors %} <p style="text-align:center; margin-bottom:30px; color:red;">something went wrong</p> {%endif%} <div class="logo"> <img src="{%static 'website/cxlabs.jpg'%}" alt=""> </div> <div class="text-center mt-4 name"> CXLabs SOC <br/> Password Change</div> <form method="post" class="p-3 mt-3"> <div class="form-field d-flex align-items-center"> <span class="far fa-user"></span> {{form.oldPwd}} </div> <div class="form-field d-flex align-items-center"> <span class="far fa-user"></span> {{form.newPwd1}} </div> <div class="form-field d-flex align-items-center"> <span class="fas fa-key"></span> {{form.newPwd2}} </div> <button type="submit" class="btn mt-3">Change Password</button> {%csrf_token%} </form> </div> {%endblock%} Urls.py import django from django.contrib import admin from django.contrib.auth import views as av from django.urls import path, include from authentication.forms import CustomAuthForm, CustomPwdChgForm from website import views from authentication import views as authv urlpatterns = [ path('logout/', av.LogoutView.as_view(template_name='registration/logout.html', next_page=None), name='logout'), path('chgpwd/', authv.changepwview, name='chgpwd'), path('sign/', include('sign.urls')), path('download/<int:id>', views.zip_download, name='zipDL') ] views.py from django.shortcuts import render, redirect from django.contrib.auth … -
Django "duplicate key value violates unique constraint" because of the save method
I am trying to update an existing instance from a model in Django admin interface but I'm getting django.db.utils.IntegrityError: duplicate key value violates unique constraint because of the save method. According to the documentation, the save method should not have any problems UPDATING the model, but it seems like the primary key is set to a value that evaluates as False. https://docs.djangoproject.com/en/4.0/ref/models/instances/#how-django-knows-to-update-vs-insert . Django abstracts the need to use INSERT or UPDATE SQL statements. Specifically, when you call save() and the object’s primary key attribute does not define a default, Django follows this algorithm: If the object’s primary key attribute is set to a value that evaluates to True (i.e., a value other than None or the empty string), Django executes an UPDATE. If the object’s primary key attribute is not set or if the UPDATE didn’t update anything (e.g. if primary key is set to a value that doesn’t exist in the database), Django executes an INSERT. Now this is my model and the save method: class Examene(models.Model): saptamani = models.IntegerField(default=3, validators=[MinValueValidator(1), MaxValueValidator(5)]) zile = models.IntegerField(null=False, blank=True) profesor = models.ForeignKey(Materii_profesor, on_delete=models.CASCADE) materii = models.ManyToManyField(Materie) def save(self, *args, **kwargs): self.zile = (self.saptamani * 5) super(Examene, self).save(self, *args, **kwargs) I am … -
Microsoft auth doesn't redirect after successful login
I am integrating Microsoft's login using Django Microsoft Authentication Backend. I have managed to to get a successful response and create a new "Microsoft" user and am able to see it in the admin site if I login to the admin site as a local superuser. When I login using Microsoft, the pop up window to Microsoft opens, authenticates, and it doesn't redirect to anywhere. But, with a local non-Microsoft user, it can successfully redirects to the admin panel. I don't understand why this is so, it doesn't make sense. I have a frontpage constructed that I would like this login page to redirect to after successful login. I have included LOGIN_REDIRECT_URL = 'home' LOGOUT_REDIRECT_URL = 'home' in the settings.py file but that does not change anything. -
Python selenium send_keys not working on password field
send_keys() works with the username field but not the password field. Here is my code: class PpeLiveTest(LiveServerTestCase): # test that the first cell for the tennessee total row is the correct sum # for quince and allenbrooke for the incentives table def test_sums_incentives_tennessee(self): options = webdriver.FirefoxOptions() options.add_argument("--headless") driver = webdriver.Firefox(options=options) driver.get('https://[redacted]/pr-run-ppe?group=MS%2FTN%2FLA&check_date=05%2F01%2F2022') # login first username_element = driver.find_element_by_id('id_login') username_element.send_keys('[redacted]') password_element = driver.find_element_by_id('id_password') password_element.send_keys(os.environ.get('ADMIN_PASS')) login_button = driver.find_element_by_xpath('/html/body/div/div/div/form/button') login_button.click() I look at driver.page_source in the console when running this test. It's still the login page. username is filled with the [redacted] as expected but the password field is blank. Anyone know why? os.environ.get('ADMIN_PASS') is not blank. password_element is the correct element that we expect -
HTMX does not trigger get on load if it's a radio check
I am working on Django and using htmx I have checkbox input, select tag and radio input both work as expected on page load it sends a request to an endpoint to the server to retrieve certain information which is rendered through a partial template. The problem is only radio deosn't trigger it when the appropriate input value is checked. Here is the radio input. <input id="option_{{ option.id }}" class="form-check-input" type="radio" name="radio_{{ question.id }}" value="{{ option.id }}" {% if question.required %} required {% endif %} {% if question.disable %} disabled {% endif %} {% if option.id == radio_response %} checked {% endif %} hx-get="{% url 'survey:dynamic_loader' %}" hx-trigger="load, change" hx-target="#radio-result-{{question.id}}"/> Is this a normal behaviour for htmx? Or I am doing something wrong. -
How to pass undefined parameters in Serializer DRF?
I have an API in DRF where I want to get information from a non-relational database. The parameters of the API request vary, they can be many or few, and they can change. For this reason, I would like to know how I can pass multiple undefined arguments/parameters to a serializer. # serializers.py class MySerializer(Serializer): foo_1 = IntegerField() foo_2 = CharField() foo_3 = DictField() foo_n = ... ... Instead of this I would like to do this: # serializers.py class MySerializer(Serializer): # have undefined number of parameters # views.py class MyView(APIView): ... def post(self, request): params = requests.data.get('my_params') # dictionary object I'm very new to DRF so I'm not sure how to do it. I found solutions using ModelSerializer, but still I need to define a model, the parameters that I want are undefined in number and datatpye, but the output as a dictionary. -
Factory Boy Iterator generates the wrong order
I use Iterator to create a strict sequence of values. class MyModelFactory(DjangoModelFactory): class Meta: model = MyModel django_get_or_create = ("first_field",) first_field = Iterator(["value_1", "value_2", "value_3", "value_4"]) second_field = Iterator("aaaa", "bbbb", "cccc"]) third_field = Iterator([1, 2, 3, 4]) I expect that result should be next: [ ("value_1", "aaaa", 1), ("value_2", "bbbb", 2), ("value_3", "cccc", 3), ("value_4", "aaaa", 4) ] But the outcome is unpredictable: [ ("value_1", "aaaa", 4), ("value_2", "bbbb", 3), ("value_3", "cccc", 1), ("value_4", "aaaa", 2) ] And when I use this MyModelFactory as a RelatedFactory two times in row, my database raise an error duplicate key value violates unique constraint third_field. Yes third_field must be unique. The question is why does this error occur if I use django_get_or_create? Any ideas? -
Problem with aggregation by annotated fields
I have models: class Publisher(Model): name = TextField() class Author(Model): name = TextField() class Book(Model): publisher = ForeignKey("Publisher") author = ForeignKey("Author") class Magazine(Model): publisher = ForeignKey("Publisher") writer = ForeignKey("Author") I want to know which authors wrote for publishers. My version is this: from django.db.models import TextField, F, Subquery, OuterRef from django.contrib.postgres.aggregates import StringAgg # I use postgres # to lead to the same name books = Book.objects.annotate(author_name=F("author__name")) magazines = Magazine.objects.annotate(author_name=F("writer__name")) books = books.values("publisher_id", "author_name") magazines = magazines.values("publisher_id", "author_name") product = books.union(magazines) # !! here I have a problem with grouping product = product.group_by( "publisher_id" ).annonate( author_names=StringAgg("author_name", ";") ) publishers = Publisher.objects.all().annotate( author_names=Subquery( product.filter(publisher_id=OuterRef("id")).values("author_names")[:1], output_field=TextField() ) ) # I was expecting something like # name | author_names # ------------------------------------------ # Publisher1 | Author1;Author2;Author3 # Publisher2 | Author2 # Publisher3 | Author2;Author3 The problem is that QuerySet has no .group_by() method, instead the .values() method is suggested (product.values("publisher_id").annonate(...)). But this is complicated by the fact that I had previously called .values("publisher_id", "author_name") to bring two different models into the same view. I also tried using .only("publisher_id", "author_name"), but (maybe it's a Django bug) this method can't work together with annotated and normal fields. Is there any way to fix this problem or … -
NoReverseMatch error when filtering from Django ListView ('is not a valid view function or pattern name')
I'm trying to filter the objects from a Django ListView to render them in a template, but I'm getting a 'NoReverseMatch at' error ('Reverse for 'advanced' not found. 'advanced' is not a valid view function or pattern name'). Here are my Model, View, URL, and href: **Model** class Course(models.Model): location = models.ForeignKey(Location, blank=True, null=True, on_delete=models.CASCADE) title = models.CharField(max_length=200) level = models.CharField(max_length=200) date = models.CharField(max_length=200) price = models.DecimalField(max_digits=6, decimal_places=2) image = models.ImageField(null=True, blank=True) def __str__(self): return self.title def get_absolute_url(self): # establishes canonical url for the Course model return reverse('course_detail', args=[str(self.id)]) **View** class AdvancedListView(ListView): model = Course context_object_name = 'course_list' template_name = 'courses/advanced.html' def get_queryset(self): return Course.objects.filter( level__icontains='Advanced') **URL** from django.urls import path from .views import CourseListView, CourseDetailView, SearchResultsListView, AdvancedListView urlpatterns = [ path('', CourseListView.as_view(), name='course_list'), path('<int:pk>/', CourseDetailView.as_view(), name='course_detail'), path('search/', SearchResultsListView.as_view(), name='search_results'), path('courses/', AdvancedListView.as_view(), name='advanced'), ] **Link** <a class="dropdown-item" href="{% url 'advanced' %}">Advanced</a> Any advice greatly appreciated! -
Calculate the number of deltas between two dates
I want to calculate how many relativedelta() there are between two date objects. My code is below, it's not working though as a relative delata cannot divide a date, but maybe it shows what I'm trying to do. For example, if my relative delta is two weeks relativedelta(weeks=1) and my dates are 2022-05-01 and 2022-05-15 then two of the 1 week deltas will fit into the two dates that are two weeks apart. delta=relativedelta(days= self.cleaned_data['delta_days'], months=self.cleaned_data['delta_months']) no_loops = (self.cleaned_data['to_date'] - self.cleaned_data['from_date']) / delta if no_loops > 36: raise ValidationError('Too many iterations.') -
Django : Updating ForeignKey automatically with 'add' button
Using Python 4.03. I have two models that are connected, with Asset: class Asset(models.Model): Order_Number = models.ForeignKey(Order, on_delete=models.CASCADE, null=True, blank=True) Asset_QR = models.CharField(max_length=100, default='') .... more fields below being a child to Order: class Order(models.Model): Order_Number = models.CharField(max_length=100) Customer = models.CharField(max_length=100, default='') Customer_Address = models.CharField(max_length=100, default='') What I'm trying to do is to create a simple "Add" button next to a list of assets that are not attached to any Order yet. I've created a view: def attachassets (request, id): order = Order.objects.get(id=id) #This displays the Order I want to add my assets to assets = Asset.objects.exclude(Order_Number__isnull=False) #This filters to display only Assets that have no Order assigned On my HTML page I display my order info and below it just a simple table which iterates over assets and has and "ADD" button next to them: <table class="table table-hover"> <thead class="thead-dark"> <tr> <th scope="col">Attach</th> <th scope="col">Asset</th> </tr> </thead> <tbody> {%for asset in assets %} <tr> <td> <form action="" method=POST> {% csrf_token %} <button type="submit" class = "btn btn-dark", name="add" value={{order.id}}>Add</button> </td> <td><a class="btn btn-outline-secondary" name="assetid" value={{asset.id}} href='/asset/{{asset.id}}'>{{asset.Asset_QR}} {{asset.Make}} {{asset.Model}} {{asset.Serial_Number}}</a></td> </tr> </form> {% endfor %} </tbody> </table> Then in my Views I tried the following: if request.method == 'POST': x … -
Implimenting a ranking algorithm in Django query
I currently have upvotes and downvotes stored. I am trying to make a ranking algorithm as such ranking = log(upvotes - downvotes) But in doing my query in Django I am using annotate``as such, and am unsure where I would add in the math.log` to the annotate so it ranks it by log? Here is the code defeniciones = Palabra.objects.prefetch_related( 'tag_set' ).filter( nombre__iexact=palabra, aprobada=True ).annotate(total_votes=Count('userUpVotes') - NullIf((Count('userDownVotes')) ,0)).order_by(F('total_votes').desc(nulls_last=True),"total_votes") -
Django CreateView not saving all fields...but UpdateView does
I'm using Django CBV's to allow managers to add and update user information in the front end. When I create a new user, two of the fields are not saved to the database; Django's built in permission groups, and a manytomanyfield that determines what newsfeeds the user can view. The strange thing is, when I update the user using an updateview, it saves just fine. No errors when I submit on the createview, and all o Am I missing something blatantly obvious here? Both templates are laid out the same, both with enctype="multipart/form-data" method="post" . Django 4.0.4 / Allauth Model: class CustomUser(AbstractUser): #auth id = models.UUIDField(default=uuid.uuid4, unique=True, editable=False, primary_key=True) username = models.CharField(max_length = 50, blank=True, null=True, unique=True) email = models.EmailField(gettext_lazy('email address'), unique=True) #Employment info department = models.ForeignKey(Department, on_delete=models.SET_NULL, null=True, blank=False) job_title = models.CharField(max_length = 50, null=True, blank=False) #Personal Info profile_picture = ProcessedImageField( upload_to='profile_images/', processors=[ResizeToFill(width=1000, height=1000, upscale=True)], format='JPEG', options={'quality': 100}, null=True, blank=True ) # Newsfeeds viewable_newsfeeds = models.ManyToManyField(Department, blank=True, related_name='viewable_newsfeeds') #Permissions department_head = models.OneToOneField(Department, related_name='department_head', on_delete=models.SET_NULL, unique=True, null=True, blank=True) USERNAME_FIELD = 'email' REQUIRED_FIELDS = ['username', 'first_name', 'last_name', 'job_title'] class Meta: ordering = ['first_name',] verbose_name = "User" verbose_name_plural = "Users" permissions = [ ('manager_dashboard', 'Can view the manager dashboard'), ('manager_content', 'Can view … -
How to get the code returned by Cognito Hosted UI Autentication in Django?
I want to implement the Cognito Hosted UI for some users in my Django application. I have successfully been able to redirect the users to the desired url for authentication using the following: return redirect(https://....amazoncognito.com/oauth2/authorize?client_id=....redirect_uri=localhost). I am able to successfully authenticate and redirect back to my localhost where the url in the browser is localhost/?code=xyz. I do not understand how I can retrieve this code xyz back in python to perform next steps? I see that in the Django Terminal that it reads the required code. This is what the terminal shows: [04/May/2022 16:08:15] "POST /login HTTP/1.1" 302 0 [04/May/2022 12:09:04] "GET /?code=xyz HTTP/1.1" 200 8737 I just do not know how to get this code xyz in my views.py so that I can continue the login. I tried variations of request.GET that did not work. Any help is appreciated!! -
Django export-import admin
I am trying to import a json file to my database with Django export-import extension. but when i try to import i get this error msg "Line number: 1 - 'id' 20, 2, 1, CONTAINER1134, 26.30, 10, 1, 1, 3 Traceback (most recent call last): File "/Users/tiberiuminzat/.local/share/virtualenvs/redrock-planning-system-I02kV_z2/lib/python3.10/site-packages/import_export/resources.py", line 661, in import_row instance, new = self.get_or_init_instance(instance_loader, row) File "/Users/tiberiuminzat/.local/share/virtualenvs/redrock-planning-system-I02kV_z2/lib/python3.10/site-packages/import_export/resources.py", line 353, in get_or_init_instance instance = self.get_instance(instance_loader, row) File "/Users/tiberiuminzat/.local/share/virtualenvs/redrock-planning-system-I02kV_z2/lib/python3.10/site-packages/import_export/resources.py", line 340, in get_instance import_id_fields = [ File "/Users/tiberiuminzat/.local/share/virtualenvs/redrock-planning-system-I02kV_z2/lib/python3.10/site-packages/import_export/resources.py", line 341, in self.fields[f] for f in self.get_import_id_fields() KeyError: 'id'" models.py class Subtask(models.Model): subtaskID = models.IntegerField(primary_key=True, auto_created=True) operationID = models.ForeignKey('Operation', on_delete=models.CASCADE) assignee = models.ForeignKey('Employee', on_delete=models.CASCADE) containerID = models.CharField(max_length=255) containerWeightT = models.DecimalField(max_digits=6, decimal_places=2) loadSeq = models.IntegerField() moveTo = models.ForeignKey('MoveTo', on_delete=models.CASCADE) stow = models.ForeignKey('Stow', on_delete=models.CASCADE) status = models.ForeignKey( 'Status', on_delete=models.CASCADE) resources.py from import_export import resources from redrock.models import Subtask class SubtaskResource(resources.ModelResource): class Meta: model = Subtask import_id_fields = ('subtaskID') admin.py class SubtaskAdmin(ImportExportModelAdmin): list_display = ['subtaskID', 'operationID','assignee', 'containerID', 'containerWeightT', 'loadSeq', 'moveTo', 'stow', 'status'] list_editable = ['containerID', 'containerWeightT', 'loadSeq', 'status','assignee'] list_filter = ['operationID', 'status'] list_per_page = 10 def status(self, operation): return operation.status.status json [{"subtaskID": 20, "operationID": 2, "assignee": 1, "containerID": "CONTAINER1134", "containerWeightT": "26.30", "loadSeq": 10, "moveTo": 1, "stow": 1, "status": 3}] -
Django send full QuerySet in Channels
I am using Django Channels to build a game. It's a super simple multiplayer chance game. After user clicks a button the game starts and the server receives the data via Channels. I do the necessary calculations, database updates etc. Now I want to send data back to the browser. I do a filter query from the database and I would like to send the whole query back. I know I could take out the necessary data one by one and send them separately but I feel like there's a better way but I just can't figure it out. When I would send the QuerySet like in views.py I get a TypeError: Object of type QuerySet is not JSON serializable. Sending the query using list() also gives me an error ValueError: The QuerySet value for an exact lookup must be limited to one result using slicing. Is there a way I could send the whole QuerySet with Channels? consumer.py async def send_message(self, event): room_name = event['room_name'] roomObj = cbr.objects.filter(room_name=room_name) cbObj = cb.objects.filter(room=roomObj) #cbObj is what I would like to send await self.send(text_data=json.dumps({ 'cb': cbObj # Gives TypeError })) -
insert or update on table "django_admin_log" violates foreign key constraint "django_admin_log_user_id_c564eba6_fk_auth_user_id"
I have looked at a bunch of similar posts and none seem to give me the answer I need. When I try to add data to a model via the Django Admin site, it gives me this error: IntegrityError at /admin/api/appuser/ insert or update on table "django_admin_log" violates foreign key constraint "django_admin_log_user_id_c564eba6_fk_auth_user_id" DETAIL: Key (user_id)=(2) is not present in table "auth_user". When I looked at my database, the table auth_user did only have one entry with user_id 1. So it does make sense that the error is thrown. However, I am not sure why it is even looking at the auth_user table in the first place because I have another table called api_appuser where my actual users are stored. In this table, there is a user with id 2. So, can anyone help me figure out why this error is being thrown and why admin.py is looking at the auth_user table in the first place? Thanks! Also, I am using Postgres as my database if that matters. Full traceback: Traceback (most recent call last): File "/Users/jhcscomputer1/.local/share/virtualenvs/senior_project-hOu14Mps/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) psycopg2.errors.ForeignKeyViolation: insert or update on table "django_admin_log" violates foreign key constraint "django_admin_log_user_id_c564eba6_fk_auth_user_id" DETAIL: Key (user_id)=(2) is not … -
How to add Icons in Django forms creating forms from Models
i am newbie in python, i'm try to create forms from models in django. I need to put icons in the html5 lines i'm using fontawesome and i can put icon if i add the html codeline but i need to bring the variable "fa fa-shower" or "{icon name}" from my forms.py my code in forms.py is: class LoginForm(forms.ModelForm): class Meta: model = User fields = ['username', 'password'] icons = { 'username': 'fa fa-user', 'password': 'fa fa-lock', } labels = { 'username': 'User/Correo: ', 'password': 'Contraseña ', } widgets = { 'username': forms.TextInput(attrs={'class': 'form-control'}), 'email': forms.TextInput(attrs={'class': 'form-control'}), 'password': forms.PasswordInput(attrs={'class': 'form-control'}), } class iconModelForm(LoginForm): def __init__(self, *args, **kwargs): super().__init__(self, *args, **kwargs) icons = getattr(self.Meta, 'icons', dict()) for field_name, field in self.fields.items(): if field_name in icons: field.icon = icons[field_name] how can pass the context of two classes from view to html? my views.py is: class LoginLocal(View): def get(self, request): contexto = { 'formLogin': LoginForm(), # 'formIcon': iconModelForm(), } print(contexto) return render(request, 'login_reg_app/login.html', contexto) and how can i read two list in the same for in html? I tried to use ZIP but it showed error. my file login.html is: <form action="{% url 'login_reg_app:login' %}" method="post" > {% csrf_token %} {{ formLogin.non_field_errors }} …
