Django community: Django Q&A RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
configuring Django Channels for windows in production
Please, I need to configure Django Channels on redis-channel-layer on windows IIS in production. It is running very well in development. I have installed redis, daphne. I have set the IIS as proxy server with URL Rewrite pointing the Inbound to localhost 6379 to redis-layer channels. I used python manage.py runworker. and also started the daphne server with the daphne command. They all ran very well, but there is no websocket handshake for my url. -
Django app on heroku doesn't load staticfiles from S3 bucket
When I run heroku run python manage.py collectstatic it does upload staticfiles to AWS S3, however when I run django in production, my static files do not load to the page. To be honest i dont know why do i have bad request, since i already did collectstatic to S3. My AWS settings @ settings.py AWS_ACCESS_KEY_ID = os.environ.get('AWS_ACCESS_KEY_ID') AWS_SECRET_ACCESS_KEY = os.environ.get('AWS_SECRET_ACCESS_KEY') AWS_STORAGE_BUCKET_NAME = os.environ.get('AWS_STORAGE_BUCKET_NAME') STATIC_URL = 'https://' + AWS_STORAGE_BUCKET_NAME + '.s3.amazonaws.com/' AWS_URL = os.environ.get('AWS_URL') STATICFILES_STORAGE = 'storages.backends.s3boto3.S3Boto3Storage' DEFAULT_FILE_STORAGE = 'storages.backends.s3boto3.S3Boto3Storage' ADMIN_MEDIA_PREFIX = STATIC_URL + 'admin/' STATIC_URL = "https://" + AWS_STORAGE_BUCKET_NAME + ".s3.amazonaws.com/" MEDIA_URL = STATIC_URL + "media/" STATICFILES_DIRS = (os.path.join(BASE_DIR, 'static'),) STATIC_ROOT = 'staticfiles' STATICFILES_FINDERS = ( 'django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder', ) -
Fetch rows from Mysql and display it in html using Django
I am fairly new to Django. I want to know how to fetch rows from mysql and get it in views.py and send it to html where it will be displayed. My views.py: def fetchDate1(request): query = request.session.get('query') date1 = request.session.get('date1'); db = pymysql.connect(host="localhost", # your host user="root", # username passwd="=", # password db="Golden") # name of the database # Create a Cursor object to execute queries. cur = db.cursor() # Select data from table using SQL query. stmt = "SELECT * FROM golden_response WHERE query LIKE '%s' AND DATE(updated_at) = '%s' " % ( query.replace("'", r"\'"), date1) cur.execute(stmt) if cur.rowcount is None: return None else: rows = cur.fetchall() row_headers = [x[0] for x in cur.description] # this will extract row headers json_data = [] for result in rows: json_data.append(dict(zip(row_headers, result))) return json.dumps(json_data) I don't know where I am going wrong. Have also saved required configuration in settings.py. However when i try to run my program : ProgrammingError: (1146, "Table 'Golden.django_session' doesn't exist") Please help!! -
Scalability in Python, Django and Tastypie
I am building a web-service which might be heavily loaded by users in future, So I need to understand clearly how the scalability works. I use Python + Django, and Tastypie as a RES-API framework. The question is: Who of this technologies is responsible for creation of thread(s) for each user ? Is new thread generated for each http request, or it is managed by "session" for the user ? I didn't find this information in google or in Tastypie documenScalability in Python, Django and Tastypie.tation. -
making Django slug and id working together?
I want my URL contain both id and slug like Stackoverflow, but slug is not working probably and instead of being like this www.example.com/games/155/far-cry-5 the URL is like this www.example.com/games/155/<bound%20method%20Game.slug%20of%20<Game:%20Far%20Cry%205>> my models.py : class Game(models.Model): name = models.CharField(max_length=140) def slug(self): return slugify(self.name) def get_absolute_url(self): return reverse('core:gamedetail', kwargs={'pk': self.id, 'slug': self.slug}) my views.py : class GameDetail(DetailView): model = Game template_name = 'core/game_detail.html' context_object_name = 'game_detail' My urls.py : path('<int:pk>/<slug>', views.GameDetail.as_view(), name='gamedetail') thanks -
python how to display variables in the url
I have created y,x a map using leaflet and defined default zoom, x, y as variables: How can I create my url based on this parameters ? var center_x = 42.21526; var center_y = 20.74148; var map_zoom = 13; var map = L.map('map', { center: [center_x , center_y], zoom: map_zoom }); url(r'^$', MapView.as_view(template_name="index.html")), -
Dockerized Nginx, Domain not working properly
I managed to dockerized my django app. With docker-compose I can run django,postgresql and nginx but Nginx not working well. I can access my app and it works fine but when I tried to connect to my domain, always work at port 8000. I want to run my app at testapp.org but I can only access wtih testapp.org. How can I solve this? What changed do I need to use in my configuration file? Did I missed something? docker-compose: version: '3' services: db: container_name: db.postgres image: postgres:10 environment: - POSTGRES_DB=testdb - POSTGRES_USER=test - POSTGRES_PASSWORD=password ports: - '5432:5432' volumes: - ./pgdata:/var/lib/postgresql/data web: restart: always build: . image: djangoapp command: bash -c "python manage.py makemigrations && python manage.py migrate && gunicorn fatihkocnet.wsgi -b 0.0.0.0:8000" depends_on: - db volumes: - ./fatihkocnet:/fatihkocnet - ./config/nginx:/etc/nginx/conf.d expose: - "8000" nginx: restart: always image: nginx:latest ports: - "8000:8000" volumes: - ./fatihkocnet:/fatihkocnet - ./config/nginx:/etc/nginx/conf.d depends_on: - web nginx/test.conf upstream web { ip_hash; server web:8000; } # portal server { location / { proxy_pass http://web; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header Host $host; proxy_redirect off; } listen 8000; server_name testapp.org; } -
Image not uploading in Django
I have uploaded an image in admin portal but it is not rendering in html template how can i solve this? below are the source codes! models.py from django.db import models from django.contrib.auth import get_user_model from PIL import Image class Question(models.Model): question_relation=models.ForeignKey('Answer',related_name='ques',on_delete=models.CASCADE) question_image=models.ImageField(upload_to='media/') text=models.TextField(blank=True,max_length=100) def __str__(self): return str(self.question_relation) html file <div style="margin-left:35%;margin-right:35%"> <img src="{{question.question_image.url}}" alt=""> i have included these in my urls.py urlpatterns += staticfiles_urlpatterns() urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT) on checking the inspect element in img src it appears as (unknown). i dont know why it is not able to pick up the url of image settings.py MEDIA_URL="/media/" MEDIA_ROOT=os.path.join(BASE_DIR,'levels/media') -
Class refactoring advice
I have a class that prepares new team, based on data that Slack sends me. I'm bothering that this class became tigthly coupled to three Django models such as SlackTeam, SlackBot and SlackUser. Is there a way to refactor this? Should I move some code from initialize method to separate methods? How can I make this class easy to test? class TeamInitializer: def __init__(self, access_data): self.team_id = access_data['team_id'] self.team_name = access_data['team_name'] self.bot_user_id = access_data['bot']['bot_user_id'] self.bot_access_token = access_data['bot']['bot_access_token'] self.user_id = access_data['user_id'] self.access_token = access_data['access_token'] def create_team(self): team, _ = SlackTeam.update_or_create( {'id': self.team_id, 'name': self.team_name}) return team def create_bot(self, team): bot, _ = SlackBot.update_or_create( self.bot_user_id, self.bot_access_token, team) return bot def initialize(self): team = self.create_team() self.create_bot(team) client = get_client_by_team_id(self.team_id) team_info = get_team_info(client) team.update_info(team_info) users = get_users_list(client) team.update_members(users) initiator = SlackUser.get_by_ids(self.team_id, self.user_id) initiator.access_token = self.access_token initiator.save(update_fields=['access_token']) team.initiator = initiator team.save(update_fields=['initiator']) return team -
How to store json from request directly into mongo database
I would like to store json from request body directly into mongo collection without creation of specific model in django. I cannot create it because specific fields in json may change and new ones can be introduced, so I would like rather to store it as it is without this abstraction layer. Is it possible? -
fetching data using query from a particular table and showing it in admin side of django
hey am working on Django framework project ,see i want to fetch data from particular table and show it in the admin side,can anyone help me out. Am having a company model which i have registered in admin using admin.site.register(Company,Company_Admin) now i want to just get all the company after querying it from company table and just show the result in admin side class Company(models.Model): name=models.CharField(default=None,max_length=200) description=models.TextField(default=None) url=models.CharField(max_length=200) published=models.BooleanField() createdOn=models.DateTimeField(default=datetime.utcnow) updatedOn=models.DateTimeField(default=datetime.utcnow) keywords=models.ManyToManyField(Keyword) def __unicode__(self): return self.text class CompanyAdmin(admin.ModelAdmin): list_display= ['name','url','description','published','createdOn','updatedOn'] list_filter = ['name'] search_fields = ['name'] filter_horizontal=('keywords',) admin.site.register(Company,CompanyAdmin) now i want to create a option in admin which will give show me all the companies which are published. -
How can i duplicate obj in response in obj in date range
I have a Model Event like this { "id": 1, "name": "Event1", "start_date": "2018-09-14 14:22:00", "end_date": "2018-09-15 14:22:00", } { "id": 2, "name": "Event2", "start_date": "2018-09-15 14:22:00", "end_date": "2018-09-15 15:22:00", } I need to return response group_by date and If Event duration (end_date, start_date) took 2 days so i need return him twice in two days. So response should look like this: { "2018-09-14": [ { "id": 1, "name": "Event1", "start_date": "2018-09-14 14:22:00", "end_date": "2018-09-15 14:22:00", }], "2018-09-15": [{ "id": 1, "name": "Event1", "start_date": "2018-09-14 14:22:00", "end_date": "2018-09-15 14:22:00", }, { "id": 2, "name": "Event2", "start_date": "2018-09-15 14:22:00", "end_date": "2018-09-15 15:22:00", }] } How can i do this? -
BooleanField acts strange In django v2.1
Hello Why is django BooleanField(default=False) return true when printed out in the console? eg: class Themodel(models.Model): status = models.BooleanField(default=False) doing: print(status) returns True Am I confused or is something wrong here? -
Transfer and application of heroku input data
I want to deploy one django python project in heroku, but have troubles in the transfer and application of the inputs data from the visitors. Sorry that if my question is kind of foolish or too easy. The web contains the topic and entries section for visitors to give inputs (the setting.py are provided as followed). def topics(request): topics = Topic.objects.filter(owner=request.user).order_by("date_added") context = {"topics": topics} return render(request, "learning_logs/topics.html", context) @login_required def topic(request, topic_id): topic = Topic.objects.get(id=topic_id) entries = topic.entry_set.order_by("-date_added") context = {"topic": topic, "entries": entries} return render(request, "learning_logs/topic.html", context) @login_required def new_topic(request): if request.method != "POST": form = TopicForm() else: form = TopicForm(request.POST) if form.is_valid(): new_topic = form.save(commit=False) new_topic.owner = request.user new_topic.save() form.save() return HttpResponseRedirect(reverse("learning_logs:topics")) context = {"form": form} return render(request, "learning_logs/new_topic.html", context) @login_required def new_entry(request, topic_id): topic = Topic.objects.get(id=topic_id) if request.method != "POST": form = EntryForm() else: form = EntryForm(data=request.POST) if form.is_valid(): new_entry = form.save(commit=False) new_entry.topic = topic new_entry.save() return HttpResponseRedirect(reverse("learning_logs:topic", args=[topic_id])) context = {"topic": topic, "form": form} return render(request, "learning_logs/new_entry.html", context) Here's the model.py for class Topic and Entry. class Topic(models.Model): text = models.CharField(max_length=200) date_added = models.DateTimeField(auto_now_add=True) owner = models.ForeignKey(User, on_delete=models.CASCADE) def _str_(self): return self.text class Entry(models.Model): topic = models.ForeignKey(Topic, on_delete=models.CASCADE, related_name="entries") text = models.TextField() date_added = models.DateTimeField(auto_now_add=True) ... -
Passing django variables to javascript
I'm having a difficult time passing variables from the python backend to javascript. A lot of my variables look like this in javascript: if ('{{ user.has_paid_plan}}' == 'True') { isPayingUser = true; } else { isPayingUser = false; } It's ugly and I'm sure there's a much cleaner way to do this. How should this be done? -
How django implements single-user login
I use the session to record user login information and how to implement single-user login. -
Write django URL in 2.12
How to pass for /api/users?page=1&limit=10&name=James&sort=-age like this in URL.py file extract these parameters value in below class Class DetailsView(generics.RetrieveUpdateDestroyAPIView): serializer_class = UserDetailSerializer get these parameters value RetrieveUpdateDestroyAPIView class. -
Django Webtest create integration test for formset
I've got a page with a formset, that consists of three forms, each of them possessing a hidden input with a predefined value, and several textareas for the each one of the form. On the front end the formset is a single <form> tag with tabs inside. I can successfully retrieve data from the each form in the formset and post it to server. The problem goes that I need to write an integration test, where I could visit the page, fill out the form and submit it, to later check that form.cleaned_data has the correct and necessary values. Here go my templates edit.html <form action="{% url 'my_model/edit', my_model.pk" id="my_formset", method="post"> {% csrf_token %} {% for form in formset %} {# here we render hidden inputs #} {% for hidden in form.hidden_fields %} {{ hidden }} {% endfor %} {# and here go the visible ones #} {% for field in form.visible_fields %} <div class="form-field-wrapper"> {% render_field field required=False disabled=read_only %} </div> {% endfor %} {% endfor %} </form> And here comes the field that is rendered with render_field: textarea.html <div class="form-field"> <label for="field.id_for_label">{{ field.label }}</label> <textarea id="{{ field.id_for_label }}" name="{{ field.html_name }}"> {{ field.value|default:"" }}</textarea> </div> This is my ... -
Configure email on Django 2
I am trying to send email from django using SMTP email backend. Here are my configurations: EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend' EMAIL_HOST = 'mail.mydomain.com' EMAIL_PORT = 587 EMAIL_HOST_USER = 'no-reply@rmydomain.com' EMAIL_HOST_PASSWORD = '***********' EMAIL_USE_TLS = True DEFAULT_FROM_EMAIL = 'no-reply@mydomain.com' I have two problems: Everything was working fine when i was sending email using gmail but can not send email using above configurations. Secondly, i want to use POP3 as incoming email port and SMTP 26 as outgoing email port. But how can i add this to my configurations. Django's official documentation does not contain anything on this. -
Call two different urls from a form or input submit button Django
I have a form in which I have a table.In table I have a record(title).Now along with title I have two buttons delete and edit.Now I want is that, if I click edit it calls separate url along with primary key going through it or if I click delete It calls separate url with primary key going through. here's my code: <form method="POST" action="{% url 'essay:delete_view' teacher.id %}"> <div class="page-header"> <div class="span4"> <h1>Manage Essays</h1> </div> </div> <table> <tr> <th>Title</th> <th>Edit</th> <th>Delete</th> </tr> {% csrf_token %} {% for uploadassignment in teacher.uploadassignment_set.all %} <tr> <th for="uploadassignment{{ forloop.counter }}">{{uploadassignment.id}}</th> <th><input type="submit" id="Editthis" value="{{uploadassignmentEdit.id}}" class="btn btn-primary"/></th> <th><input type="submit" id="uploadassignment{{ forloop.counter }}" value="{{uploadassignment.id}}" name="uploadassignment" class="btn btn-primary"/></th> </tr> {% endfor %} </table> </form> I want this: one url is called by below (Edit button) with teacher.id <th><input type="submit" id="Editthis" value="{{uploadassignmentEdit.id}}" class="btn btn-primary"/></th> And another url is called when hit delete button with teacher id. <th><input type="submit" id="uploadassignment{{ forloop.counter }}" value="{{uploadassignment.id}}" name="uploadassignment" class="btn btn-primary"/></th> So far due to action ="{% url 'essay:delete_view' teacher.id %}" in form I can switch to only one url.Kindly help in my code so I can switch to different urls with teacher id when clicked on delete or edit button. -
move and copy table data to another table data
We have 3 tables(models) A,B and c.Table 'A' have data, if we delete the specific table data of 'A' then that deleted data i want to save in table 'B' automatically and if we added the data in table 'C' we want that data is also added in table 'A' automatically. Please help me. Thank you -
Create circle from Leaflet circle layer to save with GeoDjango in a PostGIS database
As the title indicates, I am trying to create a circle in Leaflet and send it to a GeoDjango backend to save it. But, since circles aren't part of the GeoJSON specification, I am turning it into a polygon with circle = center.buffer(radius), which creates a multi-sided polygon which I will use as a circle. There seem to be a couple problems with this approach: Doing a buffer results in a distortion thanks to the curvature of the Earth and the projections that its doing automatically, turning my circle into an oval. How do I avoid that? What units does the GeoDjango buffer take its radius in? And how do I match the units that Leaflet sends with the units that GeoDjango uses to create its buffer? Ultimately, I just want to be able to define a point and a radius with Leaflet and turn that into a multiple sided polygon that looks almost identical and save it to the PostGIS database. Thanks a lot in advance for the help. -
How to customize {% bootstrap_form form %} in django?
There is Problem Hello I'm creating a project,I created a register form, but I tried to create an email authentication submit button in the form near EmailInput, but I could not find it I'm currently using {% bootstrap_form form%} to render automatically in a register form What I want I would like to have the Submit Email Authentication button appear on the form near EmailInput, When the user clicks the Send Email Authentication button, it sends an authentication email to the user's email Then, when the user clicks the link attached to the mail, the user is informed that the confirmation has been made on the register window and When the user clicks the sign up button, the registration is completed What I've tried I created a register form using UserCreationForm supported by django, I tested using gmail smtp to send email from django. It works well The Code /django-blog/blog/settings.py import os # Build paths inside the project like this: os.path.join(BASE_DIR, ...) BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) # Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/2.1/howto/deployment/checklist/ # SECURITY WARNING: keep the secret key used in production secret! SECRET_KEY = 'y$a)3faq3*h#r0g5b^cxsw^lgdxbbu&#lsqek!_0ju+d*c!ups' # SECURITY WARNING: don't run with debug turned on in ... -
Displaying nested dictionary in view
I have a dataframe where I group by a column and then convert that dataframe to a dictionary. context['data'] = "carrier_data": noDupsdf.groupby("market").apply(dict) The resulting data looks something like this: "ATL": { "currency": ["USD", "EUR", "CAD"], "amount": [1232, 22, 44], }, "JFK": { "currency": ["GBP", "EUR"], "amount": [122, 442], } I'd like to loop through the data and display it accordingly: <ul style="list-style: none"> <li style="display: inline-block">ATL</li> <li style="display: inline-block">JFK</li> </ul> <div class="first-container"> <div class="card"> <p>Currency: USD</p> <p>Amount: 1232</p> </div> <div class="card"> <p>Currency: EUR</p> <p>Amount: 22</p> </div> <div class="card"> <p>Currency: CAD</p> <p>Amount: 44</p> </div> <div class="second-container"> <div class="card"> <p>Currency: GBP</p> <p>Amount: 122</p> </div> <div class="card"> <p>Currency: EUR</p> <p>Amount: 442</p> </div> There will be at maximum three markets. How do I display the data in the way like so? -
Django jquery AJAX form submission in view and display results
There are a lot of different posts about all parts of this, I just can't quite figure out how it all fits together. I have name that is displayed with an update button next to it. When the update button is clicked it shows a form to update the name. In the form is a save changes button. When the changes are saved, it should reload the name at the top, and should the update button be clicked again, the form should show the new name info. urls.py path('profile/<int:pk>/', views.customer_profile, name='profile'), path('update-profile/<int:pk>/', views.update_profile, name='update-profile'), views.py def customer_profile(request, pk): name = get_object_or_404(CEName, id=pk) name_form = NameForm(instance=name) return render( request, 'customer/customer_profile.html', {'name':name, 'NameForm': name_form} ) def update_profile(request, pk): if request.POST: name_form = NameForm(request.POST) if name_form.is_valid(): name_form.save() name = get_object_or_404(CEName, id=pk) context = {'name':name, 'NameForm': name_form} html = render_to_string('customer/customer_profile.html', context) return HttpResponse(html, content_type="application/json") template.html <div id="name" class="container d-flex justify-content-between pt-1"> {{ name }} <button id="update_button" class="bold btn btn-main btn-sm button-main">UPDATE</button> </div> <div id="div_NameForm" class="container" style="display: none;"> <hr size="3px"> <form id="NameForm" method="POST" data-url-name="{% url 'customer:update-profile' name.id %}"> {% csrf_token %} {{ NameForm.as_p }} <br> <button type="submit" id="save_changes" class="btn btn-main button-main btn-block">Save Changes</button> </form> </div> <script src="{% static 'ce_profiles/ce_profiles_jquery.js' %}"></script> jquery.js $('#save_changes').click(function() { var NameForm ...
