Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Even if username is not alphabetic or specified characters, it can be entered in various characters
When registering an account, usernames can be entered in various characters other than alphabets or specified characters. I want to restrict the character to use username in URL, but I don't know how. I also thought that there was a limitation when I checked the document, but I thought it might not be applicable. I want to know the cause. class User(AbstractBaseUser, PermissionsMixin): username_validator = UnicodeUsernameValidator() user_id = models.UUIDField(default=uuid_lib.uuid4, primary_key=True, editable=False) username = models.CharField(_('username'), unique=True, max_length=50,validators=[username_validator],error_messages={ 'unique': _("A user with that username already exists."), },) class SignUp(generic.CreateView): """account""" template_name = "accounts/signup.html" form_class = forms.SignUpForm success_url = reverse_lazy('') def form_valid(self, form): user = form.save(commit=False) user.is_active = False user.save() current_site = get_current_site(self.request) domain = current_site.domain context = { 'protocol': self.request.scheme, 'domain': domain, 'token': dumps(user.pk), 'user': user, } subject = render_to_string('mail/create/subject.txt', context) message = render_to_string('mail/create/message.txt', context) send_mail(subject , message, 'an@apasn.com', [user.email], fail_silently=False) # user.email_user(subject, message) return redirect('accounts:signupdone') class SignUpForm(forms.ModelForm,UserCreationForm): class Meta: model = User fields = ('email','username') def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs) for field in self.fields.values(): field.widget.attrs['class'] = 'form-control' def clean_email(self): email = self.cleaned_data['email'] User.objects.filter(email=email, is_active=False).delete() return email -
DateTimeField not saving the Time and Date DJANGO2.1
I have tried countless times different approach to save and TIME and DATE using DateTimeField but DJANGO2.1 keep throwing a template error enter a valid date/time models.py class Party(models.Model): name = models.CharField(max_length=50) date = models.DateTimeField() forms.py class PartyForm(forms.ModelForm): name = forms.CharField() date = forms.DateTimeField(widget=forms.widgets.DateTimeInput(format=['%Y-%m-%d %H:%M'], attrs={'class':'myDateClass', 'type':'datetime-local'})) class Meta: model = Party fields = ['name', 'date'] Also, when i try to use input_formats below: date = forms.DateTimeField(widget=forms.widgets.DateTimeInput(input_formats=['%Y-%m-%d %H:%M'], attrs={'class':'myDateClass', 'type':'datetime-local'})) The terminal throw the error below: File "/Users/macadmin/Documents/Django_fun4/date_and_time/date_time/core/forms.py", line 30, in PartyForm attrs={'class':'myDateClass', 'type':'datetime-local'})) TypeError: __init__() got an unexpected keyword argument 'input_formats' Can anybody help me figure out how to save the TIME and DATE. (Time is the most important data i need right now but if i can save both TIME and DATE it would be great) Thank you for your help in advance. -
visual studio code unresolved import?
I have installed python version 3.7 and visual studio code latest version, after that i have created virtual environment and installed django and created Django project. Whenever i am opening some file, its showing error like below unresolved import 'django.contrib' unresolved import 'django.urls' Undefined variable: 'path' Undefined variable: 'admin' Below are the paths of my application 1) Python : C:\Python\Python37-32\python.exe 2) Virtual environment created D:\django_projects\envs\py1\ 3) Django Project created D:\django_projects\p1\p1 Below are the things i have tried 1) Re Installing Python 2) Setting the Python Path in environment variable even i selected include in the path at the time of python installation 3) Re installing the VS Code 4) Tried commenting the "python.jediEnabled": false, in settings.json file in vs code, but it was giving different error unable to import django. 5) unresolved import 'django.contrib' unresolved import 'django.urls' Undefined variable: 'path' Undefined variable: 'admin' -
how to keep html code with chart js script in the same file to work
im trying add chartJs to my project but the problem is i cant keep the html code <canvas id="myChart" width="400" height="400"></canvas> with the script code in one file {% block body %} <canvas id="myChart" width="400" height="400"></canvas> <script> var ctx = document.getElementById('myChart').getContext('2d'); var myChart = new Chart(ctx, { type: 'bar', data: { labels: [{% for i in products %}'{{i.product}}',{% endfor %}], datasets: [{ label: '# of Votes', data: [{% for i in products %}'{{i.price}}',{% endfor %}], backgroundColor: [ 'rgba(255, 99, 132, 0.2)', 'rgba(54, 162, 235, 0.2)', 'rgba(255, 206, 86, 0.2)', 'rgba(75, 192, 192, 0.2)', 'rgba(153, 102, 255, 0.2)', 'rgba(255, 159, 64, 0.2)' ], borderColor: [ 'rgba(255, 99, 132, 1)', 'rgba(54, 162, 235, 1)', 'rgba(255, 206, 86, 1)', 'rgba(75, 192, 192, 1)', 'rgba(153, 102, 255, 1)', 'rgba(255, 159, 64, 1)' ], borderWidth: 1 }] }, options: { scales: { yAxes: [{ ticks: { beginAtZero: true } }] } } }); </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" type="text/javascript"></script> the error provide is Uncaught ReferenceError: Chart is not defined class Lists(ListView): template_name = 'charts.html' context_object_name = 'products' pass i also tried to to make a separate js file to the script but it provided Uncaught SyntaxError: Unexpected token % and when i copied the script into the … -
implement DRF get_queryset so that a bad query_param responds with an error message
I have a django model which I want to display via Django Rest framework. I am getting all objects in the model to be displayed via the get_queryset(). However, I also have a couple of query_params which will filter out certain objects. This is my main code which is working fine: class PlanView(generics.ListAPIView): """ API endpoint which allows prices to be viewed or edited """ serializer_class = PlanSerializer permission_classes = (IsAuthenticatedOrReadOnly,) # override method def get_queryset(self): //get all objects in Plan model queryset = Plan.objects.all() // possible query parameters to be read from url size = self.request.query_params.get("size", None) price = self.request.query_params.get("price", None) if size is not None: if size == "large": queryset = queryset.filter(Large=True) elif size == "small": queryset = queryset.filter(Large=False) if price is not None: queryset = queryset.filter(price=price) return queryset with this urlpattern: path(r'API/plans', views.PlanView.as_view(), name='prices'), The only problem is that when I purposefully write the below URL in a browser, http://127.0.0.1:8000/API/plans?size=sm which has a bad/misspelled query_param value, the get_query() code will just ignore it and display the objects as if there are no filters. I tried to put an else statement such as: if size is not None: if size == "large": queryset = queryset.filter(Large=True) elif size == … -
How to get and save data of the nearest element in page in python django
I need to add comment module on my homepage in django python - simple textarea under each post. I need to get the nearest post id before i save it in my form, that my comment knows to which post is related. My views.py def home(request): newPostForm = newPost() newCommentForm = newComment() if request.is_ajax(): newPostForm = newPost(request.POST) newCommentForm = newComment(request.POST) if newPostForm.is_valid(): instance = newPostForm.save(commit=False) instance.author = request.user instance.date_posted = timezone.now() instance.save() data = { 'message': 'post is added' } return JsonResponse(data) if newCommentForm.is_valid(): instance = newCommentForm.save(commit=False) instance.author = request.user instance.date = timezone.now() instance.save() data = { 'message': 'comment is added' } return JsonResponse(data) context = { 'newPostForm': newPostForm, 'newCommentForm': newCommentForm, 'posts': Post.objects.all().order_by('-date_posted'), 'comments': Comment.objects.all().order_by('-date_posted') } and my home.html <div class="leftcolumn"> <div class="new_post_form"> <form METHOD="POST" class="new_post" id="new_post"> {% csrf_token %} {{ newPostForm }} <button type="submit">Publish</button> </form> </div> <div id="posts"> {% for post in posts %} <div class="container"> <a class="user" href="#">{{ post.author }}</a>, {{ post.date_posted }} <img src="{{ post.author.profile.image.url }}" alt="{{ post.author }}" style="width:100%;"> <p>{{ post.content }}</p> {% for comment in post.comments.all %} <div class="comment"> <p>{{ comment.content }}</p> <form METHOD="POST" class="new_comment" id="new_commentt"> {% csrf_token %} {{ newCommentForm }} </form> </div> {% endfor %} </div> {% endfor %} </div> </div> I don't … -
n:m relation table foreign key column unique
i have 2 tables Pool table pid(PK) Problem table number(PK) | name | submit | accept and also have n to m relation table PoolProblem PoolProblem pid(FK from Pool table) | number(FK from Problem table) if i insert tuple in PoolProblem like this, 1 | 1 1 | 2 1 | 3 2 | 2 << i want to show error this line, because number fk is duplicated on entire table. i tried ManyToMany relation, set unique constraint at number column(but error,,,) how can i solve it? -
How to select only one row for one user in django?
I have a message database and it has senderid, receiverid, message and date. Now I would like to get list of users whom I have recently messaged with one latest message (sent or received) per person. How can I get just a single row of message per person. I tried but this game me all the messages between two users, I just want the latest message. querySet=MessageModel.objects.filter( Q(sUser=self.request.user) | Q(rUser=self.request.user) ) return querySet but this game me all the messages between two users, I just want the latest message. -
Django doesn't serve images because Debug is set to True - how can I make nginx serve those?
So I'm just deploying my second website. I have a static location with css, js files and everything works alright. Now I just realised that I also have some images uploaded by the users. Here is the model: photo_1 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_2 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_3 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_4 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_5 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_6 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_7 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_8 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) photo_9 = models.ImageField(upload_to='photos/%Y/%m/%d/', blank=True) The problem is that when I try to access those images with DEBUG set to True, I get this Not Found The requested resource was not found on this server. I found on the internet that setting Debug to True makes django not serve the files anymore. So I have to configure nginx to serve those. How can I do that? I have to make it also serve the default /static/ folder, and these photos which don't have a fixed name. (%Y/%m/%d). The absolute path would be something like /etc/USERNAME/main-website/media/photo/%Y/%m/%d. Here is my nginx file from sites-enabled. server { server_name bestdavnic73.com; location = /favicon.ico { access_log off; log_not_found off; } location /static/ { root /home/octavian56/main-website; } location / { include proxy_params; proxy_pass http://unix:/home/octavian56/main-website/bestDAVNIC73.sock; } listen 443 … -
How to realize registration via Facebook in django?
I have my API and here I developed registration view. Now I want to realize registration via facebook, idk how to do it correct. Where i can find some good example(i'm interested only backend part)? -
how can I filter a field list values whenever I change another field value?
I have 3 models Category, Subcategory, and Product I registered them on the Django admin, in the add product admin page I need the subcategories list to be filtered based on the category value I choose. right now the subcategory list shows all subcategories, I need when I choose the category A to have only the subcategories that are related to Category A. Category Model class Category(models.Model): name = models.CharField(max_length=200, db_index=True) created = models.DateTimeField(auto_now_add=True) updated = models.DateTimeField(auto_now=True) Subcategory Model class Subcategory(models.Model): category = models.ForeignKey(Category, related_name='subcategories', on_delete=models.CASCADE) name = models.CharField(max_length=200, db_index=True) created = models.DateTimeField(auto_now_add=True) updated = models.DateTimeField(auto_now=True) Product Model class Product(models.Model): category = models.ForeignKey(Category, related_name='products', on_delete=models.CASCADE) subcategory = models.ForeignKey(Subcategory, related_name='products', on_delete=models.CASCADE) -
HTML select multiple values from styled list with checkboxes
I have a django project with a list of users that I want to include in a post request. Note that only the users that I have checked should be included in the post request in the django function based view. I wonder how I can get the value of the checked users into the django post request function based view? Its not exactly like in this picture but the checkbox and the user part Is the same, I couldn't find out how to put a local file into stack overflow! The Project Page: @login_required def projectPage(request): obj = Project.objects.filter(canview__user=request.user) assignments = Assignment.objects.filter(canview__user=request.user) allstudents = UserProfile.objects.all() username = request.user context = { 'object': obj, 'MyName': username, 'Assignments': assignments, 'students': allstudents } return render(request, 'allProjects.html', context) The POST REQUEST Page: @login_required def create_project(request): if request.method == 'POST': name = request.POST.get('Project-Name') description = request.POST.get('Project-Description') parent_assignment = Assignment.objects.get(pk=request.POST.get('Project-ParentAssignmentID')) membersInProject == SOMETHING project = Project(name=name, description=description, parent_assignment=parent_assignment, members = membersInProject) project.save() return redirect('allaStudieplaner') In The HTML template: {% for student in students %} <div class="custom-control custom-checkbox"> <span class="d-flex align-items-center"> <div style="margin-right: 10px"> <div class="circle"> <span class="initials" , style="color: #ffffff"> {{ elev.user|capfirst|first }} </span> </div> </div> <div style="width: 300px"> <span class="h6 mb-0" data-filter-by="text">{{elev.user|capfirst}}</span> </div> <div … -
Using select_related in add/edit django admin for single field
I need to resolve the N+1 problem. Below is my model: class Work(models.Model): id = models.AutoField(primary_key=True) date = models.DateField(null=True, blank=True) book = models.ForeignKey('Chapter', on_delete=models.CASCADE) job = models.ForeignKey('Job', on_delete=models.CASCADE) user = models.ForeignKey('users.User', on_delete=models.CASCADE, null=True, blank=True) prev_work = models.ForeignKey('self', on_delete=models.CASCADE, editable=False, null=True, blank=True) And now I overrided get_queryset in my ModelAdmin. It works great in List View but when I want to add new element it makes multiple queries because of the "book" field. So how can I override sql for SINGLE field. To be specific, it makes so many queries because in my model file I have this: def __str__(self): return self.book.project.slug + "-" + str(self.book.number) + "-" + self.job.name and there are many books and many projects. -
Including a list view with inclusion tag
I've a list view function (searchview) that I want to include to my template home page with the help of the inclusion tag, please how do I get around this... Thanks in anticipation -
getting the counts and values of foreignkeys relations with query
hi my models are like this and i'm using mysql class UserChannel(models.Model): ... channel = models.ForeignKey(Channel) user_entry_date = models.IntegerField() channelName = models.ForeignKey(ChannelName) is_verified = models.BooleanField(default=False) users = Fk ... class Channel(models.Model): ... name = models.CharField() is_active = models.BooleanField(default=True) class ChannelName(models.Model): ... channel = models.ForeignKey(Channel,) channel_name = models.CharField() i have to show differnt UserChannels and thier counts based on distinct Channel and ChannelName of a range of time which is timestamp (its something like a logging system) right now i am getting all UserChannels of a range of time and i want to show values based on that query so far i have managed to get this done with for loops but it is very inefficient and takes a lot of time to respond channels = Channel.objects.all().values('pk', 'name') channel_names = ChannelName.objects.all().values('pk', 'channel_name') result_list = [] for query in queryset: # list of all UserChannels of a range of time res = dict() for item in channels: query_specific = query.filter(channel=item['pk']) query_is_verified = query.filter(channel=item['pk'], is_verified=True) for channel_name in channel_names: count_query_specific = query_specific.filter(channelName=channel_name['pk']).count() if count_query_specific != 0: res['count_all_specific'] += f'{item["name"]}- {channel_name["channel_name"]} : {count_query_specific}' count_query_is_verified = query_is_verified.filter(channelName=channel_name['pk']).count() if count_query_is_verified != 0: res['count_is_verified'] += f'{item["name"]}- {channel_name["channel_name"]} : {count_query_is_verified}' so i want some thing like this in … -
Django Messages show up only in admin
I have set up a django message that gets displayed when the user logs in, but the messages show up only in the admin. accounts/views.py def login_page(request): form = LoginForm(request.POST or None) context = { 'form':form } next_ = request.GET.get('next') next_post = request.POST.get('next') redirect_path = next_ or next_post or None if form.is_valid(): username = form.cleaned_data.get("username") password = form.cleaned_data.get("password") user = authenticate(request, username=username,password=password) if user is not None: login(request, user) try: del request.session['guest_email_id'] except: pass if is_safe_url(redirect_path,request.get_host()): return redirect(redirect_path) else: messages.info(request,"You are now logged in") return redirect("/") else: messages.error(request,"Something went wrong") print("Error") return render(request,"accounts/login.html", context) settings.py MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage' 'OPTIONS': { 'context_processors': [ ... 'django.contrib.messages.context_processors.messages', base.html {% if message is not None %} {% for message in messages %}{{ message }}{% endfor %}{% else %}{% endif %} -
display DB blob(image) column on html page
I need a help to display photo from oracle DB on html page in django webapp, I have django webapp, and it has Employee model which has image column as blob to save the employee photo in the DB, when I try to display the image column on the HTML page it doesn't display. and it displays it as the following: ** (b'\x89PNG\r\n\x1a\n\x00\x00\x00\rIHDR\x00\x00\x03\xbc\x00\x00\x010\x08\x02\x00\x00\x00\x1b\xcc\xea\xea\x00\x00\x12\IDATx\x9c\xed\xdd\x7flU\xf5\xf9\xc0\xf1\x16\nTj\x11\x8ct\x1bC@\x87\xd3\rA\xd0\xa1h\x1d2\x17\'\x04\xa63\xea\xe6/\xd4\x99\x918\xb3\x98-\xea\x96\x91\xb8\xcdE\xd9\x92mYt\x89f\xfa\x07\x81\x98,Q\xb6e\xfe\xc2\x88\xc4P (3\xc2\xa0\xa6\xc8\xc2\x06,\xfc\xa8h\xb5\x08\xa3\xed\xfd\xfe\xe1\xbe\xc4\x08\xf7<\xa7\xb7\xe7\x9e\xf6\xe8\xeb\xf5\xe7\xfd\x9c>\xe7Y\xd8\xbawNn\xef\xad-\x95J5\x00\x00@y\x83\xfa{\x01\x00\x00\x18\xe8D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04D3\x00\x00\x04\xea\xfa{\x81<\xd4\xd6\xd6f2\'\xcdW\x8e\xa7\xb9W&_]\x9e\xdb\x8d\xb2\x92\xe7\xc2Y\xfd\x8b\x87\x06\xd4\xc2\x03\xea\xbf\x9f)\xef\x95\x89\xac\xfe\x83gr\xa34\x06\xd4o\x89\xac|"\xff\x15r3\xd0\xfe\xc7\x1b\xcaj\x99<\xff\xdf9\x13\x85\xfb\xb5\xf6\x89\xfcW\xe8G\x9e4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@@4\x03\x00@\xa0\xb6T*\xf5\xf7\x0e\x00\x000\xa0y\xd2\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x81\xba\xfe^\x00\xe0S\xad\xa3\xa3\xe3\xf9\xe7\x9f\x7f\xed\xb5\xd7Z[[\xb7m\xdb\xd6\xd9\xd9\xf9\xde{\xef\xf5\xf4\xf4466\x8e\x181b\xc2\x84\t\x93&M:\xe7\x9csf\xcf\x9e=v\xec\xd8\xfe^\xf6\x7f\x8a\xb83@\x1f\xd5\x96J\xa5\xfe\xde\x01\xe0S\xa7\xbb\xbb\xfb\x89\'\x9ex\xf4\xd1G\xd7\xacY\xf3\xc1\x07\x1f\xa4\xf9\x91i\xd3\xa6}\xf7\xbb\xdf\xbd\xed\xb6\xdb\x1a\x1a\x1a\xaa\xbd\xdeq\x15qg\x80\xac\x88f\xe0\x13e\xff\xfe\xfdk\xd7\xaemiiY\xb5j\xd5\xab\xaf\xbe\xfa\xfe\xfb\xef\x97\xbbr\xf9\xf2\xe5\xb3g\xcf\xces\xb7\xa3\x96.]\xfa\xb3\x9f\xfdl\xc7\x8e\x1d\x15\xfc\xec\xc9\'\x9f|\xcf=\xf7\xdcu\xd7]C\x86\x0c\xc9|\xb1\x04E\xdc\x19 C\xa2\x19(\xbc\x8e\x8e\x8e\xd5\xabW\xafZ\xb5\xaa\xa5\xa5e\xe3\xc6\x8d)\x1f\x82\xf6K4\xef\xd8\xb1c\xc1\x82\x05+V\xac\xe8\xe3\x9c\xc9\x93\'/^\xbc\xf8\xbc\xf3\xce\xcbd\xabdE\xdc\x19 s\xa2\x19(\xa4\xbd{\xf7\xb6\xfc\xbf\xd6\xd6\xd6\n~\x95\xe5\x1f\xcd\xeb\xd6\xad\xbb\xf2\xca+\xf7\xed\xdb\x97\xc9\xb4\xfa\xfa\xfa\xc5\x8b\x17_w\xddu\x99L+\xa7\x88;\x03T\x83?\x04\x04\nc\xe7\xce\x9d\x1fV\xf2\xaaU\xab\xb6n\xdd\xda\xdf\xeb\xf4\xce\xb3\xcf>{\xcd5\xd7tuue5\xb0\xab\xab\xeb\x86\x1bn\xd8\xb3g\xcf\x8f~\xf4\xa3\xacf~L\x11w\x06\xa8\x12\xd1\x0c\x14\xc6\xe9\xa7\x9f\x9e\xf2\xad\x17\x03\xcd\xbau\xeb\xae\xbd\xf6\xda\x0c\xeb\xf3C\xa5R\xe9\xae\xbb\xee:\xe5\x94S\xe6\xcf\x9f\x9f\xed\xe4\x9ab\xee\x0cP=>\xa7\x19\xa0\xbav\xee\xdc9o\xde\xbcC\x87\x0eUcx\xa9T\xba\xed\xb6\xdbZZZ\xb2\x1d[\xc4\x9d\x01\xaaJ4\x03TQOO\xcf\xcd7\xdf\xdc\xd1\xd1\x91|YCC\xc3\xf7\xbe\xf7\xbd?\xff\xf9\xcf\xdb\xb7o?p\xe0@WW\xd7\xae]\xbb\x96/_~\xf7\xddw755%\xfflww\xf7\xfc\xf9\xf3;;;?\xcd;\x03T]\t\xa0 \x06\x0f\x1e\x9c\xe1o\xbf\xe5\xcb\x97\xe7\xb0\xf3\xef~\xf7\xbb\xe45jkko\xbf\xfd\xf6\x8e\x8e\x8er\x13\xba\xba\xba\xee\xbf\xff\xfe\x13N8!y\xce\xfc\xf9\xf3?\xcd;\x03T\x9bO\xcf\x00\n\xa3\xae\xae.|OsCC\xc3\x8c\x193f\xce\x9c9s\xe6\xcc\x17_|\xf1\x81\x07\x1e(we\x0e\x9f\x9e\xb1o\xdf\xbe\x89\x13\'\xee\xdf\xbf\xbf\xdc\x05\xf5\xf5\xf5K\x96,\xf9\xf6\xb7\xbf\x1d\x8e\xfa\xfb\xdf\xff~\xc5\x15W\xec\xdd\xbb7\xe1\x9a\x97_~\xf9\x82\x0b.\xa8d\xd1\x8f(\xe2\xce\x009\xf0\x87\x80@\xe1\x8d\x1c9\xb2\xb9\xb9\xf9\xc3P\xfe\xcaW\xbeRW\xf7\xbf\xdflk\xd6\xac\xe9\xdf\xc5\xee\xbb\xef\xbe\x84\xfa\x1c4h\xd0\x9f\xfe\xf4\xa7o}\xeb[iFM\x9f>}\xc5\x8a\x15\x17_|q\xc2[\x1a\xee\xb9\xe7\x9e\xbe\xbfQ\xb8\x88;\x03\xe4\xc0{\x9a\x81Bjjj\xba\xfa\xea\xab\x1f|\xf0\xc1\r\x1b6\xbc\xfd\xf6\xdb\xcf<\xf3\xcc\x8f\x7f\xfc\xe3\x193f\x1c-\xe6~\xb7{\xf7\xeeG\x1f}4\xe1\x82\x9f\xff\xfc\xe7)\xeb\xf3Cg\x9f}\xf6\xe3\x8f?\x9ep\xc1\xea\xd5\xab\xfb\xf8\x15$E\xdc\x19 \x1f\xa2\x19(\x8c\xf1\xe3\xc7\xdfx\xe3\x8d\x7f\xfc\xe3\x1f\xdb\xda\xda\xda\xdb\xdb\x97-[v\xe7\x9dwN\x9d:u\xd0\xa0\x81\xf8\xab\xec\x91G\x1eI\xf8\x12\xef\xa9S\xa7.\\\xb8\xb0\xb73\xe7\xcd\x9bw\xf3\xcd7\'\\\xf0\xe0\x83\x0f\xf6v\xe6G\x15qg\x80|xO3\xf0\x89u\xff\xfd\xf7\xdf{\xef\xbd\xe5N\xab\xfa\x9e\xe6#G\x8e\x9cz\xea\xa9o\xbe\xf9f\xb9\x0b^x\xe1\x85\xcb.\xbb\xac\x82\xc9\xbbv\xed\x9a8qb\xb9\x8fO\xae\xad\xad\xdd\xbau\xeb\xc4\x89\x13+\x98\\\xc4\x9d\x01r3\x10\x1f\xcf\x00\x14\xdds\xcf=\x97P\x9f\x17^xae\xf5YSS\xf3\xf9\xcf\x7f~\xc1\x82\x05\xe5NK\xa5\xd2\x92%K*\x9b\\\xc4\x9d\x01r#\x9a\x01\xb2\xf7\xe4\x93O&\x9c\xdeq\xc7\x1d}\x19~\xfb\xed\xb7\'\x9c.[\xb6\xac\xb2\xb1E\xdc\x19 7\xa2\x19 c\x87\x0f\x1f~\xe6\x99g\xca\x9d\x8e\x181\xe2\x9ak\xae\xe9\xcb\xfc/\x7f\xf9\xcb3f\xcc(w\xbae\xcb\x96\xd6\xd6\xd6\xde\xce,\xe2\xce\x00y\x12\xcd\x00\x19[\xbdzu\xc2\xa7\xb6\xcd\x993\xa7\xbe\xbe\xbe\x8f\xb7\xb8\xea\xaa\xab\x12N\x13\xf2\xb7\x9c"\xee\x0c\x90\'\xd1\x0c\x90\xb1U\xabV%\x9c^q\xc5\x15}\xbfE\xf2\x90\xe4\x05*\xf8\x91\x81\xb93@\x9eD3@\xc6\x92\xfbo\xd6\xacY}\xbf\xc5Yg\x9d\xf5\xd9\xcf~\xb6\xdc\xe9\x9a5k\xba\xbb\xbb{5\xb0\x88;\x03\xe4I4\x03d\xe9\xc8\x91#\xeb\xd7\xaf/wz\xfa\xe9\xa7\x8f\x193&\x93\x1b577\x97;:p\xe0\xc0\xc6\x8d\x1b\xd3\x8f*\xe2\xce\x009\x13\xcd\x00Yjkk;|\xf8p\xb9\xd3\xf3\xcf??\xab\x1b]p\xc1\x05\t\xa7\xbd\n\xd0"\xee\x0c\x903\xd1\x0c\x90\xa5M\x9b6%\x9cN\x9e<9\xab\x1b%\x8f\xda\xbcys\xfaQE\xdc\x19 g\xa2\x19 K\xc9\xe5\x97a\x80N\x992\xa5\xe25zu\xf1\xc0\xdc\x19 g\xa2\x19 K[\xb6lI8\xcd\xf0\xcb\xa2\xc7\x8c\x193|\xf8\xf0r\xa7mmm\xe9G\x15qg\x80\x9c\x89f\x80,\xed\xd8\xb1#\xe1t\xc2\x84\t\x19\xdek\xdc\xb8q\xe5\x8e\xda\xdb\xdb\x13\xde\xa6\xfc1E\xdc\x19 g\xa2\x19 K;w\xee,w\xf4\x99\xcf|\xe6\x84\x13N\xc8\xf0^\t9[*\x95\xfe\xf3\x9f\xff\xa4\x9cS\xc4\x9d\x01r&\x9a\x012s\xe0\xc0\x81w\xdf}\xb7\xdci\xc2\xa7\x14W&yB\n\x7fT\x11w\x06\xc8\x9fh\x06\xc8\xcc\x9e={\x12NG\x8f\x1e\x9d\xed\xed\x92\x07\xee\xde\xbd;\xcd\x90"\xee\x0c\x90?\xd1\x0c\x90\x99\x8e\x8e\x8e\x84\xd3\xcc\x03\xb4\xa9\xa9)\xe1\xf4\x9dw\xdeI3\xa4\x88;\x03\xe4O4\x03d&\xb9\xf9N:\xe9\xa4\x84\xd3\x83\x07\x0f\xfe\xfa\xd7\xbf>\xef\xbc\xf3N<\xf1\xc4\xc6\xc6\xc6i\xd3\xa6\xfd\xf2\x97\xbf\xec\xec\xec\xacx\xca\x00-\xe2\xce\x00\xf9\xab\xeb\xef\x05\x00>9\x92\x9b\xef\xc4\x13O,w\xd4\xd6\xd66w\xee\xdc\x7f\xff\xfb\xdfG_\xd9\xb8q\xe3\xc6\x8d\x1b\x1f~\xf8\xe1\xbf\xfc\xe5/\x17]tQo\x07\x86\xcb\xa4\xbcl\xee\x0c\x90?O\x9a\x012\xb3\x7f\xff\xfe\x84\xd3r\xbd\xb8{\xf7\xee\xaf\x7f\xfd\xeb\x1f\xad\xcf\xa3\xda\xdb\xdb\xbf\xf1\x8do\x94\xfb~\xe9\xe4\x00M~\xe2{T\x11w\x06\xc8\x9fh\x06\xc8L\xf2\xc7\x0c744\x1c\xf7\xf5\x1f\xfe\xf0\x87\t\x7f\x8dw\xf0\xe0\xc1[n\xb9\xa5\xa7\xa7\'\xfd\xc04\xcb\xa4\xbcl\xee\x0c\x90?\xd1\x0c\x90\x99\xf7\xdf\x7f?\xe1\xb4\xae\xee8\xef\x88koo_\xb6lY\xf2\xd8M\x9b6\xbd\xf8\xe2\x8b)\x07\xa6\\&\xe5e\x03sg\x80\xfc\x89f\x80\xcc$7\xdf\xe0\xc1\x83\x8f}q\xed\xda\xb5\xa5R)\x9c\xdc\xd2\xd2r\xec\x8b9D\xf3\xc0\xdc\x19 \x7f\xa2\x19 3\x15<\xb5}\xeb\xad\xb7\xd2L\xde\xb7o_\xca\x81)\x97Iy\xd9\xc0\xdc\x19 \x7f\xa2\x19 3i\x9e\xbf~\xcc\xc8\x91#\xd3\\v\xf2\xc9\'\x1f\xfbbmmm\xdf\x97)\xe2\xce\x00\xf9\x13\xcd\x00\x99\x192dH\xc2\xe9\x07\x1f|p\xec\x8b\xd3\xa7OO3\xb9\xb9\xb9\xf9\xd8\x17\x93\x9f\xcb\x0e\x1d:4\xcd\xe4"\xee\x0c\x90?\xd1\x0c\x90\x99\xe4\x00\xed\xee\xee>\xf6\xc5\xd3N;\xed\x92K.I\x1e\xfb\x85/|\xe1\xf2\xcb/O90\xe52)/\x1b\x98;\x03\xe4O4\x03d&\xf9Ai\xb9^|\xe8\xa1\x87\x12>\x88m\xe8\xd0\xa1\x8b\x17/>nM\x1e\xf71\xf0Q)\x03\xb4\x88;\x03\xe4O4\x03d&9@\xff\xfb\xdf\xff\x1e\xf7\xf5)S\xa6<\xf5\xd4S\xc7}\x07\xf0\xc8\x91#\xff\xf6\xb7\xbf}\xf5\xab_=\xee\x0f\x1e<x\xb0\xe2eR^60w\x06\xc8\x9fh\x06\xc8\xccI\'\x9d\x94pz\xe0\xc0\x81rG\x97^z\xe9\x96-[~\xfa\xd3\x9f\x9e}\xf6\xd9\xc3\x87\x0f\x1f>|\xf8\xe4\xc9\x93\x17.\\\xb8u\xeb\xd6\xd9\xb3gW0\xb0&\xf5\x9f\xeb\x15qg\x80\xfc%}\xf4\x0f\x00\xbd2j\xd4\xa8\x84\xd3\xe4^\x1c=z\xf4\xa2E\x8b\x16-Z\x94\xfev\xc9\x03\x93\x97Iy\xd9\xc0\xdc\x19 \x7f\x9e4\x03d&\xf9Aiggg\xb6\xb7K\x1e\x98\xf2\xa9m\x11w\x06\xc8\x9fh\x06\xc8\xccq\xdf\xe3{\xd4q\xbf\xec\xa3/\xde|\xf3\xcd\x84\xd3\x94Om\x8b\xb83@\xfeD3@f>\xf7\xb9\xcf%\x9cf\x1e\xa0\xc9\x03\xc7\x8c\x19\x93fH\x11w\x06\xc8\x9fh\x06\xc8Lccc\xc2\xdf\xd5\xed\xd9\xb3\'\xdb\xdb\xed\xdd\xbb7\xe1t\xdc\xb8qi\x86\x14qg\x80\xfc\x89f\x80,%d_{{\xfb\xa1C\x872\xbc\xd7\xf6\xed\xdb\xcb\x1d\xd5\xd6\xd6\x9ez\xea\xa9)\xe7\x14qg\x80\x9c\x89f\x80,\x8d\x1f?>\xe1t\xc7\x8e\x1d\x19\xde+aZSSS}}}\xca9E\xdc\x19 g\xa2\x19 Kg\x9eyf\xc2\xe9?\xff\xf9\xcf\xacn\xb4{\xf7\xeer\xdf<RSSs\xd6Yg\xa5\x1fU\xc4\x9d\x01r&\x9a\x01\xb24e\xca\x94\x84\xd3\xd6\xd6\xd6\xacn\xb4y\xf3\xe6\x8a\xd7\xe8\xd5\xc5\x03sg\x80\x9c\x89f\x80,%\x97_r5\xf6J\xf2\xa8\xc9\x93\'\xa7\x1fU\xc4\x9d\x01r&\x9a\x01\xb2\xf4\xa5/}i\xe8\xd0\xa1\xe5N\xd7\xaf_\x9f\xd5\x8d^y\xe5\x95\x84\xd3\xa9S\xa7\xa6\x1fU\xc4\x9d\x01r&\x9a\x01\xb24l\xd8\xb0\xe9\xd3\xa7\x97;\xdd\xb6m[V\x1f\xe2\xb6v\xed\xdarG\r\r\r\xd3\xa6MK?\xaa\x88;\x03\xe4L4\x03d\xec\x92K.I8}\xe9\xa5\x97\xfa~\x8b7\xdex#!d\x9b\x9b\x9b\xeb\xea\xeaz5\xb0\x88;\x03\xe4I4\x03d,9@\x9f~\xfa\xe9\xbe\xdf\xe2\xa9\xa7\x9eJ8\x9d5kVo\x07\x16qg\x80<\x89f\x80\x8c\xcd\x9c9\xb3\xb1\xb1\xb1\xdc\xe9s\xcf=w\xf8\xf0\xe1>\xde\xe2\xaf\x7f\xfdk\xc2\xe9\xbcy\xf3z;\xb0\x88;\x03\xe4I4\x03d\xac\xbe\xbe~\xee\xdc\xb9\xe5N\xf7\xef\xdf\xff\xe4\x93O\xf6e~[[\xdb\xbau\xeb\xca\x9d~\xf1\x8b_\xac\xe0c(\x8a\xb83@\x9eD3@\xf6\xae\xbd\xf6\xda\x84\xd3\x87\x1f~\xb8/\xc3\x1fy\xe4\x91\x8ao]\xf1\x0f\x0e\xcc\x9d\x01r#\x9a\x01\xb27w\xee\xdc\xd1\xa3G\x97;]\xb7n\xdd\x8a\x15+*\x9b\xbck\xd7\xae\xc7\x1e{\xac\xdcimm\xed-\xb7\xdcR\xd9\xe4"\xee\x0c\x90\x1b\xd1\x0c\x90\xbda\xc3\x86-X\xb0 \xe1\x82\x9f\xfc\xe4\'\xdd\xdd\xdd\x15L^\xb8paWWW\xb9\xd39s\xe6\x9cq\xc6\x19\x15\x8c\xad)\xe6\xce\x00\xb9\x11\xcd\x00U\xf1\xfd\xef\x7f?\xe13\xd46l\xd8\xb0h\xd1\xa2\xde\xce|\xf6\xd9g\x97.]\x9ap\xc1\x9dw\xde\xd9\xdb\x99\x1fU\xc4\x9d\x01\xf2!\x9a\x01\xaab\xec\xd8\xb1\xc9\x0fn\xef\xbb\xef\xbe\xe4Oa\xfb\x98\xd7_\x7f\xfd\xa6\x9bnJ\xb8\xe0\xa2\x8b.\xba\xfc\xf2\xcb\xd3\x0f<V\x11w\x06\xc8\x87h\x06\xa8\x96_\xfc\xe2\x17\t\x9f\xe3\xd6\xd3\xd3s\xddu\xd7\xa5\xfcT\x8aW_}\xf5\xb2\xcb.{\xf7\xddw\x13\xae\xf9\xedo\x7f\xdb\xdb\r\x8fU\xc4\x9d\x01r \x9a\x01\xaa\xa5\xa9\xa9\xe9\xde{\xefM\xb8\xe0\xd0\xa1C\xdf\xf9\xcew\xee\xb8\xe3\x8e\x84\xb2<r\xe4\xc8\xaf~\xf5\xab\x993g&\x7f\x97\xf5\r7\xdcp\xe1\x85\x17V\xbc\xeaQE\xdc\x19 \x07\xb5\xa5R\xa9\xbfw\x00Hk\xea\xd4\xa9\xff\xf8\xc7?\xf2\xbf\xef\x1f\xfe\xf0\x87\x1f\xfc\xe0\x07\x15\xfcOO\xcf\xacY\xb3V\xaf^\x9d|Ycc\xe3\xf5\xd7_?g\xce\x9cs\xcf=w\xf4\xe8\xd1\x83\x07\x0f~\xfb\xed\xb77o\xde\xbcr\xe5\xca%K\x96\xb4\xb7\xb7\'\xff\xf8\xd8\xb1c7m\xda4j\xd4\xa8\n6\xfcd\xec\x0cPm\xa2\x19(\x92\xc2EsMM\xcd\xf6\xed\xdb\xcf=\xf7\xdcw\xdey\'\xdb\x95\x8e\xaa\xab\xab{\xe1\x85\x17\xbe\xf6\xb5\xafe8\xb3\x88;\x03T\x95\xb7g\x00T\xd7\x84\t\x13\x9e~\xfa\xe9\xfa\xfa\xfa*\xcd\x7f\xec\xb1\xc72\xaf\xcf"\xee\x0cPU\xa2\x19\xa0\xea\x9a\x9b\x9b\x9fx\xe2\x89a\xc3\x86e>\xf97\xbf\xf9\xcd\xad\xb7\xde\x9a\xf9\xd8\x9ab\xee\x0cP=\xa2\x19 \x0f\xdf\xfc\xe67W\xae\y\xca)\xa7d5p\xd8\xb0a\x8f?\xfe\xf8\xddw\xdf\x9d\xd5\xc0c\x15qg\x80*\x11\xcd\x009inn^\xbf~\xfd\xa5\x97^\xda\xf7Q\x93&Mjii\xb9\xf1\xc6\x1b\xfb>*Y\x11w\x06\xa8\x06\xd1\x0c\x90\x9f\xd3N;m\xe5\xca\x95\x8b\x17/\x1e7n\e\x13F\x8d\x1a\xf5\xc0\x03\x0fl\xd8\xb0\xe1\xfc\xf3\xcf\xcfv\xb7r\x8a\xb83@\xe6D3@\xden\xbd\xf5\xd6m\xdb\xb6-]\xba\xf4\xe2\x8b/\x1e4(\xed\xef\xe1)S\xa6\xfc\xfe\xf7\xbf\xdf\xb9s\xe7\xc2\x85\x0b\x87\x0c\x19R\xd5\r\x8fU\xc4\x9d\x012\xe4#\xe7\x00\xfa\xd3[o\xbd\xf5\xfc\xf3\xcf\xbf\xf6\xdak\xad\xad\xad\xff\xfa\xd7\xbf:;;\xdf{\xef\xbd\x9e\x9e\x9e\xc6\xc6\xc6\x11#F\x8c\x1f?~\xd2\xa4I\xe7\x9cs\xce\xec\xd9\xb3+~\xd0\x9b\xb9"\xee\x0c\xd0G\xa2\x19\x00\x00\x02\xde\x9e\x01\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x01\xd1\x0c\x00\x00\x81\xff\x03\xf0\xc2\xa5\xc7\xda\xabX&\x00\x00\x00\x00IEND\xaeB`\x82') ** -
Combining two or more queryset or combining different models as a single output
I have created 2 models Images and UserDetails both contain a foreignkey field of auth_user (User) .If i provide a user id i want get data from 3 models. ie; from User , UserDetails and Images as queryset in DRF models.py from django.contrib.auth.models import User from django.db import models class Images(models.Model): name = models.CharField(max_length=10) userid = models.ForeignKey(User,on_delete=models.CASCADE) category = models.CharField(max_length=10) file = models.FileField(blank=True, null=True) class Categories(models.Model): name = models.CharField(max_length=15) class Skills(models.Model): name = models.CharField(max_length=20) category = models.ManyToManyField(Categories) class UserDetails(models.Model): userid = models.ForeignKey(User,on_delete=models.CASCADE) firebase = models.CharField(max_length=50) mobile = models.IntegerField() pin = models.IntegerField( null=True) latitude = models.CharField(max_length=50,null=True) longitude = models.CharField(max_length=50,null=True) profile_pic = models.ManyToManyField(Images,null=True) skill = models.ManyToManyField(Skills,null=True) is_freelancer = models.IntegerField() serializer.py class ImageSerializer(serializers.ModelSerializer): class Meta: model = Images fields = '__all__' views.py class Profile(ListAPIView): permission_classes = (IsAuthenticated,) authentication_classes = (TokenAuthentication,) serializer_class = ImageSerializer def get_queryset(self): img = Images.objects.filter(userid=self.request.user.id) return img if i run this in postman i get { "count": 1, "next": null, "previous": null, "results": [ { "id": 2, "name": "", "category": "profile pic", "file": "http://127.0.0.1:8000/media/media/brand_EqkvDFf.png", "userid": 14 } ] } but i want output something like this { "count": 1, "next": null, "previous": null, "results": [ { "image": { "id": 2, "name": "", "category": "profile pic", "file": "http://127.0.0.1:8000/media/media/brand_EqkvDFf.png", "userid": 14 }, … -
How to properly use django testcase's addCleanup method?
I have a test subclass of APITestCase where I'm using the class-method setUpTestData to create data for my tests and also some mocks. Basically what I want to do is to run mock.patch.stopall (as shown next), but it's not working. I have based my implementation on THIS ANSWER and I'm using: Django v2.2.4 and djangorestframework v3.10.2 import mock from rest_framework.test import APITestCase class FooTest(APITestCase): @classmethod def setUpTestData(cls): patcher_one = mock.patch('route.one') mock_route_one = patcher_one.start() patcher_two = mock.patch('route.two') mock_route_one = patcher_two.start() cls.addCleanup(mock.patch.stopall) # etc super(FooTest, cls).setUpTestData() When running my tests with this code, I get: TypeError: addCleanup() missing 1 required positional argument: 'function' So I edit the addCleanup call to: cls.addCleanup(function=mock.patch.stopall) but I get the following: TypeError: addCleanup() missing 1 required positional argument: 'self' Editing to: cls.addCleanup(cls, function=mock.patch.stopall) I get AttributeError: type object 'FooTest' has no attribute '_cleanups' At this point I'm a bit lost. The workaround that I'm using is to do it in the tearDownClass method: @classmethod def tearDownClass(cls): mock.patch.stopall() But I would like to centralize all the testing logic in the setUpTestData method. Anyone see's where I'm messing up? -
Is it better to aggregate all data in a JSONField or use model ForeignKey?
I'm trying to create a business directory in multiple languages. Should I aggregate all the data in one JSONField, or should split it into multiple models, and why. models.py from django.db import models from django.contrib.postgres.fields import JSONField class Business(models.Model): name = models.CharField(max_length=500) subsidiary = models.ForeignKey(Business, on_delete=models.SET_NULL, null=True, blank=True) data = JSONField() {"name":{"ar":"Arabic Name","en":"English Name"}} etc -
Django how to pass header on request in get_queryset
I am using Django rest framework to pass a get request with a query_param like so: views.py class PlanView(generics.ListAPIView): """ API endpoint which allows prices to be viewed or edited """ serializer_class = PlanSerializer permission_classes = (IsAuthenticated,) # override method def get_queryset(self): queryset = Plan.objects.all() size = self.request.query_params.get("size", None) if portion is not None: if size == "large": queryset = queryset.filter(Large=True) elif size == "small": queryset = queryset.filter(Small=False) return queryset however, I set up an authentication class in settings.py like this: 'DEFAULT_AUTHENTICATION_CLASSES': [ 'rest_framework.authentication.TokenAuthentication' ] so that I can pass a header with a token in request. This works well when I test with a third party client like postman. however how can I pass a header in the above view? -
Sending images twice to CouchDb instead of 1 time
I try to send zip file which is unpacked in memory and images are sent to database. But images are sent twice and I don`t know where the problem is. Can someone tell please? def uploadZIP(request): if request.method == 'POST': mosaic = 'C:/Users/lenovo/Downloads/myimages.zip' zip_name = ZipFile(mosaic) db_view = launch_db.view('_all_docs', include_docs=True) list_of_files = [name for name in zip_name.namelist()] imageNumber = len(list_of_files) imgInDBNumber = len(db_view) if imageNumber != 0: generalImageNumber = imgInDBNumber - 1 for j in range(imageNumber): for i in range(0, len(list_of_files)): archive = ZipFile(mosaic, 'r') image = archive.read(list_of_files[i]) image = Image.open(BytesIO(image)) file_name = 'img{0}'.format(generalImageNumber) rgb, img = rgbValue(image, file_name) generalImageNumber = generalImageNumber + 1 launch_db.save(rgb) launch_db.put_attachment(rgb, img, 'image.png', 'image/png') launch_db.commit() messages.info(request, 'ZIP file with images was successfully sent') return render(request, 'add_images.html') -
slow process during saving model in database
i want save a list of model in database table but i very slow when i use save() method for each item it took near 20min is that a best way to save objects to table Modles.py class Part(models.Model): block = models.CharField(max_length= 2, null= True) phase = models.CharField(max_length= 3, null= True) department = models.CharField(max_length= 20, null= True) type = models.CharField(max_length= 10, null= True) mark = models.CharField(max_length= 20, null= True) class Task(models.Model): name = models.CharField(max_length= 20) class ProjectTask(models.Model): project = models.ForeignKey('Project', on_delete= models.CASCADE) task = models.ForeignKey("Task", on_delete=models.CASCADE) weight_percent = models.FloatField() class PartTask(models.Model): part = models.ForeignKey('Part', on_delete= models.CASCADE) project_task = models.ForeignKey('ProjectTask', on_delete= models.CASCADE) progress = models.FloatField(null=True) views.py def import_part_task(_project_id): project_id = _project_id project_task = ProjectTask.objects.all().filter(project= int(project_id[0])) part_list = Part.objects.all() part_task_list = [] for part in part_list: for task in project_task: part_task = PartTask() part_task.part =part part_task.project_task = task part_task_list.append(part_task) #This ACTION TAKES VERY LOG TIME for part_task in part_task_list: PartTask.save(part_task) -
Django migrate: django.db.utils.OperationalError: (1364, "Field 'name' doesn't have a default value")
basic datas: mysql-server: 5.7.27-0ubuntu0.16.04.1 Ubuntu: 16.04 Python: 2.7.12 Django: 1.11.16 Virtualenv . I added a new application (gallery) and created the following table: class Medi(models.Model): gd_id = models.CharField(max_length=128) # name = models.CharField(max_length=512, default='1') original_name = models.CharField(max_length=512) title = models.CharField(max_length=512, blank=True, null=True) md5sum = models.CharField(max_length=32) date_of_event = models.DateTimeField() date_of_event_end = models.DateTimeField(blank=True, null=True) last_updated = models.DateTimeField(auto_now=True) created = models.DateTimeField(auto_now_add=True) . To be very clean after getting the above mentioned errors i deleted the table from the database, the entries from the django_migrations table and all the migrations file but init.py . I ran makemigrations and after that migrate which had the following output: python manage.py makemigrations Migrations for 'gallery': gallery/migrations/0001_initial.py - Create model Medi python manage.py migrate Operations to perform: Apply all migrations: admin, auth, bugtrack, common, contenttypes, follow, gallery, infokom, phonebook, sessions, sites Running migrations: Applying gallery.0001_initial... OK Traceback (most recent call last): File "manage.py", line 22, in <module> execute_from_command_line(sys.argv) File "/home/lenovo/.virtualenvs/gjt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 364, in execute_from_command_line utility.execute() File "/home/lenovo/.virtualenvs/gjt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 356, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/lenovo/.virtualenvs/gjt/local/lib/python2.7/site-packages/django/core/management/base.py", line 283, in run_from_argv self.execute(*args, **cmd_options) File "/home/lenovo/.virtualenvs/gjt/local/lib/python2.7/site-packages/django/core/management/base.py", line 330, in execute output = self.handle(*args, **options) File "/home/lenovo/.virtualenvs/gjt/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 227, in handle self.verbosity, self.interactive, connection.alias, apps=post_migrate_apps, plan=plan, File "/home/lenovo/.virtualenvs/gjt/local/lib/python2.7/site-packages/django/core/management/sql.py", line 53, in emit_post_migrate_signal **kwargs File … -
Django Import Error Module "app1.context_processor" does not define a "songs_list" attribute/class
I have 2 apps in my django project, app1 and app2 app1/views.py def list_view(request): songs = Song.objects.all() context = { 'tracks_list' : songs } return render(request,"app1/list.html",context) I want this list to appear on app2, so I created a file called 'context_processor' inside app1: from .models import Song def songs_list(request): songs = Song.objects.all() return {"songs_list":songs} and inside settings.py I added this to the context_processors: 'app1.context_processor.songs_list', And {{ songs_list }} to the templates In the end I get an Import Error: Module "app1.context_processor" does not define a "songs_list" attribute/class Thank you for any help
