Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
delete using queryset in django is not working
i have one model in my django application, which i used as a foreign key in other models. Below is the screenshot of my model. When i use .delete it is generating an error. Please check below screenshot. I am not able to find why this generating an error. -
How to send a file to a specific directory with FTP?
I want to upload a file to the server. I created a function for that but it saves the main directory. I want to save it a specific directory. My address is api.myaddress.com and I want to upload it to api.myaddress.com/uploads/arms. How can I do it? file_address = ("C:/user/otc/"+pdf.pdf.name) session = ftplib.FTP('api.myaddress.com', ftp_username, ftp_password) file = open(file_address, 'rb') # file to send session.storbinary('STOR '+pdf.pdf.name, file) # send the file file.close() # close file and FTP session.quit() -
Django database queries
I want to change this code to a faster query, response = [] for player in Player.objects.all(): total_earn = Credit.objects.filter(player=player).aggregate(Sum('amount')).get('amount__sum', 0) total_earn += Purchase.objects.filter(player=player).aggregate(Sum('amount')).get('amount__sum', 0) reponse.append([player.id, player.email, player.phone, total_earn]) -
Boto3 AWS python
Need a little help with the boto3 client, I would like to send message to AWS sqs. The flow is, that I will have one parent class with the default settings and two child classes, with unique parameters. (this is because the message is different for two child classes and context as well). I don't understand what need to be include in base class and how to inherit it in child with separate parameters. The message will be sent in JSON. Cant find any answer or similar topics on WEB What I have right now: import boto3 import logging import json from abc import ABC, abstractmethod from rest_framework.renderers import JSONRenderer logger = logging.getLogger(__name__) class BaseQueueController(ABC): """" Base controller for Amazon SQS """ def __init__(self): sqs = boto3.client('sqs', region_name=region, aws_access_key_id=access, aws_secret_access_key=ssecret, endpoint_url=endpoint, ) @abstractmethod def send(self, sqs, body: str, attributes: Dict): try: sqs.send_message( QueueUrl=url, MessageBody=body, MessageAttributes=message_attributes, ) except Exception as e: logger.error(f"Error {e} on trying to send message {sqs}") class TwitterSqs(BaseQueueController): """" SQS child first """ pass class YoutubeSqs(BaseQueueController): """" SQS child second """ pass -
I am try too write to register a user in Django with username where no special character include in the username
here is my forms.py from django import forms from django.forms import fields, models from numpy import not_equal from .models import TextToAudio from django.contrib.auth.forms import UserCreationForm from django.contrib.auth.models import User class TextForm(forms.ModelForm): class Meta: model=TextToAudio fields="all" class SignUpForm(UserCreationForm): username = forms.CharField(required=True , widget=forms.TextInput(attrs={'placeholder': 'username'}),not_equal) first_name = forms.CharField(max_length=30, required=False, help_text='Optional.') last_name = forms.CharField(max_length=30, required=False, help_text='Optional.') email = forms.EmailField(max_length=254, help_text='Required. Inform a valid email address.' , widget=forms.TextInput(attrs={'placeholder': 'xyz@gmail.com'})) password1 = forms.CharField(required=True , widget=forms.PasswordInput(attrs={'placeholder': 'password'})) password2 = forms.CharField(required=True , widget=forms.PasswordInput(attrs={'placeholder': 'confirm password'})) class Meta: model = User fields = ('username', 'first_name', 'last_name', 'email', 'password1', 'password2', ) -
can I grab some specific third api data as an additional property to my django api view?
I have an api view which fetches data from its model. I want this api view to have an additional value from third party api. Here is views.py which grabs all of its model properties. @api_view( ["GET"], ) def bussiness_asset_risk_details(request): res = models.BusinessImpact.objects.all().values( "hierarchy", "business_assets", "asset_name", "vendors", "product", "version", "cpe", "asset_type", "asset_categorization", "_regulations", "asset_risk", ) return Response({"business_impact_details": res}) Here is third party api view fetching a specific values of it's own. @api_view( ["GET"], ) def cve_summery(request, key): r = requests.get( "https://services.nvd.nist.gov/rest/json/cves/1.0?cpeMatchString={}".format( key) ) if r.status_code == 200: result = [] res = r.json().get("result").get("CVE_Items") for rs in res: data = { "VulnID": rs.get("cve").get("CVE_data_meta").get("ID"), "Summery": rs.get("cve").get("description").get("description_data"), "exploitabilityScore": rs.get("impact") .get("baseMetricV2") .get("exploitabilityScore"), "severity": rs.get("impact").get("baseMetricV2").get("severity"), "impactScore": rs.get("impact").get("baseMetricV2").get("impactScore"), } result.append(data) return Response(result) return Response("error happend", r.status_code) The logic here is, I want bussiness_asset_risk_details view to return "severity": rs.get("impact").get("baseMetricV2").get("severity"), from cve_summery view. NB: THE KEY parameter in cve_summery view IS cpe of bussiness_asset_risk_details Thanks. -
How to deploy django app using bitbucket pipelines
I want to deploy my Django app which is dockerized using BitBucket pipelines to AWS EC2 instance. How can I deploy to EC2 using BitBucket pipelines? -
Django : Max retries exceeded with url: /o/token/ [Errno 11001] getaddrinfo failed
Hey guys I'm creating a multi-tenant app using DJANGO TENANTS and DRF I'm trying to create a login api using the following function login api-view @api_view(['POST']) @permission_classes([permissions.AllowAny]) def login(request): restaurant_name = request.POST.get('restaurant_name') email = request.POST.get('email') password = request.POST.get('password') restaurant_schema = restaurant_name if not restaurant_name: restaurant_schema = 'public' domain_name = 'http://localhost:8000/o/token/' else: domain_name = 'http://' + restaurant_name + '.localhost:8000/o/token/' with schema_context(restaurant_schema): # c = Client.objects.get(name='BFC') # return Response(c.reverse(request,'test')) app = Application.objects.first() r = requests.post(domain_name, data={ 'grant_type': 'password', 'username': email, 'password': password, 'client_id': app.client_id, # 'scope': 'read', 'client_secret': app.client_secret, },) return Response(r.json()) But I'm getting this error: HTTPConnectionPool(host='bfc.localhost', port=8000): Max retries exceeded with url: /o/token/ (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001E24200D600>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed')) I have tried to check the connection using: socket.create_connection(('localhost',8000),timeout=2) and socket.create_connection(('bfc.localhost',8000),timeout=2) bfc.localhost cant create a connection yet localhost and also I can access the domain from my browser Additional info: In Postman OAuth 2 section I can get a response with the same fields enter image description here -
Got a `TypeError` when calling `WordsTable.objects.create()`
I am trying to save some data in the database using serializer. I have created a model and a serializer but I get this error when I try to save the data. I have seen many answers but haven't come up with the solution. I get this error:Got a TypeError when calling WordsTable.objects.create(). This may be because you have a writable field on the serializer class that is not a valid argument to WordsTable.objects.create(). You may need to make the field read-only, or override the WordsTableSerializer.create() method to handle this correctly. models.py: class WordsTable(models.Model): session_id = models.IntegerField(db_column='session_ID', blank=True, null=True) # Field name made lowercase. user_id = models.IntegerField(db_column='user_ID', blank=True, null=True) # Field name made lowercase. date = models.DateField(blank=True, null=True, default=datetime.date.today) hour = models.TimeField(blank=True, null=True, default=datetime.date.today) run_label = models.IntegerField(blank=True, null=True) status = models.IntegerField(blank=True, null=True) word1 = models.CharField(max_length=45, blank=True, null=True) word2 = models.CharField(max_length=45, blank=True, null=True) word3 = models.CharField(max_length=45, blank=True, null=True) word4 = models.CharField(max_length=45, blank=True, null=True) word5 = models.CharField(max_length=45, blank=True, null=True) class Meta: db_table = 'words_table' The serializer: class WordsTableSerializer(serializers.ModelSerializer): class Meta: model = WordsTable fields = "__all__" Views.py: #API @api_view(['POST']) def save_words(request): if request.method=="POST": saveserialize=WordsTableSerializer(data=request.data) if saveserialize.is_valid(): saveserialize.save() return Response(saveserialize.data, status=status.HTTP_201_CREATED) return Response(saveserialize.data, status=status.HTTP_400_BAD_REQUEST) What do I have to add? it's the first … -
Migrating from SQLite to MySQL error: django.db.utils.OperationalError: Problem installing fixture
I've migrated to MySQL from SQLite in my Django project. I've changed the DB settings in settings.py, I've exported my data to a JSON file and I've ran migrations to change to the MYSQL DB. I am at the stage to load the data into the new MYSQL DB I used: python manage.py loaddata datadump.json but it came up with the following error: django.db.utils.OperationalError: Problem installing fixture '/home/myuser/djangoproject/djangoproject/datadump.json': Could not load userfiles.File(pk=61): (1054, "Unknown column 'data' in 'field list'") Any ideas on how I can resolve this? -
How to add google analytics to a Django website dashboard?
I have linked my website hosted on heroku to google analytics. I want to display all the analytics on the dashboard of my website. I tried every stack overflow answer but nothing seemed to work for me. Can anyone please help? -
Context has no dynamic value while sending email with send_mail() in django
I am trying to send mail with dynamic valued templates in django, But the parameter context sends nothing to the template tasks.py def send_verification_mail(username,mail): msg_html = render_to_string('templates/email.html', {'context':"value","context2":"value2"}) html=strip_tags(msg_html) send_mail( 'From online store', 'Welcome '+username, 'praveenkumarstream@gmail.com', [mail], html_message=html, fail_silently=False, ) email_template.html <html> <body>To verify click below<br> <button> Verify your account</button> {{context}} {{context2}} </body> </html> -
Strange behaviour when deleting items using Django and React stack applications
I work on a full stack application that is composed of: Django (Django Rest Framework) React PostgreSQL database Redis Celery It is deployed through docker. Whole application works well and has no bugs that cannot be traced. However, when I try to delete Project item from database (this is domain specific), I get error 500 and no specific trace. I figured this bug out on deployed application. While inspecting Networking tab in Developer Tools I found the request and saw 500 return code. However, nothing was returned in returned in Response. However, I think something should have been returned. Code is as such: class ProjectCRUD(GenericAPIView): # [...] def delete(self, request, pk): try: # [...] code that deletes all referenced values and current project except ProtectedError as e: return JsonResponse({ "error": "Project still referenced", "details": str(e) }, status=400) except Exception as e: return JsonResponse({"error": "Wrong project id"}, status=status.HTTP_400_BAD_REQUEST) return JsonResponse({ 'message': f'Project with id {project_id} was deleted successfully!' }, status=status.HTTP_204_NO_CONTENT) # [...] This "Wrong project id" assumption is by all means bad and this will be refactored as soon as this bug is also found. This code makes sure that if exception is raised, it is caught, something is returned with … -
Operation of standard Django view, form and template code to update a model
I am trying to understand how a very regularly used code-form in Django views.py actually works. I see the following (or a variation) used a lot, but I can’t find a line-by-line explanation of how the code works – which I need if I am to use it confidently and modify when needed. I will start with the model then introduce urls.py the view and the form. I will go through the relevant parts of the code. I will consider: The model: #models.py class CC_Questions(models.Model): # defining choices in Model : https://docs.djangoproject.com/en/4.0/ref/models/fields/ personality = [ ('IF','IF'), ('IT','IT'), ('EF','EF'), ('ET','ET'), ] q_text = models.CharField('Question text', max_length=200) #C1_Type = models.CharField('Choice 1 Type', max_length=2) C1_Type = models.CharField(choices=personality, max_length=2) Choice1_text = models.CharField('Choice 1 text', max_length=100) #C2_Type = models.CharField('Choice 2 Type', max_length=2) C2_Type = models.CharField(choices=personality, max_length=2) Choice2_text = models.CharField('Choice 2 text', max_length=100) # def __str__(self): return self.q_text[:20] The url # #urls.py app_name = ‘polls’ urlpatterns = [ ….. # ex: /polls/p2create path('p2create/', p2_views.p2create, name='p2create'), … The view: #views.py from.forms import Anyform # def p2create(request): if request.method == 'POST': form = AnyForm(request.POST) if form.is_valid(): form.save() return redirect('/polls/p2') else: form = AnyForm() context = {'form' : form} return render(request, 'pollapp2/create.html', context) # The form: #forms.py # …. … -
How to show foreign key strings related value in Django Rest Framework
I get responses in foreign key values as shown below image Image is here but I want the response of values in string which Is returned from str method in models file. my models is given below from django.db import models from django.contrib.auth.models import AbstractUser,AbstractBaseUser from .Manager import Custom_Manager # Create your models here. class user_profile(AbstractUser): username = None first_name = models.CharField(max_length=250,blank=True,default='') last_name = models.CharField(max_length=250,blank=True,null=True,default='') email = models.EmailField(verbose_name='email_address', max_length=255, unique=True) address=models.CharField(max_length=250) profile_picture=models.ImageField(upload_to='Profile Pictures', blank=True) objects = Custom_Manager() USERNAME_FIELD = 'email' REQUIRED_FIELDS = [] def __str__(self): return self.email; class Category(models.Model): name=models.CharField(max_length=250,null=True,blank=True) def __str__(self): return self.name; class Services(models.Model): s_name=models.CharField(max_length=255) provider_user=models.ForeignKey('digi_khidmat.user_profile',on_delete=models.CASCADE) category=models.ForeignKey(to='digi_khidmat.Category',on_delete=models.CASCADE ,blank=True,null=True) Services_image=models.ImageField(upload_to='Services', blank=True,null=True) description=models.CharField(max_length=1000,blank=True) services_rate_per_hour=models.IntegerField() def __str__(self): return self.s_name class request_services(models.Model): services = models.ForeignKey(to='digi_khidmat.Services', on_delete=models.CASCADE,related_name="Services") provider_user = models.ForeignKey(to='digi_khidmat.user_profile', on_delete=models.CASCADE,related_name="service_provider") category = models.ForeignKey(to='digi_khidmat.Category', on_delete=models.CASCADE, blank=True, null=True ) request_user = models.ForeignKey(to='digi_khidmat.user_profile', on_delete=models.CASCADE,related_name="request_user") status=models.ForeignKey(to='digi_khidmat.services_status', on_delete=models.CASCADE,related_name="request_user") class services_status(models.Model): status=models.CharField(max_length=10,default='Pending') def __str__(self): return self.status; my Serializer class is below class user_profile_serializer(serializers.ModelSerializer): class Meta: model=user_profile fields='__all__' class Category_serializer(serializers.ModelSerializer): class Meta: model=Category fields='__all__' class Services_serializer(serializers.ModelSerializer): class Meta: model=Services fields='__all__' class Services_status(serializers.ModelSerializer): class Meta: model=services_status fields='__all__' class request_services_serializer(serializers.ModelSerializer): serviese_name=serializers.StringRelatedField(read_only=True) class Meta: model=request_services fields='__all__' when i convert serviese_name=serializers.StringRelatedField(read_only=True) to serviese_name=serializers.StringRelatedField(read_only=True, many=True) it throws the following error ceback (most recent call last): File "C:\Users\Muhammad Arshad\anaconda3\lib\site-packages\django\core\handlers\exception.py", line 47, in inner response = … -
How to write class based testview for Django Channels using unittest module
I am trying to write unittests for my web sockets. I haven't wrote any previously so I am struggling understanding how to write using module unittest python package. This is my consumer: class DepartmentInfoConsumer(JsonWebsocketConsumer): def connect(self): if not self.scope["user"]: raise DenyConnection() self.accept() self.group_name = "test" async_to_sync(self.channel_layer.group_add)(f"department{self.scope['company'].id}", self.channel_name) departmentobject = Department.objects.get(company=self.scope["company"]) self.send_json({"used_id": departmentobject.my_id}) def disconnect(self, close_code): async_to_sync(self.channel_layer.group_discard)(f"department{self.scope['company'].id}", self.channel_name) raise StopConsumer() def used_id_info(self, event): self.send_json({"used_id": event["used_id"]}) MY URL: websocket_urlpatterns = [ re_path("bill/", consumers. DepartmentInfoConsumer.as_asgi(), name="billing-ws"), ] -
django error with postgresql database on real host
this is my first python programe to run on server and i have error in database connection. when i add this line to setting file DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'rahepooy_afsoone_db', 'USER': 'rahepooy_afsoone', 'PASSWORD': '****************', } } and migrate the code i have error : psycopg2.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? if i add "hoset':'IP' to setting.py i have this error : psycopg2.errors.UndefinedColumn: column c.relispartition does not exist LINE 3: CASE WHEN c.relispartition THEN 'p' WHEN c.relki... where is my mistake!? and this project is on real host on internet -
Can anyone help me,when i send mail through django send mail i am getting errors,if i send mail without deploy then it working [closed]
but if i send without deploy , it's working 1: enter image description herehttps://i.stack.imgur.com/AhOTz.jpg*emphasized text* -
I want to print my data on html that is stored in excel sheet(xlsx), actually i am getting output but it is not in a proper way . please check code
Views.py info = [] def get_info(request): r1 = pd.read_excel('file_data.xlsx') for index, row in r1.iterrows(): if row["USER NAME"] == str(user_name()): info.append(row) #name = row['USER NAME'] #date = row['DATE'] #file_name = row['FILE NAME'] #remarks = row['REMARKS'] return render(request,'files.html',{'info':info}) #return render(request,'files.html',{'name':name, 'date':date, 'file_name':file_name, 'remarks':remarks, 'info':info}) output enter image description here I need to print data in corresponding fields but it coming only in single field in list format. -
What queryset should I do to select all One-to-one relations that are broken?
I have this 2 models : class Asset(models.Model): created = models.DateTimeField(auto_now_add=True) modified = models.DateTimeField(auto_now=True) ... some other fields ... class AssetConstructorData(models.Model): asset = models.OneToOneField( Asset, on_delete=models.CASCADE, primary_key=True, related_name='constructor_data', ) ... some other fields ... For some historical reason, I have some One-to-one which are broken : some AssetConstructorData object has not their corresponding Asset object. I would like to delete all AssetConstructorData objects that are broken. Actually I have done : for cd in AssetConstructorData.objects.all(): try: cd.asset except Asset.DoesNotExist: cd.delete() Which is definitively not optimized : Is that possible to make a queryset that selects all broken relations ? I tried with .filter(asset=None) and .filter(asset__isnull=True) but it does not work. -
Getting issue while edit record in Django Form
I Everyone i am getting issue while edit record based on problem id, only problem record show automatically chatquestion and option record not show automatically, maybe my ORM is wrong somewhere, please help me out. this is crud operation i have done list and add record but that is also complex if anyone can do simple its more helpful for me.. Thanyou. models.py -this is all 3 models. class Problem(models.Model): Language = models.IntegerField(choices=Language_CHOICE, default=1) type = models.CharField(max_length=500, null=True, blank=True) def __str__(self): return self.type class ChatQuestion(models.Model): question = RichTextField(null=True, blank=True) problem_id = models.ForeignKey( Problem, models.CASCADE, verbose_name='Problem', ) sub_problem_id = models.ForeignKey( SubProblem, models.CASCADE, verbose_name='Sub Problem', null=True, blank=True ) def __str__(self): return self.question class Option(models.Model): option_type = models.CharField(max_length=250, null=True, blank=True) question_id = models.ForeignKey( ChatQuestion, models.CASCADE, verbose_name='Question', ) problem=models.ForeignKey( Problem, models.CASCADE, verbose_name='Problem', null=True, blank=True ) next_question_id = models.ForeignKey(ChatQuestion, on_delete=models.CASCADE, null=True, blank=True, related_name='next_question') forms.py class Editchatbot(forms.Form): problem=forms.ModelChoiceField(queryset=Problem.objects.all(), required=True, widget=forms.Select(attrs={'class': 'form-control select2'})) question=forms.ModelChoiceField(queryset=ChatQuestion.objects.all(), required=True, widget=forms.Select(attrs={'class': 'form-control select2'})) option=forms.ModelChoiceField(queryset=Option.objects.all(), required=True, widget=forms.Select(attrs={'class': 'form-control select2'})) class Meta: fields=['problem','question','option'] views.py def edit_chatbot(request,id=None): problem=Problem.objects.get(pk=id) question=ChatQuestion.objects.filter(problem_id=id) option=Option.objects.filter(question_id=id) if request.method == 'POST': form = Editchatbot(request.POST) if form.is_valid(): problem=form.changed_data['problem'] question=form.changed_data['question'] option=form.changed_data['option'] form.save() messages.success(request,'successfully!') return redirect('/fleet/chatbot_list') else: messages.error(request,'Please correct following',form.errors) else: form = Editchatbot(initial={'problem':problem,'question':question,'option':option}) context = { 'menu_management': 'active', 'chatbot': 'active', 'form': form, 'question':question, 'option':option … -
Python pipenv failts to install libraries?
My pipenv environment refuses to install various python libraries, citing a problem with the ssl certificate, any solutions out there? Here is the error message: PS C:\Users\NAME\OneDrive\Documents\GitHub\mainsite> pipenv install django Installing django... Error: An error occurred while installing django! Error text: Could not fetch URL https://pypi.org/simple/django/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.org', port=443): Max retries exceeded with url: /simple/django/ (Caused by SSLError("Can't connect to HTTPS URL because the SSL module is not available.")) - skipping WARNING: pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available. WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError("Can't connect to HTTPS URL because the SSL module is not available.")': /simple/django/ WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError("Can't connect to HTTPS URL because the SSL module is not available.")': /simple/django/ WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError("Can't connect to HTTPS URL because the SSL module is not available.")': /simple/django/ WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError("Can't connect to HTTPS URL because the SSL module is not available.")': /simple/django/ WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after … -
Django-Tenants causes App_model does not exist with functional pytest
I have been trying to do this using functional test approach not class test class based approach: class SomeTest(TenantTestCase): def setup(): super().setup() def test_some_do_something(): #... test_code def test_some_do_something_again(): #... test_code_again The above class based approach works well since it can easily create a tenant based on TenantTestCase but then when try to replicate the above in normal functions., I face difficulties , another reason is I am using pytest for my test and pytest works better with Normal Functional test approach than Class test approach Function approach: def test_some_thing_using_functional_test_approach(): # .. some assertion code #The above causes error the app_model relation does not not exist . This is because they live in schemas and therefore how do I ensure the tenant is created first and accessed in a functional test approach to avoid this issue -
How to use model functions in Views for multiple instances in Django?
I have a Blog Post Model and I have defined a function to calculate the no of likes. The Model is as follows -> class Post(models.Model): user = models.ForeignKey(User, on_delete=models.PROTECT) title = models.CharField(max_length=255) description = models.CharField(max_length=1000,null=True) Tags = models.CharField(max_length = 255,null=True,blank=True) Created_date = models.DateTimeField(auto_now_add=True) Updated_date = models.DateTimeField(auto_now=True) category = models.ForeignKey(Category, on_delete=models.PROTECT) Likes = models.ManyToManyField(to=User, related_name='Post_likes') def __str__(self): return self.title def likesCount(self): return self.Likes.count() Now I am querying the Post Model from the DB to get all the Posts as follows -> posts = Post.objects.select_related().prefetch_related('images_set','comments_post').annotate(Count('comments_post')).all() Here when I loop over the posts I can call the likesCount function and it gives me the correct result as well but I want to return the No of likes to the template. How can I do that? -
React vs Django : Which framework shall I learn
I am front end developer[React]. I also want to learn the backend. I am confused due to contradictory statement in different blogs etc. Some says that node may be out of date after some time. So says node is better to learn than Django. Can someone help me by providing the authentic information. So learn the framework. Thanks in advance.
