Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Raise error if the input is False (Boolean) while uploading excel sheet via Django Form
I have a Django form through which I am uploading an excel sheet to Database, Here, some columns have boolean fields (True/False). In such fields (e.g. block_covered, village_covered etc) , I want to raise an error such as: "This field can not be false", whenever the field value is False(0), so that it only takes the value which are True(1) and ignore the user/myself to give false boolean value as input in excel sheet while uploading i.e. prevent them from uploading the sheet. The related files are as below. Model.py BOOL_CHOICES = ((True, 'Yes'), (False, 'No')) UNIT_CATEGORIES = (('ABC', 'ABC'), ('XYZ', 'XYZ')) class GroupDetail(models.Model): unit_type = models.CharField(max_length=16, choices=UNIT_CATEGORIES) state_name = models.CharField(max_length=100) unit_name = models.CharField(max_length=100) districts_covered = models.BooleanField(verbose_name=_('Districts Covered "yes/no"'), choices=BOOL_CHOICES) block_name = models.CharField(max_length=100) block_covered = models.BooleanField(verbose_name=_('Block Covered "yes/no"'), choices=BOOL_CHOICES) village_name = models.CharField(max_length=100) village_covered = models.BooleanField(verbose_name=_('Village Covered "yes/no"'), choices=BOOL_CHOICES) number_of_group = models.PositiveIntegerField(validators=[MinValueValidator(1), MaxValueValidator(100)]) number_of_farmers = models.PositiveIntegerField(validators=[MinValueValidator(1), MaxValueValidator(1000)]) Form.py class add_to_database(forms.ModelForm): class Meta: model = GroupDetail fields = ["unit_type", "state_name", "unit_name", "district_name", "districts_covered ", "block_name", "block_covered", "village_name", "village_covered", "number_of_group", "number_of_farmers"] labels = { "unit_type":"Unit Type", "state_name":"State Name", "unit_name":"Unit Name", "district_name":"District Name", "districts_covered":"Districts Covered (Yes/No)", "block_name":"Block Name", "block_covered":"Block Covered (Yes/No)", "village_name":"Village Name", "village_covered":"Village Covered (Yes/No)", "number_of_group":"Number of groups", "number_of_farmers":"Number of farmers"} widgets = … -
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc4 in position 1: ordinal not in range(128)
So, as title of the questions says, I have a problem with encoding/decoding of strings. I am using: python 2.7 | django 1.11 | jinja2 2.8 Basically, I am retrieving some data from data base, I serialize it, set cache on it, then get the cache, deserialize it and rendering it to the template. Problem: I have first names and last names of persons that have characters like "ă" in the names. I serialize using json.dumps. A sample of serialized dictionary looks like (I have 10 like this): active_agents = User.region_objects.get_active_agents() agents_by_commission_last_month = active_agents.values(.... "first_name", "last_name").order_by( '-total_paid_transaction_value_last_month') Then, when I set the cache I do it like: for key, value in context.items(): ...... value = json.dumps(list(value), default=str, ensure_ascii=False).encode('utf-8') , where value is the list of dictionaries returned by .values() from the aforementioned code and key is region_agents_by_commission_last_month (like the variable from the previous code) Now, I have to get the cache. So I am doing the same process, but reversed. serialized_keys = ['agencies_by_commission_last_month', 'region_agents_by_commission_last_month', 'region_agents_by_commission_last_12_months', 'region_agents_by_commission_last_30_days', 'agencies_by_commission_last_year', 'agencies_by_commission_last_12_months', 'agencies_by_commission_last_30_days', 'region_agents_by_commission_last_year', 'agency', 'for_agent'] context = {} for key, value in region_ranking_cache.items(): if key in serialized_keys: objects = json.loads(value, object_hook=_decode_dict) for serilized_dict in objects: .... d['full_name'] = d['first_name'] + " " + … -
AttributeError: '_io.BufferedWriter' object has no attribute 'save'
I am trying to save the following file Here is the model: class someModel(models.Model): someFile = models.FileField(storage=someModule(), blank=True) Here is how I create the file I want to save: flat_array = array.flatten(order="F") with open(filename, "wb") as some_transformed_file: some_transformed_file.write(struct.pack(">i", 192837465)) some_transformed_file.write(flat_array[i].real) return some_transformed_file Here is the saving part: doc_io = BytesIO() some_transformed_file.save(doc_io) some_file_object = File(doc_io, filename=os.path.basename(name)) item = someModel.objects.create(someFile=some_file_object ) I get the error AttributeError: '_io.BufferedWriter' object has no attribute 'save' -
Hi dear community I'm new to django and right now I want encrypt and decrypt the model field and save in database [closed]
Hi friends I want to encrypt the subject field and store in the database and again want decrypt the same field only when required. But as I new here I'm not getting exactly how to that can u please help me with this coading part...? If anyone knows the answer can u please send me the full code which u already apllies and works fine...Please help me with this friends asap...Thanking u all.... -----------models.py from smtplib import SMTP_PORT from django.db import models from encrypted_model_fields.fields import EncryptedCharField # from django_cryptography.fields import encrypt from cryptography.fernet import Fernet class WarmupEmail(models.Model): user_email=models.EmailField(max_length=150,default="") password= models.CharField(max_length=50) SMTP_PORT=models.CharField(max_length=150,default="") password=EncryptedCharField(max_length=100) SMTP_HOST=models.CharField(max_length=150,default="") Is_Active=models.BooleanField(default=False) subject=models.CharField(max_length=200,default="") ### this field want to encrypt Body=models.CharField(max_length=1000,default="") def __str__(self) : return self.user_email class Recipient(models.Model): user_email=models.EmailField(max_length=150,default="") password=models.CharField(max_length=50) SMTP_PORT=models.CharField(max_length=150,default="") SMTP_HOST=models.CharField(max_length=150,default="") Is_Active=models.BooleanField(default=False) Reply_msg=models.CharField(max_length=200,default="") Reply_Body=models.CharField(max_length=1000,default="") def __str__(self) : return self.user_email ----------serializers.py from rest_framework import serializers from .models import * class WarmupEmail_Serializer(serializers.ModelSerializer): class Meta: model = WarmupEmail fields = '__all__' class Recipient_Serializer(serializers.ModelSerializer): class Meta: model = Recipient fields = '__all__' -
Can't upload Picture in Django by user
I could upload pictures by the user, please help me to solve my problem. view.py def Detail(request, orid): data = cartData(request) cartItems = data['cartItems'] name = request.user.profile form = Uplaodpic(instance=name) if request.method == 'POST': form = Uplaodpic(request.POST, request.FILES,instance=name) if form.is_valid(): form.save() orders = Order.objects.filter(id=orid, name=name) OrderItems = OrderItem.objects.filter(order=orid) pengirimans = Pengiriman.objects.filter(order=orid) context = {'orders':orders, 'OrderItems':OrderItems,'pengirimans':pengirimans, 'form':form, 'cartItems':cartItems } return render(request, 'store/detail.html' ,context) detail.html <form action="" method="post" enctype="multipart/form-data"> {% csrf_token %} {{form.as_p}} <input type="Submit" id="submit" name="Update Information" > </form> forms.py from django.forms import ModelForm from .models import * class Uplaodpic(ModelForm): class Meta: model = Order fields = ['bukti'] -
Stuck While migrating from Python2 to Python3 [closed]
python2 except Exception, e: return HttpResponse(status=500,content_type="application/json",content=json.dumps({'Response':'Failure','Response_status':'Invalid data provided','Error':e.message})) python3 except Exception as e: return HttpResponse(status=500,content_type="application/json",content=json.dumps({'Response':'Failure','Response_status':'Invalid data provided','Error':str(e)})) Tried to change the e.message to str(e) and django manage.py runserver ran without any errors but the response was not returned as str in Database. As I am new to this kindly help me in solving this issue -
How to Verify Email in Django using OTP and UserCreationForm
I am creating a Quiz App. In that I have a sign up page for user authentication which is using the default User Model and User CreationForm. I want to add a email verification in it by sending a otp on the email. Please explain me how can I send otp on email using default user model and user creation form to verify the otp on the email. My user app code is: forms.py from django import forms from django.contrib.auth import get_user_model from django.contrib.auth.forms import UserCreationForm email = forms.EmailField() class Meta: model = get_user_model() fields = ['username', 'email', 'password1', 'password2'] views.py import pyotp from django.contrib.auth.models import User from .forms import UserRegisterForm from django.contrib import messages from django.shortcuts import render, redirect def register(request): if request.method == 'POST': form = UserRegisterForm(request.POST) if form.is_valid(): otp=pyotp.totp('base32secret3232') form.save() messages.success(request, f'Account Created for {User.username}. You can Login') return redirect('login') else: form = UserRegisterForm() return render(request, 'users/register.html', {'form': form}) -
best way to validate a user's upload files in django
What is the best way to validate a user's upload files, both in size and type? -
How to aggregate score by value of manytomany field in django queryset
class Subject(models.Model): name = models.CharField(max_length=100, blank=True, null=False) category = models.CharField(choices=TYPE_CHOICES, null=True, max_length=50) setting = models.ManyToManyField(Contact) class Contact(models.Model): name = models.CharField(max_length=50, blank=True, null=True) email = models.EmailField(max_length=50, blank=True) id subject_id contact_id 1 66 13 2 66 28 3 71 13 4 71 28 5 98 13 6 98 28 7 98 37 8 20 13 The setting field is a manytomany property, and it can have multiple setting values per subject object. The result I want to get is a score by contact_id. The score is calculated as follows. 1. 50 points per subject object. 2. If two people are in charge of a subject, each person gets 25 points, and if three people are in charge of a subject, each person gets 16 (50/3) points. Desired result: {'contact_id': 13, 'score': 91}, {'contact_id': 28, 'score': 41}, {'contact_id': 37, 'score': 16} workers = Subject.objects.filter(setting__isnull=False)\ .values('id')\ .annotate(worker=Count('setting')) setting_performance = Subject.objects.filter(setting__isnull=False) \ .values('setting')\ .annotate( setting=Count('id', filter=Q(id__in=workers.filter(worker=1).values('id')), distinct=True) * Value(50), collabo_setting=Count('id', filter=Q(id__in=workers.filter(worker__gte=2).values('id')), distinct=True) * Value(50) / workers.filter(id=F('id')).values('worker'),)\ .values_list('setting__name', 'setting', 'collabo_setting') The above expression is the code I wrote. It's not correct. Any feedback on django and queryset calculations? -
one-to-many to many-to-many Relationship in Django model
I am looking for a relationship that A user creates an incident, Select multiple types And every type has many subtypes that users select from front-end I have a table called the incident, Incident name - XYZ type - Multiple types subtype - Multiple subtypes * Note A type has many subtypes in the system I am trying to do the below, Incident name - type - M2M(Type) Type name - subtype - M2M(Subtype) Subtype Name - Please suggest if the below design is good to go. Thanks! -
GET operation using Django rest_framework gets ConnectionRefusedError [Errno 111] after several hours of normal operation
I setup use Django to create a APP (let's call it central APP) that aggregate operation data from multiple applications on remote server. I then installed Django REST_Framework, to allow other applications, like Prometheus to get information from my Django central APP. The related Django APPs is shown below INSTALLED_APPS = [ ... #central APP I created 'django_prometheus', #This is not used 'rest_framework', 'django_filters', 'drf_multiple_model', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', ] Other applications, like Prometheus, can successfully get info return. The API call frequency is 1 minutes per GET request. However, after around 5 hour of normal operation, Django will stop working. It seems the Djagon rest_framework cause the exception: File "/home/centos/.local/lib/python3.8/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception raise exc The full exception return is shown below: (full exception removed since the system says "This looks like spam") In the past two weeks, I have disabled the REST_Framework API url, meaning other applications can not get info from the central APP through REST API. And the system is running fine. So I am pretty sure the problem comes from the API call. I have also tried things like changing the allowed Memory allocation for MySQL, change the localhost to '127.0.0.1', but … -
Can’t Access Procfile with Heroku (Django)
I can’t access wsgi in heroku Procfile web:gunicorn Medical_Portal.Medical_Portal.wsgi My files : My wsgi file in Medical_Portal/Medical_Portal/wsgi.py -
Django: Prepopulate Formset with ManyToMany Relationship and additional Fields
I have two models with an M2M relationship and extra fields: A menu is a compilation of many courses (i.e. dishes). The M2M relationship is reflected in MenuItem class/table. MenuItem has two additional fields: course_type (i.e. starter, appetizer, etc.) and course_position (to keep track of the position). models.py class Menu(models.Model): creator = models.ForeignKey(User, related_name='creator_id_menu', on_delete=models.PROTECT) menu_name = models.CharField(max_length=100, default='', verbose_name=_('menu name'), help_text=_('i.e. saturday night fajita night')) menu_description = models.CharField(max_length=300, default='', verbose_name=_('menu description'), help_text=_('this menu will blow your mind...')) menu_item = models.ManyToManyField(Course, through='MenuItem', blank=True) class Course(models.Model): creator = models.ForeignKey(User, related_name='creator_id_course', on_delete=models.PROTECT) course_name = models.CharField(max_length=100, help_text=_('give your creation a nice name!')) course_description = models.CharField(max_length=300, default='', verbose_name=_('course description'), help_text=_('give your creation a brief description!')) class MenuItem(models.Model): menu = models.ForeignKey(Menu, on_delete=models.CASCADE, verbose_name=_('menu name')) course = models.ForeignKey(Course, on_delete=models.PROTECT, verbose_name=_('course name')) course_type = models.CharField(choices=CourseType.choices, max_length=3, verbose_name=_('course type')) course_position = models.PositiveSmallIntegerField(verbose_name=_('course position')) forms.py class CourseForm(forms.ModelForm): course_type = forms.ChoiceField(choices=MenuItem.CourseType.choices) course_description = forms.Textarea() class Meta: model = Course fields = ['course_name', 'course_description'] CourseFormset = modelformset_factory(Course, form=CourseForm, extra=0) I can prepopulating the ModelFormset with the data from Course, but don't know, how to correctly access the MenuItem instance. That is why, my views.py misses the request.POST processing. views.py def update_menu_with_courses(request, pk): context = {} menu_instance = Menu.objects.get(id=pk) # initializing forms … -
Django datetimefield can't show d-m-y in templates
I was make a small project. I create a class Groups in model had create_date = datetimefield(). When I show create_date in template it just show the time I create. But when I add the |date=:"d-m-Y" it don't show any thing. Did you know how to change it. Thank! models.py class Group(models.Model): name = models.TextField(max_length=200,unique=True) slug = models.SlugField(allow_unicode=True,unique=True) descripsion = models.TextField(max_length=800,default=' ') image = models.ImageField(upload_to='group_pics/',default='group_pics/default_group.jpg', height_field=None, width_field=None, max_length=None) create_date = models.TimeField(auto_now_add=True) templates <h2>{{ group.name|safe }}</h2> <h4>{{ group.descripsion|safe }}</h4> <p>{{ group.create_date}}</p> If I don't use |date:"d-m-Y".It show time. But when I add the |date:"d-m-Y". It only show the name and descripsion. -
Django SMTP error sending e-mail with https(SSL) - deploying in AWS ElasticBeanstalk
Im sending an account verification e-mail and im utilizing AWS-EB to deploy it,in local with localhost it's functioning, but with https I get an error(I just configured the gmail to allow other apps, I don't know if I need to set an configuration at ElasticBeanstalk) The only configuration I did in Gmail was to allow less secure apps nothing else, and I have an recuperation e-mail and number, but my to steps verification is disabled and my number verification too. settings.py: if DEBUG: EMAIL_HOST = 'smtp.gmail.com' EMAIL_PORT = 587 EMAIL_USE_TLS = True EMAIL_HOST_USER = 'pleaeseSomebodyHireMeIWillBeTheHardestWorker@gmail.com' EMAIL_HOST_PASSWORD = 'mypassword bla bla bla' # important else: EMAIL_BACKEND = 'django.core.mail.backends.console.EmailBackend' {% autoescape off %} Hi {{ user.user_name }}, Sua conta foi registrada com {%comment%} http://{{ domain }}{% url 'account:activate' uidb64=uid token=token %} {%endcomment%} https:/{{ jamelaumn.com }}{% url 'account:activate' uidb64=uid token=token %} {% endautoescape %} views.py def account_register(request): if request.user.is_authenticated: return redirect('account:dashboard') if request.method == 'POST': registerForm = RegistrationForm(request.POST) if registerForm.is_valid(): user = registerForm.save(commit=False) user.email = registerForm.cleaned_data['email'] user.set_password(registerForm.cleaned_data['password']) user.is_active = False email_to = user.email user.save() email_subject = 'Ative sua conta' current_site = get_current_site(request) message = render_to_string('account/registration/account_activation_email.html', { 'user': user, 'domain': current_site.domain, 'uid': urlsafe_base64_encode(force_bytes(user.pk)), 'token': account_activation_token.make_token(user), }) html_message = "<br> oi </br>" email_body = message … -
How to send notification to a perticular user id from django
I am able to send notification from admin to all using this github code https://github.com/priyanshu2015/django-channels-celery but not able to send notification to a perticular userid what modification should i do to achive this. also from view i want send notification to user specific. -
postgres hstore removed from django model, but getting error in testing
I removed the postgres hstore field when I rewrote my models. But I'm getting this error. django.db.utils.ProgrammingError: type "hstore" does not exist LINE 1: ...r(254) NULL UNIQUE, "bio" text NOT NULL, "follow" hstore NUL... This follow hstore field doesn't exist anymore. I tried migrating again, but changes are already made. I used a many to many field to create following, I was just trying to learn what hstore field could do when I added it. Does Django still think I have an hstore field? This stackoverflow answer says that testing started working when hstore extension was added to template1 postgres database. Should I just try that? But if my model doesn't use hstore, why would I need to? -
how to create three tables in nested-serializer objects using django rest framework
I am trying to create a three model nested objects in django rest framework models.py class Project(models.Model): project_id = models.AutoField(primary_key=True, unique=True) project_name = models.CharField(max_length=100) class ProjectSite(models.Model): site_id = models.AutoField(primary_key=True, unique=True) site_name = models.CharField(max_length=200,name='project_site_name') project_id = models.ForeignKey(Project, on_delete=models.CASCADE, blank=True, null=True, related_name="projectid") class Assignment(models.Model): assignment_id = models.AutoField(primary_key=True) assignment_name = models.CharField(max_length=150) site_id = models.ForeignKey(ProjectSite,related_name="projectsiteidkey", on_delete=models.CASCADE) assigned_to_id = models.ForeignKey('auth.User',related_name="assignedtoidfkey",on_delete=models.CASCADE) serializer.py class ProjectSerializer(serializers.ModelSerializer): class Meta: model = Project fields = '__all__' class ProjectSiteSerializer(serializers.ModelSerializer): class Meta: model = ProjectSite fields = '__all__' class AssignedUserSerializer(serializers.ModelSerializer): class Meta: model = Assignment fields = '__all__' class CreateNewProjetSerial(serializers.ModelSerializer): site_name = ProjectSiteSerializer(many=True) assigned_to_id = AssignedUserSerializer(many=True) class Meta: model = Project fields = ['site_name','project_name','assigned_to_id'] def create(self, validated_data): site_name = validated_data.pop('site_name') assigned_to_id = validated_data.pop('assigned_to_id') projects = Project.objects.create(**validated_data) for i in site_name: ProjectSite.objects.create(site_name=projects, **i) for j in assigned_to_id: Assignment.objects.create(assigned_to_id=projects, **j) return projects view.py class MultieCreateAPIView(generics.CreateAPIView): queryset = Project.objects.all() serializer_class = CreateNewProjetSerial I would like to post a JSON object like this { "site_name": [{"site_name": "site1"}, {"site_name": "site2"}], "project_name": "test_project", "assigned_to_id": [{"assigned_to_id":2}, {"assigned_to_id":3}] } When I try to post this I got error with "Cannot assign "<Project: test_project>": "Assignment.assigned_to_id" must be a "User" instance". Thank you for helping me in advance. -
Routing Problem in calling API from REACT using Redux
I have create api with Python (django restframework). I am calling that api from my react applicaation using redux. It works fine when i call it like this const {data} = await axios.get(`http://127.0.0.1:8000/api/products/${id}`) but when i change the url to const {data} = await axios.get(`api/products/${id}`) It then makes a request to a different route ( http://localhost:3000/product/api/products/6) and I want it to make a call to (http://localhost:8000/api/products/6 I have added the path in django server and allowed calls from the react app. and it is working perfectly when i was working with other routes. for example it was working fine when i was making call to this route const {data} = await axios.get('api/products/') -
In Django rest framework, can I modify serializer instead of accepting 2 lists to accept a list of objects containing them
I am trying to modify the way I want to accept data from endpoints without modifying the model defined for it. Hence I want to modify the serializer. I am not sure how should I redefine it. I have a serializer defined as class AssetWorkorderSerializer(MaxenBaseSerializer): id = ReadOnlyField() assets = PrimaryKeyRelatedField( many=True, read_only=False, allow_null=False, queryset=models.Asset.objects.all(), ) assignee = PrimaryKeyRelatedField( many=False, read_only=False, allow_null=True, queryset=User.objects.all() ) checklists = PrimaryKeyRelatedField( many=True, read_only=False, queryset=Checklist.objects.all() ) assigned_by = PrimaryKeyRelatedField( many=False, queryset=User.objects.all()) deadline = ReadOnlyField() overdue = ReadOnlyField() class Meta: model = models.AssetWorkorder fields = "__all__" So objects accepted are: { "count": 1, "next": null, "previous": null, "results": [ { "url": "https://<some-url>/assetworkorders/29/", "id": 29, "assets": [ 292, 293 ], "assignee": 33, "checklists": [ 7, 8, 9 ], "assigned_by": 32, "deadline": "2022-03-31", "overdue": true, "created": "2022-03-31T03:52:59.123745Z", "updated": "2022-03-31T17:18:49.599963Z", "name": "Service HVACs", "description": "Service HVACs", "status": "OP", "priority": "LO", "duedate": "2022-03-31", "scheduleddate": "2022-03-30", "notifications_enabled": false }, ] } Instead I want to accept like this: { "count": 1, "next": null, "previous": null, "results": [ { "url": "https://<some-url>/assetworkorders/29/", "id": 29, "assetChecklist": [ {"asset": 292, "checklists": [7,8]}, {"asset": 293, "checklists": [8,9]}, ], "assignee": 33, "assigned_by": 32, "deadline": "2022-03-31", "overdue": true, "created": "2022-03-31T03:52:59.123745Z", "updated": "2022-03-31T17:18:49.599963Z", "name": "Service HVACs", "description": "Service HVACs", … -
Django ModuleNotFoundError: No module named 'models'
I'm building a web app in Django to purchase movie tickets. All the logic handling the database is in the 'ticket_handler' app. The actual website is in the 'movie_site' app and I'm building a restful api in the 'ticketing_api' app. Whenever I try to import something from one app to another, I get a "ModuleNotFound" error. Here is my directory structure: Movie_Ticketing_Service |- movie_server | |- movie_server | | |- __init__.py | | |- asgi.py | | |- settings.py | | |- urls.py | | |- wsgi.py | |- movie_site | | |- migrations | | |- templates | | |- __init__.py | | |- admin.py | | |- apps.py | | |- forms.py | | |- models.py | | |- tests.py | | |- urls.py | | |- views.py | |- ticket_handler | | |- migrations | | |- __init__.py | | |- admin.py | | |- apps.py | | |- billing_handler.py | | |- mail_handler.py | | |- models.py | | |- tests.py | | |- ticket_handler.py | | |- views.py | |- tecketing_api | | |- migrations | | |- __init__.py | | |- admin.py | | |- apps.py | | |- forms.py | | |- models.py … -
django.contrib.admin.sites.NotRegistered: The model User is not registered
I am trying to register my custom user model to the admin site (I have name my custom user model User), but I am getting this error. as I understood that I should unregister the original User model then register my custom model and this what I have tried to do!! ---------setings.py------- INSTALLED_APPS = [ 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'users', # This is custom user model ] AUTH_USER_MODEL = 'users.User' ---------users/admin.py------- from django.contrib import admin from django.contrib.auth.admin import UserAdmin from .models import User as MyUser # my Custom User Model from django.contrib.auth.models import User admin.site.unregister(User) class MyUserAdmin(UserAdmin): list_display = ('username', 'email') admin.site.register(MyUser,MyUserAdmin) -
How to send image from Expo Image Picker to Django REST using axios
I have spent about a week on this and cannot understand what is going on. I need to upload images from React-Native (EXPO) to Django REST. It seems to be that axios is sending an object instead of an image (I think). React Native EXPO Image Picker/Axios: const pickImage = async () => { // No permissions request is necessary for launching the image library let result = await ImagePicker.launchImageLibraryAsync({ mediaTypes: ImagePicker.MediaTypeOptions.All, allowsEditing: true, aspect: [4, 3], quality: 1, }); if (!result.cancelled) { const formData = new FormData(); formData.append("image", { uri: result.uri, name: "image.jpeg", type: "image/jpeg", }); try { const response = await axiosInstance({ method: "post", url: `/api/businesses/84/upload_image/`, data: formData, headers: { "Content-Type": "multipart/form-data" }, }) console.log(response.data); } catch (error) { console.log(error.response.data); } } }; Django API: class BusinessProfileViewSet(MixedPermissionModelViewSet): """ API endpoint that allows business profiles to be viewed, created, or edited. """ queryset = BusinessProfile.objects.all().order_by('-created_on') serializer_class = BusinessProfileSerializer permission_classes_by_action = { 'list': [IsOwnerOrStaff], 'create': [AllowAny], 'update': [IsOwnerOrStaff], 'retrieve': [IsOwnerOrStaff], 'partial_update': [IsOwnerOrStaff], 'destroy': [IsAdminUser] } paginator = None parser_classes = [MultiPartParser, FormParser] @action(methods=['post'], detail=True, permission_classes=[IsAuthenticated]) def upload_image(self, request, pk=None): try: print(request.data) image = request.data except KeyError: raise KeyError('Request has no image attached') business_profile = BusinessProfile.objects.get(user=request.user) business_profile.image = image business_profile.save() return … -
Django - send_mail -No error while trying to send e-mail, but no e-mail is Sent
Im trying to send an verification email to new registred accounts, but the e-mail is not being sent, the html page that is being loaded when I send the e-mail is being perfectly loaded, and I dont get an error in console aaaaaaaaaaaaaaaaaaaaaa if DEBUG: EMAIL_HOST = 'smtp.gmail.com' EMAIL_PORT = 587 EMAIL_USE_TLS = True EMAIL_HOST_USER = 'jamelaumn@gmail.com' EMAIL_HOST_PASSWORD = xxxxx # important else: EMAIL_BACKEND = 'django.core.mail.backends.console.EmailBackend' def account_register(request): if request.user.is_authenticated: return redirect('account:dashboard') if request.method == 'POST': registerForm = RegistrationForm(request.POST) if registerForm.is_valid(): user = registerForm.save(commit=False) user.email = registerForm.cleaned_data['email'] user.set_password(registerForm.cleaned_data['password']) user.is_active = False email_to = user.email user.save() email_subject = 'Ative sua conta' current_site = get_current_site(request) message = render_to_string('account/registration/account_activation_email.html', { 'user': user, 'domain': current_site.domain, 'uid': urlsafe_base64_encode(force_bytes(user.pk)), 'token': account_activation_token.make_token(user), }) html_message = "<br> oi </br>" email_body = message send_mail([email_to], subject=email_subject, message=message, from_email=settings.EMAIL_HOST_USER, html_message=html_message) """ email = EmailMessage( email_subject, email_body, settings.EMAIL_HOST_USER, [email_to]) email.send() """ return HttpResponse('registered succesfully and activation sent') else: registerForm = RegistrationForm() return render(request, 'account/registration/register.html', {'form': registerForm}) def account_activate(request, uidb64, token): try: uid = urlsafe_base64_decode(uidb64) user = UserBase.objects.get(pk=uid) except(TypeError, ValueError, OverflowError, user.DoesNotExist): user = None if user is not None and account_activation_token.check_token(user, token): user.is_active = True user.save() login(request, user) return redirect('account:dashboard') else: return render(request, 'account/registration/activation_invalid.html') -
Raw sql query issue in Django
I am trying to to make an SQL query to impliment the answer given here. The user suggested I try doing a raw sql query to solve. I am having issues implimenting what he suggests. For example, this is what I have so far. ingredients = ["eggs", "bacon", "salt"] recipes = Recipe.objects.raw('select whattocook_RecipeIngredients \ from whattocook_Recipe a \ inner join whattocook_RecipeIngredients b \ on a.id = b.recipe_id and b.ingredient in (ingedients) \ group by recipeingredients \ having count(*) >= 2') But this does not work. His answer says to do this recipe_list = Recipe.objects.raw('select a.* from app_Recipe a inner join app_RecipeIngredients b on a.id = b.recipe_id and b.ingredient in ("egg", "bacon", "rice") group by a.* having count(*) >= 2') maybe replace app_ with your project name, replace a.* with list of column names. So I think I am misunderstanding which columns I need to replace, given my code gives me this error. django.db.utils.ProgrammingError: column "ingedients" does not exist LINE 1: ... on a.id = b.recipe_id and b.ingredient in (ingedients... ^ HINT: Perhaps you meant to reference the column "b.ingredient". My app is named whattocook, and the models are as follows class RecipeIngredients(models.Model): recipe = models.ForeignKey(Recipe, on_delete=models.CASCADE, null=True) ingredient = models.TextField(null=True, …
