Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
'42S02', "[42S02] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name django
I am trying to make access a table in my database but this error always occurs although a tried to access another table in the same schema and it worked PS: When I inspected the database a model of the table that I want was not created so I manually inspected it using python manage.py tableName --databse=DataAdmin > model.py it worked but the problem was not solved class Rfde2003Syd0827(models.Model): pe = models.CharField(db_column='PE', max_length=30, blank=True, null=True) # Field name made lowercase. pe_physical_interface = models.CharField(db_column='PE_PHYSICAL_INTERFACE', max_length=30, blank=True, null=True) # Field name made lowercase. pe_channel_interface = models.IntegerField(db_column='PE_CHANNEL_INTERFACE', blank=True, null=True) # Field name made lowercase. ts_usid = models.CharField(db_column='TS_USID', max_length=30, blank=True, null=True) # Field name made lowercase. ts_dna = models.IntegerField(db_column='TS_DNA', blank=True, null=True) # Field name made lowercase. new_pe = models.CharField(db_column='NEW_PE', max_length=30, blank=True, null=True) # Field name made lowercase. new_pe_physical_interface = models.CharField(db_column='NEW_PE_PHYSICAL_INTERFACE', max_length=30, blank=True, null=True) # Field name made lowercase. class Meta: managed = False db_table = 'RFDE2003SYD0827' -
Display image in dropdown list in django
I am bigenner to django ,I work on project that let user to rate countries in dropdown list, How I can display flag of each country in dropdown list of countries in django ? -
Dynamic linear interpolation between multiple HTML input field values with JavaScript
I'm trying to make a dynamically generated array of input fields where only the first and the last are editable. When either of the border fields are modified, the remaining should update their values by linearly interpolating between the two border values. Example below. I have written a (Django/Bootstrap) HTML template which generates the input fields themselves, and leaves only the border fields editable and assigns "-first" and "-last" id extensions. I have also written a basic JavaScript which takes two input values to interpolate between and output array size. This is how the input fields are instantiated. I started writing a JS function "change_values()" which would be activated on onchange event, but got nowhere. <div class="custom-control custom-linspace-field"> <div class="row" id="linspace-field"> {% for field in fields %} <div class="col p-1"> {% if forloop.first %} <input type="text" class="form-control" onchange="change_values()" id="linspace-field-first" value="{{ field | floatformat:3 }}" placeholder="min"> {% elif forloop.last %} <input type="text" class="form-control" onchange="change_values()" id="linspace-field-last" value="{{ field | floatformat:3 }}" placeholder="max"> {% else %} <input type="text" class="form-control" onchange="change_values()" id="linspace-field" value="{{ field | floatformat:3 }}" readonly> {% endif %} </div> {% endfor %} </div> </div> This is my linear interpolation JS script: function lerp(value1, value2, amount) { step = (value2 - value1) … -
DRF filter self foreign key
I have model as follows: class Category(models.Model): name = models.CharField(max_length=100) slug = models.SlugField(max_length=100, unique=True, blank=True) parent = models.ForeignKey('self', on_delete=models.SET_NULL, null=True, blank=True) and I have to filter according to parent my view looks like this class CategoryView(generics.ListCreateAPIView): queryset = Category.objects.all() serializer_class = CategorySerializer lookup_field = 'slug' name = 'category-list' filter_fields = ('name', 'parent_id') search_fields = ('^name',) ordering_fields = ('name',) as it can be seen from the view in filter_fields there is parent_id but it does not work if I select parent it returns nothing except [ ]. If I write get_queryset() def get_queryset(self): return Category.objects.filter( Q(parent_id=1) ) it returns objects whose id is 1. But I do not need to write id in numbers because in front end id can be in any number like 1, 2, 3, ... etc it should detect automatically that's why it should filter by id. Now I have no idea how to do it. Any idea please? Thanks in advance! -
TemplateDoesNotExist at / error, even though index.html exists in the stated folder
Following up on [https://realpython.com/location-based-app-with-geodjango-tutorial/] and implementing the nearby shops app. However getting a TemplateDoesNotExist at/, even though the file exists in the stated folder. Tried out solutions: Created subdirectory(templates) in the 'shops' app Changed DIRS in settings.py settings.py TEMPLATES = [ { 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [''], 'APP_DIRS': True, 'OPTIONS': { 'context_processors': [ 'django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', ], }, }, ] Also, Template postmortem states: Template-loader postmortem Django tried loading these templates, in this order: Using engine django: django.template.loaders.filesystem.Loader: /home/username/sampleShops/nearbyshops/nearbyshops/shops (Source does not exist) django.template.loaders.app_directories.Loader: /home/username/.local/lib/python3.6/site-packages/django/contrib/admin/templates/nearbyshops/shops (Source does not exist) django.template.loaders.app_directories.Loader: /home/username/.local/lib/python3.6/site-packages/django/contrib/auth/templates/nearbyshops/shops (Source does not exist) django.template.loaders.app_directories.Loader: /home/username/.local/lib/python3.6/site-packages/django/contrib/gis/templates/nearbyshops/shops (Source does not exist) ` Moreso, I am not working in a virtual env(if that makes a difference, although it shouldn't) -
Accessing database table in Django view template
I expect this is a simple fix, but I've been unable to read objects from a SQLite database in my Django app in a particular instance. In /blog/views.py there are two functions defined, one to get all the instances of Article (index), and one to show some details of a particular Article (detail). detail is working as expected; i.e., I can navigate to localhost/xxxx/blog/1, and it will display the Article's title and description as expected. However, on the index page (which is routed to just localhost/xxxx/blog/), the object latest_article_list is not loaded, as "No articles are available" is displayed. The latter means that the routing is working, but it's just not reading Article.objects.all(). views.py from django.shortcuts import render, get_object_or_404 from .models import Article, Tags, Author def index(request): """ Will render templates/blog/index.html when called. This should show all articles. """ latest_article_list = Article.objects.all() return render(request, 'blog/index.html', {'latest_article_list': latest_article_list}) def detail(request, article_id): article = get_object_or_404(Article, pk=article_id) return render(request, 'blog/detail.html', {'article': article}) detail.html (working as expected, returns Article.title and Article.description for a given primary key) {% block content %} <br /> <h1> {{ article.title }} </h1> <p> {{ article.description }} </p> {% endblock %} index.html (not working as expected, if latest_article_list is evaluating … -
Work with selected data from a Select2 Remote Data dropdown
I have a select2 dropdown which loads remote data from a model in django. It loads correctly and now I want to work with the selected data. I want to add the selected query object to another db model. What's the best approach in this case? I did a lot of googling, but can't find any examples.. maybe I'm missing something? This is the current code: select2 box: <select class="js-data-ajax form-control"></select> jquery: $(document).ready(function(){ $(".js-data-ajax").select2({ tags: false, multiple: false, placeholder: "Select a product", // tokenSeparators: [',', ' '], minimumInputLength: 2, minimumResultsForSearch: 10, ajax: { url: '{% url 'inventory_json_data' %}', dataType: "json", type: "GET", params: { csrfmiddlewaretoken:'{{csrf_token}}', contentType: "application/json; charset=utf-8", }, data: function (params) { var queryParameters = { q: params.term } return queryParameters; }, processResults: function (data) { return { results: $.map(data, function (item) { return { text: item.product_name, id: item.pk } }) }; } } }); }); </script>``` -
Accessings fields directly in Django adminform template?
I have a ton of fields that I need to layout (reorder) in a specific way the form (with some other extra html stuff). I created change_form.html file for my model, which itself works. The problem is all examples are looping over the fields, I just want to refer to each field by name. # this works {% for fieldset in adminform %} {% for line in fieldset %} {% for field in line %} <p>{{ field.field }}</p> {% endfor %} {% endfor %} {% endfor %} I know you can customise the admin.ModelAdmin with fieldsets, etc.. But that's not what I want. I was trying different ways like below, but it doesn't work: # assuming the admin model has the fields: first_name & last_name {% block content %} <!-- doesn't work !!! -> {{ adminform.fieldsets.0.1.fields.first_name.field }} {{ adminform.fieldsets.0.1.fields.last_name.field }} <!-- neither does this --> {{ adminform.fields.first_name.field }} {{ adminform.fields.last_name.field }} {% endblock %} Now this doesn't work, is there any efficient way to directly access the fields I need? -
django url is loading in the console ,but the function in the view is not working
[26/Aug/2019 09:51:08] "GET /update HTTP/1.1" 200 32972 my basic url on the above and after ajax call below. [26/Aug/2019 09:51:11] "GET /updateline?client_response=true%20 HTTP/1.1" 200 32972 views.py def update_line(request): if request.method == 'GET': print("okey") #username = request.POST.get('username', None) label = ["INDIA", "PAK", "Europe", "Latin America", "North America"] data = json.dumps(label) return JsonResponse({"label":data}) jscript $("button").click(function(){ $.get( { url: '{% url "update_line" %}', //dataType: 'json', //method: "GET", data : { client_response : "true ", }, error: function(e){ alert('fail');}, success: function(data){ var dt =data.label alert(dt); addData(); }}); }); url.py urlpatterns = [ url(r'^$', views.HomePageView.as_view()),# views -Homepageview() url(r'chart', views.charts1,name='chart'), url(r'blank', views.blank_page,name='blank'), url(r'update', views.update_page,name='update'), url(r'updateline',views.update_line,name='update_line') #url(r'^$', views.HomePageView.as_view()), ] # -
How to update database in django using javascript
I want to update my django database using javascript. I searched a lot but i didn't get the relevant answer. Anyone help me to solve this problem class FriendList(models.Model): Friend = models.ForeignKey(SignUp,on_delete=models.CASCADE,default=None) Friend_name = models.CharField(max_length=30,default=None,blank=True) Status = models.CharField(max_length=20,default=None,blank=True,null=True) This is my model and I want to update Status field as either accepted or rejected when button is clicked. -
How to use next_page in Django URL path
I have two URL class views from django.contrib.auth: path('login/', auth_views.LoginView.as_view( template_name='accounts/login/login.html'), name='my_login'), path('logout/', auth_views.LogoutView.as_view( template_name='accounts/logout/logout.html', next_page=XXXX), name='my_logout'), What's the correct syntax to pass to next_page in the LogoutView? E.g.: next_page='accounts/login/' next_page='accounts/login/login.html' next_page=my_login next_page='my_login' next_page=reverse_lazy('my_login') -
update jsonfields in django model formsets with mongdb
I'm trying to create an editable bootstrap table where each cell represents a json value. I've defined a Django Model with this JSONField (not the Postgres's one) This is my Model: class Extracted_Tables(models.Model): ... content = JSONField(blank=True, null=True) My Template <tbody> {% for form in formset.forms %} <tr> {% for field in form %} {% if field.is_hidden %} <input type="hidden" >{{ field }}</input> {% else %} {% for k,v in field.value.items %} <td>{{v}}</td> {% endfor %} {% endif %} {% endfor %} </tr> {% endfor %} </tbody> This template renders the following HTML <tr> <td>Jamaica</td> <td>Kingston</td> <td>North America</td> <td>11424</td> <td>2500000</td> <input type="hidden"><input type="hidden" name="formset_1-0-id" value="353" id="id_formset_1-0-id"> </tr> To have a better idea on why it's not working: I've used a Django Model where my cells were this model's attributes. I had no problem editing the cells in this case as I was editing the model's fields This time, my cells are not the model's fields themselves: the only model field I have is a JSONField and I'm trying to edit the cells that are that json's values. Model: class Extracted_Variables(models.Model): variables = models.CharField(max_length=500) values = models.CharField(max_length=500) The Template: <tbody> {% for form in formset.forms %} <tr> {% for field in … -
How to force subquery in Django-ORM?
I have the following table: > select * from request_tripinterval order by id +-----+----------------------------+-------+------+-----------+---------+ | id | timestamp | path | time | params_id | trip_id | +-----+----------------------------+-------+------+-----------+---------+ | 411 | 2019-08-25 21:09:18.193870 | 47.0 | 67.0 | 1 | 1 | | 412 | 2019-08-25 21:09:18.311034 | 99.0 | 67.0 | 1 | 1 | | 413 | 2019-08-25 21:09:18.436022 | 66.0 | 67.0 | 1 | 1 | | 414 | 2019-08-25 21:09:18.544529 | 44.0 | 67.0 | 1 | 1 | | 415 | 2019-08-25 21:09:18.636328 | 16.0 | 67.0 | 1 | 1 | | 416 | 2019-08-25 21:09:18.728114 | 18.0 | 67.0 | 1 | 1 | | 417 | 2019-08-25 21:09:18.802324 | 52.0 | 67.0 | 1 | 1 | | 418 | 2019-08-25 21:09:18.886299 | 92.0 | 52.0 | 1 | 1 | | 419 | 2019-08-25 21:09:18.977108 | 13.0 | 52.0 | 1 | 1 | | 420 | 2019-08-25 21:09:19.059118 | 5.0 | 26.0 | 1 | 1 | | 421 | 2019-08-25 21:09:19.134312 | 91.0 | 26.0 | 1 | 1 | | 422 | 2019-08-25 21:09:19.209511 | 75.0 | 87.0 | 1 | 1 | | 423 | 2019-08-25 … -
Does success_url in PasswordChangeView override PasswordChangeDoneView?
When using PasswordChangeView in Django auth: path('password_change/', auth_views.PasswordChangeView.as_view( template_name='accounts/password_change.html', success_url='accounts/password_change_success.html'), name='password_change'), Does the success_url override the PasswordChangeDoneView, as it does when success_url is passed in PasswordResetView and overrides PasswordResetDoneView? From the docs: PasswordResetDoneView This view is called by default if the PasswordResetView doesn’t have an explicit success_url URL set. The docs are silent on the behaviour between success_url in PasswordChangeView and PasswordChangeDoneView. -
Unable to filter, order and search the data for nested endpoints API
My API endpoint is http://127.0.0.1:7009/apps/2/versions I am unable to filter, order and search the particular version data models.py: class App(models.Model): app_id = models.CharField(max_length=40,help_text="app_id of the app",unique=True) name=models.CharField(max_length=40,help_text="name of the app") class AppVersion(models.Model): app_version = models.CharField(max_length=200) app_description = models.CharField(max_length=200,blank=True) Views.py : from django_filters.rest_framework import DjangoFilterBackend from rest_framework.filters import OrderingFilter,SearchFilter class AppVersionListView(mixins.ListModelMixin,mixins.CreateModelMixin,generics.GenericAPIView): lookup_field = 'pk' serializer_class = appVersionsSerializer queryset = AppVersion.objects.all() filter_backends = (DjangoFilterBackend, OrderingFilter,SearchFilter,) filter_fields = ('id','app_version','app_description ') ordering_fields = '__all__' search_fields =('app_version','app_description ') I want to filter the versions data based on "app_description" i.e., GET: http://127.0.0.1:7009/apps/2/versions?app_description =FileCommander Expected Output : Should filter the data and return results which is having that description [ { "apps": 2, "app_version": "v1", "app_description ":"FileCommander" }] Actual Output : [ { "apps": 2, "app_version": "v1", "app_description ":"FileCommander" }, { "apps": 2, "app_version": "v2", "app_description ":"cooking" }] How can I search , filter or order the versions data? -
Django's __ notation
Can anyone describe Django's __ notation. I didn't see any description in Django's documentation or in the internet. When I use this notations I heavily rely on ide's suggestion and intuition is it normal? -
How to fix " AttributeError at /api/doc 'AutoSchema' object has no attribute 'get_link' " error in Django
We are practicing an example of REST API on the Internet. However, the following error occurred. I tried a way in this link, but the situation hasn't changed. why swagger raises unclear error - Django from django.contrib import admin from django.conf.urls import url, include from rest_framework import routers from rest_framework_swagger.views import get_swagger_view import consumer.api app_name = 'consumer' router = routers.DefaultRouter() router.register('consumers', consumer.api.ConsumerViewSet) urlpatterns = [ url(r'^admin/', admin.site.urls), url(r'^api/doc', get_swagger_view(title='Rest API Document')), url(r'^api/v1/', include((router.urls, 'consumer'), namespace='api')), ] Exception Type: AttributeError at /api/doc Exception Value: 'AutoSchema' object has no attribute 'get_link' -
django, celery : create worker per user basis
Does it make sense (or not at all) to create a worker for each user logged in the website ? The idea came as a user may have some long tasks to execute but must be allowed to cancel them at will. And as there is no warranty that any task stops when it's asked with : revoke(task_id, terminate=True) according to the docs, even with abortable tasks (which does not allow to abort by task_id, with the risk also to terminate the worker. So, to prevent that unknown outcome, I thought of that solution which allows fine control on task execution without risk. Any advice is welcomed, thanks. -
Django allauth login/logout error: is_safe_url() missing 1 required positional argument 'allowed_hosts'
I'v implemented django-allauth on my local website for handling register/login/... things but i keep getting this error when try to login or logout: TypeError at /accounts/login/ is_safe_url() missing 1 required positional argument: 'allowed_hosts' my urls.py: urlpatterns = [ url(r'^admin/', admin.site.urls), url(r'^accounts/', include('allauth.urls')), ] all settings mentioned in here have been implied. -
Django 2: upload media to Google Cloud Storage with google-cloud-storage
I want to deploy Django app on Google Cloud (Google AppEngine and Cloud Sql). SO I need to store media files in Google CLoud Storage. I found this code in google docs: from google.cloud import storage client = storage.Client() # https://console.cloud.google.com/storage/browser/[bucket-id]/ bucket = client.get_bucket('bucket-id-here') # Then do other things... blob = bucket.get_blob('remote/path/to/file.txt') print(blob.download_as_string()) blob.upload_from_string('New contents!') blob2 = bucket.blob('remote/path/storage.txt') blob2.upload_from_filename(filename='/local/path.txt') I think I can use this in the views (for a FileField and an ImageField). But what should I do in my Django settings with MEDIA_ROOT in this case? -
Error encountered when generating numbers in series
In every post that will be posted by user, I want number to be generated from Integer field in series. I have encountered the error named "TypeError: unsupported operand type(s) for +: 'dict' and 'int'" How would I get rid off this error? views.py @login_required def Claim(request): max_val = Documents.objects.all().aggregate(Max('pay_no')) # then just make new object, and assign max+1 to 'that_field_in_question' control_number = Documents(pay_no=max_val + 1) control_number.save() return render(request,"loststuffapp/claim.html",context={"documents":Documents.objects.all()}) -
Write an API to get the average of sales done in the week
I have to write an API for finding the average of the sales done in current week and compare that number with the weekly average of last 52 weeks and return the difference. Can someone help me to write this API. You can assume that we have certain data in our database. I have tried my level best but unable to find from where i have to start. Please someone can help me for the same. -
use get and patch request in a single page in react
I'm making an edit invoice button and by that I'm trying that when user clicks on edit invoice button then a get request should get an id from database and fill and id into a hidden field and then a patch request runs when user edit the form and that hidden field id should be used as an id for patch request also. I'm facing problems in get request. My code is unable to fetch details of user in first place. This is my api.js const GET_INVOICE = '/api/invoice/'; const EDIT_INVOICE = 'api/invoice/'; export const getInvoiceDetails = (id) => loadSecureUrl(`${GET_INVOICE}${id}`); export const editProfileShipper = (data) => loadSecureUrl(EDIT_PROFILE_SHIPPER, { data: data, method: 'patch' }); This is my editInvoice.js page: import React, {useState, useEffect} from 'react'; import { Button, Card, CardBody, CardHeader, Col, Form, FormGroup, Input, Label, Row, } from 'reactstrap'; import GooglePlacesAutocomplete from 'react-google-places-autocomplete'; import {editInvoice, getInvoiceDetails} from "../../../helpers/api"; export default () => { // // var len = window.location.href.length; // var id = window.location.href[len-1]; //TODO THIS IS NOT THE REACT METHOD TO FETCH ID FROM THE URLTT const [form, setForm] = useState({ 'id': '', 'invoice_number': '', 'invoice_date': '', 'invoice_due_date': '', 'invoice_place_of_supply': '', 'invoice_destination': '', 'invoice_destination_address': '', 'invoice_destination_pincode': '', 'invoice_gst': '', … -
Is it possible to access the Models/Database Entries that are present in a different project? [DB names are same in settings]
I am working on 3 different Django Projects named frontend,API,Backend. I have successfully implemented a custom Admin Interface as Backend, A middle layer for API request/Response and a Front End for consuming those APi's [without using Python & Django] (Only HTML,CSS,Javascript, Jquery, ajax) Now the Problem is that I do not know a way to use all these together. Someone told me that these can be run at once like a single project. How can I access the DB present in the API project's Models to use in Backend and Front End? Can providing the same DB name in API and Backend Solve the problem? How can I integrate my Backend to the API? -
GraphQL execution errors for query
I'm setting up my graphql client using Appolo-vue. I passed my authorization token in my http headers but i get 200 ok status code but did not get back any data. I'm setting up my graphql client using Appolo-vue. I passed my authorization token in my http headers but i get 200 ok status code but did not get back any data. here is my main.js code. import App from './App.vue' import router from './router' import store from './store/store' import './registerServiceWorker' import axios from 'axios' import VueProgressBar from 'vue-progressbar' import VueSVGIcon from 'vue-svgicon' import 'uikit/dist/js/uikit.js' import 'uikit/dist/js/uikit-icons.js' import './custom-icons' //uikit css and javascript import VueContentPlaceholders from 'vue-content-placeholders' Vue.use(VueContentPlaceholders) import './theme/theme.less' Vue.use(VueSVGIcon) Vue.prototype.$http = axios const options = { color: '#21D397', failedColor: '#874b4b', thickness: '8px', transition: { speed: '0.2s', opacity: '0.6s', termination: 300 }, autoRevert: true, location: 'top', inverse: false } import VueApollo from 'vue-apollo' import { ApolloClient } from 'apollo-client' import { createHttpLink } from 'apollo-link-http' import { InMemoryCache } from 'apollo-cache-inmemory' import { setContext } from 'apollo-link-context'; // Cache implementation const cache = new InMemoryCache() // HTTP connection to the API const httpLink = createHttpLink({ // You should use an absolute URL here uri: 'http://127.0.0.1:8000/', }) // Create a …