Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Django with aurora, how to use two instances?
I have django script with mysql My settings is below. mysql server is in the local. DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', "NAME": config("DB_NAME"), "USER": config("DB_USER"), "PASSWORD": config("DB_PASSWORD"), "HOST": 127.0.0.1, "PORT": config("DB_PORT"), 'OPTIONS': { 'charset': 'utf8mb4', 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" }, } } Now I want to use amazon AURORA It has two instances reader/writer How can I set the instance to django?? -
'SimpleHistoryAdmin' has no attribute _meta problem
i installed django-simple-history but, it's not working. I tried python manage.py makemigrations i paced below error. like AttributeError: type object 'SimpleHistoryAdmin' has no attribute '_meta' I want to see history in django-admin. what's wrong????? Traceback (most recent call last): class AccountClassificationAdmin(admin.ModelAdmin): File "/root/miniconda3/envs/gdaj/lib/python3.9/site-packages/django/contrib/admin/decorators.py", line 100, in _model_admin_wrapper admin_site.register(models, admin_class=admin_class) File "/root/miniconda3/envs/gdaj/lib/python3.9/site-packages/django/contrib/admin/sites.py", line 113, in register if model._meta.abstract: AttributeError: type object 'SimpleHistoryAdmin' has no attribute '_meta' # settings.py i added 'simple_history', at installed_app 'simple_history.middleware.HistoryRequestMiddleware', at middleware # models.py class PayHistory(TimeStampedModel): package_patient = models.CharField(max_length=10, null=False) package_classification = models.CharField(max_length=10, null=False) history = HistoricalRecords() class PayHistoryChange(TimeStampedModel): payhistory = models.ForeignKey(PayHistory, on_delete=models.CASCADE, null=False) history = HistoricalRecords() # admin.py @admin.register(PayHistory) class AccountCategoryAdmin(SimpleHistoryAdmin): list_display = ( "package_patient", "package_classification" ) -
Cannot get "images" net::ERR_CONNECTION_REFUSED (Gitpod)
On Gitpod, my NextJS frontend is trying to fetch the list of objects which contain "product names", "prices" and "images" from my Django Rest API backend. Then, my NextJS frontend can get the list of objects which contain "product names" and "prices" but not "images" so my NextJS frontend cannot get only "images" as shown below: ("product names" such as "boots 4", "boots 3" ... and "prices" such as "£12.10", "£10.50" ... are displayed but not "images") This is my desired output with "product names", "prices" and "images": On Gitpod, both my NextJS frontend on port 3000 open (private) and my Django Rest API backend on port 8000 open (private) are running: And my NextJS frontend uses this Rest API call with "localhost" as shown below to get the list of objects which contain "product names", "prices" and "images": http://localhost:8000/api And, this is the errors: 3000-gitpodio-templatetypescr-tqzkjl97w1d.ws-us33.gitpod.io/:987 GET http://localhost:8000/media/images/paid.png net::ERR_CONNECTION_REFUSED 3000-gitpodio-templatetypescr-tqzkjl97w1d.ws-us33.gitpod.io/:987 GET http://localhost:8000/media/images/size.png net::ERR_CONNECTION_REFUSED 3000-gitpodio-templatetypescr-tqzkjl97w1d.ws-us33.gitpod.io/:987 GET http://localhost:8000/media/images/download.jpg net::ERR_CONNECTION_REFUSED 3000-gitpodio-templatetypescr-tqzkjl97w1d.ws-us33.gitpod.io/:987 GET http://localhost:8000/media/images/02173_l.jpg net::ERR_CONNECTION_REFUSED Actually, I solved these errors above by using this Rest API call with my Gitpod domain as shown below to get the list of objects: https://8000-gitpodio-templatetypescr-tqzkjl97w1d.ws-us33.gitpod.io/api But other error occurs as shown below: Server Error FetchError: invalid json response … -
Django 2.0 migration breaks django-autocomplete-light unit test with TypeError
I am trying to migrate to Django 2.0 from 1.11 but some unit tests related to django-autocomplete-light (3.5.1) have started failing with a TypeError after calling self.client.get() from TestCase class. (__init__() takes 1 positional argument but 2 were given) Some suggestions I found stated that missing as_view() in the URL view could be the issue but it is already there. I also changed the MIDDLEWARE_CLASSES variable to MIDDLEWARE in the settings. test.py from django.urls import reverse from django.test import TestCase from django.contrib.auth.models import User class AutocompleteTestCase(TestCase): def setUp(self): self.admin_cred = { 'username': 'test', 'password': 'test', } self.user = User.objects.create_superuser('test', 'test@test.com', self.admin_cred['password']) def query_autocomplete_view(self, url_name, query=None): data = {} if query: data['q'] = query self.client.force_login(self.user) response_json = self.client.get(reverse(url_name), data=data).json() return response_json.get('results') Error Traceback Traceback (most recent call last): File "/home/circleci/project/test/apps/dataadmin/tests/test_autocomplete_views.py", line 131, in test_dataadmin_field_autocomplete results = self.query_autocomplete_view('admin:dataadmin_autocomplete_dataadminfield', query='test') File "/home/circleci/project/dataadmin/common/test_utils.py", line 23, in query_autocomplete_view response_json = self.client.get(reverse(url_name), data=data).json() File "/home/circleci/project/venv/lib/python3.6/site-packages/django/test/client.py", line 517, in get response = super().get(path, data=data, secure=secure, **extra) File "/home/circleci/project/venv/lib/python3.6/site-packages/django/test/client.py", line 332, in get return self.generic('GET', path, secure=secure, **r) File "/home/circleci/project/venv/lib/python3.6/site-packages/django/test/client.py", line 404, in generic return self.request(**r) File "/home/circleci/project/venv/lib/python3.6/site-packages/django/test/client.py", line 467, in request response = self.handler(environ) File "/home/circleci/project/venv/lib/python3.6/site-packages/django/test/client.py", line 125, in __call__ self.load_middleware() File "/home/circleci/project/venv/lib/python3.6/site-packages/django/core/handlers/base.py", line 39, in load_middleware … -
Django how to add specific query results to model when appending to database
I have a model that holds "title", "area", "price" and "price2". I have a database table that holds "area", and "price2". First I create model object. Then I want to go to database, get average "price2" for the "area" of the model, and then save that into "price2" of the model. How can I accomplish this? Thank you. -
Django postgres full text search error "Unsupported lookup 'search' for CharField"
All similar problems have been solved by adding django.contrib.postgres to INSTALLED_APPS in settings.py, which is also all the docs mention on how to use the lookup. I've already done this and the lookup still isn't working, despite whether I use __search or search= for the filter. Any ideas? Do I need to register the lookup in my model myself? settings.py: INSTALLED_APPS = [ ... 'django.contrib.postgres', # my_project 'my_project.apps.appname', 'my_project.apps.appname', ... error line: x = y.objects.filter(description__search="example") -
Select specific option from dropdown menu DJANGO
I have a page that lists all the items from a table named Stocks for each row there's a clickable ORDER button that leads users to another page where they can enter all their details as well as select what item and how much they wanna buy which would then save all of that data to a table named Orders. This orders table is linked with the Stocks table like this: class Order(models.Model): name = models.CharField(max_length=50, blank=True, null=True) quantity = models.IntegerField(default='0', blank=False, null=True) order_item = models.ForeignKey(Stock, on_delete=models.CASCADE, blank=True) address = models.CharField(max_length=50, blank=True, null=True) city = models.CharField(max_length=50, blank=True, null=True) Depending on what item they clicked the order button for I wanted to automatically select the corressponding item from the dropdown menu on the next page so that they won't have to. def create_order(request, pk): queryset = Stock.objects.get(id=pk) form = CreateOrderForm(request.POST or None, initial={'order_item':queryset.item_name}) if form.is_valid(): form.save() context = { 'form':form } return render(request, 'add_items.html', context) I tried doing this by using the intitial command but for some reason it just won't change from the default blank option. Here's my forms.py just in case class CreateOrderForm(forms.ModelForm): class Meta: model = Order fields = ['name','quantity','order_item','address','city'] -
Cannot import name 'force_text' from partially initialized module 'django.utils.encoding'
My project was working perfectly fine until I tried installing security for Bruteforce for the login system by installing packages like Django-defender & BruteBuster. However, suddenly I was prompted with this error and cannot seem to find the reason why. There are many other similar questions where the answer would say to change the force_text to force_str within the graphene_django folder in my ENV. Therefore, I do not know where to insert or change the text to str as I do not have a graphene_django folder at all. Furthermore, I have checked other Django projects within my device which also shows a similar error even though I have barely done anything. For more description here is the full error: Traceback (most recent call last): File "manage.py", line 15, in <module> execute_from_command_line(sys.argv) File "C:\Users\DELL7390\AppData\Local\Programs\Python\Python38-32\lib\site- packages\django\core\management\__init__.py", line 425, in execute_from_command_line utility.execute() File "C:\Users\DELL7390\AppData\Local\Programs\Python\Python38-32\lib\site- packages\django\core\management\__init__.py", line 419, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\Users\DELL7390\AppData\Local\Programs\Python\Python38-32\lib\site- packages\django\core\management\__init__.py", line 263, in fetch_command klass = load_command_class(app_name, subcommand) File "C:\Users\DELL7390\AppData\Local\Programs\Python\Python38-32\lib\site- packages\django\core\management\__init__.py", line 39, in load_command_class module = import_module('%s.management.commands.%s' % (app_name, name)) File "C:\Users\DELL7390\AppData\Local\Programs\Python\Python38- 32\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 … -
How to use a model inside django settings?
I need to use one of my models to define Django settings variables. Meaning, the django variables will be dinamically defined by what's on the database. When I use a function that uses one of my models: from util.auth_utils import get_app_auth auth = get_app_auth() It throws an error: django.core.exceptions.AppRegistryNotReady: Apps aren't loaded yet. If I try to use this code inside the settings.py: import django django.setup() Also throws an error: RuntimeError: Model class django.contrib.contenttypes.models.ContentType doesn't declare an explicit app_label and isn't in an application in INSTALLED_APPS. Besides that, I tryed to move the django.setup() part to after the INSTALLED_APPS, but then it wont load settings correctly. Any clues? -
What's the difference beetwen django database engines?
In setting.py file I can that sqlite3 is set by default as db engine. In the docs i read that I can change it to other engines like PostgreSQL MariaDB or MySQL. But here is my question. What for ? Are these engines better/faster than default sqlite3 ? Is there any point of learning how to change database for other than default ? -
Get Value for Specific Select Option in Django Template
I am trying to get the value for a select option in my django template. I can iterate through an object like this: <select id="id_name" name="name"> {% for x, y in form.fields.name.choices %} <option value="{{ x }}">{{ y }}</option> {% endfor %} </select> but is there any way to get a specific value eg; form.fields.name.choices.2? without looping? Thanks! -
Django and Pandas - Create an object from a Foreying Key field
I am trying to create objects importing data from an excel with pandas, than creating objects with django. But i am geting this error message: Asset matching query does not exist. My Models class Asset(models.Model): ticker = models.CharField(max_length=255, unique=True) class Transaction(models.Model): id = models.AutoField(primary_key=True) OrderChoices = ( ('Buy', 'Buy'), ('Sell', 'Sell'), ) date = models.DateField(("Date"), default=date.today) order = models.CharField(max_length = 8, choices = OrderChoices) asset = models.ForeignKey(Asset, on_delete=models.CASCADE, default=1) shares_amount = models.FloatField() share_cost = models.FloatField() And here is my updater file code: class Command(BaseCommand): def handle(self, *args, **options): excel_file = "orders.xlsx" df_2 = pd.read_excel(excel_file) df_2 = df_2[['Date(UTC)','Pair', 'Type', 'Order Amount', 'AvgTrading Price']] df_2.columns = ['date', 'asset', 'order', 'shares_amount','share_cost'] df_2['date'] = df_2['date'].str[:9] df_2['asset'] = df_2['asset'].str.replace('USDT', '') df_2['order'] = df_2['order'].str.replace('BUY', 'Buy') print(df_2['asset']) for index, row in df_2.iterrows(): try: Transaction.objects.create( date = datetime.date.today(), order = df_2['order'] , asset = Asset.objects.get(ticker = df_2['asset']), shares_amount = df_2['shares_amount'], share_cost_brl = df_2['share_cost'], ) except Exception as e: print(f' Key Exception - {e}') pass When i try to print(df_2['asset']), i get as result a list with id(from pandas index) and ticker -
How can we overrider serializer.save() method in django rest framework?
I have update functional view. And i'm update profile instance with serializer.save() method. I want to override that default save method. and want to save that in to profile managers file. Can you tell me how can i do that ? functional view where i'm using that save method. if request.method=="PUT": request.data["update_time"] = timezone.now() serializer = UserProfileSerializer(profile, data=request.data,partial=True) if serializer.is_valid(): serializer.save() trying to move that in managers : def save_me(self,obj): obj = obj.save() return obj -
How to remove username and password2 fields from form errors
I have a problem with these fields in their output to the html template. I need to output only error text without field data in the Messages function. error on website Create messages in views.py messages.error(request, form.errors) -
Django HttpResponseRedirect sends request but doesn't actually render?
I am attempting to redirect a user to http://127.0.0.1:8000/register/Pro/success after a successful registration. This is my URLs code: from accounts import views from django.urls import path,re_path from django.contrib.auth import views as auth_views urlpatterns = [ # path('signup',views.signup_user,name='signup'), path('login', views.login_user, name="login"), path('logout', views.logout_user,name='custom_logout'), re_path(r'^password_reset/$', auth_views.PasswordResetView.as_view(), name='password_reset'), re_path(r'^password-reset/email-sent/$', auth_views.PasswordResetDoneView.as_view(), name='password_reset_done'), path('password-reset/<uidb64>/<token>/', auth_views.PasswordResetConfirmView.as_view(), name='password_reset_confirm'), re_path(r'^password-reset/complete/$', auth_views.PasswordResetCompleteView.as_view(), name='password_reset_complete'), path('register/<str:plan>/', views.register, name="register"), path('register/<str:plan>/success', views.success, name="redirect") ] And this is what I am attempting to redirect it with: return HttpResponseRedirect(f'/register/{plan}/success') This sends a get request, but it only shows up in the networks tab of developer tools, it doesn't actually render in the same way as if you went to the URL manually. How would I achieve this? -
Overriding a Django core class without modifying its import path
Is there a way to override a core Django class without modifying its import path? For example, the class BaseCommand is imported by django.core.management.base. I want to override/modify BaseCommand and still be able to import it from the same path. Is that possible? -
django Rest-framework serialize two tables
i have table "Books" with some fields, and i have table "Prices", each customer have self price, i don't know how get price for definitely client, how i must configure serializer? please, help me, class Book(models.Model): title = models.CharField('Заголовок', max_length=250) code = models.CharField('Код', primary_key=True, max_length=10) isbn = models.CharField('ISBN', max_length=18, null=True, blank=True) ean13 = models.CharField('EAN-13', max_length=13, null=True, blank=True) author = models.ForeignKey(Author, on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Автор') class PricesName(models.Model): name = models.CharField('Вид цены', max_length=20) def __str__(self): return self.name class Price(models.Model): book = models.ForeignKey(Book, on_delete=models.CASCADE) PricesName = models.ForeignKey(PricesName, on_delete=models.CASCADE) price = models.FloatField() def __str__(self): return self.book.title+" "+self.PricesName.name ######### Serializers.py ########################## class BookSerializer(serializers.ModelSerializer): author = serializers.StringRelatedField() class Meta: model = Book fields = #'__all__' #### API.py #### class BookViewSet(viewsets.ModelViewSet): queryset = Book.objects.all() permission_classes = [ permissions.AllowAny ] serializer_class = BookSerializer filter_backends = (DjangoFilterBackend, filters.SearchFilter, filters.OrderingFilter) filter_fields = ('title', 'author') search_fields = ('title', 'author') pagination_class = StandardResultsSetPagination -
DJANGO POSTGRES matching query does not exist
Hi i have a seller model that is related one to one field with user in DJANGO. Seller can create a "deal" and to become seller you first have to create a normal account as a user. I dont have any idea how to take to the view deals that are from the specyfic seller MY views. @user_passes_test(is_seller) def seller_page(request): if request.method == "GET": user = request.user _seller = Seller.objects.get(user_id=user) # TODO: doesnt work deals = Deal.objects.get(seller_id=_seller) form = forms.DealModelForm context = {'deals': deals, 'form': form} return render(request, 'seller_page.html', context) My models class Seller(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) name = models.CharField(max_length=255) address = models.CharField(max_length=255) city = models.CharField(max_length=255) post_code = models.CharField(max_length=6) phone = models.CharField(max_length=12) email = models.CharField(max_length=255) bank_account = models.CharField(max_length=255) nip = models.CharField(max_length=255) is_seller_active = models.BooleanField(default=False) sells = models.IntegerField(default=0) class Deal(models.Model): seller = models.ForeignKey(Seller, on_delete=models.CASCADE) title = models.CharField(max_length=255) description = models.TextField() image = models.ImageField() is_deal_on = models.BooleanField(default=True) sell_price = models.DecimalField(default=0, decimal_places=2, max_digits=6, help_text='Cena sprzedaży') origin_price = models.DecimalField(default=0, decimal_places=2, max_digits=6, help_text='Oryginalna cena', blank=True, null=True) time_valid = models.IntegerField(default=12) # ilość miesięcy ile warty jest deal unique_code = models.CharField(max_length=60, null=True, blank=True) quantity = models.IntegerField(default=0) province = models.IntegerField(choices=PROVINCES) ERROR : _seller = Seller.objects.get(user_id=user) -
Create a instance of another model on the basis of a value provided on the request of a view
Problem: I want to create a new instance of the DogAcknowledgement inside the serializer whenever a dog instance is created on the basis of the provided value(which can be true, false, or null) provided on the request. what I have tried: Create a custom_field on the serializer which will hold the value of the provided value. when the post-call is made for the dog on the to_internal_value I would add logic to create a dog_acknowledgement. if certain_value is not None: dog_ack, _ = DogAcknowledgement.objects.get_or_create(dog=???(object)) else: something But how do I access the dog object that is being created in the post request? when I send the object itself I get an error. -
How do I access a server's file manager using cwp simple terminal?
I am currently new to using CWP panel and understand it provides a user friendly file manager. However, I am trying to configure the Apache server to run Django and need to download mod_wsgi package on the server. -
post request body additional data from drf serializer
I need user to send me data in this format. Each items in the "data", mast contain "mandatory_key" and they can additionally send any other keys they want. { "data": [ { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... }, { "mandatory_key": "Value", "key_1": "value_1", "key_2": "value_2", "key_3": "value_3", ... } ] } since "mandatory_key" is the only key that I know, I can make my serializer like this. class MySerializer(Serializer): mandatory_key = CharField() When I initiate this serializer with data attribute, in the validated_data, it only gives me mandatory_key, not other keys. serializer = MySerializer(data=request.data) if serializer.is_valid(): print(serializer.validated_data) Is there any ways I can do this using serializer? I don't want to manually validate it. Because the use case is much different. Thanks! -
How to remove all symbols within a given string in Javascript?
Currently I am using the following Javascript code to convert a product title into URL-slug within the base template of my django project. document.getElementById("title").onkeyup = function () { document.getElementById("url_slug").value = document .getElementById("title") .value.toLowerCase() .replaceAll(" ", "-") .replaceAll("'", "") }; This is using consecutive replaceAll() methods to replace space with dash then remove apostrophes but i would like to prevent all other symbols (e.g. +=()[]$%@#... etc) as well. Surely there must be a better way? Thanks in advance for any suggestions! -
How can I override contrib.auth.LoginView permission?
how can I override default permission on contrib.auth.LoginView? I am working on a Django Rest Api using DRF. I am using django's default authentication methods from django.contrib.auth. And the problem is, I can't test login via Postman, because I don't have csrf token(yes, I am using SessionAuthenctication). How am I getting csrf, if I'm not allowed to login? -
I can not fetch Datas from Django Rest Frame work Api
I made a pagination on API. After that I got a problem. I cant display my datas that I fetched from api. So after implementation of pagination , Displaying is stopped. pagination.py from rest_framework.pagination import PageNumberPagination class SmallPagination(PageNumberPagination): page_size =5 List Api class MeetingList(generics.ListAPIView): queryset = CreateNewMeeting.objects.all() pagination_class = SmallPagination serializer_class = MeetingSerializer Permission_Classes = [permissions.IsAuthenticatedOrReadOnly] filter_backends = (SearchFilter, OrderingFilter) search_fields = ('meeting_name', 'id') index.html def MeetingViewSearch(request): meeting = "http://127.0.0.1:8000/meetingdetails/?page=1" read_meeting = requests.get(meeting).json() context = {'meetings': read_meeting} return render(request, 'index.html', context) I'll be glad If someone could help me ... -
Django site not loading using Apache2 and mod_wsgi
Trying to deploy a Django site using Apache and wsgi on an AWS EC2 instance. When running the site using python manage.py runserver 0.0.0.0:8000 everything works perfectly when connecting via the elastic ip. I was under the impression that using Apache and wsgi the site would automatically start and be kept up even after closing the shell. I may be wrong about that though so please correct me if so. I followed the official documentation for setting up the files, and also checked out some other tutorials to try and get it to show but nothing. They all say once the 000-default.conf file is setup and Apache is restarted, to check the site IP, but mine never loads the connection eventually times out. my file structure is: home └── ubuntu/ └── django/ └── portfolio/ ├── portfolio/ │ ├── base │ ├── portfolio/ │ │ ├── settings.py │ │ └── wsgi.py │ ├── static/ │ ├── templates/ │ └── manage.py └── venv/ └── lib/ └── python3.8/ └── site-packages/ my Apache 000-default.conf is <VirtualHost *:80> ServerAdmin YourEmail@yourProvider.com DocumentRoot /home/ubuntu/django/portfolio/portfolio ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined Alias /static /home/ubuntu/django/portfolio/portfolio/static <Directory /home/ubuntu/django/portfolio/portfolio/static> Require all granted </Directory> <Directory /home/ubuntu/django/portfolio/portfolio/portfolio> <Files wsgi.py> Require all granted </Files> </Directory> …
