Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Total likes on all posts of a user
How can I count the total likes on all the posts of a particular user in django ? models.py class Post(models.Model): author = models.ForeignKey(User, on_delete = models.CASCADE, related_name='posts') slug = models.SlugField(unique=True, blank=True, default=uuid.uuid1) likes = models.ManyToManyField(User, blank=True, related_name='post_likes') def __str__(self): return self.title def get_like_url(self): return reverse("like-toggle", kwargs={"slug" :self.slug}) def get_api_like_url(self): return reverse("like-api-toggle", kwargs={"slug" :self.slug}) -
Django Validation with clean not working
my forms.py class AccountForm(forms.ModelForm): foo = forms.ModelDecimalField() bar = forms.ModelDateField() def clean_foo(self): foo_passed = self.cleaned_data.get("foo") if foo_passed > 1000: raise forms.ValidationError("Sorry, Maximum is 1000.") return foo_passed my template.html {{form.as_p}} on my code above, iam trying to validate the input, if value higher than 1000 will raise error. But its not working, what i miss. -
Django dropdown selection is not working when submit button is pressed
I have a dropdown selection and 'submit' button in the page. Some fields disappears upon specific dropdown selection. I can hide/show all other fields but except password field. Whenever I hide the password field with a jquery the submit button doesnot work. following are my code files. HTML template django < script > $(document).ready(function() { $('#type').change(function(eventObject) { if ($(this).val() == 'sercomm') { $('.sample').show(); $('.sample_netip').show(); $('.sample_password').show(); $('.sample_username').hide(); } else { $('.sample').show(); $('.sample_password').show(); $('.sample_netip').hide(); } }).change(); }); < /script> <form class="form-horizontal" method="post" role="form">{% csrf_token %} {# dropdown#} <div class="form-group"> <label class="col-sm-3 control-label">{% trans "Mode" %}</label> <div class="col-sm-6"> <select name="type" class="form-control" id="type"> <option value="ex1" selected>{% trans "ex1" %}</option> <option value="ex2">{% trans "ex2" %}</option> </select> </div> </div> {# end of dropdown#} <div class="form-group sample"> <label class="col-sm-3 control-label">{% trans "Name" %}</label> <div class="col-sm-6"> <input type="text" class="form-control" name="name" placeholder="{% trans " Name " %}" maxlength="20" id="name" required pattern="[a-zA-Z0-9\.\-_]+"> </div> </div> <div class="form-group sample"> <label class="col-sm-3 control-label">{% trans "Management Network IP Address" %}</label> <div class="col-sm-6"> <input type="text" class="form-control" name="ipaddr" value="192.168.255.129" maxlength="20" required pattern="^(25[0-5]|2[0-4]\d|[0-1]?\d?[1-9]|[0-1]?[1-9][0])(\.(25[0-5]|2[0-4]\d|[0-1]?\d?\d)){3}$"> </div> </div> <div class="form-group sample_netip"> <label class="col-sm-3 control-label">{% trans "Radio Network IP Address" %}</label> <div class="col-sm-6"> <input type="text" class="form-control" name="netipaddr" value="192.168.255.129" maxlength="20" required pattern="^(25[0-5]|2[0-4]\d|[0-1]?\d?[1-9]|[0-1]?[1-9][0])(\.(25[0-5]|2[0-4]\d|[0-1]?\d?\d)){3}$"> </div> </div> <div class="form-group sample_username"> <label class="col-sm-3 control-label">{% trans "User ... -
Daphne issue in Otree
I'm running an Otree application, there are a total of twenty clients. The problem is that in some clients I get the following error. 503 Service Unavailable Request queue full. Daphne Can someone get me a idea about how to fix that error? -
Get the current value on click in my ModelAdmin (Django)
I want to get the current value on click from Django Admin. I created a function in the admin.ModelAdmin. This function displays a button. Currently, I get all the values on click then I will only want the value on which the click has occurred. class: class SchedulejoursAdmin(admin.ModelAdmin): list_display = ('go_url','user_id','date') def go_url(self, obj): print(obj.pk, ' obj.pk') print(obj.date, ' obj.date') return format_html(u'<a href="https://www.w3schools.com">Visit W3Schools</a>') go_url.allow_tags = True go_url.short_description = 'Go to site' admin.site.register(Schedulejour,SchedulejoursAdmin) Thank -
Django : how to use pattern searching?
Does someone of you know how the django's pattern searching is developed ? using : python manage.py test --pattern=test* My tests are launched. But when i try : python manage.py test --pattern=[test] I've no match If you could enlight me :) -
JQuery event not firing on Django dynamic content
I am developing Django application where i wanted to do lazy load. I followed this tutorial https://simpleisbetterthancomplex.com/tutorial/2017/03/13/how-to-create-infinite-scroll-with-django.html. All working fine except when i tried to add a script below, $(".infinite-item").on("click", function () { alert("click"); }); Only first 20 div are firing click event. Why click event is not firing for rest of div's ? -
Django - Upload a file to a network shared storage
I'm using Django v1.7 and my app uploads files to a local storage. The thing is, I have a load balancer and 2 front end machines server the django app. Therefore I need to run a task periodically to sync the content of both local storages from the front end servers.... Is there any way to upload to a remote location, like a network storage? (e.g. may I uploaded it to remote IP or something?) I'm sorry, but I haven't found a solution for this yet :( Cheers, -
413 Request Entity Too Large uploading files with Django Admin and Nginx Configuration
Whenever I upload a small file, such as an image, the data is saved successfully. However, when I upload an audio file I get this error: 413 Request Entity Too Large. The file sizes are around 8MB. The confusing part is that uploading these files in development process easily but now that the website is live, it doesn't work. I read that you can change the limit of the upload size but can't seem to figure it out. Another thing I read is that you should have files uploaded to a server, and you can use Nginx. I think I configured it; I typed the command scp -r * root@[my ip address] /usr/share/nginx/html and the files from my media folder were uploaded there. Now with that the files are not automatically put there, instead they are sent to the project's media folder. Shouldn't it automatically upload to the Nginx server? -
Set Windows Django Project Folder To OS-X/Linux Style
In when adding a Django project to Bitnami on OS-X, the path to the projects is "*installdir*\apps\django\django_projects" ( in the install directory) When in windows it is "C:\Users\*USER*\Bitnami DjangoStack Projects" (outside the install directory) I'm on windows 7 and would like to configure Bitnami to use the OS-X style folder where it is all contained within the install directory rather than being in a separate folder. If this is a possibility, how would I go about doing this? -
How convert files im memory with moviepy?
I am using moviepy to converter videos. I use this follow instruction to load the movie file and converter: clip = VideoFileClip('/home/developer/Pictures/aa.mov') clip.write_videofile('/home/developer/Pictures/aa.mp4') This works fine but in my system i dont receive a file via file path. Instead i receive this file via Django. type(request.data['file']) [1] <class 'django.core.files.uploadedfile.InMemoryUploadedFile'> If i made this also not works: arq = open('/home/developer/Pictures/aa.mov','rw').read() clip = VideoFileClip(arq) --------------------------------------------------------------------------- TypeError Traceback (most recent call last) <ipython-input-23-9976dbcf241a> in <module>() ----> 1 teste= VideoClip(arquivo) /home/developer/.virtualenv/movie/local/lib/python2.7/site-packages/moviepy/video/VideoClip.pyc in __init__(self, make_frame, ismask, duration, has_constant_size) 84 if make_frame is not None: 85 self.make_frame = make_frame ---> 86 self.size = self.get_frame(0).shape[:2][::-1] 87 self.ismask = ismask 88 self.has_constant_size=has_constant_size <decorator-gen-123> in get_frame(self, t) /home/developer/.virtualenv/movie/local/lib/python2.7/site-packages /moviepy/decorators.pyc in wrapper(f, *a, **kw) 87 new_kw = {k: fun(v) if k in varnames else v 88 for (k,v) in kw.items()} ---> 89 return f(*new_a, **new_kw) 90 return decorator.decorator(wrapper) 91 /home/developer/.virtualenv/movie/local/lib/python2.7/site-packages/moviepy/Clip.pyc in get_frame(self, t) 92 return frame 93 else: ---> 94 return self.make_frame(t) 95 96 def fl(self, fun, apply_to=None, keep_duration=True): TypeError: 'str' object is not callable Is there a way to load the file without using path, just receiving the file in bytes? -
Django subquery throws "more than one row returned by a subquery used as an expression"
I have recently upgraded to django 1.11 and I want to use the newly released, Subquery exrpession feature. There are two models as follows class Project(models.Model): title = models.CharField(_("Project Name"), max_length=128) class PrivateDonation(models.Model): project = models.ForeignKey(Project) value = models.DecimalField(_("value"),max_digits=19, decimal_places=2) ............ I want to get a queryset of Project objects annotated with sum of the private donation values for each project. I know, there are other ways to accomplish this and I already have a working solution for my app but since I am learning this feature so I tried the following queries private_donations = PrivateDonation.objects.filter(project=OuterRef('pk')).values('value') private_donations_sum = private_donations.annotate(s=Sum('value')).values('s') Project.objects.annotate(pd_sum=Subquery(queryset=private_donations_sum)) But the above query throws an exception django.db.utils.ProgrammingError: more than one row returned by a subquery used as an expression The only query that successfully runs is the one below. private_donations = PrivateDonation.objects.filter(project=OuterRef('pk')).order_by().values('project') private_donations_count = private_donations.annotate(c=Count('*')).values('c') projects = Project.objects.annotate(space_count=Subquery(queryset=private_donations_count)) But if I choose anything other than the 'project' attribute in 'private_donations' query it throws the same error And here is the stack-trace The above exception was the direct cause of the following exception: Traceback (most recent call last): File "<input>", line 1, in <module> File "/Users/sajidur/Coding/socialfunders/sf/venv3/lib/python3.5/site-packages/django/db/models/query.py", line 226, in __repr__ data = list(self[:REPR_OUTPUT_SIZE + 1]) File "/Users/sajidur/Coding/socialfunders/sf/venv3/lib/python3.5/site-packages/django/db/models/query.py", line 250, in ... -
Celery 4 + Django 2.0 - CELERY_BROKER_TRANSPORT_OPTIONS is ignored
I'm using Django 2.0 with Celery 4 & SQS as a broker. I used CELERY_BROKER_TRANSPORT_OPTIONS to set a prefix for the queue names and the region of the SQS. like this: {'queue_name_prefix': 'qa-', 'region': 'eu-west-1'} I have a dedicated worker running using celery -A <app_name> worker -Q <queue_name> And a Django web service that calls a task with .delay(). The issue is that the worker is able to read the broker_transport_options, and it created a queue with the correct prefix in the correct region as I stated in the settings, but when the web service calls the task, it ignores these settings and search for the queue name without prefix and not in the correct environment. Does anyone know what is the case here? Thanks, Dar -
Specific loading of related manytomany field in queryset
I'm using intermediate model with extra fields on many-to-many relationships like this: class A(models.Model): name = models.CharField(max_length=128) class B(models.Model): name = models.CharField(max_length=128) a = models.ManyToManyField(A, through='AB') class AB(models.Model): a = models.ForeignKey(A, on_delete=models.CASCADE) b = models.ForeignKey(B, on_delete=models.CASCADE) number = models.IntegerField(default=0) date = models.DateTimeField() By default, AB.date is NULL in database. I retrieve all my B instances with something like this B.objects.all(). Then, for each instance of B, I can get a set of AB like this, b_instance.ab_set.all(). How to load only ab_set elements where date is null ? In SQL it would have looked like this : SELECT * FROM B INNER JOIN AB ON AB.id = B.ab_id AND AB.date IS NULL -
How to update the serializer field for m2m relationship
I am trying to update submitted data by implementing the update() method on the a SerializerClass. However i do not know how to get access to the current ingredient of the current instance and also i do not know how to iterate through the validated data such that i can assign the key and values correctly. any advice would be appreciated! My Serializer class RecipeSerializer(ModelSerializer): ingredients = IngredientSerializer(many=True) owner = ReadOnlyField(source='owner.username') class Meta: fields = ['owner', 'name', 'description', 'image', 'ingredients'] model = Recipe def create(self, validated_data): ingredient_datas = validated_data.pop('ingredients') recipe = Recipe.objects.create(**validated_data) for ingredient_data in ingredient_datas: recipe.ingredients.create(**ingredient_data) return recipe def update(self, instance, validated_data): instance.name = validated_data.get('name', instance.name) instance.description = validated_data.get('description', instance.description) instance.image = validated_data.get('image', instance.image) for ingredient in validated_data.get('ingredients'): for key, value in ingredient.items(): print(key, value) instance.ingredient.name = value instance.ingredient.amount = value instance.save() return instance My Models class Recipe(models.Model): owner = models.ForeignKey('auth.User', related_name='recipes', on_delete=models.CASCADE) name = models.CharField(max_length=100) description = models.TextField(max_length=200, blank=True) image = models.CharField(max_length=100, blank=True) ingredients = models.ManyToManyField(Ingredient, related_name='recipes') class Ingredient(models.Model): name = models.CharField(max_length=50) amount = models.IntegerField(default=1) Some window shell ouputs print(validated_data) {'name': 'bedddef', 'description': 'gdddoot', 'image': 'httpdddlo', 'ingredients': [OrderedDict([('name', 'tomatoes'), ('amount', 2)]), OrderedDict([('name', 'bread'), ('amount', 3)])]} print(key, value) name tomatoes amount 2 name bread amount 3 -
from where the "}" is coming (The current path, entries/}, didn't match any of these.) in Django
I have just started learning Django and while making an app in the link it is showing %7D and giving the error : Using the URLconf defined in ag.urls, Django tried these URL patterns, in this order: admin/ entries/ [name='list'] [name='home'] ^about/$ [name='about'] contact/ [name='contact'] The current path, entries/}, didn't match any of these. I have searched for this over the internet but I have not get the solution yet. -
Django: Adding foreign key to form -> Cannot assign "<SimpleLazyObject:, must be a "User" instance
The user is in a DetailView of a patient with a in id (parent table/model), or selects a patient to create a child (table/model) object (I hope that is accurate terminology). I'm trying to "pre-populate" my form with the correct foreign key from the parent table. Basically, Each patient will have several visits, and the visits need to have the correct foreign key relationships with the patient table ("main" model). I am getting the following error relating to my def form_valid command in the views.py file. If I remove this command I get a not null error as the field needs to be filled. I also tried get_instance function but the forums advise against this in favor of the def form_valid. Error Cannot assign "<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object at 0x10d62d278>>": "Visit.fk_visit_user" must be a "User" instance. Request Method: POST Request URL: http://127.0.0.1:8000/clincher/visit/add/2 Django Version: 2.0.4 Exception Type: ValueError Exception Value: Cannot assign "<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object at 0x10d62d278>>": "Visit.fk_visit_user" must be a "User" instance. Exception Location: /Users/nrsmoll/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py in __set__, line 197 Python Executable: /Users/nrsmoll/venv/bin/python Python Version: 3.6.4 Python Path: ['/Users/nrsmoll/PycharmProjects/clincher', '/Users/nrsmoll/PycharmProjects/clincher', '/Library/Frameworks/Python.framework/Versions/3.6/lib/python36.zip', '/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6', '/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/lib-dynload', '/Users/nrsmoll/venv/lib/python3.6/site-packages', '/Users/nrsmoll/venv/lib/python3.6/site-packages/setuptools-28.8.0-py3.6.egg', '/Users/nrsmoll/venv/lib/python3.6/site-packages/pip-9.0.1-py3.6.egg', '/Applications/PyCharm.app/Contents/helpers/pycharm_matplotlib_backend'] Server time: Wed, 6 Jun 2018 13:16:29 +0000 Traceback Environment: Request Method: POST Request ... -
Django from dynamic data insertion
I am basically making a django form using the models given below: class DeviceType(models.Model): device_type = models.CharField(max_length=200,unique=True) class Device(models.Model): device_type = models.ForeignKey(DeviceType,to_field='device_type') serial_number = models.CharField(max_length=200,unique=True) in_use_by = models.ForeignKey(User,to_field='username') brand = models.CharField(max_length=200,default="-", null=False) model = models.CharField(max_length=200,default="-", null=False) type_number = models.CharField(max_length=200,blank=True,null=True) mac_address = models.CharField(max_length=200,blank=True,null=True) class Repair(models.Model): device_type = models.ForeignKey(DeviceType,to_field='device_type') submitted_by = models.ForeignKey(User,to_field='username') comments = models.TextField() repair_request_date = models.DateField(default=datetime.now) repair_status = models.ForeignKey(RepairStatus, to_field="repair_status", null=True) repair_cost_estimate = models.FloatField(null=True) My devicetype option contains the following values: Dongle Charger Desktop Power Cord Laptop Charger Dongle Keyboard Mouse Desktop Laptop Now, suppose a particular user possesses only laptop and mouse. If he clicks for repair device option in my main form then, according to the models, the form will display all the values of the devicetype in the dropdown. What I want is, the dropdown must display only laptop and mouse i.e. only those devicetype that are associated with a particular user. How can i achieve this? Requesting help at the earliest. -
Can't `pip3 install -r requirement.txt`
I'm getting dependency error while installing dependency for django project Here is my part of requirement file social-auth-app-django==1.2.0 social-auth-core==1.7.0 ... stream-django==1.4.0 .. PyJWT==1.3.0 .. without pyJWT == 1.3.0 line, stream-python 2.8.1 has requirement pyjwt==1.3.0, but you'll have pyjwt 1.6.4 which is incompatible. with pyJWT == 1.3.0 social-auth-core 1.7.0 has requirement PyJWT>=1.4.0, but you'll have pyjwt 1.3.0 which is incompatible. djangorestframework-jwt 1.11.0 has requirement PyJWT<2.0.0,>=1.5.2, but you'll have pyjwt 1.3.0 which is incompatible. -
Error viewing pages/ in wagtail CMS
I started getting an error when viewing pages in wagtail cms: ProgrammingError at /cms/pages/ column "wagtailcore_page.content_type_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "wagtailcore_page"."id", "wagtailcore_page"."content_... Viewing the Root CMS page seems to be fine and also editing pages. If i access a child page such as /cms/pages/6/ that works but if i view the parent /cms/pages/5/ it causes the error. Any ideas how this is happening? wagtail==1.13.1 Django==1.10.5 The page class looks like: class LandingPage(Page): body = StreamField([ ('heading', blocks.CharBlock(classname="full title")), ('rich_text', RichTextBlock()), #('image', ImageChooserBlock()), ('image_grid', ImageGridBlock()), ('two_columns', TwoColumnBlock()), ('landing_map', MapBlock()), ('video_grid', VideoGridBlock()), ('slider', SliderBlock()), ('steps', StepsBlock()), ('pricing', PricingBlock()), ('centered', RichTextBlock(template='blocks/centered.html')), ]) content_panels = Page.content_panels + [ StreamFieldPanel('body'), ] -
Django&Python, scrap page to fill up database
I've got django running with models. Now, I want that fill todatabase with information from different websites. There comes scrapping, I know. What I'm missing is knowledge if there's any tool to scrap pages with Django that gives compatibility with existing database/models? Please note that I'd like to run this scrapping task every 5 mins for example, so it won't be one-run script. Could you please point me out which tools should I use? Should I stay with Django or use something external? -
Can't install my old Django project from new mac computer
I just pulled out my old django project (I stopped developing 6 months ago). And I try to run it on my mac computer. I had weird erros such as Could not find a version that satisfies the requirement ufw==0.35 (from -r pip3_requirements_copy.txt (line 95)) (from versions: ) No matching d But I solved it by deleting that line from requirement.txt. And finally it gives me new error below build/temp.macosx-10.13-x86_64-3.6/_openssl.c:2407:14: error: typedef redefinition with different types ('void' vs 'struct comp_method_st') typedef void COMP_METHOD; ^ /usr/local/opt/openssl/include/openssl/ossl_typ.h:181:31: note: previous definition is here typedef struct comp_method_st COMP_METHOD; ^ 1 error generated. error: command 'clang' failed with exit status 1 ---------------------------------------- Command "/usr/local/opt/python/bin/python3.6 -u -c "import setuptools, tokenize;__file__='/private/var/folders/90/vbn67txd7zngjs2kzcsp73fw0000gn/T/pip-install-67i1eh50/cryptography/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /private/var/folders/90/vbn67txd7zngjs2kzcsp73fw0000gn/T/pip-record-d3q5_te0/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/var/folders/90/vbn67txd7zngjs2kzcsp73fw0000gn/T/pip-install-67i1eh50/cryptography/ I'm frustrated because this project is not working on my laptop. It used to work on ubuntu but now it's not working for some reasons. :( -
IndexError tuple index out of range
I am getting IndexError tuple index out of range the print in comment also gives ValueError malformed node or string: ['(300, 600)'] dict3={'diameter': {'attri': ['(300, 600)'], 'op': 'range'}} result = Product.objects.all() for key, value in dict3.items(): print(value['attri']) print(value['op'])#print( ast.literal_eval(value['attri'])) if value['op'] is 'range': result = result.filter(**{'attributes__{}__{}'.format(key, value['op']): ast.literal_eval(value['attri'])}) else: result = result.filter(**{'attributes__{}__{}'.format(key, value['op']): value['attri']}) print(result) -
How to exhaustively see queries Django is running?
I am optimizing a big part of my code so I am trying to reduce the database hits to the minimum and try to grab all necessary data in big but few queries and cache it. However I have not found an effective way of seeing whether Django is actually running a query against the database or whether it is returning cached or prefetched data. Ideally, I want to debug the relevant parts of my code line by line and each raw SQL queries should be displayed as they are executed. This way to check running queries suggested by the docs is not good enough, as it only displays queries formed in the same file where you access connection.queries, apparently. Accessing QuerySet.query is no good either, as it requires a, well, QuerySet object. There are other scenarios where queries are run against the database but the return type is not a QuerySet. I am not sure the Django Debug Toolbar would work either, because I don't want my behavior wrapped in a view, I want to execute an independent script and thoroughly debug it. -
Django : test with multiple patterns
I'm coding a class which is overriding DiscoverRunner (link). And i've three kind of tests : front tests called tests_front.py back tests called tests_back.py tests from different modules i'm using called tests.py My front tests are very slow, and i'd like to have a parameter to call only tests_back.py and tests.py files. The pattern i'm currently using: pattern='(*back.py|tests.py)' But this is calling any test, it looks like manage.py's pattern is not a real pattern. Ran 0 test in 0.000s Do you know how to solve my problem ? Thank you !
