Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Stack: docker + nginx + postgres + django data lost
I have several Digital Ocean droplets (5$) hosting docker with django and postgres (image mdillon/postgis) but since 2 weeks ago I have lost data in 7 of them randomly. In all of these droplets Postgres database is located in a volume but even so it lost all the django tables and return to default status. Some of these droplet had been working for months and others just days. All of them have the same docker-compose.yml: version: '2' services: nginx: build: './docks/nginx/.' ports: - '80:80' - "443:443" volumes: - letsencrypt_certs:/etc/nginx/certs - letsencrypt_www:/var/www/letsencrypt volumes_from: - web:ro depends_on: - web web: build: './sources/.' image: 'websource' ports: - '127.0.0.1:8000:8000' env_file: '.env' command: '/venv/bin/gunicorn project.wsgi:application -k gevent -w 3 -b :8000 --worker-connections=1000 --reload --capture-output --enable-stdio-inheritance --log-level=debug --access-logfile=- --log-file=-' volumes: - 'cachedata:/cache' - 'mediadata:/media' - 'staticdata:/static' depends_on: - postgres - redis celery_worker: image: 'websource' env_file: '.env' command: 'python -m celery -A project worker -l debug' volumes_from: - web depends_on: - web celery_beat: container_name: 'celery_beat' image: 'websource' env_file: '.env' command: 'python -m celery -A pinwins beat --pidfile= -l debug' volumes_from: - web depends_on: - web postgres: container_name: 'postgres' image: 'mdillon/postgis' ports: - '5432:5432' volumes: - 'pgdata:/var/lib/postgresql/data/' redis: container_name: 'redis' image: 'redis:3.2.0' ports: - '127.0.0.1:6379:6379' volumes: - 'redisdata:/data' … -
How can I run different actions from one view in django pushing two different buttons at HTML page
I have html page with 2 buttons. I want open one bootstrap modal window were I can load photo cliking at "Photo" button and another bootstrap window for load video cliking at "Video" button. I was looking in google but I didn't find solutions. I tried to use in wiew.py this code "if 'photo' in request.POST: do somthing", and "if request.POST.get('Photo') == 'Photo': do somthing" view.py def make_post(request): if request.POST.get('Photo') == 'Photo': if request.method == 'POST': form = InstagramPhotoForm(request.POST, request.FILES) if form.is_valid(): form.save() return redirect('success_send') else: form = InstagramPhotoForm() return render(request, 'createinstagrampost/createinstagrampost.html', {'photoform' : form}) else: if request.method == 'POST': form = InstagraVideoForm(request.POST, request.FILES) if form.is_valid(): form.save() return redirect('success_send') else: form = InstagramVideoForm() return render(request, 'createinstagrampost/createinstagrampost.html', {'videoform': form}) createinstagrampost.html <form> {% csrf_token %} <div> <button class="btn btn-success" type="button" data-toggle="modal" data-target="#modal-1" name="photo" value="Photo"></button> </div> <br> <div> <button class="btn btn-success" type="button" data-toggle="modal" data-target="#modal-2" name="video" value="Video"></button> </div> <br> </form> <div class="modal fade" id="modal-1"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <div class="modal-header"> <h4 class='modal-title'>Make photo post</h4> <button class="close" type="button" data-dismiss="modal">&times;</button> </div> <div class="modal-body"> <form method="POST" enctype="multipart/form-data"> {% csrf_token %} <fieldset class="form-group"> {{ photoform|crispy }} </fieldset> <div class="form-group"> <button class="btn btn-outline-info" type="submit">Update</button> </div> </form> </div> <div class="modal-footer"> <button class="btn btn-danger" type="button" data-dismiss="modal">Cancel</button> </div> </div> </div> </div> … -
Django: is there a difference in performance between .filter("key__in"=set) and .filter("key__in"=list)
I'm asking this question in the context where I already have a list and I'm wondering if it's worth converting it into a set to use in the filter query or not, i.e. which is better: some_set = set(some_list) some_qs = SomeModel.objects.filter("some_key__in"=some_set) vs some_qs = SomeModel.objects.filter("some_key__in"=some_list) I know that if you want to lookup the elements from a list a in another list b, it's generally worth converting list b into a set since x in list is O(n) and x in set is O(1). But I don't know how Django implements the query filter __in so I'm not sure which is the better option in this context. -
How to setup a Django server state before starting gunicorn
I'm building a Django server which I'm going to host using gunicorn and want to setup its (Django's) inner state (fetch and cache some data from the blockchain, start couple threads that would perform some background updates etc.) before starting an actual HTTP server with my API endpoints. While it's fairly easy to do with the "manage.py runserver" (create my own implementation with all the actions I need before actual server starting), I'm struggling to wrap my head around the best way to do that with the WSGI gunicorn server which seems to start right away with no obvious way to specify any pre-run actions. -
SSL: TLSV1_ALERT_PROTOCOL_VERSION while POSTING
I'm doing a project, which both dev and prod branches are hosted on a server and everything works fine. I had to install it on another server to separate dev from prod, which worked well until i try to use an API used to send mails with an internal product. The site is in HTTPS and everything is up to date, from pip to django etc. When Posting to the API, i got the following error : SSLError at /api/signup HTTPSConnectionPool(host='xxxxxxxx.xx', port=443): Max retries exceeded with url: /xxxx/xxxxxxxxx/ (Caused by SSLError(SSLError(1, '[SSL: TLSV1_ALERT_PROTOCOL_VERSION] tlsv1 alert protocol version (_ssl.c:1076)'))) Anyone has an idea on why i got this error Raised by "requests" package ? -
Django Populating ManyToManyField getting value from another field of same model
Very easy problem for Expert!! For last 7 days, i am trying to solve this problem and posted 5 times on Stackoverflow with the same problem and no one can help me in this case! Stackoverflow banned my an account too! Going through a horrible frustration now! this is my last post! This is My Models... from django.db import models class Person(models.Model): name = models.CharField(max_length=20) class Group(models.Model): admin = models.ForeignKey( Person, on_delete=models.CASCADE, related_name='group_admin' ) members = models.ManyToManyField( Person, related_name='group_members', blank=True ) def save(self, *args, **kwargs): self.members.add(self.admin) super(Group, self).save(*args, **kwargs) I want An admin of a group also will be a memebrs of the group! I will fill only admin field!! and the members field will be filled automatically and its value will be the admin of the groups! I mean, an Admin of a group also will be a memebers of the same group.. Simple requirement, is not it? But this simple problem can't solve anyone on stackoverflow, so much frustration it creates! When i try to create new group, it throws me this error: "<Group: Group object (None)>" needs to have a value for field "id" before this many-to-many relationship can be used. but if i keep this method … -
How to populate dropdowns with ForeignKey in Django
I would like to populate the question and category selects according to the foreign key of the previous selects, but I am not getting either with AJAX or creating a form. What could you do? index.html <div class="row"> <div class="col-md-4"> <div class="form-group "> <select id="prova" class="form-control" name="prova"> <option value='' selected>Prova</option> {% for prova in provas %} <option value="{{ prova.idProva }}">{{ prova.tipoProva }} {{prova.anoProva}}</option> {% endfor %} </select> </div> </div> <div class="col-md-4"> <div class="form-group "> <select id="questao" class="form-control" name="questao"> <option value='' selected>Questão</option> {% for questao in questoes %} <option value="{{ questao.idQuestao }}">{{ questao.idQuestao }}</option> {% endfor %} </select> </div> </div> <div class="col-md-4"> <div class="form-group "> <select id="categoria" class="form-control" name="categoria"> <option value='' selected>Categoria</option> {% for categoria in categorias %} <option value="{{ categoria.idCategoria }}">{{ categoria.nomeCategoria }}</option> {% endfor %} </select> </div> </div> </div> views.py def index(request): prova = request.POST.get('prova') form = QuestaoProvaForm() provas = Prova.objects.all().order_by('idProva') questoes = Questao.objects.filter(idProva=prova).order_by('idProva') categorias = Categoria.objects.all().order_by('nomeCategoria') return render(request, 'polls/index.html',{'form':form,'prova':prova,'categorias':categorias,'questoes':questoes,'provas':provas}) -
Django form not saving despite POSTing ok
I have what should be a very simple django form and model. Far as I can tell everything is working as it should. In my web server logs I get a 200 POST OK message, however...the form never redirects as it should, and nothing is saved to the database. I'm unsure how to troubleshoot this as there doesn't seem to be anay clear error. Relevant section from my forms.py: class StoreItemForm(forms.ModelForm): class Meta: model = StoreItem fields = ('item_name', 'description', 'manufacturer', 'product_category', 'price', 'item_pic', 'height', 'width', 'length', 'items_in_stock') widgets = { 'item_name' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Item Name'}), 'description' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Description'}), 'manufacturer' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Manufacturer'}), 'price' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Price'}), 'height' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Height'}), 'width' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Width'}), 'length' : forms.Textarea(attrs={'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Length'}), 'items_in_stock' : forms.TextInput(attrs = {'class': 'sizefull s-text7 p-l-22 p-r-22', 'placeholder': 'Quantity'}), } views.py: def additems(request): item_name = request.POST.get('item_name', False) description = request.POST.get('description', False) manufacturer = request.POST.get('manufacturer', False) product_category = request.POST.get('product_category', False) price = … -
how to select values from joined table?
I have two models, class model_1(models.Model): id = models.IntegerField(primary_key=True) tableName = models.CharField(max_length=20, default=None) class Meta: db_table = "table1" class model_2(models.Model): id = models.IntegerField(primary_key=True) tableId = models.ForeignKey(model_1, on_delete=models.CASCADE, db_column='tableId') class Meta: db_table = "table2" i am performing, queryset = model_2.objects.select_related('tableId').values('tableName').annotate(tcount=Count('tableId')) i want the following query select table1.tableName, count(table2.tableId) from table2 INNER JOIN `table1` ON (`table1`.`id` = `table2`.`tableId`) group by table2.tableId; but its giving me, django.core.exceptions.FieldError: Cannot resolve keyword 'tableName' into field. Choices are: tableId, id Thank you for your suggestions -
solr server stops indexing after some records
I have solr installed on AWS cloud, which is not able to complete my indexing. I have similar DB and solr on my local system where indexing runs fine and I can search all data. I have monitored memory consumption , heap size on AWS while indexing is running. Nothing seems unusual. python manage.py rebuild_index --noinput -b 1000 --workers 4 This command shows that 168252 records will be indexed while indexing stops at 164252 and it never completes. On local it completes all records indexing. What is the reason for this unusual behaviour ? -
Inline action with no object instance in Django Admin
I am having troubles with working with GenericTabularInline in my django app. The case is: I have some object called Status which has relation to some Property (ForeignKey). I would like to have an additional actions on that Status object in Property change form. I am using inline_actions library to create custom actions for Status object. The struggle is when I try to render that Inline instance if there is no Status object attached to my Property. Is there any way I can override my custom actions to render even if there is no Status object attached to my Property? Here is my Inline code: class AbstractPropertyCheckInline(InlineActionsMixin, GenericTabularInline): model = Status readonly_fields = ('status_type', 'last_check', 'additional_message') extra = 0 inline_actions = ['revalidate'] def revalidate(self, request, obj, parent_obj=None): # My revalidation code What revalidate does is that it creates a Status object and attaches it to the Property if such doesn't exist. I would like to trigger such behavior from within admin page -
How to display data in the instance to which I want to edit?
I want to edit the information in an instance of a crud, but at the time of doing so, it does not show me the information, which I had previously put in the create view and I do not understand how to show it, I have tried with the arguments 'form': form.cleane_data , 'form': form, but still does not show me the data that is in the fields, but that can be previously seen in a list view, which I have in the home of the application. this is my funtion in views.py def update_permisos(request, pk): if request.method == 'POST' and request.is_ajax(): form = permiForm(request.POST, instance=request.user) if form.is_valid(): permiso = form.save(commit=False) permiso.usuario = request.user permiso.save() permiso.usuario.status = request.POST['status':'Aceptado'] permiso.usuario.d_pendientes = request.POST['d_pendientes']#valores, que van al campo permiso.usuario.h_pendientes = request.POST['h_pendientes']#valores, que van al campo permiso.usuario.save() return JsonResponse({'status':'true', 'msg':'Datos procesados correctamente'})#retornando JSon en jsConsole else: return JsonResponse({'status':'false', 'msg':'Datos procesados incorrectamente'})#retornando respuesta en jsConsole else: form = permiForm(instance=request.user) args = {'form':form.data} return render(request, 'plantillas/permisos.html', args) this is my forms.py forms.py class permiForm(forms.ModelForm): class Meta: model = permiso fields = [ 'disponer', 'razon', 'periodo_i', 'periodo_f', 'dias_disponer', 'horas_disponer', ] if somebody, want see some other part of me code, tell me and i post it -
Filter permission list and show what is necessary
As you know, Django gives you a list of default permissions. by default those authentication permissions have 'auth', 'conttentypes', 'sessions' and I don't want those permissions in my opinion. where I customize the code so that this doesn't happen ... If someone helped me, it would be useful. The image shows these permissions that I do not want to be displayed. -
Django elasticsearch not displaying data
I have created the following document using django-elasticsearch-dsl @skill.doc_type class SkillDocument(DocType): class Meta: model = data_Skills fields = { 'SKILL_ID', 'SKILL_NAME', 'DESCRIPTION', } This is my Consultant and consultant skill model class data_Consultant(models.Model): CONSULTANT_ID=models.AutoField(primary_key=True) FIRST_NAME=models.CharField(max_length=50) LAST_NAME=models.CharField(max_length=50) EMAIL=models.CharField(max_length=255) CONSULTANT_GRADE=models.CharField(max_length=50) class data_ConsultantSkills(models.Model): SKILL_LEVEL_SCORE=models.IntegerField() SKILL_ID=models.ForeignKey(data_Skills, on_delete=models.CASCADE,to_field='SKILL_ID') CONSULTANT_ID=models.ForeignKey(data_Consultant, on_delete=models.CASCADE, to_field='CONSULTANT_ID') And have the following views. I am currently trying to match the skill name, and in that results, filter out consultants that have that particular skill if choice == "Skillset": //form selection skill= SkillDocument.search().query("match", SKILL_NAME=q) for item_s in skill: s_id = data_ConsultantSkills.objects.filter(SKILL_ID=item_s.SKILL_ID) if s_id.exists(): for item_c in s_id: cons_id = item_c.CONSULTANT_ID consultant_name= data_Consultant.objects.filter(CONSULTANT_ID=cons_id.CONSULTANT_ID) return render(request, 'search/Results.html', {'consultant_name':consultant_name}) else: return render(request,'search/Results.html') And the following is my html {% for item in consultant_name %} <tr><th> {{item.FIRST_NAME}} {{item.LAST_NAME}} {{item.LAST_CLIENT}} </th></tr> <br> {% endfor %} My current problem is that it is only displaying one data (the earliest data added) instead of displaying multiple data. What do I need to do to change that? Thanks in advance! -
Python Django website not recognizing css changes
I am making a django website and I am loading in my css in the html as static. I am using to css files the first is for the bootstrap that i am using and the second on is my own css but the bootstrap variables are showing but not my own variables I have tried remaking the css document and changing from "class" to "id" html code: {% load static %} <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>Wedding planner - Dashboard</title> <link href="{% static 'css/main.css' %}" rel="stylesheet" /> <!-- Bootstrap --> <link href="{% static 'css/bootstrap-4.3.1.css' %}" rel="stylesheet" /> </head> <body> {% block content %} <nav class="navbar navbar-expand-lg navbar-dark bg-dark"> <a class="navbar-brand" href="{% url 'Home' %}">Wedding Planer</a> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation" > <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="navbarSupportedContent"> <ul class="navbar-nav mr-auto"> <li class="nav-item active"> <a class="nav-link" href="#" >Home <span class="sr-only">(current)</span></a > </li> <li class="nav-item"> <a class="nav-link" href="#">About</a> </li> <li class="nav-item"> <a class="nav-link" href="#">Plans</a> </li> </ul> <a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" > User </a> <div class="dropdown-menu" aria-labelledby="navbarDropdown"> {% if user.is_authenticated%} <a class="dropdown-item" href="{% url 'logout' %}">Logout</a> {% else %} <a … -
ValueError: Unable to configure handler 'rotated_logs': in python 3.6?
$ python3 ./manage.py makemigrations Traceback (most recent call last): File "c:\python36\Lib\logging\config.py", line 558, in configure handler = self.configure_handler(handlers[name]) File "c:\python36\Lib\logging\config.py", line 731, in configure_handler result = factory(**kwargs) File "c:\python36\Lib\logging\handlers.py", line 150, in init BaseRotatingHandler.init(self, filename, mode, encoding, delay) File "c:\python36\Lib\logging\handlers.py", line 57, in init logging.FileHandler.init(self, filename, mode, encoding, delay) File "c:\python36\Lib\logging__init__.py", line 1025, in init StreamHandler.init(self, self._open()) File "c:\python36\Lib\logging__init__.py", line 1054, in _open return open(self.baseFilename, self.mode, encoding=self.encoding) FileNotFoundError: [Errno 2] No such file or directory: 'F:\tmp\fb_debug.log' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "./manage.py", line 22, in execute_from_command_line(sys.argv) File "F:\python\venv\lib\site-packages\django\core\management__init__.py", line 381, in execute_from_command_line utility.execute() File "F:\python\venv\lib\site-packages\django\core\management__init__.py", line 357, in execute django.setup() File "F:\python\venv\lib\site-packages\django__init__.py", line 19, in setup configure_logging(settings.LOGGING_CONFIG, settings.LOGGING) File "F:\python\venv\lib\site-packages\django\utils\log.py", line 76, in configure_logging logging_config_func(logging_settings) File "c:\python36\Lib\logging\config.py", line 795, in dictConfig dictConfigClass(config).configure() File "c:\python36\Lib\logging\config.py", line 566, in configure '%r: %s' % (name, e)) ValueError: Unable to configure handler 'rotated_logs': [Errno 2] No such file or directory: 'F:\tmp\fb_debug.log' -
Django countries full name value
Is there a way to get the full name of country in the database using Django-countries. My dropdown list shows the full country names but when submitted the country abbreviations are the values that appear in my database. Is there an argument to put in my model? I can’t find an example that shows this. country = CountryField(blank_label='(select country)') -
Django: Applying database migration on server start
I would like Django to automatically apply migrations when server starts. How to do it? -
invalid literal for int() with base 10: 'first'
I want to filter post list on the basis of category using django mptt. Here is my code. models.py class Post(models.Model): title = models.CharField(max_length=120) category = TreeForeignKey('Category', null=True, blank=True, on_delete=models.CASCADE) content = models.TextField('Content') slug = models.SlugField() def __str__(self): return self.title class Category(MPTTModel): name = models.CharField(max_length=50, unique=True) parent = TreeForeignKey('self', null=True, blank=True, related_name='children', db_index=True, on_delete=models.CASCADE) slug = models.SlugField() class MPTTMeta: order_insertion_by = ['name'] class Meta: unique_together = (('parent', 'slug',)) verbose_name_plural = 'categories' def __str__(self): return self.name views.py class CategoryView(ListView): model = Post template_name = 'apps/category_view.html' def get_context_data(self, **kwargs): context = super().get_context_data(**kwargs) post_list = Post.objects.filter(category=self.kwargs.get('category')) context['category_list'] = post_list return context And urls.py urlpatterns = [ path('category/<str:category>/', CategoryView.as_view(), name='category_filter'), ] Here every things is imported correctly. When i entered urls some things like below. http://localhost:8000/category/first/ I'm getting error as below shown in image. Am I missing somethings, Any help will be appreciated. -
Django bootstrap-pagination work with inherited templates?
Does "bootstrap-pagination" in django work with inherited template files? I have a situation like the following. I have a template file like so: *{% extends "shared/table.html" %}* *... some html stuff ... ....end of file ...* Then I have the table.html like so: *{% extends "shared/tablepage.html" %} {% load bootstrap_pagination %} <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" type="text/css" media="screen" title="no title" charset="utf-8"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/font-awesome.css" type="text/css" media="screen" title="no title" charset="utf-8"> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.js"></script>* *...some html table here...* *{% bootstrap_paginate pagination_query range=10 show_prev_next="false" show_first_last="true" %}* end of file. I am doing something wrong here. But what is that? I can see the list of page links in the page. But all pages contain all the records. The views file is absolutely "traditional". It contains the necessary code and that code works with template files that are not inherited (or use inheritance). Thanks in advance. I would appreciate a quick response, but I understand that might not be possible. -
Translating urls Django
I'm using gettext_lazy as _ for translating urls in Django. My question is how can I translate only particular single string, for example: path(_('<int:document_id>/preview/<uuid:uuid_link>/') here i want to get only /preview/ for translation in my django.po file not the whole string? -
how to add maxlength attribute to some input field dynamically?
i am trying to add maxlength attribute to my html form dynamically but i cannot able to add. Initially i adden input field type dynamically and it runs but maxlength is not adding dynamically. can some one help me in this? this is my html input field code- <label for="field_type">Field Type</label> <select name="field_type" id="field_type"> <option value="text" >Char Field</option> <option value="email">Email Field</option> <option value="url">Url Field</option> <option value="number">Integer Field</option> <option value="checkbox">Boolean Field</option> </select> </div> field_type is my object of my model in which my value stores. class Field(models.Model): field_name = models.CharField(max_length=100, unique=True) field_type = models.CharField(max_length=50) max_length = models.IntegerField(default=None) is_required = models.BooleanField() def __str__(self): return self.field_name i tried this for maxlength attribute - <div class="col-lg-8 mb-20"> <br><br> <label for="maxlength">Field Length</label> <input name="max_length" id="maxlength"> </div> -
How to access .env file in jquery?
So I have django project with jquery for interactivity in frontend. I already have .env file to store database configuration to be used by django settings.py, but I need jquery to be able to access the .env file too. From what I read in dotenv documentation, I need to install the dotenv using npm or yarn. But I think jquery don't have/use npm? I am a newbie in javascript -
Case insensitive sort in django rest framework with mongoengine
Django already has a way to achieve this for RDBMS: MyModel.objects.order_by(Lower('myfield')) I'm using DRF with mongoengine but the above throws error: TypeError: 'Lower' object is not subscriptable I'm guessing this is a bug in the way order_by has been implemented in mongoengine. -
Populate table with database records
I am trying to populate html table from database, but I can't find a good solution for doing that. I hope this is not too broad question. I am scraping data about hotel bookings and it's prices and I want to display it nicely on the table. I am working on it for quite a while but I am still struggling, hopefully someone will be able to help me. The table result I am trying to get: The first column represents what time scraping was executed, and top shows for what dates booking is made(checkin date). And the rest would be prices. +--------+-------+-------+-------+-------+ | | 1Apr | 2Apr | 3Apr | 4Apr | +--------+-------+-------+-------+-------+ | 11am | 40(A) | 40(A) | 40(A) | 40(A) | | 1110am | 40(X) | 40(X) | 42(A) | 42(A) | | 1120am | | | | | +--------+-------+-------+-------+-------+ Main model is PriceDatum, where all the prices are stored and another important model for this table is RoomScans which stores the time when scan was made. models.py: class PriceDatum(models.Model): room_scan = models.ForeignKey(RoomScan,default=1, on_delete=models.CASCADE) room = models.ForeignKey(Room, on_delete=models.CASCADE) checkin = models.DateField(db_index=True, help_text="Check in date", null=True) checkout = models.DateField(db_index=True, help_text="checkout date", null=True) price = models.PositiveSmallIntegerField(help_text="Price in the …
