Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Elastic Beanstalk - Cant migrate Django Database
I'm having the worst time trying to set up my Elastic Beanstalk instance and get it to work with Django. I am trying to get my migrations to work but I encounter every problem in the book one after another. I use: Python 3.8 with Amazon Linux 2/3.3.9 I start from a brand new database with no previous migrations and run these commands from my db-migrate.config file: container_commands: 01_collectstatic: command: "source /var/app/venv/*/bin/activate python3 manage.py collectstatic --noinput" 02_show_migrations: command: "source /var/app/venv/*/bin/activate && python3 manage.py showmigrations" 03_migrate_sites: command: "source /var/app/venv/*/bin/activate && python3 manage.py migrate sites" 04_migrate_ct: command: "source /var/app/venv/*/bin/activate && python3 manage.py migrate contenttypes" 05_makemigrations: command: "source /var/app/venv/*/bin/activate && python3 manage.py makemigrations app1" 06_migrate: command: "source /var/app/venv/*/bin/activate && python3 manage.py migrate app1" 07_makemgirations: command: "source /var/app/venv/*/bin/activate && python3 manage.py makemigrations app2" 08_migrate_custom_user: command: "source /var/app/venv/*/bin/activate && python3 manage.py migrate app2" 09_makemigrations: command: "source /var/app/venv/*/bin/activate && python3 manage.py makemigrations app3" 10_migrate: command: "source /var/app/venv/*/bin/activate && python3 manage.py migrate app3" ... 17_migrate: command: "source /var/app/venv/*/bin/activate && python3 manage.py migrate" As you can deduce, I went through a painful 'trial and error' process to find an order to my apps which wouldn't trigger migration errors. That was the only way I could finally migrate every … -
How to catch all stripe webhook events that are not explicitly handled?
There are a lot of different types of Stripe events. Further, they note they can add more at any time. I am using dj-stripe. With my event handlers I have an OK idea of what types of webhooks I should be monitoring for a pretty straightforward Stripe subscription setup. Within the dj-stripe framework is there an easy way to catch unhandled webhooks that I encounter in production? On these I'd like to email myself that an unhandled Stripe webhook event has occurred. For example, I have the following webhook handlers: @csrf_exempt @webhooks.handler("checkout") def my_handler(event, **kwargs): print("handling checkout event...") print(event.type) @csrf_exempt @webhooks.handler("customer") def my_customer_handler(event, **kwargs): print("handling customer event... in my_customer_handler") print(event.type) @csrf_exempt @webhooks.handler("charge") def my_charge_handler(event, **kwargs): print("handling charge event... in my_charge_handler") print(event.type) @csrf_exempt @webhooks.handler("payment_intent") def my_payment_intent_handler(event, **kwargs): print("handling payment_intent event... in my_payment_intent_handler") print(event.type) @csrf_exempt @webhooks.handler("price", "product") def my_price_and_product_handler(event, **kwargs): print("handling price/product event... in my_price_and_product_handler") print(event.type) Now let's say that some type of invoice webhook comes in. I understand that djstripe will save this event to the djstripe_invoice table (via path('stripe/', include("djstripe.urls", namespace="djstripe")),). But what if I want to catch that it not a webhook type that is currently handled outside of the built-in dj-stripe URLs? Is there any webhook signature I … -
How to set default_lon, default_lat for admin page using GISModelAdmin
How do you set default_lon, default_lat, and default_zoom for a PointField in the django admin page using GISModelAdmin class? With the following code the admin page loads correctly, but with the default location in Europe. model.py from django.contrib.gis.db import models class Enclosure(models.Model): location = models.PointField() name = models.CharField(max_length=15) admin.py from .models import Enclosure @admin.register(Enclosure) class EnclocusreAdmin(GISModelAdmin): pass I've tried the following code to try to set default lat, lon for the widget. However doing this results in no map displayed for the PointField on the admin page. admin.py from .models import Enclosure @admin.register(Enclosuer) class EnclosureAdmin(GISModelAdmin): gis_widget_kwargs = {'attrs': { 'default_lon': 50, 'default_lat': 100,}} The relevant Django code is class GISModelAdmin(GeoModelAdminMixin, ModelAdmin): pass class GeoModelAdminMixin: gis_widget = OSMWidget gis_widget_kwargs = {} def formfield_for_dbfield(self, db_field, request, **kwargs): if ( isinstance(db_field, models.GeometryField) and (db_field.dim < 3 or self.gis_widget.supports_3d) ): kwargs['widget'] = self.gis_widget(**self.gis_widget_kwargs) return db_field.formfield(**kwargs) else: return super().formfield_for_dbfield(db_field, request, **kwargs) class OSMWidget(OpenLayersWidget): """ An OpenLayers/OpenStreetMap-based widget. """ template_name = 'gis/openlayers-osm.html' default_lon = 5 default_lat = 47 default_zoom = 12 def __init__(self, attrs=None): super().__init__() for key in ('default_lon', 'default_lat', 'default_zoom'): self.attrs[key] = getattr(self, key) if attrs: self.attrs.update(attrs) -
get() got an unexpected keyword argument 'pk'
I am learning how to use django, and I am trying to make some class based views. In this case I have a model named Recurso and I want to get an specific one based on it's id (the primary key). This is my view: class Recurso(View): model = Recurso def get(self, request, recurso_id): recurso = get_object_or_404(Recurso, pk=recurso_id) etiquetas = recurso.tags.all() context = { 'recurso': recurso, 'lista_etiquetas': etiquetas } return render(request, 'recurso.html', context) And this is it's respective url: path('proveedor/recurso/<int:recurso_id>', Recurso.as_view(), name='recurso'), -
all methods of a class in powershell
I want to see all methods of p = Post.objects I know in Linux if you hit TAB 2 times you can, but in windows I don't know how should I do that I use PyCharm terminal -
Can you make a equivalent to google adsense?
I am currently working on a blogging website using django. Once it is finished I would like to show ads on my website, but I do not want to use google adsense or any other pre-existing services that can do that no I want to build my own. Where do I start? -
Update date and name field of model based on the field of another model
I am a bit stuck... I am building a bookkeeping system as a practice for me to learn django more I have a model for Bank as below: class Bank(models.Model): bank_name = models.CharField(max_length=50, blank=True, null=True) sales_invoive = models.ForeignKey("Income", on_delete=models.CASCADE, blank=True, null=True, related_name='sales_invoices') payment_date = models.DateField(blank=True, null=True) I then have an Income sheet statement like below class Income(models.Model): invoice_number = models.CharField(max_length=20) line_item = models.IntegerField() invoice_date = models.DateField() doc_number = models.ForeignKey(Document, on_delete=models.CASCADE) payment_date = models.ForeignKey(Bank, on_delete=models.CASCADE, related_name='sales_invoices', blank=True, null=True) customer_name = models.ForeignKey(Customer, on_delete=models.CASCADE, blank=True, null=True) product_name = models.ForeignKey(Product, on_delete=models.CASCADE, blank=True, null=True) My wish is that, when I enter an invoice in the Income sheet I can be able to select the same invoice number from Bank model and when I enter the payment date of that invoice it must update the Income sheet automatically TIA!!! -
IF logic for rating of bookstores django python
I want to make a program, if I haven't chosen a rating, I can't write a review. Here is the program code in views.py if request.method == 'POST': if request.user.is_authenticated: if form.is_valid(): temp = form.save(commit=False) temp.reviewer = User.objects.get(id=request.user.id) temp.buku = buku temp = Buku.objects.get(id_buku=id) temp.totalreview += 1 temp.totalrating += int(request.POST.get('review_star')) form.save() temp.save() messages.success(request, "Review Added Successfully") form = ReviewForm() else: messages.error(request, "You need login first.") -
Django TypeError: 'NoneType' object is not subscriptable
I have some trouble with one of my functions in my projects view file. I have tested with removing this function and then things work. Here is the view, This is my view file def createPurchaseOrder(request): form = PurchaseOrderForm() if request.method == 'POST': form = PurchaseOrderForm(request.POST) if form.is_valid(): form.save() return redirect('/') context = {'form':form} return render(request, 'order_form.html', context) Here is the hmtl file with the link which tries to access the view {% for order in orders %} <tr> <td>{{order.po_number}}</td> <td>{{order.product}}</td> <td>{{order.status}}</td> <td><a href="{% url 'update_order' update_order.id %}">Update</a></td> <td><a href="">Delete</a></td> </tr> {% endfor %} I also have attached the urls.py urlpatterns = [ path('admin/', admin.site.urls), path('', views.home, name="home"), path('supplier/<str:pk>/', views.supplier, name="supplier"), path('products/', views.products, name="products"), path('purchase_order/', views.purchase_order, name="purchase_order"), path('order_form/', views.createPurchaseOrder, name="create_purchase_order"), path('update_order/<str:pk>/', views.updatePurchaseOrder, name="update_order"), ] I expect there to be a simple mistake, but can't seem to find it. -
AttributeError at /user/ 'CommentSection' object has no attribute 'post' django
When i try uploading a comment to a post i get this error The post model is a foriegnKeyfield of the post the comment is posted on I tried changing the model name but it did nothing i get the same error again Here is the models code : class Comment(models.Model): post = models.ForeignKey(Meme, on_delete=models.CASCADE) op = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, default=1) comment = models.TextField() date_added = models.DateTimeField(auto_now_add=True) and here is the view : def user_home(request): comment = CommentSection() id = request.POST.get('id') if request.method == 'POST': comment = CommentSection(request.POST) if comment.is_valid(): comment.save(commit=False) comment.op = request.user comment.not_post_method_ok.id = id comment.save() comments = Comment.objects.all() imgs = Meme.objects.all() ctx = { 'imgs': imgs, 'comment': comment, 'comments': comments, } return render(request, 'User_Home.html', ctx) the id i get works but for some reason i keep getting this error please help and thanks a lot -
How to Implement 4-way Dependent Dropdown List with Django?
i am trying to make a 4 Dependent dropdown list using Django. I am following this example of code with 3 dropdowns https://github.com/masbhanoman/django_3way_chained_dropdown_list but i am getting an error. This is my code: models.py from django.db import models class Country(models.Model): name = models.CharField(max_length=30) def __str__(self): return self.name class City(models.Model): country = models.ForeignKey(Country, on_delete=models.CASCADE) name = models.CharField(max_length=30) def __str__(self): return self.name class Vanue(models.Model): name = models.CharField(max_length=10) city = models.ForeignKey(City, on_delete=models.CASCADE) def __str__(self): return self.name class Area(models.Model): name = models.CharField(max_length=10) vanue = models.ForeignKey(Vanue, on_delete=models.CASCADE) def __str__(self): return self.name class Person(models.Model): name = models.CharField(max_length=100) birthdate = models.DateField(null=True, blank=True) country = models.ForeignKey(Country, on_delete=models.SET_NULL, null=True) city = models.ForeignKey(City, on_delete=models.SET_NULL, null=True) vanue = models.ForeignKey(Vanue, on_delete=models.SET_NULL, null=True) def __str__(self): return self.name forms.py from django import forms from .models import Person, City, Vanue, Area class PersonForm(forms.ModelForm): class Meta: model = Person fields = ('name', 'birthdate', 'country', 'city', 'vanue', 'area') def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs) self.fields['city'].queryset = City.objects.none() #city if 'country' in self.data: try: country_id = int(self.data.get('country')) self.fields['city'].queryset = City.objects.filter(country_id=country_id).order_by('name') except (ValueError, TypeError): pass # invalid input from the client; ignore and fallback to empty City queryset elif self.instance.pk: self.fields['city'].queryset = self.instance.country.city_set.order_by('name') #vanue self.fields['vanue'].queryset = City.objects.none() if 'city' in self.data: try: city_id = int(self.data.get('city')) self.fields['vanue'].queryset = Vanue.objects.filter(city_id=city_id).order_by('name') except … -
Linear regression prediction
I have source code to predict heart diseases, but it shows 1-if disease is exist, and 0-if none disease. I need to make precent of disease. Here is an example with logistic regression, but i have 4 algorithms, so i need to show precentege of risk. Actually, i am new in AI, so this is not my code at all but i need to improve it if form.is_valid(): features = [[ form.cleaned_data['age'], form.cleaned_data['sex'], form.cleaned_data['cp'], form.cleaned_data['resting_bp'], form.cleaned_data['serum_cholesterol'], form.cleaned_data['fasting_blood_sugar'], form.cleaned_data['resting_ecg'], form.cleaned_data['max_heart_rate'], form.cleaned_data['exercise_induced_angina'], form.cleaned_data['st_depression'], form.cleaned_data['st_slope'], form.cleaned_data['number_of_vessels'], form.cleaned_data['thallium_scan_results']]] standard_scalar = GetStandardScalarForHeart() features = standard_scalar.transform(features) SVCClassifier,LogisticRegressionClassifier,NaiveBayesClassifier,DecisionTreeClassifier=GetAllClassifiersForHeart() predictions = {'SVC': str(SVCClassifier.predict(features)[0]), 'LogisticRegression': str(LogisticRegressionClassifier.predict(features)[0]), 'NaiveBayes': str(NaiveBayesClassifier.predict(features)[0]), 'DecisionTree': str(DecisionTreeClassifier.predict(features)[0]), } pred = form.save(commit=False) l=[predictions['SVC'],predictions['LogisticRegression'],predictions['NaiveBayes'],predictions['DecisionTree']] count=l.count('1') result=False if count>=2: result=True pred.num=1 else: pred.num=0 pred.profile = profile pred.save() predicted = True #### logistic regression #fitting LR to training set from sklearn.linear_model import LogisticRegression classifier =LogisticRegression() classifier.fit(X_train,Y_train) #Saving the model to disk #from sklearn.externals import joblib #filename = 'Logistic_regression_model.pkl' #joblib.dump(classifier,filename) #Predict the test set results y_Class_pred=classifier.predict(X_test) #checking the accuracy for predicted results from sklearn.metrics import accuracy_score accuracy_score(Y_test,y_Class_pred) # Making the Confusion Matrix from sklearn.metrics import confusion_matrix cm = confusion_matrix(Y_test, y_Class_pred) #Interpretation: from sklearn.metrics import classification_report print(classification_report(Y_test, y_Class_pred)) #ROC from sklearn.metrics import roc_auc_score from sklearn.metrics import roc_curve logit_roc_auc = roc_auc_score(Y_test, classifier.predict(X_test)) fpr, … -
Django logger file created but no content for django or gunicorn
I am using Django 3.2 and gunicorn 20.1 I am trying to provide useful log tracing in my models, views etc. Typically, I am using named loggers as follows: /path/to/myproject/myapp/somemodule.py import logging logger = logging.getLogger(__name__) logger.warn('Blah blah ...') /path/to/myproject/mypoject/settings.py # https://stackoverflow.com/questions/27696154/logging-in-django-and-gunicorn # https://stackoverflow.com/questions/33990693/django-log-to-file-by-date-or-hour LOGGING = { 'version': 1, 'disable_existing_loggers': False, 'formatters': { 'verbose': { 'format' : "[%(asctime)s] %(levelname)s [%(name)s:%(lineno)s] %(message)s", 'datefmt' : "%d/%b/%Y %H:%M:%S" }, 'simple': { 'format': '%(levelname)s %(message)s' }, }, 'handlers': { 'console': { 'level': 'DEBUG', 'class': 'logging.StreamHandler', }, 'logfile': { 'level':'DEBUG', 'class': 'logging.handlers.TimedRotatingFileHandler', 'filename': os.path.join(BASE_DIR, 'logs/site.logs'), 'maxBytes': 1024 * 1024 * 15, # 15MB 'when': 'D', # this specifies the interval 'interval': 1, # defaults to 1, only necessary for other values 'backupCount': 10, # how many backup file to keep, 10 days 'formatter': 'verbose', }, }, 'loggers': { 'gunicorn': { # this was what I was missing, I kept using django and not seeing any server logs 'level': 'INFO', 'handlers': ['logfile'], 'propagate': True, }, 'root': { 'level': 'INFO', 'handlers': ['console', 'logfile'] }, }, } As my title says, the logfile is created, however, there is no content. What is causing this, and how do I fix it? -
I am trying to use search on my object in 3 fields name, category, and tags, so now similar item three time
views.py if search: wallpapers = Wallpaper.objects.filter(Q(name__icontains=search) | Q(category__category_name__icontains=search) | Q(tags__tag__icontains=search)) Html code <form method="GET" action="/" class="d-flex"> <input class="form-control me-2" name="search" id="search" type="search" placeholder="Search" aria-label="Search"> <button class="btn btn-outline-success" type="submit">Search</button> </form> n class="btn btn-outline-success" type="submit">Search -
Why I am getting 'no file chosen' error while uploading image in django
Here is my codes and I tried all methods but none of them work :( models.py file ''' from django.db import models class Review(models.Model): name = models.CharField(max_length=50) job = models.CharField(max_length=200) body = models.TextField() image = models.ImageField() created = models.DateTimeField(auto_now_add=True) def __str__(self): return self.name + ' | ' + self.job[:50] class Meta(): ordering = ('-created',) ''' forms.py file ''' from django import forms from .models import Review class ReviewForm(forms.ModelForm): class Meta: model = Review fields = '__all__' ''' views.py file ''' from django.shortcuts import render from django.views.generic import ListView from .forms import ReviewForm from .models import Review class ReviewView(ListView): model = Review template_name = 'testimonals/home.html' def WriteReview(request): if request.method == 'POST': form = ReviewForm(request.POST, request.FILES) if form.is_valid(): form.save() form = ReviewForm() context = {'form': form} return render(request, "testimonals/create_post.html", context) ''' html file ''' <form action = "" method = "POST"> {% csrf_token %} {{ form.as_p }} <input type="submit" value="Submit"> </form> ''' Here is problem but I fill all fields Here is result which I added by admin panel -
How to loop through the multiple items in Django Template
How can I loop through items in django template. {% for brand in categories%} <div class="brand-col"> <figure class="brand-wrapper"> <img src="{{brand.product_feature_image.image.url}}" alt="Brand" width="410" height="186" /> </figure> <figure class="brand-wrapper"> <img src="imgsrc" alt="Brand" width="410" height="186" /> </figure> </div> {% endfor %} Here, first I want to loop item 1 and item 2 on figure tag and again I want to loop entire div and loop item 3 and 4 inside the div on figure tag. I tried to do with cycle, but no luck. Any help will be highly appreciated. -
I deployed an Django app on heroku as hobbyist. Why does admin changes i make disapear after a while [closed]
https://marcelinoacademy.herokuapp.com/ The admin page is programmed to help me add information to the site. Unfortunately all the information I add keep disapearing after a while. -
How do I return the url back to details page once the comment is deleted - Django?
So at the moment once the comment is deleted, the URL takes back to the post list page. As probably you could tell that I am not very experienced with Django yet so if someone could explain that how do I figure out what key is to be passed and where, that would be a great help. Please find the codes below: MODELS: class Post(models.Model): CHOICES = ( ('celebrate', 'celebrate'), ('planning', 'planning'), ('outdoor', 'outdoor'), ('holidays', 'holidays'), ('festivals', 'festivals'), ('movies', 'movies'), ('shopping', 'shopping'), ('laptop', 'laptop'), ('data', 'data'), ('sciance', 'science'), ('summers', 'summers'), ('medical', 'medical'), ('art', 'art'), ) author = models.ForeignKey(User, on_delete=models.CASCADE, default="") title = models.CharField(max_length=200) date_posted = models.DateTimeField(default=timezone.now) text = models.TextField() category = models.CharField(max_length=100, null=True, choices=CHOICES) tags = models.ManyToManyField(Tag) class Meta: """ Meta class to change the configuration, ordering by the name""" ordering = ['-date_posted'] def get_absolute_url(self): """ Reverse the Post object to the url once action has been taken with primary key to direct back to the same post """ return reverse('posts:post_list') def __str__(self): return self.title class Comment(models.Model): """ comments for Post model """ comment_post = models.ForeignKey(Post, on_delete=models.CASCADE, related_name='comment_for_post', null=True, default='') comment_text = models.TextField(null=True) date_posted = models.DateTimeField(auto_now=True) def get_absolute_url(self): """ Reverse the Post object to the url once action has been … -
TypeError: argument must be int or float in Django 3.0
Here i guess i am getting this error when trying to print the item_name let us consider my models.py as class Wastage(models.Model): client = models.ForeignKey(Client,on_delete=models.CASCADE) date = models.DateField(auto_now_add=True) item_name = models.ForeignKey(Items,on_delete=models.CASCADE) class JobItems(models.Model): item_name = models.CharField(max_length=512) here is my views.py class WastageView(ListView): template_name = 'wastage_list.django.html' model = Wastage context_object_name = "stock_wastage" def get_context_data(self, **kwargs): context = super(WastageView, self).get_context_data(**kwargs) context["faulty_reasons"] = FaultyReason.objects.filter(client=self.request.user.client,is_deleted=False) return context def get_queryset(self): user = self.request.user client = user.client query = self.request.GET.get('query') if query: return self.model.objects.filter(client=client, name__icontains=query).order_by('-date') return self.model.objects.filter(client=client).order_by('-date') Now let us consider my template wastage_list.django.html as {% for item in stock_wastage %} <tr> <td>{{ item.date|date }}</td> <td>{{ item.item_name }} </td> </tr> {% endfor %} Here my issue is with the item_name here is an example of my database record id client_id date item_name_id 1 3 2021-06-24 103 2 3 2021-11-23 21 3 3 2022-01-02 53 Please help me to display item_name -
Django error: no such table: main.auth_user__old
I am trying to add a product in the admin part of my website. However, when I press save, I get this error: OperationalError at /admin/products/product/add/ no such table: main.auth_user__old Request Method: POST Request URL: http://127.0.0.1:8000/admin/products/product/add/ Django Version: 4.0 Exception Type: OperationalError Exception Value: no such table: main.auth_user__old Exception Location: C:\Users\timotrocks\PycharmProjects\Django project\venv\lib\site-packages\django\db\backends\sqlite3\base.py, line 416, in execute Python Executable: C:\Users\timotrocks\PycharmProjects\Django project\venv\Scripts\python.exe Python Version: 3.9.5 Python Path: ['C:\Users\timotrocks\PycharmProjects\Django project', 'C:\Users\timotrocks 'pek\AppData\Local\Programs\Python\Python39\python39.zip', 'C:\Users\timotrocks\AppData\Local\Programs\Python\Python39\DLLs', 'C:\Users\timotrocks\AppData\Local\Programs\Python\Python39\lib', 'C:\Users\timotrocks\AppData\Local\Programs\Python\Python39', 'C:\Users\timotrocks\PycharmProjects\Django project\venv', 'C:\Users\timotrocks\PycharmProjects\Django ' 'project\venv\lib\site-packages'] -
iframe inside electron app (django backend) returns CSRF verification failed on form submit
I have the following stack: Django backend. electron (React) frontend. I'm rewriting an old server side rendering frontend with React but for the meanwhile we want to still be able to use it. So we're trying to use an iframe , but when I try to the login form we have, I'm getting 403 CSRF verification failed. -
Authentication to my app does not work when I deploy on heroku
Here is my code def connexion(request): if request.method == "POST": form = LoginForm(request.POST) if form.is_valid(): email = form.cleaned_data["email"] password = form.cleaned_data["password"] matricule = form.cleaned_data["matricule"] user = authenticate(email=email, password=password) if user is not None: user = User.objects.get(email=email) if Agent.objects.filter(user=user, matricule=matricule).exists(): agent = get_object_or_404(Agent, user=user) profile = agent.profile if user.is_active: login(request, user) request.session["profile"] = profile return redirect(reverse("elec_meter:home")) else: messages.add_message(request,messages.WARNING,"Votre profile n'est pas " "encore activé! Veuillez contacter l'administrateur.") return render(request, "elec_meter/login.html", {"form": form}) else: messages.add_message(request,messages.ERROR,"Utilisateur non existant !") return render(request, "elec_meter/login.html", {"form": form}) else: messages.add_message(request,messages.ERROR,"Utilisateur non existant !") return render(request, "elec_meter/login.html", {"form": form}) else: form = LoginForm() return render(request, "elec_meter/login.html", {"form": form}) This is the code that allows authentication to my app. It works very well locally. But when I deploy the application on heroku it doesn't work anymore. It always sends me back to the login page without any messages. Sometimes it sends me a 403 forbidden while I have {% csrf_token%} in the form. Are there any configurations to add ? How can I solve this problem ? -
Many-to-many relationship between 3 tables in Django
I have the following models: class Project(models.Model): project_name = models.CharField(max_length=50) project_users = models.ManyToManyField('Users.UserAccount', related_name='project_users', blank=True) .... class UserAccount(AbstractBaseUser, PermissionsMixin): username = models.CharField(max_length=30, unique=True) .... class Discipline(models.Model): name = models.CharField(unique=True, max_length=27, choices=discipline_choices) The DB table for project_users looks like this: *--------*----------------*---------------------* | ID | project_id | user_account_id | *--------*----------------*---------------------* I want to have an extra relationship in project_users field/table with the Discipline model. Is that possible in Django? I have been looking at intermediary-manytomany relationships in Django, but that's not exactly what I want. In my application, there are a set amount of disciplines, and what I'm trying to achieve is to give each user multiple disciplines in a single project. So something like this: *--------*----------------*---------------------*-------------------* | ID | project_id | user_account_id | discipline_id | *--------*----------------*---------------------*-------------------* Is this possible? -
Python (Django) how to assign a default value in case of error
Hey I'm using django in a project, using a POST method, the view in Django receives data, it works fine if the data is received but if no data is received I want to assign a default value instead of getting an error here is my code. I tried to use the if assignement but it doesn't work. @api_view(['POST']) def getPacsPatients(request): data = json.loads(request.body.decode('utf-8')) if request.method == 'POST': PatientName = data["patientName"] if data["patientName"] else "*" #it works fine if data["patientName"] is present, but if not I get an error -
How can i use Exists with WHEN CASE in Django
I am trying to write ORM in Django something like this: DECLARE @vari1 INT = 2 DECLARE @vari2 INT = 0 SELECT *, CASE WHEN EXISTS (SELECT B_id FROM dbo.Subscription WHERE AreaSubscription.BusinessId = CompanyMaster.BusinessId) THEN @vari1 ELSE @vari2 END) FROM dbo.Subscription;
