Relative Content

Tag Archive for pythondjango

How to alter data entered into django models to fit a criteria?

I have a django models.py file that I use to store information in my database. I store information on businesses and the countries that they operate in. I get the list of countries from their website. However they may call each country by a different name or use different formatting, for example ‘The Gambia’ vs ‘Gambia’, ‘Eswatini’ vs ‘Swaziland’, ‘Trinidad and Tobago’ vs ‘Trinidad & Tobago”, ‘The United States’ vs ‘United States of America’. I want that when I store the names of these countries in my database they automatically follow a set of rules to ensure consistent formatting of their names. Additionally, some websites state something like ‘We operate in 150 countries’. I want to enter this information into the database but not have it come up when I request a list of countries from the frontend.

Queryset needs to be custom sorted into dictonary

can I have sort my queryset in custom order. By custom I mean for every ten products I receive, the first two should be featured (set to true), while the remaining eight should be unfeatured. This pattern should be repeated for each set of ten products and saved to a dictionary. The dictionary should save the data in the format of 'id':'rank'. if is_featured is same look at rank.The database should be hited one time.

Queryset needs to be custom sorted into dictonary

can I have sort my queryset in custom order. By custom I mean for every ten products I receive, the first two should be featured (set to true), while the remaining eight should be unfeatured. This pattern should be repeated for each set of ten products and saved to a dictionary. The dictionary should save the data in the format of 'id':'rank'. if is_featured is same look at rank.The database should be hited one time.

Queryset needs to be custom sorted into dictonary

can I have sort my queryset in custom order. By custom I mean for every ten products I receive, the first two should be featured (set to true), while the remaining eight should be unfeatured. This pattern should be repeated for each set of ten products and saved to a dictionary. The dictionary should save the data in the format of 'id':'rank'. if is_featured is same look at rank.The database should be hited one time.

ManytoMany fields generating “no such table:” error where is related to no model in models.py

I’m sorry if question title is confusing or not clear but i didn’t have a better way of writting it.
I have a django app root, in models.py i created a model Post containing 3 manytomany fields ; File, Video and Picture and some other fields and while trying to populate the model in Django Admin or even to view any of the created Posts i get this error message django.db.utils.OperationalError: no such table: root_post_Picture. I already ran python manage.py sqlmigrate root 0001_initial and saw no table with such name and it’s not surprising since root_post_Picture corresponds to none of my models . I think it is related to the manaytomanyfields i created since the name root_post_Picture seems to be a combination of the tables root_post and root_picture from my database.
views.py