Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Users can add a movie and other people, except the creator, can rate it. And remember a user can onlyrate a movie once
Users can add a movie and other people, except the creator, can rate it. And remember a user can only rate a movie once and even after logging in api, my database is not showing please help -
How to delete file in python inside docker container?
The code below is part of my code. In my local machine, everything is fine.However, I deploy my code and inside of docker container,it gives the error "result": "[Errno 13] Permission denied: path". What could be solution to delete in docker container also? I tried os.remove() also,It didn't work. path = "/mypath/" output = path + "myfile.pdf" result_file = open(output, "w+b") pisa_res = pisa.CreatePDF( source_html, dest = result_file) result_file.close() with open(output, "rb") as pdf_file: encoded_string = base64.b64encode(pdf_file.read()) os.system(f"rm -rf {output}") -
How to use mysql-connector mysql adapter with django??/
I cannot use mysqlclient package in the hosting server because it is a shared hosting server and they would not let me have a root privilige!! so I found about the mysql-connector adapter, I guess it is developed by MySQL but I could not find anyone using it to connect to the database, does someone know how to use it?? please help -
A timer button of a Door Lock with Raspberry Pi GPIO in a DJANGO view with multiple users
I want to build a django app in a Raspberry Pi so multiple users can press a button and open a lock connected with Raspberry Pi GPIO. When someone calls for the view in the django app, the door will open for 5 seconds. I tried to use the code below but it cannot work because the door will open for 10 seconds (run the script twice) instead of ~5.1 seconds if the user double tap the button. let alone multiple users may call for the view at the same time. from django.shortcuts import render from django.http import HttpResponse from openlock.openlock import openlockcommand # Create your views here. def opencommand(request): openlockcommand() return HttpResponse("opened") views.py import RPi.GPIO as GPIO import time def openlockcommand(): relay=18 GPIO.setwarnings(False) GPIO.setmode(GPIO.BCM) GPIO.setup(relay,GPIO.OUT) GPIO.output(relay,1) time.sleep(5) GPIO.output(relay,0) GPIO.cleanup() openlock.py Please help.. -
TemplateSyntaxError: Templates and static files
I have components for the website and they all work fine, for example I have a navbar.html and works flawlessly. However, I think the issue begins when I have a static file. I have another component called 'header.html' (which contains a profile picture) and SHOULD have loaded up a header in my index.html file. But it spits 'TemplateSyntaxError' and says that the issue is with the line code '{% static ... %}'. My settings.py seems correct (see below). I also included 'django.contrib.staticfiles' and {% load static %} in the main index.html. This is also the html part: The structure of my project is as such: -myproject --base --myproject --static --staticfiles -
Can I edit cronjobs using my Django application?
I am creating a Django application for school project. I want to schedule jobs (every (work)day on 9:00 and 17:00). I am trying to do it with Celery right now, but I stuck very hard on it, and as the deadline is in sight, I want to use alternative options: just a cronjob. I think just the cronjob works fine, but the user should be able to edit the times of the cronjobs using the Django web application (so not logging in to SSH, edit the crontab manually). Is this possible? Can't find anything about it on the internet. -
how to active a venv in a Django app that created in windows and we want continue in linux?
I know the way that we active it in Linux: source venv/bin/activate and in windows it just venv/Scripts/activate.bat but i have a project that started in windows and both command didnt work Does anyone have a solution? -
Issues with migrating Models in Django after doing inspectdb from an external database
I connected my external postgreSQL database to Django and ran inspect db to import models into my app. While migrating the changes, I am getting the following errors: python manage.py makemigrations Traceback (most recent call last): File "manage.py", line 22, in <module> main() File "manage.py", line 18, in main execute_from_command_line(sys.argv) File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line utility.execute() File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\core\management\__init__.py", line 377, in execute django.setup() File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\__init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\apps\registry.py", line 114, in populate app_config.import_models() File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\apps\config.py", line 211, in import_models self.models_module = import_module(models_module_name) File "C:\Users\prateek.jain\Anaconda3\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1014, in _gcd_import File "<frozen importlib._bootstrap>", line 991, in _find_and_load File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 671, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 783, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "C:\Users\prateek.jain\OneDrive - XTRACAP FINTECH INDIA PRIVATE LIMITED\Desktop\XtraCap\django_api\api\models.py", line 1092, in <module> class Holidays(models.Model): File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\db\models\base.py", line 320, in __new__ new_class._prepare() File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\db\models\base.py", line 333, in _prepare opts._prepare(cls) File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\db\models\options.py", line 254, in _prepare model.add_to_class('id', auto) File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\db\models\base.py", line 326, in add_to_class value.contribute_to_class(cls, name) File "C:\Users\prateek.jain\Anaconda3\lib\site-packages\django\db\models\fields\__init__.py", line 2393, in contribute_to_class assert not cls._meta.auto_field, ( AssertionError: Model api.Holidays can't have more than … -
maximum recursion depth exceeded even if i use Depth = 1
I am trying to use Follow system in Django Rest Framework.Here is my code: Models.py class User(AbstractUser,PermissionsMixin): id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False) email = models.CharField(max_length=255,unique=True) username =models.CharField(max_length=80,unique=True,default='SOME STRING') USERNAME_FIELD = 'email' REQUIRED_FIELDS = [] objects = UserManager() class Meta: verbose_name = _('user') verbose_name_plural = _('users') class FollowUserModel(models.Model): id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False) author = models.ForeignKey(User,on_delete=models.CASCADE,related_name='follows') profile = models.ForeignKey(User,unique=True,on_delete=models.CASCADE,null=True) created = models.DateTimeField(auto_now=True) Serializers.py class UserSerializer(serializers.ModelSerializer): following_set = serializers.SerializerMethodField() def get_following_set(self, user): return UserSerializer(User.objects.filter(follows__author=user), many=True).data class Meta: model = User depth = 1 fields = ('id','following_set','email','username') Even if i use Depth = 1 in Serializer,i still get this error: RecursionError at /api/users/ maximum recursion depth exceeded solution please? -
Django unable to display the logout template provided
I have the following problem; Im trying to set up user login and logout using the default contrib.auth views but the logout page that is displayed is the default page of django admin while the login page has no problem and displays the support template that I have provided it django-tutorial/urls.py from django.contrib import admin from django.conf.urls.static import static from django.urls import path, include from django.conf import settings urlpatterns = [ path('admin/', admin.site.urls), path('', include('landingpage.urls')), path('articles/', include('articles.urls')), path('accounts/', include('accounts.urls')), ] if settings.DEBUG: urlpatterns += static(settings.STATIC_URL, document_root=settings.STATIC_ROOT) accounts/urls.py from django.urls import path from django.contrib.auth import views as auth_views app_name = 'accounts' urlpatterns = [ path('login/', auth_views.LoginView.as_view(), name='login'), path('logout/', auth_views.LogoutView.as_view(), name='logout'), path('password_change/', auth_views.PasswordChangeView.as_view(), name='password_change'), path('password_change/done/', auth_views.PasswordChangeDoneView.as_view(), name='password_change_done'), path('password_reset/', auth_views.PasswordResetView, name='password_reset'), path('password_reset/done/', auth_views.PasswordResetDoneView, name='password_reset_done'), path('reset/<uidb64>/<token>/', auth_views.PasswordResetConfirmView.as_view(), name='password_reset_confirm'), path('reset/done/', auth_views.PasswordResetCompleteView.as_view(), name='password_reset_complete'), ] login.html {% extends "landingpage/base.html" %} {% block page_content %} {% if form.errors %} <p>Your username and password didn't match. Please try again.</p> {% endif %} {% if next %} {% if user.is_authenticated %} <p>Your account doesn't have access to this page. To proceed, please login with an account that has access.</p> {% else %} <p>Please login to see this page.</p> {% endif %} {% endif %} <form method="post" action="{% url 'accounts:login' %}"> … -
Django FormView: Add if record does not exist and update if it does exist
I created a FormView and it works fine if the user executed the process the first time. However when it is executed the second time I get an error that the record already exist. This is expected as the user in the model is unique. How can I overcome this problem so that the current record is overwritten by the form.save if the record already exist. models.py class ttemp_selection(models.Model): select_account = models.ForeignKey(tledger_account, on_delete=models.CASCADE) date_from = models.DateField(default=datetime.today) date_to = models.DateField(default=datetime.today) user = models.ForeignKey(custom_user, on_delete=models.CASCADE, unique=True) def __str__(self): return self.select_account forms.py class Meta: model = ttemp_selection fields = ['select_account', 'date_from', 'date_to', 'user'] def __init__(self, *args, **kwargs): self.request = kwargs.pop('request') super(SelectAccountForm, self).__init__(*args, **kwargs) user = self.request.user current_company = user.current_company self.fields['select_account'].queryset = tledger_account.objects.filter( company=current_company, gl_category='Cash and Bank') view.py class sasView(FormView): template_name = 'cashflow/select_account.html' form_class = SelectAccountForm success_url = 'home' def form_valid(self, form): form.save() return super().form_valid(form) def get_form_kwargs(self): kwargs = super(sasView, self).get_form_kwargs() kwargs['request'] = self.request return kwargs I can determine the record by using ttemp_selection.objects.get(user=request.user) I know I can make use of the UpdateView class but that will create a problem when the record does not exist. It will also add an extra step that is unnecessary. Assistance will be appreciated. -
Migrate from multi-table inheritance model to abstract base classes in Django
My current project uses multi-table inheritance models: from django.db import models class Place(models.Model): name = models.CharField(max_length=50) address = models.CharField(max_length=80) class Restaurant(Place): serves_hot_dogs = models.BooleanField(default=False) serves_pizza = models.BooleanField(default=False) class Cinema(Place): sells_tickets = models.BooleanField(default=False) sells_popcorn = models.BooleanField(default=False) I want to switch to abstract base classes instead. Since my model is already deployed I need to write some custom migrations to convert the above schema to this one: from django.db import models class AbstractPlace(models.Model): name = models.CharField(max_length=50) address = models.CharField(max_length=80) class Meta: abstract = True class Restaurant(Place): serves_hot_dogs = models.BooleanField(default=False) serves_pizza = models.BooleanField(default=False) class Cinema(Place): sells_tickets = models.BooleanField(default=False) sells_popcorn = models.BooleanField(default=False) Does anyone have any advice on the steps to take to achieve this? -
Stock code request application in Django & SQL
I have a material excelfile and it has different type of material. Each category has start specific prefix like AB001 or BC001 I am planning to write a webservice for the request of this material stock codes. But I need to import the my old database and i have stucked how can i implement this? I have created a model in DJANGO like Materials, But i could not solve that if i import the my old excel file, the software how can understand the numbers will be correct. It must be consecutively. Like ( AB001 , AB002, AC001,AC002,AZ001) Thanks in advance! -
How can I connect my existing external PostgreSQL Database to automatically create my Models.py for a Django Rest Framework?
I have an existing PostgreSQL Database and I want to create APIs around it using Django Rest Framework. How do I display the tables in my Database as models in Django to further use them for the API? -
can i used model A field in model B as foregin key and model B field in model A as OnetoOneField in django
model A: field 1 field 2 --> foregin key model B model B: field 1 field 2 --> foregin key model A -
TypeError: unhashable type: 'dict' while annotate
for value in (annotated_qs.values('row', 'col').order_by('row', 'col').annotate(count=Count('row'))): print('---------value--------', value['row'],value['col]) -
How to use django rest framework [closed]
Thanks for your time. I'm a self taught Jr Developer and just re-done the Django rest-framework quick start for the third time. although i'm not beeing able to understand his usability and reasons. As far as i know the great part of a REST Full api is to receive the data as a common data format (ex: JSON, Xml, etc.), to be able to communicate with all type of API's. with the same database. allowing to comunicate with differents kind of OS. ----> Please correct me if i'm wrong <---- I'd like if i'm right and how to comunicate the rest framework system with the front end of the web api, should i use JS? is there any tutorial that you could recommend me to understand the whole picture of how a rest api should work and apply it on Django? -
Run server Django
I am trying to setup Django on my device but I am encountering issues. I am able to install python and setup a virtual environment, but I am unclear as to whether Django is established. I have tried reinstalling both Django and Python, but it does appear that Django is installed. The issue presents itself when I try to run the Django server in a virtual environment (or even not in a virtual environment). I am confronted by the following error: "Couldn't import Django. Are you sure it's installed and available on your PYTHONPATH environment variable? Did you forget to activate a virtual environment?" Any advice would be gratefully received. Thanks. Screen shot -
Google sheets api- Python/Django, receive a hidden links from cells
enter image description here Hi, I have a problem with parsing a link from google sheets cells. I need to create parser that will parse sheets with links in cells. Here is a piece of code: range='Some Table!A2:J28', valueRenderOption='FORMULA').execute()``` But I received only the name from the cell. How can I receive a hidden link? -
Django REST Framework. How to get full url of a page with protocol, domain, and path?
There is Django REST framework. I need to unload the full path of the page into the tag. For example, there is a page: https://domain-name.com/category/article In serializers.py: class someClass(serializers.ModelSerializer): url = serializers.URLField(source='get_absolute_url', read_only=True) class Meta: model = onlyURL fields = ['url'] This does not work correctly, since I do not get the full url, only part: <url>**/category/article**</url> How to get full url with protocol, domain, and path? -
Django Template inheritance is not working
I am using base.html {% extends "base.html"%} but when i render them by using my block they are not rendering The own Content of file is not loading pls help -
Create nested pages-list from Postgresql database using Django
I want to store nested pages-list using Django models. I want to to use; page_id parent_page_id title fields. But ı dont know how to get pagelist as a json using recursive function like; -Page1 -Page1.1 -Page1.2 -Page1.2.1 Is there any method for this? Is it enough to use only parent_page_id ? -
Convert Javascript Datetime object to Django python3 datetime field
From the webpage I pass a JavaScript Datetime object to my Django(v2.2) function views.py Ex: sdate = new Date() Fri Dec 18 2020 13:09:19 GMT+0530 (India Standard Time) Using the datetime.datetime.strptime function I was able to match most of the object except the timezone difference (+0530 (India Standard Time)) Here is my code: datetime.strptime(sdate, "%a %b %d %Y %H:%M:%S %Z+0530 (India Standard Time)") How to match the +0530 and India Standard Time using any other datetime specifier? Because the incoming datetime objects are not always of IST time. -
DRF Help to solve nested serializers dependency
So, Here is my serializers structure in the Django Rest FrameWork: class FieldDataSerializer(serializers.ModelSerializer): class Meta: model = FieldData fields = '__all__' extra_kwargs = {'data_size': {'read_only': True}, } parent = DataSheetFieldSerializer(many=False, required=True) owner = MemberSerializer(many=False, required=True) class IndexedFieldDataSerializer(serializers.ModelSerializer): class Meta: model = IndexedFieldData fields = '__all__' field_data = FieldDataSerializer(many=False, required=True) class DataSheetFieldSerializer(serializers.ModelSerializer): class Meta: model = DataSheetField fields = '__all__' extra_kwargs = {'is_indexed': {'read_only': True}, } @property def field_size(self): return record_data_manager.get_field_size(self.data['id']) size = serializers.ReadOnlyField(source='field_size') data = FieldDataSerializer(many=True) indexed_data = IndexedFieldDataSerializer(many=True) owner = MemberSerializer(many=False, required=True) parent = DataSheetSerializer(many=False, required=True) class DataSheetsCategorySerializer(serializers.ModelSerializer): class Meta: model = DataSheetsCategory fields = '__all__' parent = ClusterSerializer(many=False, required=True) class DataSheetSerializer(serializers.ModelSerializer): class Meta: model = DataSheet fields = '__all__' @property def datasheet_size(self): return record_data_manager.get_datasheet_size(self.data['id']) size = serializers.ReadOnlyField(source='datasheet_size') fields = DataSheetFieldSerializer(many=True, read_only=True) parent = DataSheetsCategorySerializer(required=False, many=False) owner = MemberSerializer(required=True, many=False) class ClusterSerializer(serializers.ModelSerializer): class Meta: model = DataSheetsCluster fields = '__all__' extra_kwargs = {'total_size_limit': {'read_only': True}, } @property def cluster_size(self): return record_data_manager.get_cluster_size(self.data['id']) size = serializers.ReadOnlyField(source='cluster_size') members = MemberSerializer(many=True) roles = RoleSerializer(many=True) datasheets = DataSheetSerializer(many=True, read_only=True) owner = MemberSerializer(many=False, required=True) As you can see, I am having trouble because of my model's structure. I cannot reference the serializers below and hence am getting an unreferenced error, my serializers are nested. How … -
Got AttributeError when attempting to get a value for field `phone_number` on serializer
AttributeError:Got AttributeError when attempting to get a value for field phone_number on serializer ListBusCompanyStaffSerializer. Bascially I have two models User and BusCompanyStaff, User consists of phone_number field BusCompanyStaff consists of following models fields class BusCompanyStaff(BaseModel): user = models.OneToOneField( BusCompanyUser, on_delete=models.CASCADE ) position = models.ForeignKey( StaffPosition, on_delete=models.SET_NULL, null=True, related_name='position' ) created_by = models.ForeignKey( User, on_delete=models.CASCADE, related_name='created_by' ) staff_of = models.ForeignKey( BusCompany, on_delete=models.CASCADE ) I basically wants to list particular BusCompanyStaff from BusCompany so here is my serializer I tried till now class ListBusCompanyStaffSerializer(serializers.ModelSerializer): position = serializers.CharField() class Meta: model = BusCompanyStaff fields = ( 'id', 'phone_number', 'position', 'email', ) there is defintely Error as BusCompanyStaff dont consist of phone_number field but requirement is to put User phone number and email Here is my rest of code in views.py and usecases.py #usecases.py class ListBusCompanyStaffUseCase(BaseUseCase): def __init__(self, bus_company: BusCompany): self._bus_company = bus_company def execute(self): self._factory() return self._bus_company_staffs def _factory(self): self._bus_company_staffs = BusCompanyStaff.objects.filter(staff_of=self._bus_company) #views.py class ListBusCompanyStaffView(generics.ListAPIView): serializer_class = bus_company_user_serializers.ListBusCompanyStaffSerializer def get_bus_company(self): return GetBusCompanyUseCase( bus_company_id=self.kwargs.get('bus_company_id') ).execute() def get_queryset(self): return ListBusCompanyStaffUseCase( bus_company=self.get_bus_company() ).execute() how can I serialize in this format id , phone_number , position, email,
