Advertisements How do you reference the model name in field definition in a model mixin? Ie, what would replace model_name here: class CreatedByMixin(models.Model): class Meta: abstract = True created_by = ForeignKey( User, verbose_name="Created by", help_text="User that created the record", related_name=f"{model_name}_created", editable=False, ) Such that the related name on this model is ‘MyModel_created’? class MyModel(UserAuditMixin, TimeStampedModel):… Read More How do you reference a model name in a Django model mixin field definition?

Advertisements I like to make a filter where user can search based on last_name or a regio(region). I made the query but it filters well only if I using the last_name filter, but the regio gives all the users in the db. I’m used before Sqlite3 and raw queries but now I like to learn… Read More Why Django ORM filter lists all the users?

Advertisements Child.objects.select_related("parent").filter(parent=parent_instance) or Child.objects.filter(parent=parent_instance).select_related("parent") which one is less time consuming I am not sure which one is taking minimum queries and improve performance >Solution : Both will result in the same query. It is not necessary to .select_related(…) [Django-doc] or .prefetch_related(…) [Django-doc] to filter. If you filter on a related item, it will just make JOINs. The… Read More query optimization and improve performance

Advertisements my program is querying a sqlite database, and thre result is like this (simplified) in the cursor ready to be fetched. connection = sqlite3.connect(IMAGE_LOG_DB_PATH) connection.isolation_level = None cur = connection.cursor() sql_query = "Select date, name, count(*) as sells from sellers group by date, name order by date asc;" cur.execute(sql_query) result = cur.fetchall() 2023-01-01 |… Read More python – split query results into multiple objects based on one column

Advertisements Using sqlalchemy.orm I am trying to link two tables on a composite key, but keep getting an error. Unfortunately, the official docs provide an example that uses a single primary key (not composite), so I tried to come up with a basic example that reproduces the issue: from sqlalchemy import Column, ForeignKey, Integer, String… Read More Using `sqlalchemy.orm` with composite primary keys