Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
How to insert PDF table data into database
I have extracted pdf table data by using Camelot but now how can I do put my table data into my database like do I need to convert it into CSV? like is there any other way to put it into my database? and is there any other way to choose my specific tables or just put the number of the tables. cause in here I need to specify my table no. to be extracted. ''' def tables_extract(file_name): filename_with_path = 'upload/media/pos/pdfs/{}'.format(file_name) tables = camelot.read_pdf(filename_with_path, pages="1-end") table= tables[2].df ''' Below is the table data in the pdf which I want to put the values into my DB -
Receving a NoReverseMatch error in Django with Python
I am currently working on a tutorial in the "Python Crash course" Book. The tutorial is about creating a "Learning Log" Webapp with Django. The idea of the app is to allow users to: 1. create "Topics" they have learned about 2. add "Entries" to those Topics, describing details they have learned specific to those topics I am currently stuck at creating an Entry form and receive an Error, when I run http://127.0.0.1:8000/new_entry/1 NoReverseMatch at /new_entry/1 Reverse for 'topic' with arguments '('',)' not found. 1 pattern(s) tried: ['topics/(?P<topic_id>[0-9]+)/$'] Request Method: GET Request URL: http://127.0.0.1:8000/new_entry/1 Django Version: 3.0.5 Exception Type: NoReverseMatch Exception Value: Reverse for 'topic' with arguments '('',)' not found. 1 pattern(s) tried: ['topics/(?P<topic_id>[0-9]+)/$'] Exception Location: C:\Users\DR\Desktop\learning_log\ll_env\lib\site-packages\django\urls\resolvers.py in _reverse_with_prefix, line 677 Python Executable: C:\Users\DR\Desktop\learning_log\ll_env\Scripts\python.exe Python Version: 3.8.2 Python Path: ['C:\\Users\\DR\\Desktop\\learning_log', 'C:\\Program ' 'Files\\WindowsApps\\PythonSoftwareFoundation.Python.3.8_3.8.752.0_x64__qbz5n2kfra8p0\\python38.zip', 'C:\\Program ' 'Files\\WindowsApps\\PythonSoftwareFoundation.Python.3.8_3.8.752.0_x64__qbz5n2kfra8p0\\DLLs', 'C:\\Program ' 'Files\\WindowsApps\\PythonSoftwareFoundation.Python.3.8_3.8.752.0_x64__qbz5n2kfra8p0\\lib', 'C:\\Users\\DR\\AppData\\Local\\Microsoft\\WindowsApps\\PythonSoftwareFoundation.Python.3.8_qbz5n2kfra8p0', 'C:\\Users\\DR\\Desktop\\learning_log\\ll_env', 'C:\\Users\\DR\\Desktop\\learning_log\\ll_env\\lib\\site-packages'] Server time: Wed, 15 Apr 2020 19:46:06 +0000 The forms.py file: from django import forms from .models import Topic, Entry class TopicForm(forms.ModelForm): class Meta: model = Topic fields = ['text'] labels = {'text': ''} class EntryForm(forms.ModelForm): class Meta: model = Entry fields = ['text'] labels = {'text': ''} widgets = {'text': forms.Textarea(attrs={'cols': 80})} The urls.py file: from django.urls … -
What is the difference between Serializer and ModelSerializer
What is the difference between django rest framework's Serializer vs ModelSerializer? When do you one or the other? Can I use ModelSerializer for Auth? Thanks a lot for the help. -
What do I set as a default parameter when customizing models.py in Django?
I'm trying to ask the user for their city, state and zip when signing up. In my models.py I have: class Profile(models.Model): ... city = models.CharField(max_length=50) state = models.CharField(max_length=3) zip = models.CharField(max_length=5) I'm getting the following error when migrating: You are trying to add a non-nullable field 'city' to profile without a default; we can't do that (the database needs something t o populate existing rows). Please select a fix: 1) Provide a one-off default now (will be set on all existing rows with a null value for this column) 2) Quit, and let me add a default in models.py Select an option: What should I put as a method parameter? I tried default=None, but that gives an error too. -
Change Django modelForm Foreign Key field to Text Field
I have to generate a form for adding member to model which is Foreign Key to User model. It gives me dropdown field, how can i make it a charfield. -
redirect url with primary key DJANGO
Hei, So i have list with some recipes and i wish that user after clicking on recipe would be redirect to view with more details. With different words i wish that every recipe has his own url. I am trying this code as below, but it does not work, it redirect 404 side after i click on recipe. View: def GenerallView(request): lista1 = Recipe.objects.all() return render(request, 'drinks/GenerallView.html', {'lista1': lista1}) def DetailView(request, pk): lista = get_object_or_404(Recipe, pk=pk) return render(request, 'drinks/DetailView.html', {'lista': lista}) Url: path('generall_view', views.GenerallView, name='GenerallView'), path('detail_view/<int:pk>', views.DetailView, name='DetailView'), Templates: generall view <ul> {% for drink in lista1 %} <li><a href="{% url 'detail_view' Recipe.pk %">{{ drink.recipe_name }}</a></li> {% empty %} <li>No notes yet.</li> {% endfor %} </ul> detail view <h1>{{ recipe.name }}</h1> -
How to evaluate the object type an individual message in the django message framework
I am attempt to write a comprehensive message handling and display framework for Django. As a result I want to handle for messages that are of different object types. Some maybe a string others maybe a dictionary. e.g. consider this trivial example messages.error(request, form.errors.as_json()) messages.warning(request, "error 2") messages.info(request, 'error 3') an example of a form error could be. add_error('username',ValidationError('User does not exist', code=40)) now if you loop through the messages dictionary you get the following output to the console: {"username": [{"message": "User does not exist", "code": 40}]} error 2 error 3 Now we just need to loop through the messages dictionary and format the message for display. For this I plan to use a customer filter. The challenge is that when evaluating the object type of the message they are all coming back as strings. Even thought the first message is a dictionary object. print (type(error.message)) returns (for all the messages) <class 'str'> I suspected that the dictionary was being returned as a string. '{"username": [{"message": "User does not exist", "code": 40}]}'. Hence I tired using literal_eval. Following is the full draft of the template filter.: from django import template from ast import literal_eval register = template.Library() @register.filter() def format_err(error): … -
Not getting any data in POST request in views django admin
I'm trying to get a value from a select option in django view but not getting any value in post request: my HTML looks like <form method="post"> <select class="custom-select" title="region_list" value="{{ region }}"> <option selected>Open this select menu</option> {% for i in region_id %} <li><option value="{{ i.region }}">{{ forloop.counter }}. {{ i.region }}</option></li> {% endfor %} </select> <input type="submit" value="submit"> </form> and my view file looks like : class updateOrderType(View): template_view = 'admin/custom_orders_all.html' @csrf_exempt def dispatch(self, request, *args, **kwargs): return super().dispatch(request, *args, **kwargs) def get(self, request): region_id = list(UserRegionMapping.objects.filter(user=request.user.id).values_list('region_id', flat=True)) store_list=list(StoreRegionMapping.objects.filter(region__id__in=region_id).values_list('store_id__name', flat=True)) region_name = UserRegionMapping.objects.filter(user=request.user.id) # store_id=Order.objects.filter(id=ixd).values_list('store_id') return render(request, self.template_view, {'region_id': region_name, 'store_list':store_list}) @csrf_exempt def post(self, request): data=request.POST in this I'm not getting any data in "data=request.POST". -
delete and modify comments by users
i've added to my Blog post comments now the problem is that i'm trying to create remove function for that and i have one but now eve uset thak is logged in can remove all the comments how can i fix this that user can delete only their own comments?? the funnyiest thing is that i have this function on my posts and it wokres and if i'm trying to do the same on my comments then i've get 404 error. Ive tried a few different ways but nothing worked You are my only hope:) views.py from django.shortcuts import render, get_object_or_404, redirect from django.views.generic import ListView, DetailView, CreateView, UpdateView, DeleteView from django.contrib.auth.models import User from .models import Post, Comment from django.contrib.auth.mixins import LoginRequiredMixin, UserPassesTestMixin from .forms import CommentForm from django.contrib.auth.decorators import login_required # Create your views here. def home(request): context = { 'posts': Post.objects.all() } return render(request, 'blog/home.html', context) class PostListView(ListView): model = Post template_name = 'blog/home.html' context_object_name = 'posts' ordering = ['-date_posted'] paginate_by = 5 class UserPostListView(ListView): model = Post template_name = 'blog/user_posts.html' context_object_name = 'posts' ordering = ['-date_posted'] paginate_by = 5 def get_queryset(self): user = get_object_or_404(User, username=self.kwargs.get('username')) return Post.objects.filter(author=user).order_by('-date_posted') class PostDetailView(DetailView): model = Post class PostCreateView(LoginRequiredMixin, CreateView): model … -
Django ORM - How to order objects by sum of three highes scores?
Suppose my Django users participate in different contests, where they score points. Every User has around 100 different contests in which he participated. How can I query the users model in a view to retrieve the list of users, ordered by the sum of their three heights contest scores? As I want to pass on certain filters from the view to the contest (country, year), I am trying to avoid writing raw SQL. -
Spotipy on Django authorization without copy-paste to console
I have a Django site in which I want to use spotipy to look for statistics of the song like popularity and views. I have this code right now: import spotipy import spotipy.util as util #luxury import json import webbrowser username = 'dgrqnco2rx8hdu58kv9if9eho' scope = 'user-read-private user-read-playback-state user-modify-playback-state' token = util.prompt_for_user_token(username, scope, client_id='08bb526962574a46b359bffc56048147', client_secret='bf6d4184c8ae40aca207714e02153bad', redirect_uri='http://google.com/') sp_obj = spotipy.Spotify(auth=token) ss = 'name of song' if ss.__contains__('('): q = ss[0:ss.index('(')] elif ss.__contains__('['): q = ss[0:ss.index('[')] elif ss.__contains__('['): q = ss[0:ss.index('{')] else: q = ss query = sp_obj.search(q, 1, 0, 'track') #<<<<<<<<<<SONG>>>>>>>>>> #FIND THE SONG URI song_uri = query['tracks']['items'][0]['uri'] track = sp_obj.track(song_uri) track_data = sp_obj.audio_features(song_uri) song_popularity = track['popularity'] song_danceability = track_data[0]['danceability'] song_energy = track_data[0]['energy'] song_loudness = track_data[0]['loudness'] song_tempo = track_data[0]['tempo'] However spotipy redirects me to a page for authorization and I need to paste the url in the console. The regular user however does not have access to this console. So how can I do the authorization in an alternative way or even bypass it? I was thinking about getting a spotify account in which every user will be getting logged in so that the user won't have to do the authorization and won't have to have a spotify account. Is this possible? … -
Unloading Data from Redshift to Amazon S3 | Django ORM
I'm looking for the best approach to work with Amazon S3 and Amazon Redshift. I need to unload the data from amazon Redshift and store it into S3. According to the AWS documentation, is truly simply to save the data to S3 https://docs.aws.amazon.com/redshift/latest/dg/t_Unloading_tables.html But I want to know if there's any way to do this using Django ORM, since also has support to Psycopg2. Thanks regards. -
Python 3 Django Rest Framework - Manager object has no attribute error
My custom EnrollmentManager says object has no attribute "end_date" - except it does!? class EnrollmentManager(models.Manager): def org_students_enrolled(self, organisation): return self.filter(student__organisation__name=organisation).filter(self.end_date.date() >= datetime.date.today()) class Enrollment(TimeStampedModel): objects = EnrollmentManager() course = models.ForeignKey(to=Course, on_delete=models.CASCADE, default=None, null=False) student = models.ForeignKey(to=Student, on_delete=models.CASCADE, default=None, null=False) enrolled = models.DateTimeField() last_booking = models.DateTimeField() credits_total = models.SmallIntegerField(default=10) credits_balance = models.DecimalField(max_digits=5, decimal_places=2) @property def end_date(self): return self.enrolled + datetime.timedelta(days=182) -
Nginx Configuration in Docker
I am trying to configure nginx inside docker container. However I can't reach my server ip without defining port number (8000). It seems nginx can't listen on 80 port or something. I almost tried every solution on internet but it still same. Here is my docker-compose.yml: version: '3' services: app: build: context: . ports: - "8000:8000" env_file: - django.env volumes: - ./app:/app - /static:/static command: > sh -c "python3 manage.py migrate && python3 manage.py wait_for_db && gunicorn app.wsgi -b 0.0.0.0:8000" environment: - DB_HOST=db - DB_NAME=app - DB_USER=postgres - DB_PASS=supersecretpassword depends_on: - db db: image: postgres:10-alpine environment: - POSTGRES_DB=app - POSTGRES_USER=postgres - POSTGRES_PASSWORD=supersecretpassword ports: - "5432:5432" volumes: - pgdata:/var/lib/postgresql/data - pgconf:/etc/postgresql - pglog:/var/log/postgresql nginx: build: ./nginx ports: - "10080:80" - "10443:443" volumes: - ./app:/app - ./config/nginx:/etc/nginx/conf.d - /static:/static expose: - "8000" depends_on: - app volumes: pgdata: driver: local pgconf: driver: local pglog: driver: local and nginx configuration: upstream app { ip_hash; server my_server_ip:8000; } server { location /static { autoindex on; alias /static/ } location / { proxy_pass http://app; } listen 80; server_name my_server_ip; } Thank you for your help. -
How do i fix "Failed to initiate tests: Expected [:url, "https://github.com/heroku/heroku-buildpack-python"] to respond to #to_hash" error?
I'm trying to use CI on Heroku to run automatic testing of my Django app. I am not using any special software just: python manage.py test I had gotten the tests to run a few times, but realized they used sqlite3 (which also caused some errors), and so I found out I need to make an app.json-file to get postgres to work with tests, which I have done. But I must have made a mistake: I'm now completely stuck on the following error: Failed to initiate tests: Expected [:url, "https://github.com/heroku/heroku-buildpack-python"] to respond to #to_hash My app.json file that configures the test-environment looks like this now (but I have tried many variations): { "environments": { "test": { "image": "heroku/python", "buildpacks": { "url": "https://github.com/heroku/heroku-buildpack-python" }, "addons": ["heroku-postgresql:in-dyno"], "scripts": { "test-setup": "python manage.py collectstatic", "test": "python manage.py test" } } } } I'm at the end of my wits. I have no idea what this means. And there are like 8 results in google for "Expected [:url, "https://github.com/heroku/heroku-buildpack-python"] to respond to #to_hash", and none of them seemingly have anything to do with this. -
How can i save same selected name in multiple forms in Django
I created model which have 3 different foreign key and created four forms with same model and i'm trying to store same emplooyeename in multiple form which is not storing. Mentioned all detailed in down hope you can understand. Models.py class UserTimezone(models.Model): employeename = models.ForeignKey(Enrollment,db_column='EmployeeName',related_name="enrollment", on_delete=models.SET_NULL,null=True) on_delete=models.SET_NULL,null=True) doorname = models.ForeignKey(DoorInfo,db_column='DoorName',related_name="doornames",on_delete=models.CASCADE) timezonename = models.ManyToManyField(TimeZone,db_column='TimezoneName', related_name="timezone") Forms.py Here i made four forms with same model. class UserTimezoneForm1(forms.ModelForm): class Meta: model = UserTimezone fields = "__all__" def __init__(self, *args, **kwargs): super(UserTimezoneForm1, self).__init__(*args, **kwargs) self.fields['timezonename'].widget = CheckboxSelectMultiple() self.fields['timezonename'].queryset = TimeZone.objects.all() class UserTimezoneForm2(forms.ModelForm): class Meta: model = UserTimezone fields = "__all__" # widgets = {'employeename': forms.HiddenInput()} exclude = ["employeename"] def __init__(self, *args, **kwargs): super(UserTimezoneForm2, self).__init__(*args, **kwargs) self.fields['timezonename'].widget = CheckboxSelectMultiple() self.fields['timezonename'].queryset = TimeZone.objects.all() class UserTimezoneForm3(forms.ModelForm): class Meta: model = UserTimezone fields = "__all__" exclude = ["employeename"] def __init__(self, *args, **kwargs): super(UserTimezoneForm3, self).__init__(*args, **kwargs) self.fields['timezonename'].widget = CheckboxSelectMultiple() self.fields['timezonename'].queryset = TimeZone.objects.all() Views.py Tried to cleaned employeename data in all form but storing only first form value. def usertimezone(request,*args,**kwargs): user_data = UserTimezone.objects.all() if request.method == "POST": form1 = UserTimezoneForm1(request.POST,prefix='form1') if form1.is_valid(): obj = UserTimezone() obj.employeename = form1.cleaned_data["employeename"] obj.doorname = form1.cleaned_data['doorname'] form1.save() form2 = UserTimezoneForm2(request.POST,prefix='form2') form1 = UserTimezoneForm1(request.POST,prefix='form1') if form2.is_valid(): obj = UserTimezone() #obj.employeename = form2.cleaned_data["employeename"] obj.doorname = form2.cleaned_data['doorname'] form2.save() … -
Tf objection detection API deployment on django
I am currently trying to serve into a webapp build in Django however I am facing some difficulties. 1. I have succesfully trained my model and I have the precious frozen_inference_graph. 2. I am creating the webapp on django. I would like to call my model directly from my webapp folder. However, when using the inference method from my webapp folder, no inference is done: there is not bug and the script does nothing . In my tf folder, the script does the proper inference. Do you have any clues? Also I have not found any tutorial for serving tensorflow on Django, are you aware of some? Thanks, Have a nice day ! -
How can I query over a manyTOmany model field correctly?
Alright so here's what I am trying to do, as a developer noobie. I am attempting to create an inbox for a user. I have a Conversation model that has a many to many field and then I have an InstantMessanger model the has sender_id, date, and a receiver_id field that is a foreign key to Conversation. What I am attempting to do is iterate over Conversation first and display the members whom the user has had convo's with and then display a link to where it takes you to the actual contents of that message. However, I'm stuck at getting the members to even display. I've tried a number of things here and looked around, but I keep getting errors such as 'conversation' model is not iterable or displaying but displaying as 'dating_app.Profile.none`, the object, and so forth. So I'm pretty stuck here and not sure how to do this. What's the right way to do this? views.py def messages(request,profile_id): messages = InstantMessage.objects.filter(Q(sender_id=request.user)).\ values('sender_id','receiver_id', 'message', 'date', ).\ order_by('date',) profile = get_object_or_404(Profile,id=profile_id) conversations = Conversation.objects.filter(members=request.user) return render(request, 'dating_app/messages.html', {'messages': messages,'profile': profile,'conversations':conversations,}) messages.html {% for conversation in conversations %} <li class="text-right list-group-item"> {% for members in conversation %}{% if members != … -
Standard Python VS "New Projects" don't work in Azure
I am trying to create a Python Azure App Service. I have created a number of Python projects (using the normal "File, New Project" in Visual Studio). I haven't changed the solutions or projects in any way (except for creating the required virtual environment for each). I've included a number of flavors of Flask, Bottle and Django projects. For each, after using the VS Publish command, I deploy from the Azure Deployment Center using the Azure repo and the Kudu build. I've also tried the same from VS2017 and VS2019. They all work fine on my local computer (showing Hello World or something similar). They all fail in the exact same way after deploying to Azure. Browsing to the site shows: You do not have permission to view this directory or page. The error log shows: HTTP Error 403.14 - Forbidden As a control, I created and published two different flavors of ASP.NET applications. They both worked fine on my local computer AND on Azure. So, it seems like it must be something Python- or Linux-specific. I've been working and searching on this for a couple of days and haven't found anything. Any suggestions would be greatly appreciated. Bill -
How to export local postgres db with schema and contents to production db
I have a local Postgres db, I would like to use this Db along with the contents in a production db for app. How do I migrate the local db to my nginx production server? -
Django on_delete parameter exists on local code but not on server code
For example, here is my actual code. category = models.ForeignKey(Category, verbose_name=_("Category"), blank=True, null=True, on_delete=models.CASCADE) But on the server (I use pythonanywhere to deploy my code) it has some kind of application error. The error messages are: 2020-04-15 07:12:30,651: Error running WSGI application 2020-04-15 07:12:30,669: TypeError: __init__() missing 1 required positional argument: 'on_delete' 2020-04-15 07:12:30,670: File "/var/www/misterfish_pythonanywhere_com_wsgi.py", line 34, in <module> 2020-04-15 07:12:30,672: application = get_wsgi_application() 2020-04-15 07:12:30,673: 2020-04-15 07:12:30,673: File "/home/misterfish/.virtualenvs/myenv/lib/python3.8/site-packages/django/core/wsgi.py", line 12, in get_wsgi_application 2020-04-15 07:12:30,673: django.setup(set_prefix=False) 2020-04-15 07:12:30,673: 2020-04-15 07:12:30,673: File "/home/misterfish/.virtualenvs/myenv/lib/python3.8/site-packages/django/__init__.py", line 24, in setup 2020-04-15 07:12:30,673: apps.populate(settings.INSTALLED_APPS) 2020-04-15 07:12:30,673: 2020-04-15 07:12:30,674: File "/home/misterfish/.virtualenvs/myenv/lib/python3.8/site-packages/django/apps/registry.py", line 114, in populate 2020-04-15 07:12:30,674: app_config.import_models() 2020-04-15 07:12:30,674: 2020-04-15 07:12:30,674: File "/home/misterfish/.virtualenvs/myenv/lib/python3.8/site-packages/django/apps/config.py", line 211, in import_models 2020-04-15 07:12:30,674: self.models_module = import_module(models_module_name) 2020-04-15 07:12:30,674: 2020-04-15 07:12:30,674: File "/home/misterfish/.virtualenvs/myenv/lib/python3.8/site-packages/quiz/models.py", line 45, in <module> 2020-04-15 07:12:30,675: class SubCategory(models.Model): 2020-04-15 07:12:30,675: 2020-04-15 07:12:30,675: File "/home/misterfish/.virtualenvs/myenv/lib/python3.8/site-packages/quiz/models.py", line 51, in SubCategory 2020-04-15 07:12:30,675: category = models.ForeignKey( Clearly the server didnt recognize there is a on_delete method. It took me some time to figure out there might be something wrong with the server code. So I look into it. quiz = models.ManyToManyField(Quiz, verbose_name=_("Quiz"), blank=True) category = models.ForeignKey(Category, verbose_name=_("Category"), blank=True, null=True) sub_category = models.ForeignKey(SubCategory, verbose_name=_("Sub-Category"), blank=True, null=True) figure = models.ImageField(upload_to='uploads/%Y/%m/%d', … -
django how to perform query on two models?
i have two models 'Post' and 'Like' which are in foreignkey relation. if i want to list all post(published=True) with number of likes of each post how to do in django query. Post.objects.filter(published=True).?.....join(count likes) -
Django CRUD - create and update view doesn't work
I'm really new to Django and I want to teach myself by making a simple note. I maked a simple form for creating a new note but I don't know how to make this just for the user is logged in. What I mean is that I want the user field from the creationNoteForm to be removed and the note to be sumbitted automatically for the person who is logged in. Hope that I was clear enough. Here is my "view.py": from django.shortcuts import render, redirect from django.contrib.auth.forms import UserCreationForm from django.contrib.auth.models import User from django.contrib.auth import authenticate, login, logout from .forms import CreateUserForm, CreateNoteForm from django.contrib import messages from django.contrib.auth.decorators import login_required from .models import * # Create your views here. def loginPage(request): if request.method == 'POST': username = request.POST.get('username') password = request.POST.get('password') user = authenticate(request, username=username, password=password) if user is not None: login(request, user) return redirect('home') else: messages.info(request, 'Username or pasword is incorrect') context = {} return render(request, 'accounts/login.html', context) def registerPage(request): form = CreateUserForm() if request.method == 'POST': form = CreateUserForm(request.POST) if form.is_valid(): form.save() user = form.cleaned_data.get('username') messages.success(request, 'Account was created for '+ user) return redirect('home') context = {'form': form} return render(request, 'accounts/register.html', context) def logoutUser(request): logout(request) … -
making proxy authentication server in Django
I want to make a proxy server in python django (3.0) like the one at the following link: https://blogs.oracle.com/wssfc/handling-proxy-server-authentication-requests-in-java -
Converting HTML to Draft-JS ContentState in Python/Django
I'm migrating from using a html wysiwyg editor (CKEditor) to using Draft-JS and want to be able to convert existing HTML data into Draft-JS ContentState in a Django Migration but I've been unable to find a way to do this. Is this possible? Or is this even the correct approach?
