Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
DRF Nested Serializer field not appearing
I'm trying to retrieve some data from two related models however i am unable (or would like to avoid to be more precise) to change the models. The problem is that the nested serializer doesn't return the data of the first model. I have the following serializers class NameSerializer(serializers.ModelSerializer): class Meta: model = Microcontrollers fields = ['name'] class DataCUTSerializer(QueryFieldsMixin, serializers.ModelSerializer): stationName = NameSerializer(read_only=True) class Meta: model = MeasurementsBasic fields = ['stationName', 'temp', 'hum'] def to_representation(self, instance): representation = super().to_representation(instance) return {'timestamp': instance.time_taken, **representation} return representation These serializers use the following models class MeasurementsBasic(models.Model): microcontroller = models.OneToOneField('Microcontrollers', related_name='measurements_basic', primary_key=True, on_delete=models.CASCADE) time_taken = models.DateTimeField() time_received = models.DateTimeField(blank=True, null=True) frame = models.IntegerField(blank=True, null=True) temp = models.FloatField(blank=True, null=True) hum = models.FloatField(blank=True, null=True) pres = models.FloatField(blank=True, null=True) co = models.FloatField(blank=True, null=True) no2 = models.FloatField(blank=True, null=True) o3 = models.FloatField(blank=True, null=True) so2 = models.FloatField(blank=True, null=True) latitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) longitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) altitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) name = models.CharField(max_length=30, blank=True, null=True) class Meta: managed = True db_table = 'measurements_basic' unique_together = (('microcontroller', 'time_taken'),) class Microcontrollers(models.Model): name = models.CharField(max_length=25) serial_number = models.CharField(max_length=20, blank=True, null=True) type = models.CharField(max_length=15, blank=True, null=True) software = models.CharField(max_length=20, blank=True, null=True) version = models.CharField(max_length=5, blank=True, null=True) date_installed = … -
Overriding restore method in Django
I would like to run a piece of code after object is restored in Django but not have it run every time save() is runed. How can I override restoration method in Django? I know it is using save() method, but I would rather have it seperate from it. Is there any way? Or if I were to use the save() method, is there a way to determine if the request is from restoration page? -
Celery workers not working with RabbitMQ after upgrade
Problem description I have a working django application using Celery along with Mongo and RMQ (3.7.17-management-alpine) The application runs on kubernetes cluster The application works fine in general But when I upgrade Celery (3.1.25) and Kombu (3.0.37) to Celery (4.1.0) and Kombu (4.1.0), I face following issue: Celery worker pods come up but do not receive the tasks I have verified that RMQ receives the messages needed to run tasks in celery workers There is no error in RMQ or celery worker pod In fact, celery pod mentions that it is connected to RMQ Strangely, when I restart the RMQ pod after Celery worker pod comes up things become fine I am able to run the new tasks in celery workers after I restart RMQ pod So I guess something happened wrt Celery/Kombu/RMQ after upgrade to 4.1.0 The code works fine with older version of Celery and Kombu. Can someone please help me wrt this? -
How to call a Django function from template and save return in a variable
Context: I have a piece of HTML that I want to dispaly in the template just in case a function return "true". Details: My function def show_avg_kpi(): return config.avg_times_visible register.filter('show_avg_kpi', show_avg_kpi) Template ( is the piece of code to display or not): {% if show_avg_kpi %} <HTML CODE> {% endif %} I want something like this, but I don't know how to save the result of the show_avg_kpi function in a variable to use it with the {% if %} tags Thank you in advance. -
Check In System by input user data in Django
I trying to do a Check In System where Students can do it themselves by input their ID's but I am really struggling. Follow views, models, forms and html VIEW class Attendance(CreateView): template_name = 'homepage.html' model = GetAttendance fields = ['aluno'] success_msg = "Check In Succesfully" def form_valid(self, form): form.save() success_msg = self.get_success_message(form.cleaned_data) if success_msg: messages.success(self.request, success_msg) return super().form_valid(form) def get_success_url(self): return reverse('attendance:homepage') def get_success_message(self, cleaned_data): return self.success_msg % cleaned_data MODELS class Aluno(models.Model): id = ShortUUIDField(primary_key=True, editable=False, alphabet="0123456789", length=5) photo = models.ImageField(upload_to='photos/', default='static/images/defaultuser.jpeg', blank=True) nome = models.CharField(max_length=255) phone = models.CharField(max_length=255) email = models.EmailField(max_length=255, unique=True) location = models.ForeignKey(MasterUser, on_delete=models.CASCADE) belt = models.CharField(max_length=255, choices=BELT) stripe = models.CharField(max_length=255, choices=GRAU) join_date = models.DateField(default=timezone.now) last_graduation = models.DateField(default=timezone.now) gender = models.CharField(max_length=255, choices=GENDER) def __str__(self): return self.nome class GetAttendance(models.Model): aluno = models.ForeignKey(Aluno, on_delete=models.CASCADE) attendance = models.DateTimeField(default=timezone.now) def __str__(self): return str(self.aluno) + ' - ' + str(self.attendance) That's views.py My models.py forms html check in page Basically what I need is instead having a choices form be able to input the student ID and run the model GetAttendance. -
Can't reach this page took too long to respond. Django, Gunicorn and Nginx. This is until I reboot my instance manually
I hosted my Django website on AWS Lightsail instance on an Ubuntu server with Nginx and Gunicorn. Everything works fine when it is running super fast everything works great, but sometimes it stops running, I can't reach the website only until I restart my lightsail instance manually. This I think happens in the interval of 24 hours (probably). I don't know why it is happening? what causing it? Someone suggested to me that it's something related to the server itself, Server goes to sleep, or something but when any request comes it can't respond to that. If there is anything that you want to see to get more info plz comment I'll add that. I don't have much idea about this problem, I'll appreciate your help. -
How to send kwargs for form MultipleChoiceField in POST view unit test
I am struggling to find the answer for testing my POST view with data. I have a form that generates the the choices options on init and the issue in my test is that I am not passing the list_of_ids required to populate the choices for the form on init so I am getting an error of "12345 is not one of the available choices." This then means my repsonse code is returing 200 as my form is not valid and failing the test. I cant work out the right way to test this or how I would pass the choices to the form in the test. class AddAccountForm(forms.Form): account_id = forms.MultipleChoiceField(widget=forms.CheckboxSelectMultiple, choices = []) def __init__(self, *args, **kwargs): self.list_of_ids = kwargs.pop('list_of_ids') super(AddAccountForm, self).__init__(*args, **kwargs) self.helper = FormHelper() self.helper.form_action = 'add_account_ids' self.fields['account_id'].choices = [(id['account_id'],id['account_id']) for id in self.list_of_ids] self.helper.layout = Layout( 'account_id', Submit('submit', 'Add', css_class='btn btn-primary btn-sm ml-2'), ) the list_of_ids is coming from and api call in my view: @login_required def add_account_ids(request): api_client = api_authentication(request.user) list_of_ids = get_list__ids(api_client) if request.method == "POST": form = AddAccountForm(request.POST, list_of_ids=list_of_ids) print(request.POST) if form.is_valid(): for id in form.cleaned_data['account_id']: LinkedAccount.objects.create( account_id=id, social_provider="api", user=request.user ) return HttpResponseRedirect('/') else: print('test') form = AddAccountForm(list_of_ids=list_of_ids) context = {'form' : … -
How to query data from two tables using django?
I have mySQL tables connected with "one to many" relationship params of the main table are: name age height params of the second table are: f_name (as foreign key of ) salary_date salary I already get data from first table using this code: models.py from tabnanny import verbose from django.db import models, connections from django.urls import reverse class collection_data(models.Model): name = models.CharField(max_length=50) age =models.IntegerField() height = models.IntegerField() class Meta: verbose_name = 'Collection Data' class second_data(models.Model): # connect this table with previos data = models.ForeignKey(collection_data, on_delete=models.CASCADE) salary= models.FloatField(max_length=100) salary_date= models.DateTimeField(auto_now_add=True) class Meta: verbose_name = 'Frequent Collection Data' ordering = ['salary_date'] views.py from django.views.generic import DetailView class InfoDetailView(DetailView): model = collection_data template_name = 'info/Info.html' context_object_name = 'info' urls.py path('<int:pk>', views.InfoDetailView.as_view(), name="info-data"), Info.html <ul class="data"> <li>{{ info.name }}</li> <li>{{ info.age }}</li> <li>{{ info.height}}</li> </ul> <table> <tr> <th>Date</th> <th>Salary</th> </tr> {% for el in second_data %} <tr> <td>05/06/2021</td> <td>1350$</td> </tr> {% endfor %} </table> Result on the page must be: -
Django update or create - pre save
I am struggling with what may be a simple issue. I am trying to create a record or update if there is already an existing record in place. I am trying to override the models save function. The criteria is based on is there a user that already has an answer for their exp_type. I want ed to update it if so, if not then i want to create it. Here is what i have: class UserExperienceTypeAnswer(TimeStampedModel): NA, NONE, SOME, LOTS, EXPERT = range(5) ANSWER_CHOICES = { (NA, "Not interested"), (NONE, "None"), (SOME, "Some"), (LOTS, "Lots"), (EXPERT, "Expert"), } user = models.ForeignKey(User, models.CASCADE, null=False, blank=False) exp_type = models.ForeignKey( RecruitmentExperienceType, models.CASCADE, null=False, blank=False ) answer = models.PositiveSmallIntegerField( choices=ANSWER_CHOICES, default=NONE, blank=False, null=False ) unique_together = ["user", "exp_type"] def save(self, *args, **kwargs): record = UserExperienceTypeAnswer.objects.filter( user=self.user, exp_type=self.exp_type ).first() if not record: super(UserExperienceTypeAnswer, self).save(*args, **kwargs) else: //This is the part im unsure of. I tried to save the record from query above record.answer = self.answer super(UserExperienceTypeAnswer, record).save(*args, **kwargs) // This gives duplicate key error (which i assume is because its trying to create new record) // I also tried to create model directly but this creates recursion error (as i assume i am calling … -
I'm having an issue with this. Trying to install mysqlclient with 'pip install mysqlclient' but it's bringing out this error
Collecting mysqlclient Using cached mysqlclient-2.1.0.tar.gz (87 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error × python setup.py egg_info did not run successfully. exit code: 1 [16 lines of output] /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 2, in <module> File "<pip-setuptools-caller>", line 34, in <module> File "/tmp/pip-install-hyrw6bdf/mysqlclient_3a83953da9be4f2d8196d1a7de0c4479/setup.py", line 15, in <module> metadata, options = get_config() File "/tmp/pip-install-hyrw6bdf/mysqlclient_3a83953da9be4f2d8196d1a7de0c4479/setup_posix.py", line 70, in get_config libs = mysql_config("libs") File "/tmp/pip-install-hyrw6bdf/mysqlclient_3a83953da9be4f2d8196d1a7de0c4479/setup_posix.py", line 31, in mysql_config raise OSError("{} not found".format(_mysql_config_path)) OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs [end of output] note: This error originates from a subprocess, and is likely not a problem with pip. error: metadata-generation-failed × Encountered error while generating package metadata. note: This is an issue with the package mentioned above, not pip. -
Using concurent.futures raise me a strange AttributeError on django python with channels
I'm facing an issue trying to use the concurrent.futures package in python. I'm working on a website using django and channels to perform asynchronous comunication. I have to load data from many url and i want to be able to do it with multiprocessing. Unfortunately i'm enable to make this code work as it always give me an AttributeError. Could it be related to the architecture of django or channels ? I'm using the ProcessPoolExecutor in a channels receive() function inside a WebSocket Object. Here is a sample of my code : class CreateValuesConsumer(WebsocketConsumer): def connect(self): self.accept() def disconnect(self, close_code): pass def create_single_value(self, card): print('start create_single_value') condition = Condition.objects.filter(short_name='NM')[0] card_language = Language.objects.filter(short_name='FR')[0] seller_origin = Language.objects.filter(short_name='FR')[0] value = card.create_value(condition, card_language, seller_origin) if value is not None: message = "models.value." + str(value.id) + ' : create | card_name = ' \ + card.name_en.lower() + " | price = " + str(value.cheaper_price) is_error = 0 else: error = ParsingError.objects.filter(card=card)[0] message = error.message is_error = 1 self.send(text_data=json.dumps({ 'message': message, 'is_error': is_error })) print('end') def receive(self, text_data): json_data = json.loads(text_data) extension = Extension.objects.get(pk=json_data["id"]) cards_to_value = Card.objects.filter(extension=extension) today = datetime.now() for card in cards_to_value: values = Value.objects.filter(card=card, date__year=today.year, date__month=today.month, date__day=today.day) for value in values: print('delete' + … -
Is it possible to access to the admin page once the application is uploaded to the internet? | Django
I'm very new on django and I want to ask just a simple question: in the developing phase, I can easily access to the admin page of django. I'm wondering if this is still possible to do when the website will be uploaded. I'm sorry for the trivial question, hope you will help me. -
problems puling data out of django database and testing it
really sorry but a complete beginner here with Django and Python. I am trying to pull some data out of a database so I can assert against it in the testing faze but I am having problems understanding how to get the data out of the model. Any help would be appreciated. My code: Models.py class CurrentAccountState(AccountState): enable_personal_profile = models.BooleanField(default=False) class CurrentAccountSetting(TimestampedModel): ACCOUNT_SEND_TO_OPTIONS = ( ("buyer", _("Receipt sent to the buyer")), ("payment_profile_contact", _("Receipt sent to payment profile contact")), ) account_state = models.ForeignKey( CurrentAccountState, related_name="account_settings", on_delete=models.CASCADE ) payment_profile_id = models.CharField(max_length=36) send_to = models.CharField(max_length=32, choices=SEND_TO_OPTIONS, default="buyer") views.py @action(detail=True, methods=["post"]) def update_state(self, request, pk=None): integration = AccountServiceManager.get_by_name(str(pk)) if not account: raise Http404() return Response("", status=status.HTTP_200_OK) test update_state.py def test_update_state(self): user = self.admin_user self.client.force_login(user) account = AccountFactory( name="account name", enabled=True, provider=str_to_kebab_case("account name") ) payload = { "enable_personal_profile": True, "payment_profile_settings": [ { "payment_profile_id": "Something", "send_to": "buyer", }, { "payment_profile_id": "Something else", "send_to": "payment_profile_contact", } ] } response = self.client.post(f"{self.url}/account/update_state", data=json.dumps(payload), content_type="application/json") assert response.status_code == status.HTTP_200_OK account_account = CurrentAccountSetting.objects.all() assert len(account_account) == 1 assert account_account.enable_personal_payment_profile is True What I am struggling with is understanding how I can pull the data out of the actual database so I can make assertions in the test. Currently the len(account_account) … -
Different users/groups should see different rows when editing post?
Let's say, I have a model: class Post(models.Model): title = models.charfield(max_length=50) content = models.TextField() approved = models.BooleanField(default=False) and I have 2 user groups/types: editor manager Managers can make posts and edit every line of it (title, content, approved). Editors should only be able to edit certain rows, such as Title and Content, they shouldn't be able to edit the approved field, they shouldn't even see it. Is there a way to do this? I want to hide some inputs based on the user's role/group they're in. -
How to make/use Navigations Menu for Header and Sider in ReactJS using Django Rest API?
Hi There, I want to make my header menu using Django Rest API based on roles/groups. I am using ReactJS as Frontend and Django as Backend. It's like users can see and use links based on their roles/Groups in the Rest api. Any Idea? -
Django model validation not raising Exception on full_clean()
I have a Model and ModelForm with custom validator (which only allows "H" or "A" in the CharField): def home_away_valid(value): return value == 'H' or value == 'A' class Team(models.Model): name = models.CharField(max_length=180) home = models.CharField(max_length=2, validators=[home_away_valid], default='H', db_index=True) class TeamForm(ModelForm): class Meta: model = Team fields = ['home', 'name'] However when I run full_clean() with another value (not H or A) it doesn't not raise a validation exception: try: team = TeamForm({ 'name': 'Test Team', 'home': 'S' }) team.full_clean() new_team = team.save() print(new_team.id) except ValidationError as e: print(e) Why does this not raise an Exception? (I have tried doing the full_clean() on both the ModelForm and Model, neither raises an Exception) -
How i can remove or hide the second lign of this table [duplicate]
I have a table this is my code How i can remove all the second lign 'Date'? new = output_df.groupby([output_df['Date'].dt.date, 'type']).size().unstack(fill_value=0) new.sort_values(by=['Date'], ascending=True) new['Total per date'] = output_df.groupby([output_df['Date'].dt.date])['type'].count() new.loc['Total', :] = new.sum(axis=0) new = new.astype(int) enter image description here -
Django filter where model doesn't have a foreign object or foreign field is equal to
I have two models Community and UserCommunity Community Model class Community(models.Model): # Community name name = models.CharField(max_length=64) slug = models.CharField(max_length=40, blank=True) admins = models.ManyToManyField( settings.AUTH_USER_MODEL, related_name="admins", blank=True ) admins = models.ManyToManyField( settings.AUTH_USER_MODEL, related_name="admins", blank=True ) members = models.ManyToManyField( settings.AUTH_USER_MODEL, related_name="members", blank=True, ) ------ UserCommunityModel class UserCommunity(models.Model): user = models.ForeignKey( settings.AUTH_USER_MODEL, on_delete=CASCADE, related_name="user" ) group = models.ForeignKey( Community, on_delete=CASCADE, related_name="group") role = models.CharField(max_length=15, blank=True, null=True) # True is in community, false is not in community active = models.BooleanField(null=True, blank=True) I need to get all the community objects where a user is not part of the community I've tried using this Community.objects.filter(group__user=request.user.id, group__active=False,state=location.state, group_discoverability="public").exclude( hofAdmins__isnull=True, admins__isnull=True, members__isnull=True)[:10] But this returns the communities which has a UserCommunity object, UserCommunity object is created when user joins the community. Any help would be appreciated, thanks! -
ImportError: cannot import name 'ExceptionReporterFilter'
Getting an error in my Django project. ImportError: cannot import name 'ExceptionReporterFilter' I'm using it in the following class from django.views.debug import ExceptionReporterFilter class JSONExceptionReporterFilter(ExceptionReporterFilter): pass I'm using Django==2.2.1 What can be the fix for this? -
Print Multiselect checkbox options of 1 input field in 4 columns
I am using Django Form to get one input from user, this is a check-box field where user can select multiple values. Since the number of options are more than 100, I am trying to show them in 4 columns based on option values. I mean, if option value starts with 'A-' then in first column if option value starts with 'B-' then second column so on. Example: [ ] A-Opt-1 | [ ] B-Opt-6 | [ ] C-Opt-11 | [x] D-Opt-16 [ ] A-Opt-2 | [x] B-Opt-7 | [ ] C-Opt-12 | [x] D-Opt-17 [ ] A-Opt-3 | [ ] B-Opt-8 | [ ] C-Opt-13 | [ ] D-Opt-18 [x] A-Opt-4 | [ ] B-Opt-9 | [x] C-Opt-14 | [ ] D-Opt-19 [ ] A-Opt-5 | [ ] B-Opt-10 | [x] C-Opt-15 | [ ] D-Opt-10 -
Django Rest Framework:How to calculate percentage of video duration?
In my project, I have a video section in which I want to calculate the percentage of time the user will watch. Through the below URL can access the details of video URL : video/video_id output: "video": { "id": "84e7288c-dc09-44aa-850c-08546a98ffde", "deleted": null, "datetime_created": "02/04/2022 06:56 AM", "datetime_updated": "02/04/2022 06:56 AM", "video_name": "video name3", "description": "description about video", "duration": "00:33:20", "create_date": "02/04/2022 06:56 AM", "video_type": "micro", "file_url": "https://vimeo.com/216763352", "general_status": "high", "review_status": "draft", "video_number": "VD6129", "created_by": null }, "duration": "00:33:20" is the total duration of video. How to calculate the percentage of video time that the user is watching, if passing the time in total seconds like { "time":200 } -
best way to edit or update object in Django
i'm new in django and django rest framework, i create an app with multiple models and they have ForeignKey and ManytoManyField My question is what is the best way to add object, update field , set value (ForeignKey),or create object in django when have multiple models with multiple relations Signals , override save , create , update method in serializers or anything else -
Generate sphinx documentation with Django tags
I am trying to generate a sphinx documentation using the Read the Docs template for a Django project. I am documenting it using the Django tags For example Download :model:`ManagementSoftware.Order` CSV When I try to generate the documentation with the command make html I get the error docstring of ManagementSoftware.views.DownloadOrdersCSV:1: ERROR: Unknown interpreted text role "model". What should I do? Is there any sphinx extension to include those tags? Thanks in advance -
How to do model instance in django update views
views.py def visitor(request): fruser = FRUser.objects.get(id=1) if request.method == "POST": fruser.uid = request.POST.get('visitor_nric_no') fruser.name = request.POST.get('name') fruser.company_name = request.POST.get('company_name') fruser.user_type = request.POST.get('userType') fruser.visit_purpose = request.POST.get('purposeOfVisit') fruser.valid_from_date = request.POST.get('validFrom') fruser.valid_till_date = request.POST.get('validTill') fruser.save() print(fruser.name) return render(request,'kiosk/visitor-checkIn/photo-registration.html',{'fruser':fruser}) else: return render(request, 'kiosk/visitor-checkIn/visitor-new-registration.html') models.py class FRUser(models.Model): image = models.ForeignKey(to=Image, on_delete=models.CASCADE, null=True) frtemplate = models.ForeignKey(to=FRTemplate, on_delete=models.CASCADE, null=True) name = models.TextField(null=True) user_type = models.TextField(null=True) uid = models.TextField(null=True) company_name = models.TextField(blank=True, null=True) visit_purpose = models.TextField(blank=True, null=True) employee_number = models.TextField(blank=True, null=True) designation = models.TextField(blank=True, null=True) valid_from_date = models.DateField(null=True) valid_till_date = models.DateField(null=True) valid_from_time = models.TimeField(null=True) valid_till_time = models.TimeField(null=True) is_blacklisted = models.BooleanField(default=False, null=True) is_other_visit_purpose = models.BooleanField(default=False, null=True) is_active = models.BooleanField(default=True, null=True) created_date = models.DateTimeField(auto_now_add=True, null=True) created_by = models.ForeignKey(to=User, on_delete=models.CASCADE, related_name='+', null=True) modified_date = models.DateTimeField(auto_now=True, null=True) modified_by = models.ForeignKey(to=User, on_delete=models.CASCADE, related_name='+', null=True) html <form id="visitorRegistration" data-bind="submit: save" method="post" action="/kiosk/visitor/{{fruser.id}}"> <div class="row"> <div class="col-lg-4 col-12"> <div class="form-group"> <label class="text-white float-left pl-3">User Type</label> <input type="text" class="form-control bord-r form-control-s" value="{{ fruser.user_type }}" disabled="disabled" name="userType"> </div> </div> <div class="col-lg-4 col-12"> <div class="form-group"> <label class="text-white float-left pl-3">Name <i class="text-danger">*</i></label> <input type="text" class="form-control bord-r form-control-s" name="name" data-bind="value: name" value="{{ fruser.name }}" > </div> </div> <div class="col-lg-4 col-12"> <div class="form-group"> <label class="text-white float-left pl-3">NRIC/FIN Number</label> <input type="text" class="form-control bord-r form-control-s" name="visitor_nric_no" value="{{ fruser.uid }}"> </div> </div> <div class="col-lg-4 … -
DRF: FieldError Cannot resolve keyword 'microcontrollers' into field when trying to join models
I am trying to serialize two models so that i get the name field from one and the rest of the data from another. However when i try to join them i get the following error. FieldError at /api/CUTAQ/SE1/testdata/ Cannot resolve keyword 'microcontrollers' into field. Choices are: altitude, co, frame, hum, latitude, longitude, microcontroller, microcontroller_id, name, no2, o3, pres, so2, temp, time_received, time_taken I am fairly new to Django and i am trying to understand what part of the code is causing the problem. Models.py class MeasurementsBasic(models.Model): microcontroller = models.OneToOneField('Microcontrollers', related_name='measurements_basic', primary_key=True, on_delete=models.CASCADE) time_taken = models.DateTimeField() time_received = models.DateTimeField(blank=True, null=True) frame = models.IntegerField(blank=True, null=True) temp = models.FloatField(blank=True, null=True) hum = models.FloatField(blank=True, null=True) pres = models.FloatField(blank=True, null=True) co = models.FloatField(blank=True, null=True) no2 = models.FloatField(blank=True, null=True) o3 = models.FloatField(blank=True, null=True) so2 = models.FloatField(blank=True, null=True) latitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) longitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) altitude = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) name = models.CharField(max_length=30, blank=True, null=True) class Meta: managed = True db_table = 'measurements_basic' unique_together = (('microcontroller', 'time_taken'),) class Microcontrollers(models.Model): name = models.CharField(max_length=25) serial_number = models.CharField(max_length=20, blank=True, null=True) type = models.CharField(max_length=15, blank=True, null=True) software = models.CharField(max_length=20, blank=True, null=True) version = models.CharField(max_length=5, blank=True, null=True) date_installed = models.DateField(blank=True, null=True) date_battery_last_replaced = models.DateField(blank=True, null=True) …