Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How to convert .cshtml code to html?
I have to make an app in Django/Python and I already have the templates in .cshtml as the app was earlier made in .net, How can I convert the .cshtml code into .html code, I am new to this so please explain in detail, below is the code in .cshtml format. Also is there any online tool that can convert this directly for me? I also want to know how to open these .cshtml file because when I try to open them in chrome only few lines of the code gets executed. Any help is appreciated. @model XYZ.Model.ViewModel.qwertyViewModel @{ ViewBag.Title = "CreateUser"; Layout = "~/Views/Shared/_MainLayout.cshtml"; } <div class="main-container" id="main-container"> <div class="main-content"> <div class="main-content-inner"> <div class="breadcrumbs" id="breadcrumbs"> <ul class="breadcrumb"> <li> <i class="ace-icon fa fa-home home-icon"></i> <a href="@Url.Action("Index", "Home")">Home</a> </li> <li> <a href="@Url.Action("Index", "Organizations")">Organizations</a> </li> <li> <a href="@Url.Action("Users", "Organizations",new { id=Model.OrganizationId})">Users</a> </li> <li class="active">Add User</li> </ul><!-- /.breadcrumb --> </div> <br /> <div class="page-content"> @using (Html.BeginForm("CreateUser", "Organizations", FormMethod.Post, new { @class = "form", id = "frmDpuConfig" })) { @Html.AntiForgeryToken() <div class="row"> <div class="col-md-10"> <div class="card"> <div class="card-head style-primary"> <header>Add @Model.OrganizationName<span>'s</span> User</header> </div> <div class="col-md-8 col-md-offset-1"> <!-- FORM CONTENT BEGINS --> <div class="card-body"> @Html.ValidationSummary(true, "", new { @class = "ValidationErrorMessage help-block" }) @Html.HiddenFor(model=>model.OrganizationId) <div ... -
How to restrucutre my Django code?
I am new to Django.I want to create app that would enable selected users to login and then upload files that would latter be processed. models.py class Profile(models.Model): username = models.OneToOneField(User, on_delete=models.CASCADE) password = models.TextField(max_length=80,blank=True) company = models.TextField(max_length=80, blank=True) @receiver(post_save, sender=User) def create_user_profile(sender, instance, created, **kwargs): if created: Profile.objects.create(user=instance) @receiver(post_save, sender=User) def save_user_profile(sender, instance, **kwargs): instance.profile.save() class Document(models.Model): uploaded_by = models.ForeignKey(Profile,on_delete=models.CASCADE) date_uploaded = models.DateTimeField(auto_now_add=True) forms.py class LoginForm(forms.Form): username = forms.CharField() password = forms.CharField(widget=forms.PasswordInput) company = forms.CharField() class DocumentForm(forms.Form): docfile = forms.FileField(label='Select a file') malex.urls(application urls) from malex.views import list from malex.views import login urlpatterns = [ url(r'^list/$', list, name='list'), url(r'^login/$', login, name='login'), ] project/urls urlpatterns = [ path('admin/', admin.site.urls), url(r'^newp/', include('malex.urls')), ] Now the login and upload operations are separated. How to change my views and urls to have login first and upload latter? Do I need to use Class based views with decorators? -
Django how to save time to the forms?
I want to book a car if user click on the available time . how to save the clicked time to the field of time in form . [![This is the time available picture i want one of this time that user clicked to save to the forms and redirect to the booking form -
Protocol error, got "H" as reply type byte
I am trying to use django channels for the first time and i am following the tutorial in the documentation. But when I use python manage.py runserver and try to connect i get this error. Protocol error, got "H" as reply type byte Here is the whole console(I'm using anaconda): Quit the server with CTRL-BREAK. 2018-06-20 15:59:25,665 - INFO - server - HTTP/2 support not enabled (install the http2 and tls Twisted extras) 2018-06-20 15:59:25,665 - INFO - server - Configuring endpoint tcp:port=8000:interface=127.0.0.1 2018-06-20 15:59:25,665 - INFO - server - Listening on TCP address 127.0.0.1:8000 [2018/06/20 15:59:36] HTTP GET /chat/lobby/ 200 [0.12, 127.0.0.1:62590] [2018/06/20 15:59:36] WebSocket HANDSHAKING /ws/chat/lobby/ [127.0.0.1:62594] 2018-06-20 15:59:37,694 - ERROR - server - Exception inside application: Protocol error, got "H" as reply type byte File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels\sessions.py", line 175, in __call__ return await self.inner(receive, self.send) File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels\middleware.py", line 41, in coroutine_call await inner_instance(receive, send) File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels\consumer.py", line 54, in __call__ await await_many_dispatch([receive, self.channel_receive], self.dispatch) File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels\utils.py", line 50, in await_many_dispatch await dispatch(result) File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels\consumer.py", line 67, in dispatch await handler(message) File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels\generic\websocket.py", line 173, in websocket_connect await self.connect() File "C:\Users\Pc\Documents\tutorial\django-channel-tut\chat\consumers.py", line 11, in connect self.channel_name File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\channels_redis\core.py", line 282, in group_add channel, File "C:\Users\Pc\Anaconda3\envs\django\lib\site-packages\aioredis\connection.py", line 181, in _read_data ... -
ImproperlyConfigured: Requested settings DATABASES
I have seen 10 different ways of configuring the MySQL database with Django, and none of them work. I am running MySQL 8.0 and Django 2.0 I updated the Project/settings.py with the database settings as followed: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'name_of_db', 'USER': 'root_user', 'PASSWORD': 'not_telling_u_my_pass_:)', 'HOST': 'localhost', 'PORT': '3306', } } When I run the command to test the connectivity: python manage.py dbshell I get error: django.core.exceptions.ImproperlyConfigured: Requested setting DATABASES, but settings are not configured. You must either define the environment variable DJANGO_SETTINGS_MODULE or call settings.configure() before accessing settings. No other settings have been made, however, I have tried to follow a few guides which say that I must declare: set DJANGO_SETTINGS_MODULE=mysite.settings With no luck. I am running Windows 7 as well. I have all of the mysql dependencies installed for connecting from Python to MySQL. I know this question has been asked a number of times, but a thread should exist with clear instructions. Many of the other threads do not have clear and concise instructions, and I'm using a later version of MySQL so hopefully this will help solve others issues experiencing the same. -
How can I optimize queries django rest-framework
I have the following serilizers class AutoSerializer(serializers.ModelSerializer): class Meta: model = Auto fields = ("nombre",) class MarcaSerializer(WritableNestedModelSerializer): autos = AutoSerializer(many=True) class Meta: model = Marca fields = ("codigo", "descripcion", "autos") ModelViewSet class MarcaViewSet(viewsets.ModelViewSet): queryset = Marca.objects.all() serializer_class = MarcaSerializer def list(self, request, *args, **kwargs): queryset = self.queryset serializer = self.get_serializer(queryset, many=True) return Response(serializer.data) Querys How can you optimize access to the base, that is, make fewer inquiries -
Equivalent of Rails' seed file in Django with Python3
I would like to manually populate the database in my Django app. In Rails, I just have to enter the info in the seed file and that's it. The db.sqlite3 file has many numbers in it which I don't get. My questions are how can I manually create a database and in which directory should I put it, and how can I retrieve the info to display it in my view? Thanks! -
Changing the id attribute of select tags within Django's SelectDateField
I'm looking for a way to modify in code the ids of the select tags created by SelectDateField. Specifically, I'd like to have, for example, <select name='date_year' id='date_year'> rather than the default <select name='date_year' id='id_date_year'>. From my reading, subclassing SelectDateField is generally the way to customise the HTML generated but this seems rather unfortunately inelegant for such a trivial change. Is there an alternative I've overlooked? -
How to save HTML template data to mySQL database in Django?
I am using django and want to store the information from html template to a mySQL database. When I click on the submit botton it redirects me to the same page and no data is saved in the database. How can I solve this error? This is my views file from django.http import HttpResponse from django.template import loader from . models import adduser from django.shortcuts import render def user(request): all_users = adduser.objects.all() template = loader.get_template('p1/adduser.html') context = { 'all_users':all_users, } return HttpResponse(template.render(context, request)) def createpost(request): if request.method == 'POST': if request.POST.get('Name') and request.POST.get('Designation') and request.POST.get('Email') and request.POST.get('Password') and request.POST.get('Confirmpassword') and request.POST.get('ContactNumber'): post = adduser() post.Name = request.POST.get('Name') post.Designation = request.POST.get('content') post.Email = request.POST.get('Email') post.password = request.POST.get('password') post.confirmpassword = request.POST.get('confirmpassword') post.contactnumber = request.POST.get('contactnumber') post.save() return render(request, 'p1/adduser.html') This is my models file from django.db import models class adduser(models.Model): name = models.CharField(max_length=255) designation = models.CharField(max_length=255) email = models.CharField(max_length=255) password = models.CharField(max_length=255) confirmpassword = models.CharField(max_length=255) ContactNumber = models.IntegerField() This is my adduser.html template <!DOCTYPE html> <html> <body> <h2>Add User</h2> <form action="" method="POST"> {% csrf_token %} Name:<br> <input type="text" name="Name"><br> Designation:<br> <input type="text" name="Designation"><br> Email:<br> <input type="Email" name="Email"><br> Password:<br> <input type="password" name="Password"><br> Confirm Password:<br> <input type="password" name="Confirm Password"><br> Contact Number:<br> <input type="number" name="Number" ><br> ... -
Recieve a file as response to an Ajax request from Django view
I'm working on a project with Python(3.6) and Django(1.11) in which I have implemented a Django view which calls by an ajax request and the view will return an audio mp3 file. How can I get this file response and send to the browser (should be downloaded to the user)? Here's My code: views.py: if form.is_valid(): obj = form obj.textFile = form.cleaned_data['textFile'] obj.gender = form.cleaned_data['gender'] obj.pitch = form.cleaned_data['pitch'] obj.speed = form.cleaned_data['speed'] obj.voice_type = form.cleaned_data['voice_type'] obj.save() text_path = os.path.join(settings.MEDIA_ROOT, 'texts/', obj.textFile.name) text = text_path txt = Path(text).read_text(encoding='cp1252') fileName = obj.textFile.name[:-4] print('File Name is: {}'.format(fileName)) input_text = {'text': txt} voice = { 'language_code': 'en-US', 'ssml_gender': obj.gender, } audio_config = { 'audio_encoding': texttospeech_v1beta1.enums.AudioEncoding.MP3, 'pitch': float(obj.pitch), 'speaking_rate': float(obj.speed), } client = texttospeech_v1beta1.TextToSpeechClient(credentials=credentials) response = client.synthesize_speech(input_=input_text, voice=voice, audio_config=audio_config) with open('media/audios/' + str(fileName) + '.mp3', 'wb') as out: out.write(response.audio_content) print('Audio content written to file "output.mp3"') # dict_response = dict(response) response_file = FileResponse('media/audios/output.mp3', content_type='mp3') response_file['Content-Disposition'] = 'attachment; filename="output.mp3"' return HttpResponse(response_file) return HttpResponse('Get post request along with files', status=200) Ajax request code: $(document).on('submit', '#fileForm', function (e) { e.preventDefault(); var data = new FormData($('#fileForm').get(0)); $.ajax({ type: 'POST', url: '{% url 'home' %}', data: data, processData: false, contentType: false, success: function () { console.log('Succcess'); $('#success').attr('hidden', false); } }); }); Help ... -
Form is not displaying ValidationError
It is not showing any validation error but reloading the empty form till the all form fields behavior validation. views.py def Leave_management(request): if request.user.is_superuser: form = LeaveForm(request.POST or None) if form.is_valid(): form.save() return redirect('leave_list') else: form = LeaveForm() return render(request, 'leave_management.html', {'form': form}) if not request.user.is_superuser and not request.user.is_anonymous: form = LeaveForm(request.POST or None) form.fields['status'].disabled = True if form.is_valid(): form.save() return redirect('leave_list') else: form = LeaveForm() return render(request, 'leave_management.html', {'form': form}) template <hr><h1>Leave Application</h1><hr> <form method="post"> {% csrf_token %} {{form|crispy}} <input type="submit" value="submit" > </form> -
Django & Postgres: DB delivers None instead of ""
I am migrating a Django website from 1.8 to 2.0. Also Postgres-DB is upgraded from v8 to v9. I have a model defined like this: class CMSMailTemplates(models.Model): email_cc = models.CharField(max_length=200, default='', blank=True, null=True, verbose_name=u"Email cc:") temp = CMSMailTemplates.objects.get(id=1) In the old world if the DB field was empty: temp.email_cc == "" Now after migration if the field is empty temp.email_cc is None Can anybody help me with an explanation? Is there a way to get "" instead of None for these attributes? -
Transparently inherit Django model attributes
I've been wracking my brain about how to implement the following functionality on Django 1.7. I've got two Django models. Some of the fields on one are duplicated on the other. They are related with a foreign key, like so. class MyModelGroup(models.Model): name = models.CharField(max_length=128) shared_attr1 = models.NullBooleanField() shared_attr2 = models.CharField(max_length=512, null=True, blank=True) class MyModel(models.Model): group = models.ForeignKey(MyModelGroup, null=True, blank=True) name = models.CharField(max_length=128) shared_attr1 = models.NullBooleanField() shared_attr2 = models.CharField(max_length=512, null=True, blank=True) MyModel may be related to a MyModelGroup record. When shared_attr1 or shared_attr2 are changed on MyModel I want to implement the following behaviour: If the foreign key is null, just save the value on MyModel. If the foreign key is not null, and the value is different to the value shared on the record linked with the foreign key, save the value on MyModel. Otherwise, leave the value blank. Then, when I retrieve the value from either of the shared attributes on MyModel, I want it to do the following: If the foreign key is null, return the value of the attribute on MyModel. If the foreign key is not null, and the value on MyModel is different to the value on MyModelGroup, return the value on MyModel. If ... -
Installing Django-channels error
I've tried to install Django-Channels, but this error occurred: Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/4c/xy3rtg_165l0650j4tq7fvrh0000gn/T/pip-install-7anqvzhg/twisted/ -
Django query: the last Mail received from a conversation grouped by Conversations
My Model: class Mail(models.Model): subject = models.CharField(max_length=300) message = models.TextField() receiver = models.ForeignKey(User, related_name='receiver', on_delete=models.CASCADE) sender = models.ForeignKey(User, related_name='sender', on_delete=models.CASCADE) sent_date = models.DateTimeField(auto_now_add=True) conversation = models.ForeignKey(Conversation, on_delete=models.CASCADE) read = models.BooleanField(default=False) My query: Conversation.objects.filter(mail__receiver=request.user).annotate(latest_msg=Max('mail__id')).values('id','mail__id','mail__subject','mail__message','mail__sender__username','mail__sent_date','mail__read').order_by('-latest_msg') It returns all the Conversations which contains any Mail received by the logged user (request.user). Why? I want the last message received grouped by Conversations, like Gmail. -
Use Foreign Key to access other object Django
I want to access other objects of foreign key. models.py from django.db import models class Box(models.Model): name = models.CharField(max_length=200,null=True) apples= models.IntegerField(blank=True, null=True) banana = models.IntegerField(blank=True, null=True) mango = models.IntegerField(blank=True, null=True) def __str__(self): return self.name class Buyer(models.Model): name_of_buyer = models.CharField(max_length=200,null=True) address_of_buyer = models.CharField(max_length=200,null=True) interested_in = models.ForeignKey(Box,on_delete=models.CASCADE,null=True) Pickup_dt = models.DateField(null=True) Pickup_time = models.CharField(max_length=80,null=True) forms.py from .models import Price class Sale(forms.ModelForm): def clean_interested_in(self): buyer_interested_in_box = self.cleaned_data['interested_in'] #if the selected box contains less than 10 apples,10 banans and 10 mangos: raise forms.ValidationError('Not enough fruits.Please select another box') class Meta: model = Buyer widgets = { 'Pickup_dt': forms.DateInput(attrs={'class':'datepicker'}), 'Pickup_time': forms.DateInput(attrs={'class':'timepicker'}), } fields = '__all__' How can I validate this form by using the foreign key id. -
How to make an article disapper in django app
I 'm new in web development and I started with django My question if I have article in my blog and a I like to make timing that it disapper afet a specific time or date Delete the full field of the article from the database after a specific time -
Django rest token authentication
If I want to use both TokenAuthentication and SessionAuthentication, I get a CSRF error if it checks the session before the Token. Is this an indicator that something is wrong with my setup, or is this a shortcomming of DRF? -
can't download a text file from a folder in django
I am having a folder named text_file and I am having all the text files in that folder only. Here, is the directory of my folders and files: So, what I want to do is download hello.txt by clicking on a download button in home.html after searching on google what I got: link in home.html: <a href="/download/" download> download here </a> which redirects me to views.py where the download function I wrote was: from django.http import HttpResponse from wsgiref.util import FileWrapper import os def download(request): file_path = '/djangowebproject1/text_file/hello.txt' try: wrapper = FileWrapper(open(file_path, 'rb')) response = HttpResponse(wrapper, content_type='text/plain') response['Content-Disposition'] = 'inline; filename=' + os.path.basename(file_path) return response except Exception as e: return None So, what I exactly wants is to download file like what we do in html by just redirecting at the file location Like: /text_file/hello.txt When I try with the above approach it shows : The view app.views.download didn't return an HttpResponse object. It returned None instead.. Please help me. I am just begineer in the Django. Thanks in advance. -
getting sum in django
I am trying to get the sum of posts and likes. But getting some errors.I am not sure whether to use aggregate or annotate. def count_posts_of(user): return Post.objects.filter(author=user).count() def total_likes_received(user): return user.posts.aggregate(total_likes=Count('likes'))['total_likes'] or 0 def get_queryset(self): return (Post.objects.filter(published_date__lte=timezone.now()) .order_by('date') .annotate(author_total_likes = (Count('author__posts__likes'), Post.count_posts_of)) ) -
Sending email with attached .ods File
send_mail('Subject here', 'Here is the message.', 'selva@gmail.com', ['stab@gmail.com'], fail_silently=False) mail = send_mail('Subject here', 'Here is the message.', 'selvakumaremmy@gmail.com', ['vsolvstab@gmail.com'], fail_silently=False) mail.attach('AP_MODULE_bugs.ods','AP_MODULE_bugs.ods','application/vnd.oasis.opendocument.spreadsheet') mail.send() I'm using Django send_mail class for sending mail. Here I want to send mail with attachment, my attachment File (.ods) is in local storage. -
How to save post into Django (2.0) like I bookmarked it
How to save a post into Django (2.0) like I bookmarked that post for later usage. I need to implement it into one of my project. -
Django Crispy forms hide fields conditional on other field value
How can I hide/show a form field in Django crispy forms based on the value of another field in the form. E.g. Field A has a dropdown with choices '1' and '2' Field B is show when Field A = '1' Field C is shown when Field A = '2' All other fields are shown in regular ways I've tried multiple query/javascript solutions from the forums, but they don't seem to work on crispy forms. jQuery/Javascript method to show/hide multiple fields upon selection with common fields to multiple selections Show and hide dynamically fields in Django form Django crispy form - use Radio button to hide/show other fields Maybe I'm misunderstanding these solutions or they just won't work on Crispy forms. My code Models.py class TestCondition(models.Model): some_name = models.ForeignKey(key_name, on_delete=models.CASCADE) A_type_choices = ( ('1','1'), ('2','2'), ) Field_A = models.CharField(max_length=20,choices= A_type_choices,default='1') B_field_choices = ( ('abc','ABC'), ('cba','CBA'), ) Field_B = models.CharField(max_length=20,choices= B_field_choices,default='abc',blank=True,) Field_C = models.CharField(max_length=40, blank=True, default='') views.py class ViewUpdateTestCondition(LoginRequiredMixin,UpdateView): model = TestCondition template_name = 'update.html' form_class = TestConditionForm class TestConditionForm(ModelForm): class Meta: model = TestCondition fields = ('some_name','Field_A','Field_B','Field_C') def __init__(self, *args, **kwargs): super(ModelconfigForm, self).__init__(*args, **kwargs) self.helper = FormHelper(form=self) self.helper.form_class = 'form-horizontal' self.helper.label_class = 'col-lg-2' self.helper.field_class = 'col-lg-8' self.helper.form_method = 'post' # ... -
Django: can't display formset and form proper
Good day, I need a little help with a code or advice. I'm making site for applications. And have two models: Applications and Guests and they have manytomany connection, because application can have 2 or more guests and 1 guest may be in many applications. For making applications i use formset_factory with delete option. The problem is - I can't find any good examples with code for manytomanyfield and formset and I can't bound them in template. I can't display the table at all. Here's the code. p.s. don't pay attention to cyrillic symbols p.p.s i'm only studying models class Guests(models.Model): unique_number_guest = models.IntegerField(unique=True, primary_key=True, verbose_name='№') organisation = models.CharField(max_length=100, verbose_name='Организация', null=True) full_name = models.CharField(max_length=100, verbose_name='ФИО') position = models.CharField(max_length=100, verbose_name='Должность', blank=True, null=True) chosen = models.BooleanField(default=False, verbose_name='Выбран') class Applications(models.Model): ntc_cabins = ( ('2-5', '2-5'), ('2-10', '2-10'), ('2-12', '2-12'), ) ntc_blocks = ( ('ЦОК', 'ЦОК'), ('БМЗ', 'БМЗ') ) unique_number_app = models.IntegerField(unique=False, null=True) visit_date = models.DateField(default=date.today()+timedelta(days=1), verbose_name='Дата:') visit_time = models.TimeField(default='12:00', verbose_name='Время:') cabin = models.CharField(max_length=5, verbose_name='Кабинет:', choices=ntc_cabins, default='2-12') block = models.CharField(max_length=10, verbose_name='Корпус:', choices=ntc_blocks, default='ЦОК') author = models.CharField(max_length=100, verbose_name='Автор:') guests = models.ManyToManyField(Guests) views def ApplicationFormation(request): form = ApplicationsForm(request.POST) form.guest_instanses = GuestsFormSet(request.POST) if request.method == "POST": if form.is_valid(): applications = Applications() applications.cabin = form.cleaned_data['cabin'] applications.save() for person ... -
Login cannot be done in my app
Login cannot be done in my app.I wrote in views.py from django.shortcuts import render,redirect from django.urls import reverse from app.forms import RegisterForm,LoginForm from app.models import Data from app.forms import DataForm from django.db.models import Q def index(request): data = Data.objects.order_by('-created_at') form = RegisterForm() loginform = LoginForm() dataform = DataForm() return render(request, 'index.html',{'data':data,'form':form,'loginform':loginform,'dataform':dataform,'user': request.user}) in index.html <section id="top"> {% if user and not user.is_anonymous %} <p>Hello</p> <h3>{{ user.username }}</h3> {% else %} <form action="{% url 'app:index' %}" method="POST"> {{ loginform.non_field_errors }} {% for field in loginform %} {{ field }} {{ field.errors }} {% endfor %} <button type="submit">LOGIN</button> {% csrf_token %} </form> {% endif %} </section> in forms.py from django import forms from django.contrib.auth.forms import ( AuthenticationForm ) class LoginForm(AuthenticationForm): def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs) for field in self.fields.values(): field.widget.attrs['class'] = 'form-control' field.widget.attrs['placeholder'] = field.label in child's app's urls.py from django.urls import include, path from . import views from django.contrib.auth.views import login app_name = 'app' urlpatterns = [ path('index', views.index,name='index'), ] in parent's app's urls.py from django.contrib import admin from django.urls import path,include urlpatterns = [ path('admin/', admin.site.urls), path('app/',include('app.urls') ), ] When I login from loginform,if statement of {% if user and not user.is_anonymous %} did not become true.But when I ...
