Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
POSTing foreign keys to Django Rest Framework, using Postman
So I've made a simple REST API for the company I work for. This is a side project, so I'm still learning a lot. So far it works nicely for GET requests. The problem I'm facing now is trying to do POST requests (Using Postman for now, the idea is to connect the API straight to a sensor that broadcasts JSON data and upload all that data to our DB through the API). The way we have set up the models, there are several ForeignKey relationships in our DB (we are using PostgreSQL if that makes a difference). I'm trying to POST one of our most basic bits of information, but arguably the most important which is measurement data. The model for a data point has a ForeignKey to a parameter, and a sensor. A parameter would be a model that has a parameter name, type, position, and a sensor would be another model that itself has a ForeignKey to a Chamber (another model that also includes it's own ForeignKeys, to Customers), and another ForeignKey to SensorType. In short, for relationships, data relates to parameter, and sensor (which relates to SensorType, and to Chamber which itself relates to Customer which … -
Django How can I render Images through a for loop
I uploaded images with admin, but cannot render them in the template. I've been looking at other questions but nothing is working. What am I missing? Settings.py STATIC_URL = '/static/' STATIC_DIRS = { os.path.join(BASE_DIR, "static"), } MEDIA_URL = '/media/' MEDIA_ROOT = os.path.join(BASE_DIR, 'media') Models.py class Function(models.Model): name = models.CharField(max_length=50) fimage = models.ImageField(upload_to="images") def __unicode__(self): return "name{},id{}".format(self.name, self.id) HTML {% for function in functions %} <a href="function_page/{{function.id}}"> <img id=function_menu_pic src="{{MEDIA_URL}}{{function.fimage.url}}"></a> {% endfor %} -
Django-filter and Django-tables2 Using a foreign attribute
I've read through previous questions, and tried reading up in the docs but I've had no real luck with this. I'm using Django-tables2 in conjunction with Django-filter to display and filter data of students. Question 1: Table ordering One of the columns in the table (current standing) is populated using an accessor to a model manager in the student model, as follows: models.py class Student(models.Model): #a bunch of fields def get_current_standing(self): current_standing = AcademicStanding.objects.get(year=self.enrol_term, student=self).standing return current_standing tables.py class StudentTable(tables.Table): current_standing = tables.Column(accessor='get_current_standing') class Meta: model = Student fields = ["last_name", "first_name", "campus_id", "current_standing"] The table populates and displays correctly, but sorting by generates an error. I can adjust the Column as follows: current_standing = tables.Column(accessor='get_current_standing', order_by='academicstanding.standing') But because the relationship is 1:N I get multiple results, where (as shown by the manager in the students model), I only want the academic standing for a student for that particular year of enrolment. This method also doesn't group the entries according to the standing. Question 2: Django-filter I now wish to be able to filter by current_standing, too. filters.py class StudentFilter(django_filters.FilterSet): qset = AcademicStanding.objects.order_by('standing').values_list('standing', flat=True).distinct() l = [(t, t) for t in qset] current_standing = django_filters.ChoiceFilter(choices=l) class Meta: model = Student … -
Filter a table based on other two tables Django OMR
I have a table with fields email and department_name, another table named Department with a dept_name and a user table. Department table have a manytomany relation to user table. I need to filter first table with departments having user with email columns. Is there anyway to do this in a single query. My query may look like TempUser.objects.filter(email__in=Department.objects.filter(dept_name="department name from first table").users.value_list('email', flat=True) -
Function's url staying after a new render
I have just started learning Django after completing the tutorial on their website and I am trying to get my Django website's form to render a template with a dictionary describing the "login_error" variable after a login attempt has failed. This works fine but the URL still contains the view functions name and I don't want this. Redirecting the page to itself works fine but then I cannot define the "login_error" variable. The URL to start the views login function: path('login_user', views.login_user, name='login_user'), If the login fails I am re-rendering the page like so: return render(request, 'sign_in/sign-in.html', { 'login_error': "We couldn't find an account with that email and/or password." }) Here is what I am using to navigate to this function: <form class="sign_in" method="post" action="{% url 'sign-in:login_user' %}"> Here are some images to help explain what's happening: I submit a bad login: This is the part of the URL stays after the render: Any advice, links or resources to direct me in the way of a solution would be highly appreciated as I have been searching for hours now and still can't find anything related to this issue, thanks! -
django: trying to organize clean_data functions, and validators. Where does each thing go?
I am trying to find the way to organize code snippets the right way but I am getting mixed up with all this: I have the models.py where I have declared (show part of the fields) this class Posts(models.Model): image = models.ImageField(upload_to=user_directory_path, null=True, blank = True) Then I want to sanitize that field just in case someone wants to be funny in the form page. So I went to forms.py and created a custom method to clean it class PostsForm(ModelForm): class Meta: model = Posts fields = ['image' , 'otherfields'] def clean_image(self): image = self.cleaned_data['image'] Ok that cleans it, but I need more, like making sure they dont upload a file too large. So I thought I could create a directory in templates/validators and create a file like validators.py where I write my validation functions and then I can import that function. So. validators.py from django.core.exceptions import ValidationError def file_size(value): limit = 2 * 100 * 100 if value.size > limit: raise ValidationError('File too large. Should be less than 200 Kbs') so when I am in the forms.py I wanted to import that file validators.py like this from myaapp.validators import file_size but it tells me that it doesn't know what … -
Django Migration is not apply new migrations
I tried to make new migrations but show me error. I am using django1.9 and python 2.7 .Is any solution for this so i can create new migration.How can I do the migration? django.db.utils.IntegrityError: could not create unique index "appointments_userappointments_advance_c37857a7_uniq" DETAIL: Key (advance, status)=(5000, 3) is duplicated. Here is my model: class UserAppointments(models.Model): """ Represent an Appointment entity """ STATUS = ( ("1", 'Scheduled'), ("2", 'Active'), ("3", 'Completed'), ("4", 'Cancelled') ) customer = models.ForeignKey(Customer, null=True, blank=True) staff_user = models.ForeignKey(StaffUser, null=True, blank=True, related_name='staff_user') service = models.ForeignKey(Service, null=True, blank=True) advance = models.IntegerField(default=0, null=True, blank=True) date_time = models.DateTimeField(auto_now_add=True) creation_date = models.DateTimeField(auto_now=True) created_by = models.ForeignKey(StaffUser, null=True, blank=True, related_name='created_by') update_date = models.DateTimeField(auto_now=True, null=True, blank=True) updated_by = models.ForeignKey(StaffUser, null=True, blank=True, related_name='updated_by') status = models.CharField(max_length=1, default=1, choices=STATUS) class Meta: verbose_name_plural = 'Appointments' ordering = ['date_time'] def __unicode__(self): return self.date_time.strftime("%Y-%m-%d %H:%M:%S") and my migration file: from __future__ import unicode_literals from django.db import migrations class Migration(migrations.Migration): dependencies = [ ('appointments', '0009_auto_20180114_1838'), ] operations = [ migrations.AlterModelOptions( name='userappointments', options={'ordering': ['advance'], 'verbose_name_plural': 'Appointments'}, ), migrations.AlterUniqueTogether( name='userappointments', unique_together=set([('advance', 'status')]), ), ] -
Django ManyToManyField Storing None objects
I am trying to create an audit app in which a model contains all the questions, answers in form of choices and comments class AuditQuestion(models.Model): NOT_INITIATED = 'NI' IN_PROCESS = 'IP' COMPELETED = 'C' STATUS = ( (NOT_INITIATED, 'Not Initiated'), (IN_PROCESS, 'In Process'), (COMPELETED, 'Completed'), ) type_of_room = models.ForeignKey(TypeOfRoom, null=True, blank=True) question = models.CharField(max_length=512) status = models.CharField(max_length=2, choices=STATUS, default=NOT_INITIATED) comments = models.TextField(null=True, blank=True) def __str__(self): return self.question Another model contains project status which contains details of the project such as location, project_name, user and floor no of the building class ProjectStatus(models.Model): floor_no = models.IntegerField(null=True) project_details = models.ForeignKey(ProjectDetails, null=True) question = models.ManyToManyField(AuditQuestion, null=True) def __str__(self): return str(self.floor_no) The logic goes like this... a new project is created using ProjectDetails model, and a project status is generated for every floor of the building. and each floor is to be audited against the questions present in AuditQuestion model and status and comments are to be registered. I used ManyToMany relation so that project status model can have multiple questions and their status and comments. But, when i try to save question it doesn't happen my view.py function is below: @login_required def save_question(request): project_status_id = request.POST.get('project_status_id') question_id = request.POST.get('question_id') status = request.POST.get('status') comments = … -
Request CSRF + Access-Control-Allow-Headers
Im developing an application with two core. Client Side with ReactJs and a Server Side made with Django. The Client will makes a lot of GET/POST request to the server. To prevent CSRF problem, every Ajax Request has CSRF-TOKEN. beforeSend: function (xhr, settings) { if (!csrfSafeMethod(settings.type) && !this.crossDomain) { xhr.setRequestHeader("X-CSRFToken", window.csrftoken); } [...] } This is a piece of the Django/Python view view example of the server: response = HttpResponse(json.dumps(software_settings), content_type="application/json" ) response['Access-Control-Allow-Origin'] = "*"; response['Access-Control-Allow-Headers'] = "X-Requested-With, X-Prototype-Version, X-CSRF-Token"; response['Access-Control-Allow-Methods'] = "POST, GET, OPTIONS"; I have two big problems: FIRST: On online solutions, window.csrftoken variables is usually taken from cookie. I sincerely don't know how to create it. Im using unversal-cookie to read and write cookie with React, but I missing the correct data flow between the two applications. The default values is "null" so the first call has null as CRFT Token; SECOND: I have a problem with response. As see above, I've tried to put a lot of configurations entry fro Access-Control. This is a piece of request headers: Access-Control-Request-Headers:x-csrftoken Access-Control-Request-Method:POST Connection:keep-alive Host:localhost:8000 Origin:http://localhost:3000 This is the error I get: Failed to load http://localhost:8000/get_software_settings/: Request header field X-CSRFToken is not allowed by Access-Control-Allow-Headers in preflight response. I … -
standalone applications should use blank.html as redirect_uri to access messages
I use django 1.11 and django-allauth for autentification. I'm all set up and everything works. Then I tried to write a message on the social network vkontakte. I take token connected vk-account from allauth access_token = SocialToken.objects.filter(account__user=request.user, account__provider='vk') then i install api-library for vk. pip install vk Then I tried to write in vk. access_token = SocialToken.objects.filter(account__user=request.user, account__provider='vk') session = vk.Session(access_token=access_token) api = vk.API(session, scope=['offline', 'messages']) api.wall.post(message='Hello, World!') I got an scope error about insufficient rights. I added in scopthe necessary rights. class VKProvider(OAuth2Provider): id = 'vk' name = 'VK' account_class = VKAccount def get_default_scope(self): scope = ['groups', 'notify ', 'friends', 'photos', 'audio', 'video', 'pages', '+256', 'status', 'notes', 'wall', 'ads', 'wall', 'offline', 'ads', 'docs', 'notifications', 'stats', 'email', 'market', 'messages',] if app_settings.QUERY_EMAIL: scope.append('email') return scope def extract_uid(self, data): return str(data['uid']) def extract_common_fields(self, data): return dict(email=data.get('email'), last_name=data.get('last_name'), username=data.get('screen_name'), first_name=data.get('first_name')) Но после этого я получил еще одну ошибку. {"error":"invalid_scope","error_description":"standalone applications should use blank.html as redirect_uri to access messages"} I sometimes don't understand what's going on? Could you help me to understand? -
How to get user queryset who commented to certain post in Python, Django?
I would like to get a user queryset who commented in certain post. Assume that there is a post(id=3), and there 8 people commented on it. I want to notify something to 8 people, so I want to get 8 people's queryset(user objects). How can I do it? I have model User, Post, and Comment. For example, User.objects.get(comment__Post.objects.filter(id='3')) like this way. (of course, the upper doesn't work) Help me! -
AttributeError when I import model from another app
I don't know why but I got an error: AttributeError: module 'downloads.models' has no attribute 'AbstractDownload' in this place: class Download(models_downloads.AbstractDownload): In download app I have already AbstractDownload class Here is my model from products products/models.py from downloads import models as models_downloads class Download(models_downloads.AbstractDownload): product = models.ForeignKey('products.Product', related_name='downloads') file = FilerFileField(related_name="file_products_download") Here is downloads models downloads/models.py class AbstractDownload(models.Model): title = models.CharField(max_length=500) subtitle = models.CharField(max_length=1000, blank=True) file = FilerFileField(related_name="file_abstract_download") order = models.PositiveIntegerField(default=0) class Meta: abstract = True def __str__(self): return self.title -
There is a django AUTHORIZATION module?
I have already a django project, which does the users authentication. Now I nedd an authorization module (for clients and groups to certain resources). I would an existing django module or api. thanks -
How to insert data on a table using a form?
I want to POST a message to the Message table in my db, wich contains the following fields: id; body; normaluser; chat.html: <form method="post" id="msg"> <div class="form-group"> <label for="comment">Message:</label> <textarea class="form-control" rows="5" id="comment"></textarea> </div> {% csrf_token %} {{ form.as_p }} <button type="submit">Enter</button> </form> views.py @login_required def msg(request): if request.method == 'POST': form = UserCreationForm(request.POST) if form.is_valid(): form.save() body = form.cleaned_data.get('body') raw_password = form.cleaned_data.get('password1') user = authenticate(username=username, password=raw_password) Message(request, user) else: form = 'msg' args = {'form': form} return render(request, 'accounts/chat.html', args) I am basing my view from the def I use to make a new user. But I'm not understanding how to change it to accept a message, wich also receives the info of the user authenticated at the time he sends the message. -
Django Python: How to convert datetime.time(2, 3) to String format H:M:S
In my Django models I have a models.TimeField to store time. When doing model.objects.filter().values() my TimeField gets return as datetime.time(2,3) for example. I want to return it as a string. In this case since the time is AM my string should look like 2:03:00 AM or if PM then 2:03:00 PM. It could also be formatted as a 24-hour format. How do I do that? -
What is the proper regular expression for uid in base64 and token in Python?
In Django 2.0, I deal with uid and token for user email confirmation. 'uid': urlsafe_base64_encode(force_bytes(user.pk)), 'token': PasswordResetTokenGenerator().make_token(user), My urlpatterns is like below, however pattern is not found urlpatterns = [ re_path(r'^confirm/(?P<uidb64>[0-9A-Za-z_\-]+)/' '(?P<token>[0-9A-Za-z]{1,13}-[0-9A-Za-z]{1,20})/$', confirm_user_email, name='confirm-user-email'), ] the error message is like this, Reverse for 'confirm-user-email' with keyword arguments '{'uidb64': b'Mw', 'token': '4t9-a61218655569c14203b8'}' not found. 1 pattern(s) tried: ['member\/confirm/(?P[0-9A-Za-z_\-]+)/(?P[0-9A-Za-z]{1,13}-[0-9A-Za-z]{1,20})/$'] -
Dictionary Errors with Django Intermediate Model
I have three tables. Table A, B, and C. I have a form where the user can select choices from each table. I need to save the relationship between Tables A & C and the relationship between Tables B & C. The relationships between Tables B&C are saving fine(AssignmentManager). However, the relationships between Tables A & C are not. They are linked through an intermediary model. I'm trying to follow the documentation examples, but I don't know if I'm interpreting them right. https://docs.djangoproject.com/en/dev/topics/db/models/#intermediary-manytomany I keep getting one error after another. The latest one is a multi key dictionary error. The intermediary manager for Tables A and C is the FunctionAssignmentManager. Models.py class AssignmentManager(models.Manager): def relationship (self, Role_id, Assignment_title): select = Assignment.objects.get (id= Assignement_title) roles = Role.objects.get(id=Role_id) select.role.add(roles) select.save class FunctionAssignmentManager(models.Manager): def functionA (self,postData): newrel = FunctionAssignment.objects.create( function = ['function'], assignment = ['assignment'] ) newrel.save() class Function(models.Model): name = models.CharField(max_length=50) image = models.ImageField(upload_to="images") objects = FunctionManager() class Role(models.Model): level = models.CharField(max_length=255) function = models.ForeignKey(Function, related_name="roles") objects = RoleManager() class Assignment(models.Model): function = models.ManyToManyField(Function, through='assignments') role = models.ManyToManyField(Role, related_name='assignments') title = models.CharField(max_length=255) definition = models.TextField() objects = AssignmentManager() class FunctionAssignment(models.Model): function = models.ForeignKey(Function, on_delete=models.CASCADE) assignment = models.ForeignKey(Role, on_delete=models.CASCADE) review= models.TextField() objects = … -
Generic detail view ProfileView must be called with either an object pk or a slug
I'm new to Django 2.0 and i'm getting this error when visiting my profile page view. It's working with urls like path('users/<int:id>') but i wanted to urls be like path('<username>'). Not sure what exactly is the problem. I hope you can help. #views.py class ProfileView(views.LoginRequiredMixin, generic.DetailView): model = models.User template_name = 'accounts/profile.html' #urls.py urlpatterns = [ path('', HomePageView.as_view(), name='home'), path('signup', SignUpView.as_view(), name='signup'), path('login', LoginView.as_view(), name='login'), path('logout', logout_view, name='logout'), path('<username>', ProfileView.as_view(), name='profile') ] #base.html <ul class="dropdown-menu"> <li><a href="{% url 'accounts:profile' user.username %}">View Profile</a></li> <li><a href="#">Edit Profile</a></li> </ul> -
porting an app built using Tornado framework to Django framework
I have an app that was developed using Tornado framework and Angularjs. the app is basically a game with two type of users a moderator and players. the moderator and players exchange data in "real time" and a graph is updated based on their input. I am a decent coder but new to web development and this is just an in case question. Since the app has some issues, and since I will have to learn a framework anyway, I would rather learn Django. I was wondering if there is a resource out there that makes the conversion easier? What I am looking for is advice on how to tackle this in a way where I don't have to go through the documentation of both frameworks before I can do anything useful. Ideally, I'd like to incrementally learn more about both frameworks as I make meaningful edits to the app. -
Django ignores test database settings
I have an app deployed on pythonanywhere which runs fine. Problem is that when I want to run test django, my test database settings is completely ignored. Each time I run test I get the following message.though. Creating test database for alias 'default'... Got an error creating the test database: (1044, "Access denied for user 'funnshopp'@'%' to database 'test_funnshopp$funn'") Database name for the app is funnshopp$funn. It can be seen that django somehow always tries to create the test database by appending test_ to the database name. Never minding what I have in DATABASES settings Below is my full settings file ( Test runs fine on my PC and I am using Django 2.0, though I started the project with Django 1.11) """ Django settings for funnshopp project. Generated by 'django-admin startproject' using Django 1.11.7. For more information on this file, see https://docs.djangoproject.com/en/1.11/topics/settings/ For the full list of settings and their values, see https://docs.djangoproject.com/en/1.11/ref/settings/ """ import os from django.urls import reverse_lazy from django.core.exceptions import ImproperlyConfigured # Build paths inside the project like this: os.path.join(BASE_DIR, ...) BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) def get_env_variable(var_name): """Get the environment variable or return exception""" try: return os.environ[var_name] except KeyError: error_msg = "Set the {} environment variable".format(var_name) raise … -
I don`t know what means None in django user
class MemberStaffManager(BaseUserManager): def create_user(self, staff_id, company, position, name, password=None): user = self.model( staff_id=staff_id, company=company, name=name, position=position, ) user.set_password(password) user.save(using=self._db) return user Now I'm studying Django custom user but I don't know what means password=None maybe not mean password = null because user.set_password(password) is send password-value please help me. -
ModuleNotFoundError at /polls/register/
I am creating a registration form in django. My project name is FirstProj containing mysite and mysite containing polls. My forms.py is this from django import forms from django.contrib.auth.models import User from django.contrib.auth.forms import UserCreationForm class RegistrationForm(UserCreationForm): email= forms.EmailField(required = True) class Meta: model = User fields = { 'username', 'first_name', 'last_name', 'email', 'password1', 'password2' } def save(self, commit=True): user = super(RegistrationForm, self).save(commit=False) user.first_name = cleaned_data['first_name'] user.last_name = cleaned_data['last_name'] user.email = cleaned_data['email'] if commit: user.save() return user My views.py is this from mysite.polls.forms import RegistrationForm from django.shortcuts import render,redirect def register(request): if request.method == 'POST': form = RegistrationForm(request.POST) if form.is_valid(): form.save() return redirect('/polls') else: form = RegistrationForm() args = {'form': form} return render(request, 'polls/reg_form.html', args) However my cleaned_data() can't be read and i am getting the following erro. No module named 'mysite.polls' -
How to insert multiple Django blocks into one template?
I am trying to use more different views in one template via different blocks or include method but I have got stuck. My aim is to implement my different views into one template. I tried to more solution but these haven't worked for me. I show these solution: My views: def dashboard_data(request): # Here I collect data from my PostgreSQL database I push these into #Objects and I send it to my test_a.html via render like below. return render(request, 'my_project/test_a.html', send_data) def chart_data(request): #In these view my final goal is to collect data from database and create #charts but for the simplicity I just use a list (a=[1,2,3,4]) and I #push it to the test_b.html and I render it. render(request, 'my_project/test_b.html', send_data)) My templates: 1, base.html <!DOCTYPE html> <html lang="en"> <head> {% block title %}<title>My project</title>{% endblock %} <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Include CSS files --> {% load static %} <!-- Include CSS files --> <link rel="stylesheet" href="{% static 'css/bootstrap.css' %}"> <link rel="stylesheet" href="{% static 'css/bootstrap.min.css' %}"> <link rel="stylesheet" href="{% static 'css/bootstrap-table.css' %}"> <link rel="stylesheet" href="{% static 'css/styles.css' %}"> <link rel="stylesheet" href="{% static 'css/font-awesome.min.css' %}"> </head> <body> {% block sidebar %} {% endblock %} {% block content%} … -
Django create form wizard from model form
My requirement is to create a form wizard using model form. For example, I have a number of dynamic models, one model has 10 fields and another model have 15 fields. the model form should be split into multiple forms automatically based on fields it contains. I have tried using django-form-tools, but in django-form-tools we need to predefine the form classes in form_list attribute. Is there any other alternative to achieve this without manually doing this -
django project multiple user use the same project
I am new to django and web programming. Right now, I have created a django project for configuration form generation. It allows the user to input the values and generate a configuration form once the user got the URL. Project name: portal, App name: home, input_data.txt: a text file stored the values for the corresponding parameter and it will be read for further processing It works fine for myself, but multiple users use it at the same time. It doesn't work. what can I do in order to allow multiple users use it at the sam time?
