Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How to use custom Django Authentication with it's rest TokenAuthentication
So I am using a third party Authentication (Firebase Auth)(Facebook && Google) with my Django Application. I did set up some rest endpoints that need authentication to post some content. I will very well like to use the Django Rest Framework Token Authentication. However, this requires that I have to pass a username & password in other to get the token. Since I am using Firebase(Facebook and Google), users are not asked to set any password. Is there any workaround or ideas on this? -
Error django framework UnicodeEncodeError /xel in position 3
I have the following error when deploying to a vps of a django-framework projectenter image description here -
Django 3.0 - Multilingual models - How to make __str__ return value for current, in-use language?
I am developping a Django 3.0 application. This application has to support two languages, French and English. I don't foresee it supporting any other language in the future. Given that I only have two language, I want to support them directly in the models and not resort to apps that do funky things like adding them on the fly (for performance and simplicity reasons). Now, let's say I have a model class that looks like this: class Organization(models.Model): name_en = models.CharField(max_length=100) name_fr = models.CharField(max_length=100) def __str__(self): # how do I return the name_en or name_fr, based on active language ? I'm guessing this might have to do with lazy_get_text, but I feel like I'm missing something. Also, in templates, aside from blocktrans to display/format fields based on active language, is there something else I should be aware of ? -
Generating SQL for Django pre/post-migration hooks
I am trying to move away from running django migrations to avoid locked tables/downtime during deploys and instead use SQL via Online Schema Migrations. I want to continue using manage.py makemigrations to generate app/migrations/0001_migratation.py files in order to continue tracking model state and will continue to run these migrations on my development machine. But I wanted to use manage.py sqlmigrate <app> <migration.py> to generate SQL associated with my migration to run in my TEST and PROD environments. However, the issue that I am running into is that sqlmigrate only returns the SQL associated with the python migration file, and does not take into account any SQL that is run as part of callbacks listening to pre_migration and post_migration signals emitted during manage.py migrate. One example of such a listener is the django.contrib.auth app which ensures that the db is in a consistent state by adding any missing rows to the auth_permission and django_content_type tables; the SQL for which does not appear in the output of the manage.py sqlmigrate <app> <migration.py> command. Is there a standard way of capturing the SQL of these "side effects" of the manage.py sqlmigrate command for django apps that do not run migrations in non-development environments? -
Manager object has no attribute 'get_by_natural_key'
I am trying to set up a custom User Model in Django, and believe that the vast majority of my coding is correct, however I am greeted with the following error: 'Manager' object has no attribute 'get_by_natural_key' models.py from django.db import models from django.contrib.auth.models import AbstractBaseUser, BaseUserManager from django.core.validators import RegexValidator USERNAME_REGEX = '^[a-zA-z0-9.+-]*$' class MyAccountManager(BaseUserManager): def create_user(self, email, first_name, last_name, username, password=None): if not email: raise ValueError("Users must have an email address") if not first_name: raise ValueError("Users must have a first name") if not last_name: raise ValueError("Users must have a last name") if not username: raise ValueError("Users must hae an username") user = self.model( username=username, email=email, first_name=first_name, last_name=last_name, ) user.set_password(password) user.save(using=self._db) return user def create_superuser(self, email, username, password): user = self.create_user( username, email, first_name, last_name, password ) user.is_admin = True user.is_Staff = False user.is_superuser = True user.save(using=self._db) return user def get_by_natural_key(self, email_): return self.get(code_number=email_) def __str__(self): return self.email def get_short_name(self): # The user is identified by their email address return self.email def has_perm(self, perm, obj=None): "Does the user have a specific permission?" return True def has_module_perms(self, app_label): "Does the user have permissions to view the app 'app_label'?" return True class Account(AbstractBaseUser): objects = MyAccountManager() email = models.EmailField( verbose_name="email address", … -
DJANGO - accesing some user's profile
I'm working on web app and currently I'm developing the profiles part. I've written part to view someones profile and this basically works fine except one thing. I can open someones profile but when I click the tabs which redirects to different part of the profile (these parts are included into block to keep the profile's main information), my code instantly switches to the currently loged user. Is there any way to get the user based on the cookies ? this is the single advert: def view_advert(request, pk, title): advert = Advert.objects.get(pk=pk) return render(request, "advert.html", {'advert':advert}) html <small>from </small><a href="{% url 'profile' nick=advert.user.username %}">{{advert.user}}</a> I open the profile of person who posted the advert (it works) Here is one of the profile and tab: @login_required def profile(request, nick): user = User.objects.get(username=nick) user_profile = Profile.objects.get(user=user) return render(request, "users_templates/profile.html", {"user_profile":user_profile}) def profile_adverts(request, user): user = User.objects.get(username=user) adverts = Advert.objects.filter(user=user) context = { "objects":adverts, "no_data":"No other adverts", "user":user } return render(request, "profile_templates/general_list.html", context) html from profile.html to access tab: <a class="nav-link" href="{% url 'all_adverts' user=user %}" role="tab" aria-selected="false">All adverts</a> Appreciate for help. -
ImproperlyConfigured: Field name first_name is not valid for model CustomUser?
help, Registrations, login, logout is working perfectly but when I try the url http://127.0.0.1:8000/user/ it is showing me this error. Where am I wrong in which step of the program. ImproperlyConfigured: Field name first_name is not valid for model CustomUser? model.py from django.db import models from django.contrib.auth.models import AbstractBaseUser from django.utils.translation import ugettext_lazy as _ from .managers import CustomUserManager class CustomUser(AbstractBaseUser): username = models.CharField(_('username'), max_length=100,unique=True) email = models.EmailField(_('email address'), unique=True) is_staff = models.BooleanField(default=False) is_admin = models.BooleanField(default=False) is_superuser = models.BooleanField(default=False) is_active = models.BooleanField(default=True) last_login = models.DateTimeField(auto_now=True) date_joined = models.DateTimeField(auto_now_add=True) full_name = models.CharField(_("Full Name"), max_length=50, null=True) date_of_birth = models.DateField( auto_now=False, auto_now_add=False, null=True) is_verified = models.BooleanField(_("Verified"), default=False) USERNAME_FIELD = 'email' REQUIRED_FIELDS = ['username'] objects = CustomUserManager() def __str__(self): return self.username def has_perm(self,perm,obj=None): return self.is_admin def has_module_perms(self,app_label): return True`from rest_framework import serializers from rest_auth.registration.serializers import RegisterSerializer serializer.py class RegisterSerializer(RegisterSerializer): full_name = serializers.CharField() date_of_birth = serializers.DateField() is_verified = serializers.BooleanField(read_only=True,default=False) def get_cleaned_data(self): super(RegisterSerializer, self).get_cleaned_data() return { 'username': self.validated_data.get('username', ''), 'password1': self.validated_data.get('password1', ''), 'email': self.validated_data.get('email', ''), 'date_of_birth': self.validated_data.get('date_of_birth', ''), 'full_name': self.validated_data.get('full_name', ''), 'is_verified': self.validated_data.get('is_verified', '') } setting.py import os # Build paths inside the project like this: os.path.join(BASE_DIR, ...) BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) # Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/3.0/howto/deployment/checklist/ # SECURITY WARNING: keep … -
Why can't we use reverse side of ForeignKey relationship in a Django Form?
I'm running into a problem when using a ModelForm and I want to know if I'm crazy or not before I go off making some complicated work-around Use Case: I have the following model definitions: class Setting(models.Model): """Manufacturing settings - can be shared among materials to be manufactured""" ... class Material(models.Model): """Specific record for a material that is manufactured""" ... setting = models.ForeignKey('Setting', on_delete=models.SET_NULL, related_name='materials') class ManufacturingRun(models.Model): """An instance of a manufacturing run""" material = models.ForeignKey('Material', on_delete=models.SET_NULL, related_name='manufacturing_runs') In this application, the data in the Material model is coming from an outside source and we do not provide users the ability to edit these records. However, the setting_id field is not populated as part of the data received from this outside source. Basically I need my users to define Setting instances and be able to assign each record to multiple Material instances. To that end I define a Setting form like so: class SettingForm(forms.ModelForm): class Meta: model = Setting fields = [ ... 'materials' ] Problem: Everything seems fine until I access the View to create a new Setting, thereby triggering the instantiation of a SettingForm object. The server returns django.core.exceptions.FieldError: Unknown field(s) (materials) specified for Setting I've become so … -
Django Form to update another app's database records
I want to be able to update the user app's Profile table favorite_subjects and favorite_courses records from a form inside of my memberships app. This will then allow the {{ user.profile.favorite_subjects }} and {{ user.profile.favorite_courses }} values to change in my template after the form submission. I am not sure how to do that and whether to use an instance variable anywhere in the view. Also not sure how to populate the form with the current values of favorite_courses and favorite_subjects. User app - models.py Profile table: class Profile(models.Model): user = models.OneToOneField(User, related_name='profile', on_delete=models.CASCADE) favorite_subjects = models.CharField(max_length=20, unique=True) favorite_courses = models.CharField(max_length=20, unique=True) def __str__(self): return self.user.username --------------- Memberships app - memberships/profile.html: {{ user.profile.favorite_subjects }} {{ user.profile.favorite_courses }} <a href="{% url 'memberships:interest_view' %}">Change Interests</a> --------------- Memberships app Urls.py: from .views import ( interest_view ) path('interest_view/', interest_view, name='interest_view'), --------------- Memberships app Forms.py: class InterestsForm(forms.ModelForm): captcha = CaptchaField(widget=CustomCaptchaTextInput) class Meta: model = Profile fields = ('favorite_subjects', 'favorite_courses',) def __init__(self, *args, **kwargs): super(InterestsForm, self).__init__(*args, **kwargs) self.fields['favorite_subjects'].widget.attrs={ 'id': 'favorite_subjects_field', 'class': 'form-control', 'required': 'true', 'autocomplete':'off'} self.fields['favorite_subjects'].widget.attrs['placeholder'] = 'Favorite Subjects' self.fields['favorite_courses'].widget.attrs={ 'id': 'favorite_subjects_field', 'class': 'form-control', 'required': 'true', 'autocomplete':'off'} self.fields['favorite_courses'].widget.attrs['placeholder'] = 'Favorite Courses' self.fields['captcha'].widget.attrs['class'] = 'form-control … -
Single account for users to sign-in on my different websites
I am new to web development. I am developing different websites. I want a system in which users can sign-in on my different websites with a single account because i want to put some functionalities in there. But i have no idea how to achieve this. Please guide me how to do this. -
How to create multiple fields using one attribute in Django-filters
I'm using Django-filters to filter based on categories and price. Price is an attribute of my model, I want to create two filter fields using this same attribute, one for min price and for max price. How can I do that? Can anyone please show me the method to do that? Thanks in advance! My filters.py: class ItemFilter(django_filters.FilterSet): class Meta: model = Item fields = { 'category': ['exact'], 'price': ['lte'] } -
How do you model the following use case in Django?
Together with two friends I have been making a game similar to the drinking game piccolo where you have a list of challenges. Each challenges has variables that need to be filled in (e.g: Player X gives four sips to Player Y). Besides that, a challenge consists of rounds, with each round having an index and a description (e.g Round 0: X and Y drink 4 sips. Round 1: X and Y drink 5 sips now), with X and Y being the same names in both rounds. First we made a small console app that had the challenges hardcoded in them. The list of challenges would look like this: challenge_list = [ Challenge(["p(0)", "rand_phone_number()"],[[0, "{d[0]} moet een nummer bellen. Het volgende scherm bepaalt welk nummer"], [1, "Het nummer is {d[1]}"]]), Challenge(["p(0)", "rand(2,5)", "rand_char('a','z')", "rand(2,5)"], [[0, "{d[0]} noemt {d[1]} dieren die beginnen met de letter {d[2]} of drinkt {d[3]} slokken"]]), Challenge([], [[0, "Alle drankjes schuiven een plek naar links"]]), After requests from other friends we decided that it would be educational to migrate the project to Django, since we did not have much experience in web development and we want to learn something new. We came up with the following model … -
Django Filter on between two different ManytoMany fields
I want to model a Cake with multiple Icings. Each Icings has a flavor. An Icing can belong to multiple Cakes so this needs to be a many-to-many relationship. I achieved the requirement thourgh this model: class Cake(models.Model): layers = models.ManyToManyField(Icing, through='CakeLayer') class Icing(models.Model): flavour = models.CharField(max_length=200) class CakeLayer(models.Model): cake = models.ForeignKey(Cake, on_delete=models.CASCADE) icing = models.ForeignKey(Icing, on_delete=models.CASCADE) order = models.IntegerField() However, I want to query a cake which has a chocolate icing ontop of a vanila icing (i.e chocolate_icing.order > vanila_icing.order) I cannot achieve it through Django's ORM but its rather simple by SQL. SELECT * FROM "cake" INNER JOIN "cakelayer" i1 ON ("cake"."icing" = "reservation_triproute"."id") INNER JOIN "cakelayer" i2 ON ("reservation_triproute"."id" = "reservation_tripstop"."trip_route_id") WHERE (i1.order > i2.order AND i1.icing.flavor="chocolate" AND i2.icing.flavor="vanila" ) I would rather write python code than inject SQL. Any idea how to convert this SQL to Django ORM syntax ? -
How to keep track of users' hobbies/interests in semi-structured way?
Sorry in advance for the long question. I'm not sure the best way to ask it. I am building a social networking platform with the Django/Python web framework. On it, users can create a profile and list their interests or hobbies. I want to match users together based on the number of exact matches and similar matches of their hobbies to create a "compatibility score". For example, there might be a Music category with Jazz, Rock, and Hip Hop genres as well as a Sports category with Football, Basketball, and Soccer, etc. I want there to be a somewhat "standard" list of interests/hobbies so I can analyze them to create a compatibility score. Should I create a standard set of interests and set True/False for every hobby for every user? Or could I only store the hobbies that each user is interested in, but use auto-complete so when a user starts typing their interests, they get prompted to input them in a standard way? Or should I allow them to store their interests/hobbies as free text and use some NLP analyzer to create a compatibility score? If so, what should I use for that? -
Django-filter How to write filters with DjangoFilterBackend in a POST request?
I have written a custom filter using django-filter package as mentioned in DRF docs here: https://www.django-rest-framework.org/api-guide/filtering/#djangofilterbackend Here is my code: class GeoFilter(filters.FilterSet): village_name = filters.CharFilter(field_name='village_name', lookup_expr='icontains', label = 'village_name') country_id = filters.NumberFilter(field_name='block__district__state__country', lookup_expr='exact', label = 'country_id') country_name = filters.CharFilter(field_name='block__district__state__country__country_name', lookup_expr='icontains', label = 'country_name') class Meta: model = Village fields = ['village_name', 'country_id', 'country_name'] class VillagesViewSet(viewsets.ModelViewSet): ''' Villages list with django-filters ''' authentication_classes = [TokenAuthentication] permissions_classes =[IsAuthenticated] serializer_class = VillageSerializer queryset = Village.objects.get_queryset().order_by('id') filter_backends = [filters.DjangoFilterBackend] filterset_class = GeoFilter This is a GET request. I want to write only POST requests with filtering using DjangoFilterBackend. I am trying to find whether it is possible. I am using ORM filter currently but I want to use django-filter as I find it better for filtering. -
How to put "active" class on multiple carousel 's on the same page in Bootstrap
I am trying to add the active class to my first carousel element. But I cannot add it as apparently my selector is wrong. I am using Django templates which have a for loop and I have already added a unique id to each carousel but the script does not work: this is my for loop: {% for post in posts %} {% if post.images %} <div id="carousel-{{ post.title|cut:' ' }}-{{ post.author.username }}" class="carousel slide" data-interval="false" data-ride="carousel"> <ol class="carousel-indicators"> {% for i in post.image_count_as_list %} <li data-target="#carousel-{{ post.title|cut:' ' }}" data-slide-to="{{ forloop.counter0 }}" class="active"></li> {% endfor %} </ol> <div class="carousel-inner"> {% for pic in post.images.all %} <div class="carousel-item"> <img class="d-block img-fluid" src="{{ pic.image.url}}" alt="Content not available"> </div> {% endfor %} </div> <a class="carousel-control-prev" href="#carousel-{{ post.title|cut:' ' }}-{{ post.author.username }}" role="button" data-slide="prev"> <span class="carousel-control-prev-icon" aria-hidden="true"></span> <span class="sr-only">Previous</span> </a> <a class="carousel-control-next" href="#carousel-{{ post.title|cut:' ' }}-{{ post.author.username }}" role="button" data-slide="next"> <span class="carousel-control-next-icon" aria-hidden="true"></span> <span class="sr-only">Next</span> </a> <script type="text/javascript"> $("#carousel-{{ post.title|cut:' ' }}-{{ post.author.username }} .carousel .carousel-item:first").addClass("active"); </script> </div> {% endif %} {% endfor %} and as you can see I am using this script: <script type="text/javascript"> $("#carousel-{{ post.title|cut:' ' }}-{{ post.author.username }} .carousel .carousel-item:first").addClass("active"); </script> But the "active" class I s not being … -
Django If statement String Comparison
code.code_type has a string value "mel" and it outputs the same value in the webpage. when i just run {{code.code_type}} But when I compare it in if statement with a string {% if code.code_type == "mel" %} Nothing is happening. {% for code in codes%} {% if code.code_type == "mel" %} <div class="snippet"> <div class="snippet-container"> <div class="snippet-heading"> <a href="#">{{code.code_type}}</a> </div> <div class="snippet-code"> {{code.code_snippet}} </div> <div class="snippet-note"> {{code.code_note}} </div> </div> </div> {% endif %} {%endfor%} -
nginx looking for staticfiles in the wrong place
my Django deployment with ec2, nginx and gunicorn went well beside that my staticfiles are not loading, browser show a 404 error. And this is because nginx looks in a completely different place than statics. At this point I have tried a lot of configurations and nothing does the trick. I am wondering if a pair of fresh eyes can spot a mistake here that I do not. /sites-enabled/django.conf: server { server_name site.net www.site.net; location /static/ { autoindex on; alias /home/ubuntu/saas/static/; } location / { include proxy_params; proxy_pass http://unix:/home/ubuntu/saas/app.sock; } location ~ \.css { add_header Content-Type text/css; } location ~ \.js { add_header Content-Type application/x-javascript; } listen 443 ssl; # managed by Certbot ssl_certificate /etc/letsencrypt/live/site.net/fullchain.pem; # managed by Certbot ssl_certificate_key /etc/letsencrypt/live/site.net/privkey.pem; # managed by Certbot include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot } server { if ($host = www.site.net) { return 301 https://$host$request_uri; } # managed by Certbot if ($host = site.net) { return 301 https://$host$request_uri; } # managed by Certbot listen 80; server_name site.net www.site.net; return 404; # managed by Certbot } and my django settings.py look like this and collectstatics works fine. STATIC_URL = '/static/' STATICFILES_DIRS = [ os.path.join(BASE_DIR, 'staticfiles') ] STATIC_ROOT = … -
Request from HttpResponseRedirect is called with old URL
I have a template that renders this url: /game/<game_name>/task/<task_id> The idea is render the same template but changing content based on task_id I have this URL path('<str:slug_id>/task/<int:task_id>/', task_page,name='task') that comes from path('game/', include(('game.urls','game'),namespace='game')), And this is the view: def task_page(request,slug_id,task_id): if request.method == 'POST': form = TaskPlayForm(request.POST) if form.is_valid(): task = get_object_or_404(Task,task_id=task_id) puzzle_resultado = task.result puzzle_respuesta = form.cleaned_data['resultTask'] if puzzle_respuesta.upper() == puzzle_resultado.upper(): next_puzzle = task.task_next next_puzzle_id = next_puzzle.task_id return HttpResponsePermanentRedirect(reverse('game:task',args=(slug_id,next_puzzle_id,))) else: return HttpResponseRedirect('/no-resuelto/') return HttpResponse(form.cleaned_data) else: form = TaskPlayForm() template_name = "game_task.html" game = get_object_or_404(Game,slug=slug_id) task = get_object_or_404(Task,task_id=task_id) [..redacted..] context = {"form":form,"game":game,"task":task, "display_items":temp} return render(request,template_name, context) Rendering templates and redirects work fine I'm rendering the same template using the same view from task1 to task2 in this way: /game/example/task/1 --submit form-->/game/example/task/2 But the problem is that rendering /game/example/task/1, then submitting the form redirect to /game/example/task/2 successfully but the task_id request parameter is from previous request (1 in this case). I have tested permanent vs temporary redirects but there is no difference and debugging shows previous task_id value My question is, how can be possible that redirecting to /game/example/task/2, the request parameter task_id is 1? -
Modifying django-filter queryset with callable
I'm trying to modify the queryset of one of my ModelChoiceFilters to depend on the user accessing them. My callable function looks like: (filters.py) def is_client(request): if request is None: return Project.objects.none() return Project.objects.all() This function is being called in the filter class looks like: (filters.py) class ReportFilter(django_filters.FilterSet): project = django_filters.ModelChoiceFilter(field_name='project_name', label='Project', queryset=is_client) class Meta: model = Report fields = ['project'] When coded like this, it always triggers the first condition in is_client. When I try and play around with it and do things with request.user..., I get the error: 'NoneType' object has no attribute 'user'. I have made it so that the queryset which the filter is instantiated with in the view limits what certain users can access, however they can still see the options which are not available to them in the filter (even if when they select it nothing would be returned): (views.py) @login_required def home(request): if is_employee(request.user): reports = ConcreteReport.objects.all() else: client = request.user.id reports = ConcreteReport.objects.filter(project_name__company__user__id=client) myFilter = ReportFilter(request.GET, queryset=reports) context = {'reports':reports, 'myFilter':myFilter} return render(request, 'dashboard/home.html', context) I can't figure out why the request is a NoneType, as I use it in the view for other things and it has attributes. Any help is … -
Store a non-JSON serializable object in session
I have object of type OAuth1 oauth = OAuth1(CLIENT_ID, client_secret=CLIENT_SECRET, resource_owner_key=request.session.get('resource_owner_key'), resource_owner_secret=request.session.get('resource_owner_secret')) I do not want to have to create this object every-time an API is hit so I would rather store it in a session. It isn't JSONSerializable though What are my alternatives? I realize it isn't allowed to store objects in sessions since Django 1.6 . Creating the same object repeatedly does not look like a good option to me. For reference, The decorator that looks like this : def oauth_verify(view_func): def _wrapped_view_func(request, *args, **kwargs): if not request.session.get('oauth'): if (request.session.get('resource_owner_key') and request.session.get('resource_owner_secret')): oauth = OAuth1(CLIENT_ID, client_secret=CLIENT_SECRET, resource_owner_key=request.session.get('resource_owner_key'), resource_owner_secret=request.session.get('resource_owner_secret')) request.session['oauth'] = oauth else: return JSONResponse(result=json.dumps({ "Exception": "NotAuthorized", "Error" : "You are not authorized, please log on" }), message='failure') return view_func(request, *args, **kwargs) return _wrapped_view_func -
Django Whitenoise not serving static files sometimes in ECS with debug False
My static files are not being served nicely in production with Whitenoise and Debug=False . Sometimes it serves, sometimes it doesn't find the static. I have the following settings: # Static / Media MEDIA_URL = os.environ.get('MEDIA_URL', '/media/') MEDIA_ROOT = os.path.join(BASE_DIR, '.media') STATIC_URL = os.environ.get('STATIC_URL', '/staticfiles/') STATIC_ROOT = os.path.join(BASE_DIR, '.static') STATICFILES_FINDERS = ( 'django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder', ) STATICFILES_DIRS = [ os.path.join(BASE_DIR, 'frontend/static'), ] STATICFILES_STORAGE = 'whitenoise.storage.CompressedStaticFilesStorage' MIDDLEWARE = [ 'django.middleware.security.SecurityMiddleware', 'whitenoise.middleware.WhiteNoiseMiddleware', ... On deploying to AWS ECS, I'm collecting static normally on docker. If I run python manage.py collectstatic locally I can find the files on my STATIC_ROOT. On production if I access via browser sometimes it returns the static correct, sometimes it gives a 404 error. What it could be? Any help please. -
Django OperationalError 'no such column:' sqlite
For my basic, rudimentary Django CMS, in my effort to add a toggle feature to publish / unpublish a blog post (I’ve called my app ‘essays’ and the class object inside my models is is_published), I’ve encountered an OperationalError when trying to use the Admin Dashboard to add essay content. I’m expecting to be able to switch a tick box to publish/unpublish but now I can’t even access the Dashboard. Here is part of the traceback from my Django server: File "/home/<user>/dev/projects/python/2018-and-2020/<projectdir>/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/home/<user>/dev/projects/python/2018-and-2020/<projectdir>/venv/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute return Database.Cursor.execute(self, query, params) django.db.utils.OperationalError: no such column: essays_essayarticle.is_published The debug traceback reinforces the OperationalError above: OperationalError at /admin/essays/essayarticle/ no such column: essays_essayarticle.is_published Request Method: GET Request URL: http://<DN>.ngrok.io/admin/essays/essayarticle/ Django Version:2.2.11 Exception Type: OperationalError Exception Value: no such column: essays_essayarticle.is_published Exception Location: /home/<user>/dev/projects/python/2018-and-2020/<projectdir>/venv/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py in execute, line 383 Python Executable: /home/<user>/dev/projects/python/2018-and-2020/<projectdir>/venv/bin/python `Fri, 1 May 2020 19:37:31 +0000 Exception Value indicates ‘no such column’ which is a reference to my db. I’m running SQlite3 for test purposes. Prior to this OperationalError, I was troubleshooting issues with a DummyNode and "isinstance django.db.migrations.exceptions.NodeNotFoundError: Migration". The previous solution I arrived at was to delete my migrations in two of my … -
Optimize ORM queries in Flask using Flask-SQLAlchemy
I have written the same project using Django and Flask. The entire code is available on my Github account. The website is a small question-answer based quiz website (in CTF format with very easy questions). Here are the links: Django Project Flask Project My question is regarding optimizing ORM queries in SQLAlchemy or Flask-SQLAlchemy. I'll try to write the schema of the tables as well as I can for better understanding. Teams (id, team_name, email, phone, password) Questions (id, name, body, hint, answer, points, visible) Submissions (id, team(fk), question(fk), timestamp) In case any of you want to see the actual code, here they are: For Django - Question & Submission, Team For Flask - Question, Team, Submission For two of the routes, /submissions and /leaderboard, I had to write certain queries using the ORM. This is how the pages look like: For Django, the queries look pretty good (or at least I think so :P ) def submissions(request): all_submissions = Question.objects \ .values('id', 'name') \ .order_by('id') \ .annotate(submissions=Count('submission')) print(all_submissions.query) return render(request, 'questions/submissions.html', { 'submissions': all_submissions }) def leaderboard(request): team_scores = Team.objects \ .values('team_name') \ .order_by('team_name') \ .annotate(score=Coalesce(Sum('submission__question__points'), 0)) \ .order_by('-score') print(team_scores.query) return render(request, 'questions/leaderboard.html', { 'team_scores': team_scores, }) And the … -
Django queryset ordering by fields
i'm using django 2 and in my list view i want to oder the queryset by likecount and datetime field. The main goal is to odering the post with mostlikes for today. Like, i want to show the most liked posts for today. It's like todays top 10 post(mostliked). i have tried many ways but can't figure it out. I hope you guys can help me. My models.py: class post(models.Model): parent = models.ForeignKey("self", on_delete=models.CASCADE, blank=True, null=True) title = models.CharField(max_length=100) image = models.ImageField(upload_to='post_pics', null=True, blank=True) content = models.TextField() likes = models.ManyToManyField(User, related_name='likes', blank=True) date_posted = models.DateTimeField(default=timezone.now) author = models.ForeignKey(User, on_delete=models.CASCADE) restrict_comments = models.BooleanField(default=False) watchlist = models.ManyToManyField(User, related_name='watchlist', blank=True) def __str__(self): return self.content class Meta: ordering = ['-date_posted', 'title'] def get_absolute_url(self): return reverse ('blog-home') def total_likes(self): return self.likes.count() My views.py: @login_required def most_likes(request): posts = post.objects.annotate(like_count=Count('likes')).order_by('-like_count', '-date_posted') context = {'posts': posts} return render(request, 'blog/most_likes.html', context)
