Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Firebase for notification and aws for backend and database
I am trying to implement a notification system in Django. I find the firebase quite easy which is as follow: from fcm_django.models import FCMDevice device = FCMDevice.objects.all() Now in view: device.send_message(title="Title", body="Message", icon=..., data={"test": "test"}) In settings: FCM_DJANGO_SETTINGS = { # default: _('FCM Django') "APP_VERBOSE_NAME": "[string for AppConfig's verbose_name]", # true if you want to have only one active device per registered user at a time # default: False "ONE_DEVICE_PER_USER": True/False, # devices to which notifications cannot be sent, # are deleted upon receiving error response from FCM # default: False "DELETE_INACTIVE_DEVICES": True/False, # Transform create of an existing Device (based on registration id) into # an update. See the section # "Update of device with duplicate registration ID" for more details. "UPDATE_ON_DUPLICATE_REG_ID": True/False, } Now my question is, we are using AWS for the backend and also for the database. In this case can we use the firebase for notification? How do these two services aws and firebase work together? WIll there be any problem?? -
How do i replace or overwrite imagges stored in cloudinary using django
I want to setup user profile pic but do not want to keep adding new files each time they change the picture is there a way to overwrite or replace an image in the cloudinary database Here is Models : class CloudinaryField(BaseCloudinaryField): def upload_options(self, model_instance): return { 'public_id': UserProfile.user.username, 'filename': "Hey", 'unique_filename': False, 'overwrite': False, 'resource_type': 'image', 'tags': ['Profile'], 'invalidate': True, 'quality': 'auto:eco', } class UserProfile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) date_created = models.DateTimeField(auto_now_add=True) Nick_Name = models.CharField(default="Hey", max_length=250) Profile_pic = CloudinaryField('Profile_Pic', default="") forms : class UserProfilePage(forms.ModelForm): class Meta: model = UserProfile fields = ['Nick_Name', 'Profile_pic'] help_texts = { 'Nick_Name': 'This will act as your display name', } Profile_pic = CloudinaryFileField( options={ 'folder': 'Profile/', }) And finally the views : def edit(request): func = data(request) form = UserEdit(initial={'email': request.user.email}) profile = UserProfilePage(initial={'Nick_Name': request.user.userprofile.Nick_Name, 'Profile_pic': request.user.userprofile.Profile_pic.url}) if request.method == "POST": form = UserEdit(data=request.POST or None, instance=request.user) profile = UserProfilePage(data=request.POST or None, instance=request.user.userprofile, files=request.FILES) if form.is_valid() and profile.is_valid(): user = form.save() profiles = profile.save() return redirect("Profile_Page") ctx = { 'form': form, 'profile': profile, 'url': func[0], 'name': func[1], 'date': func[2], } return render(request, "Edit_User.html", ctx) If any more code is required please comment it i will for sure edit it into the question Thanks a … -
Django Mixing Static and Media(Public/Private)
Whenever I run the following I get (portfolio) PS C:\Users\arund\Desktop\Code\Django\portfolio-project> python manage.py collectstatic You have requested to collect static files at the destination location as specified in your settings. This will overwrite existing files! Are you sure you want to do this? Type 'yes' to continue, or 'no' to cancel: yes Traceback (most recent call last): File "C:\Users\arund\Desktop\Code\Django\portfolio-project\manage.py", line 22, in <module> main() File "C:\Users\arund\Desktop\Code\Django\portfolio-project\manage.py", line 18, in main execute_from_command_line(sys.argv) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\core\management\__init__.py", line 419, in execute_from_command_line utility.execute() File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\core\management\__init__.py", line 413, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\core\management\base.py", line 354, in run_from_argv self.execute(*args, **cmd_options) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\core\management\base.py", line 398, in execute output = self.handle(*args, **options) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\contrib\staticfiles\management\commands\collectstatic.py", line 187, in handle collected = self.collect() File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\contrib\staticfiles\management\commands\collectstatic.py", line 114, in collect handler(path, prefixed_path, storage) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\contrib\staticfiles\management\commands\collectstatic.py", line 338, in copy_file if not self.delete_file(path, prefixed_path, source_storage): File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\django\contrib\staticfiles\management\commands\collectstatic.py", line 248, in delete_file if self.storage.exists(prefixed_path): File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\storages\backends\s3boto3.py", line 469, in exists self.connection.meta.client.head_object(Bucket=self.bucket_name, Key=name) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\botocore\client.py", line 391, in _api_call return self._make_api_call(operation_name, kwargs) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\botocore\client.py", line 691, in _make_api_call request_dict = self._convert_to_request_dict( File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\botocore\client.py", line 737, in _convert_to_request_dict api_params = self._emit_api_params( File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\botocore\client.py", line 766, in _emit_api_params self.meta.events.emit( File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\botocore\hooks.py", line 357, in emit return self._emitter.emit(aliased_event_name, **kwargs) File "C:\Users\arund\Desktop\Code\Django\portfolio-project\venv\lib\site-packages\botocore\hooks.py", line 228, in emit return self._emit(event_name, kwargs) File … -
Set ForeignKey in Django Error : matching query does not exist
I want to set ForeignKeys to my tables in views.py but I got this Error Words matching query does not exist. at this line of code : word_id = Words.objects.get(pk= wordID), I don't know what's wrong and Why I got this error? So how I should set the foreign keys? this is my model.py code class Words(models.Model): word = models.CharField(max_length=50) phonetic= models.CharField(max_length=50) audio= models.URLField(max_length = 200) class Meanings(models.Model): word_id = models.ForeignKey(Words, on_delete=models.CASCADE) partOfSpeech = models.CharField(max_length=30) class Definitions(models.Model): word_id = models.ForeignKey(Words, on_delete=models.CASCADE) Meaning_id = models.OneToOneField(Meanings, on_delete=models.CASCADE, primary_key=True) definition = models.TextField() def __str__(self): return self.definition and this is the views.py : def get_details(request): words = ['hello', 'table' , windows'] wordID = 0 MeaningID = 0 for word in words: wordID+=1 print(word) url = 'https://api.dictionaryapi.dev/api/v2/entries/en/' + word response = requests.get(url) if type(response.json()) == list: response = response.json()[0] # convert list to dictionary word = response.get('word',{}) phonetics = response.get('phonetics',{}) phonetic = phonetics[0] print(phonetic) word_data = Words( word = response.get('word',{}), phonetic = phonetic.get('text', {}), audio = phonetic.get('audio', {}) ) word_data.save() meanings = response.get('meanings',{}) for i in range(len(meanings)): MeaningID +=1 meaning_data =Meanings( word_id = Words.objects.get(pk= wordID), partOfSpeech = meanings[i].get('partOfSpeech',{}) ) meaning_data.save() definitions_data = Definitions( word_id = Words.objects.get(id= wordID), meaning_id = Meanings.objects.get(id= MeaningID), definition = meanings[i].get('definition',{}) ) … -
Wrong distance calculation between two Points in django
I have a model that uses PointField to store location: from django.contrib.gis.db import models from django.contrib.gis.geos import Point class Post(models.Model) location = models.PointField() and trying to do the following calculation: initial_location = Post.objects.first().location last_location = Post.objects.last().location total_distance = initial_location.distance(last_location) The values for this locations are: print(initial_location) >>> SRID=4326;POINT (-1.407385628884526 -24.29361291088179) print(last_location) >>> SRID=4326;POINT (65.55023895708794 43.8537639564256) print(total_distance) >>> 95.53736684717059 Ok, at first glance I thought it was working, but this value is totally wrong. Using this site to convert decimal coordinates to degrees coords and this site to calculate the distance based on this coords, I get a result almost 100 times higher than Django is printing. I'm not sure what is wrong since all of these methods and functions are built-in of the Point class. -
how to get the Userid in GET method in Django Rest framework
I'm trying to pass the requested "userid" to the Stored Procedure but I couldn't able to get the requested "userid" in GET method. SP is working fine when I entered user id directly views.py: @api_view(['GET', 'POST']) def ClaimReferenceView(request, userid): try: userID = Tblclaimreference.objects.filter(userid=userid) except Tblclaimreference.DoesNotExist: return Response(status=status.HTTP_404_NOT_FOUND) if request.method == 'GET': user = Tblclaimreference.objects.get(userid=self.request.user.id) print(user) cursor = connection.cursor() cursor.execute('EXEC [dbo].[sp_GetClaims] @UserId= %s',(user,)) result_set = cursor.fetchall() print(type(result_set)) response_data = [] for row in result_set: response_data.append( { "Number": row[0], "Opened": row[1], "Contacttype": row[2], "Category1": row[3], "State": row[4], "Assignmentgroup": row[5], "Country_Location": row[6], "Openedfor": row[7], "Employeenumber": row[8], "Shortdescription": row[9], "AllocatedDate": row[10] } ) return Response(response_data, status=status.HTTP_200_OK) elif request.method == 'POST': serializer = ClaimReferenceSerializer(data=request.data) if serializer.is_valid(): serializer.save() return Response(serializer.data, status=status.HTTP_201_CREATED) return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST) models.py: class Tblclaimreference(models.Model): taskid = models.IntegerField(db_column='TaskId', primary_key=True) userid = models.IntegerField(db_column='UserID') internaldescription = models.CharField(db_column='Internaldescription', max_length=500, blank=True, null=True) additionalcomments = models.CharField(db_column='Additionalcomments', max_length=500, blank=True, null=True) -
ModuleNotFoundError: No module named 'django.db.backends.postgresql'
Try to migrate local_proxy but i got this error as shown below; Using CMD: DJANGO_SETTINGS_MODULE=maroxie.settings.local_proxy python manage.py migrate ??? Fig:1 enter image description here Fig:2 enter image description here -
Python Django ModeulNotFoundError: No module named 'SomeFolder'
I have a django app. It is quite complicated, I can't post all the code here, so I have a big picture summary. The setup of the folders in the big picture related to what I'm doing is below. Note that "SomeFolder" is a placeholder name for the actual name. Some folder is a folder containing some python scripts with functions inside of them. It wasn't installed in the Django app. I dragged and dropped SomeFolder into the backend folder. This is necessary and had to be done. It's some python stuff unrelated to Django. Dashboard backend SomeFolder A.py B.py C.py views.py Dashboard frontend manage.py Inside of views.py at the top, I do import SomeFolder Then, inside of views.py, I have a function that calls some of the functions within the python scripts A.py, B.py, and C.py. This is why I need to import SomeFolder. For example: def someFunction(): SomeFolder.A_Function_1 SomeFolder.A_Function_2 SomeFolder.B_Function_2 etc. The issue is, when I run python manage.py runserver I get a ModuleNotFoundError: No module named 'SomeFolder' in views.py. The SomeFolder folder is in the same directory as views.py, so I'm not sure why it's not being recognized. I've seen other similar examples on stackoverflow, but didn't … -
uploaded files by users in website are not showing when debug is false
hey I've been working on my website for quite a while now and finally I was deploying it for production then I've faced with this problem that I can't server media when DEBUG = FALSE apparently Django doesn't serve media for you in production for some reasons, IDK how to fix this and in my templates I've used this method to show different pictures that user have uploaded on website's database <img src="{{site.logo.url}}" alt="logo" class="footer_logo"> now none of then show up in website here are my media and static roots in setting.py STATIC_URL = '/static/' STATIC_ROOT = '../mywebsite/assets/' MEDIA_URL = '/media/' MEDIA_ROOT = os.path.join(BASE_DIR, 'media/') # Additional locations of static files STATICFILES_DIRS = ( os.path.join(BASE_DIR,'static'), I don't have a same problem with static files and I've almost tried all of the ways that others have recommended for same situation in other questions. also I have no idea how to setup nginx but I have no problem with setting it up and learn about it if you guys can give me a guide an how to do it, there was some tutorial on how to deploy django on Nginx with uWSGI but: first idk what is uWSGI and since I'm using … -
drf> What can I do for using annotate from M2M model
I have 4 models like this. user model class User(model.Model): name=models.ChaField() diary model class Diary(): title=charfield author=Foreignkey("user.User") recommend_diary model class RecommendDiary(): section=Foreignkey("recommend.RecommendSection") diary=Foreignkey("diary.Diary") recommend_section model class RecommendSection(): section=charfield diaries=M2M("diary.Diary", through=RecommendSection) when I give to users recommend item, I want to make an annotation that excludes blocked users. The queryset given to me is this queryset=Recommend.objects.filter(start time-end time) So I can take an object of a given queryset and check numerous diaries associated with this object like this. obj=queryset.first() diary_queryset=obj.diaries.all() (I made custom manager for this) After checking that the request user is blocked from the user who wrote this diary, and I can exclude it from the queryset. diary_list=[diary for diary in diary_queryset if diary.id not in block_list] but I got a filtered list not Queryset. and it is not RecommendSection queryset even. can I get a excluded RecommendSection queryset from blocked user by using annotate or something else? I wanna exclude block user list from RecommendSection ex) queryset=RecommandSection.objects.exclude(diary_id__in=block_user) (it doesnt work btw) I wanna use .annotate if able thx for help. -
Django - Encrypt whole instance
I'm currently figuring out what would be the best way to encrypt an instance of a model in Django. Encrypting single fields seems easy, but I would like to encrypt a whole instance. Context I'm currently building a note-taking application which should have the ability to optionally encrypt a note using a given password. The model looks something like this: class Note(models.Model): title = CharField() content = TextField() created_at = DateTimeField() edited_at = DateTimeField() While I could simply only encrypt the title and content, I don't want that to avoid telling any information about a note when it is encrypted. So basically all fields (event created_at and edited_at) should be encrypted. Thoughts I thought about adding a second model EncryptedNote which only holds a field encrypted_data. This field contains the data in a JSON format in an encrypted form. When the application needs to load the instance, it will decrypt the content and create a Note instance based on the JSON data. However, it feels a little bit off to manually save JSON when using a SQL-like database. Question Is there already a good (and secure) way to encrypt an instance or is this idea of manually encrypting and decrypting … -
NextJS/Django 404 page issue & Unhandled runtime error
So I am creating a blog using django as a backend, nextjs as a fronted. I am having an issue with categories in navbar, as all of them are returning 404 error (just before 404, I get Unhandled runtime error for less than a second, I attached a screenshot) Anyway, here is my Navbar.js component, where I use categories import Link from 'next/link' const Navbar = () => { return ( <nav className='navbar navbar-expand-lg navbar-light bg-light'> <div className='p-2 text-muted'><Link className='navbar-brand' href={'/'}>5minRead</Link></div> <button className='navbar-toggler' type='button' data-toggle='collapse' data-target='#navbarNavAltMarkup' aria-controls='navbarNavAltMarkup' aria-expanded='false' aria-label='Toggle navigation'> <span className='navbar-toggler-icon'></span> </button> <div className='collapse navbar-collapse' id='navbarNavAltMarkup'> <div className='navbar-nav'> <div className='p-4 text-muted'><a href={'/category/world'}>WORLD</a></div> <div className='p-4 text-muted'><Link href={'/category/enviroment'}>ENVIROMENT</Link></div> <div className='p-4 text-muted'><Link href={'/category/technology'}>TECHNOLOGY</Link></div> <div className='p-4 text-muted'><Link href={'/category/culture'}>CULTURE</Link></div> <div className='p-4 text-muted'><Link href={'/category/business'}>BUSINESS</Link></div> <div className='p-4 text-muted'><Link href={'/category/health'}>HEALTH</Link></div> <div className='p-4 text-muted'><Link href={'/category/travel'}>TRAVEL</Link></div> <div className='p-4 text-muted'><Link href={'/category/fashion'}>FASHION</Link></div> <div className='p-4 text-muted'><Link href={'/category/opinion'}>OPINION</Link></div> <div className='p-4 text-muted'><Link href={'/subscribe'}>SUBSCRIBE</Link></div> </div> </div> </nav> ) } export default Navbar here is my Category.js component (any category click from Navbar should navigate here) const Category = () => { return ( <div> category </div> ) } export default Category here is my views.py that contain APIView class BlogPostCategoryView(APIView): serializer_class = BlogPostSerializer permission_classes = (permissions.AllowAny, ) def post(self, request, format=None): data = self.request.data category … -
Django Rest Framework - How to make extra query before serializer.save
I'm new to Django Rest Framework and I'm trying to do this simple thing, but I'm not sure how to do it. So, this is my models.py class Category(models.Model): name = models.CharField(max_length=250) slug = models.SlugField(max_length=250, unique=True) email = models.EmailField(_('email address'), blank=True, null=True) class Meta: ordering = ('name',) def __str__(self): return self.name class Report(models.Model): category = models.ForeignKey(Category, on_delete=models.PROTECT) description = models.TextField() address = models.CharField(max_length=500) reporter_first_name = models.CharField(max_length=250) reporter_last_name = models.CharField(max_length=250) reporter_email = models.CharField(max_length=250) reporter_phone = models.CharField(max_length=250) report_image_1 = models.ImageField(_("Image"), upload_to=upload_to, null=True, blank=True) report_image_2 = models.ImageField(_("Image"), upload_to=upload_to, null=True, blank=True) report_image_3 = models.ImageField(_("Image"), upload_to=upload_to, null=True, blank=True) date = models.DateTimeField(default=timezone.now) class Meta: ordering = ('-date',) def __str__(self): return self.description I have a form in React that submits, among other values, the category ID. What I need to do, before saving the report to the DB, is send a mail to the email address of that category ID. This is my views.py class ManageCategories(viewsets.ModelViewSet): serializer_class = CategorySerializer def get_object(self, queryset=None, **kwargs): item = self.kwargs.get('pk') return get_object_or_404(Category, slug=item) def get_queryset(self): return Category.objects.all() class ManageReports(viewsets.ModelViewSet): serializer_class = ReportSerializer parser_classes = [MultiPartParser, FormParser] def get_permissions(self): if self.action == 'create': self.permission_classes = [permissions.AllowAny] else: self.permission_classes = [permissions.IsAuthenticated] return super(self.__class__, self).get_permissions() def create(self, request, *args, **kwargs): serializer = ReportSerializer(data=request.data) if … -
Supervisor when uploading a project to the server
I am trying to run my site (Django based) on a VPN server and I am having a problem. I am unable to set up a supervisor. When entering the command sudo supervisorctl reread The message appears: no config updates to processes It is quite possible that this is due to the fact that I changed the configuration file. But what to do now, I do not know. I changed the configuration file, but currently there are no errors. -
How can I edit manytomanyfield data
I am trying to edit manytomanyfield data. Here is my model class Permission(models.Model): shop = models.ForeignKey(Shop, on_delete=models.SET_NULL, null=True) permission_title = models.CharField(max_length=255) class Meta: ordering = ["-id"] def __str__(self): return self.permission_title class Roles(models.Model): shop = models.ForeignKey(Shop, on_delete=models.SET_NULL, null=True) role_title = models.CharField(max_length=255) permissions = models.ManyToManyField(Permission) class Meta: ordering = ["-id"] def __str__(self): return self.role_title Here in these models i have a model called permission. this model is in a manytomanyfield relation with Roles model. I want to edit this manytomanyfield. I have already did the creation part. But now i want to edit the data and I want to show the data in the templates, I chose while creating a role. I want to show it an input type checkox Here is my views:- def createRolesView(request, shop_id): shopId = get_object_or_404(Shop, pk=shop_id) permissions = Permission.objects.filter( shop=shopId.id ) if shopId.user == request.user: if request.method == "POST": role_title = request.POST.get("role_title") shop = Shop.objects.get(id=shopId.id) permissions = request.POST.getlist("permissions") rl = Roles( role_title = role_title, shop = shop, ) rl.save() for p in permissions: rl.permissions.add(p) rl.save() return redirect(f"/adminpanel/roles/{shopId.id}/") args = { "shopId": shopId, "permissions": permissions, } return render(request, "roles/create-role.html", args) else: return redirect("warning") def editRolesView(request, role_id, shop_id): shopId = get_object_or_404(Shop, pk=shop_id) roleId = get_object_or_404(Roles, pk=role_id) if shopId.user == … -
Access "Browser" location
We all have seen this prompt: As far as I know, this is not IP-based location. This is device-based location. I don't want IP-based location because 1) It's not reliable and 2) If the user browses my website with a VPN, the location data is absolutely wrong. I've searched PyPi.org and DjangoPackages.org but didn't find anything to implement that in my Django app. Is there any solution? -
How to make a dynamic query builder in Django
I am working on a small project where I need to make complex queries that can be grouped in a logical format. For example consider an table Books, and we need to select certain books based on filters such as 5 books from (author_reputation > 4 && recent_sale_rating > 3) AND 7 books from (book_length < 150 || recent_sale_rating > 4) So a total of 13 Books are selected using the above two queries. I was trying to figure out a way to use django FilterSet for this, finding it difficult to work through it. Also tried other libraries like djangoql etc. Any help or guidance on how to look at the problem will be of great help! -
Django Rest Framework Authentication not working
I was following a tutorial to create a Django authentication module in my app so I succeeded in creating user and login but unfortunately, some errors occurred in my project when I'm implementing the authentication, I have attached the code and error below, pls see if anyone can help. error: django_1 | Traceback (most recent call last): django_1 | File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 47, in inner django_1 | response = get_response(request) django_1 | File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 181, in _get_response django_1 | response = wrapped_callback(request, *callback_args, **callback_kwargs) django_1 | File "/usr/local/lib/python3.10/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view django_1 | return view_func(*args, **kwargs) django_1 | File "/usr/local/lib/python3.10/site-packages/django/views/generic/base.py", line 70, in view django_1 | return self.dispatch(request, *args, **kwargs) django_1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 492, in dispatch django_1 | request = self.initialize_request(request, *args, **kwargs) django_1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 394, in initialize_request django_1 | authenticators=self.get_authenticators(), django_1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 272, in get_authenticators django_1 | return [auth() for auth in self.authentication_classes] django_1 | File "/usr/local/lib/python3.10/site-packages/rest_framework/views.py", line 272, in <listcomp> django_1 | return [auth() for auth in self.authentication_classes] django_1 | TypeError: 'str' object is not callable authentication -> jwt.py class JWTAuthentication(BaseAuthentication): def authenticate(self, request): auth_header = get_authorization_header(request) auth_data = auth_header.decode('utf-8') auth_token = auth_data.split(" ") if len(auth_token) != 2: … -
how to get time since from datetime field
In Django templates, I can do time since on my model to get how long a post was made Model class Post(models.Model): author = models.ForeignKey(User, on_delete=CASCADE) trade = models.CharField(max_length=100) date_posted = models.DateTimeField(default=timezone.now) {{post.date_posted|timesince}} The above would return me something like 1 day, 8 hours ago My question is how would I do it on my model itself? So that the date_posted field returns it in the humanized format itself. I tried adding the following to my model but it doesn't work def FORMAT(self): return timesince(self.date_posted) -
Version control for Custom Postgres Function in Django
I have a custom postgres function in my Django app. Keeping it up to date with migrations works, but is very hard to code review / move changes from the DB to the migration, because each migration is an entire new block of SQL, like so: def update_func(apps, schema_editor): schema_editor.execute( """ CREATE OR REPLACE FUNCTION public.function() .... ect Does anyone have a similar situation and know a better way to version control the function? -
import error 'force_text' from 'django.utils.encoding'
I'm implementing a graphql solution using python, graphene and django and I'm getting the following import error: Result: Failure Exception: ImportError: cannot import name 'force_text' from 'django.utils.encoding' "/home/site/wwwroot/.python_packages/lib/site-packages/graphene_django/utils/utils.py", line 6, in <module> from django.utils.encoding import force_text I'm not sure about the versions and whether I need to import an additional module. My requirements.txt is like: graphene>=2.1,<3 graphene-django>=2.1,<3 graphql-core>=2.1,<3 graphql-relay==2.0.1 django-filter>=2 Has someone had a similar problem and can look at the versions that I use? Thanks -
I am getting a 'TypeError at /' message in the port when running my django code
this is my models.py This is my views.py This is the error page -
Change default value base on changed primary key field
my models: class Student(models.Model): code_stu = models.PositiveIntegerField() age_stu = models.PositiveIntegerField(default=20) class Cal_age(models.Model): code = models.ForeignKey(Student,on_delete=models.SET_NULL) age = models.PositiveIntegerField() When I am changing code field in admin panel,i want age field will change by related value in age_stu -
Transforming SQL Query to Django Expression
Assuming I have the following Django models and the according SQL-Tables with some data: UserAnswer: | id | answer | partquestion_id | |----|--------|-----------------| | 1 | 667 | 1 | PartQuestion: | id | question_id | |----|-------------| | 1 | 1 | Solution: | id | content | question_id | |----|---------|-------------| |1 | 667 | 1 | |2 | 85 | 2 | I want to get all User answers where the answer is equal to the solution of the according question. I've came up with this SQL-Query but can't really think of how to implement this into a Djano query: select * from (useranswer join partquestion on useranswer.partquestion_id = partquestion.id) join solution on partquestion.question_id = solution.question_id where answer=content; This will output the following: | id | answer | partquestion_id | id | question_id | id | content | question_id | |----|--------|-----------------|----|-------------|----|---------|-------------| | 1 | 667 | 1 | 1 | 1 | 1 | 667 | question_id I just can't get my head around this concept in Django. Maybe using F-Expressions and some stuff. Thanks for any advice. -
Autoincrement field dependent for number of specific value appearances in django
I'm looking for a good example or advice to solve my problem in Django & python. I've simple model like Customer class Customer(models.Model): customer_name = models.CharField(max_length=500) CUSTOMER_CHOICES = [ ('pc', 'Private Customer'), ('bc', 'Business Customer'), ] customer_type = models.CharField(max_length=2, choices=CUSTOMER_CHOICES) For all customers, I want to build (and show on page) a specific "Customer Number" based on customer type and a decimal number. I think I might store this value in the Customer table (somethink like this): |id|customer_name|customer_type|customer_number| |1 |Private 1 |pc |1 | |2 |Private 2 |pc |2 | |3 |Business 1 |bc |1 | |4 |Private 3 |pc |3 | |5 |Business 2 |bc |2 | Of course, when I'll modify the customer name or other value (except customer type and customer number) I don't want to update this number. It is possible to avoid the number gaps or duplicate numbers? I think the bellow code will not work (this is just an example as first thought), because I don't know how the code will work when I'll have two different sessions and when I press the save button at the same time. def save(): if customer_number is None: last_number = Customer.objects.all().filter(customer_type=passed_type).last() #bellow in the pseudocode new_invoice_number = …
