Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How can I make a django form field value not refresh if the field is not validated and user hits submit
I have created an HTMl register form template, and designed it such that if there is any validation error, it outputs the error and that works fine. Register form showing "passwords do not match" error The problem I'm having is the whole form fields clear once I hit submit and the errors show up, this was if a user has a "passwords do not match error" he'd have to input all his details from scratch. I want the user to input only the fields that has errors. The register HTML form ` {% csrf_token %} <div class="col-md-12"> <input class="form-control" type="text" name="first_name" placeholder="Firstname" required> {% if form.first_name.errors %} {% for error in form.first_name.errors %} <span style="color:#DC3545;"> {{error}} </span> {% endfor %} {% endif %} </div> <div class="col-md-12"> <input class="form-control" type="text" name="last_name" placeholder="Lastname" required> {% if form.last_name.errors %} {% for error in form.last_name.errors %} <span style="color:#DC3545;"> {{error}} </span> {% endfor %} {% endif %} </div> <div class="col-md-12"> <input class="form-control" type="text" name="email" placeholder="Email address" required> {% if form.email.errors %} {% for error in form.email.errors %} <span style="color:#DC3545;"> {{error}} </span> {% endfor %} {% endif %} </div> <div class="col-md-12"> <input class="form-control" type="password" name="password1" placeholder="Enter Password" required> {% if form.password1.errors %} {% for error in … -
How can i add like function with Django rest framework
0 Hey guys I try make blog app I wonder How can i add Like function I realy dont know how can i do it Add like on first press, remove like on second press like the instagram, twitter or youtube . That is The Models class Post(models.Model): title = models.CharField(max_length=100) content = models.TextField() image = models.URLField(max_length=300) publish_date = models.DateTimeField(auto_now_add=True) author = models.ForeignKey(User, on_delete=models.CASCADE) That is serializers class PostSerializer(serializers.ModelSerializer): author = serializers.StringRelatedField() class Meta: model = Post fields = ( 'title', 'content', 'image', 'author', 'id', 'like_count' ) That is views class PostView(viewsets.ModelViewSet): queryset = Post.objects.all() serializer_class = PostSerializer def perform_create(self, serializer): serializer.save(author=self.request.user) that is Urls from django.urls import path from .views import ( PostView, PostView_View, LikesView, CommentView ) from rest_framework import routers router = routers.DefaultRouter() router.register('', PostView) urlpatterns = [ ] + router.urls -
Django object.filter returns Object (1) on search bar
So I have a Django website Project that contains a database of all the different books stored in it. With my search bar, if I type in the name it will show results from the database. The problem is that whenever I type in said name (One Piece or Attack On Titan), instead of showing its title name, it will either show Book Object (1) or Book Object (2) depending on what name I type and I don't know why. This is where I defined my classes: class Book(models.Model): title = models.CharField(max_length=255) author = models.CharField(max_length=255) editor = models.CharField(max_length=255) year_published = models.IntegerField() number_in_stock = models.IntegerField() daily_rate = models.FloatField(null=True) genre = models.ForeignKey(Genre, on_delete=models.CASCADE) date_created = models.DateTimeField(default=timezone.now) manga_image = models.ImageField(null=True, blank=True, upload_to='images/') And this is where I defined my requests: def search_manga(request): if request.method == "POST": searched = request.POST[('searched')] mangas = Book.objects.filter(title__contains=searched) return render(request, 'books/search_manga.html', {'searched': searched, 'mangas': mangas}) else: return render(request,'books/search_manga.html', {}) Also this is the HTML document I'm trying to show the results on: {% extends 'base.html' %} {% block content %} <style> h1 { text-align: center; } </style> {% if searched %} <h1>You Searched For {{searched}}</h1> <br/> {% for manga in mangas %} {{ manga }}<br/> {% endfor %} {% … -
How can we specify graphql schema to use a custom db for saving objects in Django?
Graphql Schema Mutations happen to use the default DB specified in settings.py. Since I have a Django project with multiple apps and db's , how can I specify graphql mutation to use a different db and not the default one. -
How to create a database using Django and Cloudant
Please, I need to implement a web-based tool that was created using the Django framework but there is no database yet and I would like to use Cloudant. As Cloudant uses JSON, how could I get input for the user and convert it to JSON? Thank you! -
coukies django python cart
How can i do a cart for a long time on django-python using cookies please response to me !! it's an emergency def Cart(request) try: customer = request.user.customer except: device = request.COOKIES['device'] customer, created = Customer.objects.get_or_create(device=device) order, created = Order.objects.get_or_create(customer=customer,complete=False) # print(order.product) categories = Category.objects.all() context={'order':order,'categories':categories} response = render (request,'store/cart.html',context) set_cookie(response, 'cart',device) return response -
Cannot add user in django rest framework
Im trying to make an API to register a new user, but I can't and I really don't know why. Im beginner. Views.py: def register_view(request): s = serializers.CreateUserSerializer(data=request.data) if s.is_valid(): s.save() return Response(s.errors) Serializers.py: class CreateUserSerializer(serializers.ModelSerializer): class Meta: model = User fields = ['email', 'username', 'password'] extra_kwargs = {'password': {'write_only': True}} def create(self, validated_data): user = User( email=validated_data['email'], username=validated_data['username'] ) user.set_password(validated_data['password']) user.save() return user Error i get: {"username":["This field is required."],"password":["This field is required."]} im simply sending data using postman -
Allowing post request through Nginx
Trying to serve a react app, django with nginx and docker. I am not able to make a post call from docker on port 8080 to nginx on port 8082. Following is the error thrown by Nginx iris-frontend-frontend-1 | 2022/10/13 20:16:18 [error] 35#35: *4 open() "/usr/share/nginx/html/add-to-waiting" failed (2: No such file or directory), client: 172.18.0.1, server: localhost, request: "POST /add-to-waiting HTTP/1.1", host: "localhost:8080", referrer: "http://localhost:8080/" Nginx configurations are: add-to-waiting is the api call. upstream django { server website:8000; } upstream react_app { server frontend:8080; } server { listen 80; client_max_body_size 100M; proxy_set_header X-Forwarded-Proto $scheme; location / { proxy_pass http://react_app; } location /admin { proxy_pass http://django; } location /add-to-waiting { proxy_pass http://django; } location /media/ { alias /app/media/; } location /static/ { alias /app/forex/static/admin/; } } What configurations need to change to make frontend able to call the api? -
Need help displaying data in a specific format using Django and Python
I am very much a newbie at Django and python, so please be gentle! I have a database with a table that has date, time, position, group number, and the names of the people in each group. This table is for scheduling purposes. The table has several lines with date, depending on the total number of people scheduled per day, three different shifts at the moment (time), and three positions. Each group that fills each position can have a varying number of people in it, and each position has a different number of groups for each time slot. What I want is something that has the date on the first row, the three times on the second row, the three positions under each of the three times on the third row, then list the group number and each person. Row 1: 1 column (date) Row 2: 3 columns (time) Row 3: 9 columns (position) Row 4-? 9 columns (group number, names listed under each group number) Honestly, I have no idea how to accomplish this layout. Any ideas? Here's the code I have so far. Thanks! View: def index(request): context = {} sched= Schedule.objects.all() context['sched'] = sched return render(request, 'index.html', … -
ModuleNotFoundError while deploying django server on heroku
I am having trouble while deploying server on heroku (ModuleNotFoundError: No module named 'screen_sender') I think it may be because I use django-channels you can see my directories below and files: Procfile web: gunicorn websocket_image_sender.wsgi settings.py import os from pathlib import Path BASE_DIR = Path(__file__).resolve().parent.parent SECRET_KEY = 'key' IS_HEROKU = "DYNO" in os.environ if not IS_HEROKU: DEBUG = True if IS_HEROKU: ALLOWED_HOSTS = ["*"] else: ALLOWED_HOSTS = [] # Application definition INSTALLED_APPS = [ 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'screen_sender', 'channels', ] ASGI_APPLICATION = 'websocket_image_sender.asgi.application' MIDDLEWARE = [ 'django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', ] ROOT_URLCONF = 'websocket_image_sender.urls' TEMPLATES = [ { 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [BASE_DIR / 'templates'] , 'APP_DIRS': True, 'OPTIONS': { 'context_processors': [ 'django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', ], }, }, ] WSGI_APPLICATION = 'websocket_image_sender.wsgi.application' # Database # https://docs.djangoproject.com/en/4.0/ref/settings/#databases DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': BASE_DIR / 'db.sqlite3', } } # Password validation # https://docs.djangoproject.com/en/4.0/ref/settings/#auth-password-validators AUTH_PASSWORD_VALIDATORS = [ { 'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator', }, { 'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator', }, { 'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator', }, { 'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator', }, ] # Internationalization # https://docs.djangoproject.com/en/4.0/topics/i18n/ LANGUAGE_CODE = 'en-us' TIME_ZONE = 'UTC' USE_I18N = True USE_TZ = True # Static files (CSS, JavaScript, Images) # https://docs.djangoproject.com/en/4.0/howto/static-files/ STATIC_URL = 'static/' # Default primary key … -
Can I deploy a Django App if there is no "" (empty) url?
I'm trying to deploy a Django App with railways for the first time and I was wondering where exactly will be my landing page. So basically my urls.py looks something like this: path('home/', views.home, name="home"), path('blogposts/', views.blogposts, name="blogposts"), path('posts/', views.posts, name="posts"), After deploying my Blog website, let's say with the domain 12345xxx.com, where will I land? -
Python WSGI Server for Kubernetes?
I want to run my Django application in Kubernetes. In Kubernetes the available ressources could limited, and the amount of CPUs you get with traditional methods could be wrong. For Go this gets handled with https://github.com/uber-go/automaxprocs Up to now I use gunicorn, but I could switch to a different wsgi server. Which wsgi server is recommended to run Django applications in Kubernetes? -
Admin approval and email verification with all-auth
I want to implement an admin approval and email confirmation system for the signup process. For now, I am using the 'is_active' field set False by default, until the admin sets it manually to True. It works so far, the only problem is that the confirmation mail is not being sent out when 'is_active' is False. The email-confirmation flag is actually in another table called accounts_emailaddress, so I am wondering why this is not working? Depending on which flag is set to False, the user should be redirected to the corresponding Templates. The user should not be able to log in, unless the email is verified and his profile approved by the administrator. How can I achieve this result? -
DigitalOcean Django Rest Framework Authentication credentials were not provided
My live site decided to throw a 403 Forbidden error yesterday on authenticated users when calling an Ajax API and I've trying to troubleshoot with no success. The localhost on my machine works fine when DEBUG = True in my settings.py, but the same code throws the following error: HTTP 403 Forbidden Allow: GET, HEAD, OPTIONS Content-Type: application/json Vary: Accept { "detail": "Authentication credentials were not provided." } My rest framework setting in settings.py: ## REST framework default permissions REST_FRAMEWORK = { 'DEFAULT_PERMISSION_CLASSES': [ 'rest_framework.permissions.IsAuthenticated', ] } Since the browsable API requires SessionAuthentication, I tried the following with no success: ## REST framework default permissions REST_FRAMEWORK = { 'DEFAULT_AUTHENTICATION_CLASSES': ( 'rest_framework.authentication.SessionAuthentication', ), 'DEFAULT_PERMISSION_CLASSES': [ 'rest_framework.permissions.IsAuthenticated', ] } I did look at Django Rest Framework Docs and it seems to suggest that if my user is logged in, the Ajax calls after login should work fine. Am I missing something? Really appreciate your input UPDATE 1: When I run the command: sudo journalctl -u gunicorn -n 25 One of the things I see is gunicorn[820]: Session data corrupted I did restart the server, hoping that by logging back in, the new session data will be generated, but the same message is … -
Using VCR mechanics to record and play queries to SQL database
Is it a viable approach to allow recording SQL queries to a file and later loading these queries from the file to memory and playing queries by monkey patching the db driver? I had employed this method in the past for recording http queries to external services with library vcrpy. I don't see any obstacles in implementation. The question is, does it even make sense in terms of test speed improvement? Also, what inconsistencies or pitfalls in usage of such an approach might this cause? -
Modifying X-frame-options in a Django app deployed using Heroku
I'm trying to embed an iframe on my portfolio page of a django app that I deployed on heroku. After doing some reading, apparently, I have to modify this property called X-frame-options in my HTTP headers, but I'm not sure where I'm supposed to find it in my Django or Heroku files/dashboards and what I'm supposed to set it to if I want to allow it to be embedded on an external website? -
Django Rest Framework | How to create a new product with Category name not ID
I have two models created in Django. I am trying to send post request from react frontend using axios API call. My react is working fine and I can post request using category id but not with category name ( either hardcoded or from the dropdown list) I tried using Postman, I get the same result. class Category(models.Model): name = models.CharField(max_length=50) slug = models.SlugField(unique=True, null=True, blank=True) def save(self,*args, **kwargs): self.slug = slugify(self.name) super(Category, self).save(*args, **kwargs) def __str__(self): return self.name class Product(models.Model): upc = models.CharField(max_length=30) name = models.CharField(max_length=100) description = models.TextField(max_length=255) category = models.ForeignKey(Category, on_delete=models.CASCADE, null=True) quantity = models.IntegerField() price = models.IntegerField() def __str__(self): return self.name views.py from .models import Product from .serializers import ProductSerializers from rest_framework import generics class ProductList(generics.ListCreateAPIView): serializer_class = ProductSerializers def get_queryset(self): queryset = Product.objects.all() return queryset class ProductDetail(generics.RetrieveUpdateDestroyAPIView): serializer_class = ProductSerializers queryset = Product.objects.all() Serializers.py from .models import Product, Category from rest_framework import serializers class CategorySerializers(serializers.ModelSerializer): class Meta: model = Category fields="__all__" class ProductSerializers(serializers.ModelSerializer): category_name = serializers.SerializerMethodField('get_category_name') def get_category_name(self, obj): if obj.category_id: return obj.category.name class Meta: model = Product fields = '__all__' I am sending post request from react axios. axios.post(productListURL, data) How do I send post request with category name: name:"Coca Cola" , category:"Beverage" Instead … -
Django Filters on multiple models
I am a new django/python user and I am having an issue using django-filters with related models. I have created a tutorial application for myself with two models: class Customer(models.Model): def __str__(self): return self.Customer_Name Customer_Name = models.CharField(max_length=100) SFDC_Customer_Record_Number = models.IntegerField(default='') Zone = models.CharField(max_length=50, default='') Government = models.BooleanField(default=False) date_posted = models.DateTimeField(default=timezone.now) author = models.ForeignKey(User, on_delete=models.DO_NOTHING,default=User) class Vue_Quote(models.Model): def __str__(self): return self.Quote_Name Quote_Name = models.CharField(max_length=100) SFDC_Golden_Opp_ID = models.IntegerField() Vue_System_Count = models.IntegerField() date_posted = models.DateTimeField(default=timezone.now) author = models.ForeignKey(User, on_delete=models.DO_NOTHING,default=User) Quote_Type = models.CharField(max_length=100) Customer = models.ForeignKey(Customer , on_delete=models.DO_NOTHING, default='') I have also created a filter.py file: import django_filters from .models import * class CustomerFilter(django_filters.FilterSet): class Meta: model = Customer fields = { 'Customer_Name': ['icontains'], 'Zone' : ['icontains'], } class QuoteFilter(django_filters.FilterSet): class Meta: model = Vue_Quote fields = { 'Quote_Name': ['icontains'], 'author__username' : ['icontains'], 'Customer__Customer_Name' : ['icontains'], } In my templates I want to display the filter fields for quoteFilter and customerFilter (this is working). Then I have a sort of gallery/list that iterates through each customer and their respective quotes. My issue is that only my customerFilter works. I cannot find anyway to create nested for loops that can provide results for the user input across both model's fields. Here is my current html … -
Django Duplicate Detection
I've got a large database of contacts, each owned by a specific user. I'm attempting to remove any duplicates within each user's contact list. The simplest seemed to be to annotate with a string of user_id||name||address||zipcode, Count, and filter by count > 1. This has worked in most cases, but I've got some weird holdouts. Can anyone point out what I'm missing? Here's some code... I'm filtering to a specific name that I know has duplicates for testing. neighbors = neighbors.filter(name__icontains='JOHN WILLIAMS') keyed_neighbors = neighbors.values('user_id', 'name', 'address', 'zipcode', 'pk' ).annotate(dupe_id=Concat( Cast('user_id', CharField(max_length=25)), Value('||'), Upper('name'), Value('||'), Upper('address'), Value('||'), Substr('zipcode', 1, 5), Value('||'), Upper('address_line_two'), output_field=CharField())) dupes = keyed_neighbors.annotate(dupe_id_count=Count('dupe_id')) Here's a subset of the dupe_ids that I get back, and the counts: {'dupe_id': u'174563||JOHN WILLIAMS||222 WEDGEFIELD DR||28376||', 'dupe_id_count': 1} {'dupe_id': u'175875||JOHN WILLIAMS||4 TALLIN CT||29607||', 'dupe_id_count': 1} {'dupe_id': u'175875||JOHN WILLIAMS||4 TALLIN CT||29607||', 'dupe_id_count': 1} {'dupe_id': u'177178||JOHN WILLIAMS||5106 PAUL PEEL PL||28348||', 'dupe_id_count': 1} {'dupe_id': u'51||JOHN WILLIAMS||2410 COLGATE DR||28304||', 'dupe_id_count': 1} {'dupe_id': u'51||JOHN WILLIAMS||2410 COLGATE DR||28304||', 'dupe_id_count': 1} {'dupe_id': u'51||JOHN WILLIAMS||4 TALLIN CT||29607||', 'dupe_id_count': 1} If anyone can shine a light on my mistake I'd very much appreciate it. -
How to create a mysql database in Django on the first run?
I'd like my application to be "plug-and-play", so I need to automatically create the database on the first run. I use docker with docker-compose My attempt is to connect without specifying the database name and run a custom command before running the server: command: sh -c "python manage.py create_db && python manage.py runserver 0.0.0.0:8000" And the command itself: class Command(BaseCommand): """Django command to create DB""" def handle(self, *args, **options): con = connections['default'] db_name = os.environ.get('DB_NAME') db_up = False while not db_up: try: cursor = con.cursor() cursor.execute(f'CREATE DATABASE IF NOT EXISTS {db_name}') cursor.execute(f'USE {db_name}') db_up = True except Exception as err: self.stdout.write('Database unavailable, waiting 1 second...') self.stdout.write(str(err)) time.sleep(1) self.stdout.write(self.style.SUCCESS('Database available!')) If this is the right way, then now I just need to update the connection to use the newly created database, but I don't know how. The line cursor.execute(f'USE {db_name}') of course doesn't work. Is it the right way to create the database? If so, how to update the connection? If not, how to do it? Thanks! -
How do I route my databases in Django based on which user is logged in?
I am making a django website and I want each user to have their own database, for example now I have 2 databases hosted on azure, and in my settings.py file I have this: DATABASES = { 'default' :{}, 'user1': { 'ENGINE': 'django.db.backends.mysql', 'NAME' : 'temp monitoring', 'USER' : 'maxwhitehead@maxiot', 'PASSWORD' : '#######', 'PORT' : 3306, 'HOST' : 'maxiot.mysql.database.azure.com', }, 'user2':{ 'ENGINE': 'django.db.backends.mysql', 'NAME' : 'temp monitoring', 'USER' : 'maxwhitehead@maxiot2', 'PASSWORD' : '#######', 'PORT' : 3306, 'HOST' : 'maxiot2.mysql.database.azure.com', } } I have a folder called users, and within that I have a file called Fields that includes this: from django import forms from django.contrib.auth.models import User from django.contrib.auth.forms import UserCreationForm class UserRegisterForm(UserCreationForm): email = forms.EmailField() class Meta: model = User fields = ['username','email','password1','password2'] So I want people to login and see the posts from their associated database. I know I have to do something with database routing but I am not sure what, any help would be appreciated, thanks. -
Django Like Function With viewsets
Hey guys I try make blog app I take "detail": "Method "POST" not allowed." whwn I send get request to "/blog/like/1,2..." I take response but i cant send Post request That is The Models class Like(models.Model): created_by = models.ForeignKey(User, on_delete=models.CASCADE) post = models.ForeignKey(Post, on_delete=models.CASCADE) def __str__(self): return self.created_by.username That is serializers class LikeSerializer(serializers.ModelSerializer): created_by = serializers.StringRelatedField() post = serializers.StringRelatedField() class Meta: model = Like fields = ( 'created_by', 'post', 'post_id' ) That is views class LikeView(viewsets.ModelViewSet): queryset = Like.objects.all() serializer_class = LikeSerializer def perform_create(self, serializer): serializer.save(created_by=self.request.user) def post(self, post_id): post = Post.objects.get(id=post_id) if Like.objects.filter(post=post, created_by=self.request.user).exists(): Like.objects.filter( post=post, created_by=self.request.user).delete() else: Like.objects.create(post=post, created_by=self.request.user) that is Urls from django.urls import path from .views import ( PostView, PostView_View, LikeView, CommentView ) from rest_framework import routers router = routers.DefaultRouter() router.register('', PostView) router.register('like', LikeView) urlpatterns = [ ] + router.urls -
Accessing the attribute of a model through a shared foreign key in another model
I am a complete newbie to the world of Django and I'm confused as to how I can access the list of values from a table that has access to another table through a foreign key. Here is the Request model: class Request(models.Model): """ Carry requests """ sender = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, related_name="requests") offers = models.ManyToManyField("Offer", blank=True) code = models.UUIDField(max_length=64, default=uuid.uuid4, editable=False) weight = MeasurementField( measurement=Weight, validators=[MinValueValidator(Weight(g=1))], verbose_name=gettext_lazy("Weight") ) description = models.TextField(blank=False) origin_country = models.ForeignKey( Country, on_delete=models.PROTECT, related_name="origin_requests", verbose_name=gettext_lazy("Origin Country") ) origin_city = models.ForeignKey( City, on_delete=models.PROTECT, related_name="origin_requests", verbose_name=gettext_lazy("Origin City") ) destination_country = models.ForeignKey( Country, on_delete=models.PROTECT, related_name="destination_requests", verbose_name=gettext_lazy("Destination Country"), ) destination_city = models.ForeignKey( City, on_delete=models.PROTECT, related_name="destination_requests", verbose_name=gettext_lazy("Destination City"), ) status = models.CharField(max_length=40, choices=Status.choices, default=Status.AVAILABLE) reward = MoneyField( max_digits=1000, decimal_places=2, default_currency="PHP", validators=[MinMoneyValidator(defaultdict(lambda: 0.01))], verbose_name=gettext_lazy("My Initial Offer Fee"), ) photo = models.ImageField(upload_to="requests/", verbose_name=gettext_lazy("Photo of Item")) accepted_offer = models.ForeignKey( "Offer", on_delete=models.SET_NULL, blank=True, null=True, related_name="accepted_requests" ) add_insurance = models.BooleanField(default=False, verbose_name=gettext_lazy("I WANT 100% INSURANCE FOR MY ITEMS")) declared_amount = MoneyField( max_digits=1000, decimal_places=2, default_currency="PHP", validators=[MinMoneyValidator(defaultdict(lambda: 0.01))], verbose_name=gettext_lazy("Declared Amount"), blank=True, null=True, ) created = models.DateTimeField(auto_now_add=True) modified = models.DateTimeField(auto_now=True) history = HistoricalRecords(excluded_fields=["sender", "code", "created", "modified"]) @property def short_code(self) -> str: return str(self.code)[:8] def __str__(self) -> str: return f"({str(self.code)[:8]}) @{self.sender.username}: {self.origin_country} -> {self.destination_country}" Here is the Negotiation model: class Negotiation(models.Model): request … -
Using VCR mechanics to record and play queries to SQL database [closed]
Are there any libraries for python that would allow recording SQL queries to a file and later loading these queries from the file to memory and playing queries by monkey patching the db driver? I had employed this method in the past for recording http queries to external services with library vcrpy. I don't see any obstacles in implementation. The question is, does it even make sense in terms of test speed improvement? Also, what inconsistencies or pitfalls in usage of such an approach might this cause? -
Why the ListView not showing data in the template?
I'm working on my first Django project (the final project for codecademy's Django class) and I'm making webpages to show the inventory and menu that a restaurant has. I made the model, view, template, etc. for inventory and it displays the ListView perfectly. I did the same thing for my menu and it doesn't work. The page loads but the table that's supposed to output data is empty. Any insight on what might be going wrong? PS I'm new to programming and this is my first stackoverflow post so forgive any formatting errors or other faux pas ## views.py from django.http import HttpResponse from django.shortcuts import render from .models import Inventory, MenuItem, RecipeRequirement, Purchase from django.views.generic.edit import CreateView, DeleteView, UpdateView from django.views.generic import ListView # Create your views here. def index(request): return render(request, "index.html") class InventoryList(ListView): template_name = "inventory.html" model = Inventory class MenuList(ListView): template_name = "menu.html" model = MenuItem Inventory (below) works fine! :) {% extends './base.html' %} {% block content %} <h2>Inventory</h2> <table id="inventory"> <tr> <th>Ingredient</th> <th>Price</th> <th>Units Available</th> </tr> {% for ingredient in inventory_list %} <tr> <tr> <td>{{ ingredient.ingredient_name }}</td> <td>{{ ingredient.price }}</td> <td>{{ ingredient.units_avail }}</td> </tr> {% endfor %} </table> {% endblock %} This one (Menu) …
