I have two tablse with different structure: contents folders I need getting data from two tables with pagination, sorting and filter. I know only about this way like getting two tables in 2 operations. Is it possible union these tables…
How do I get a queryset of specific child classes? It doesn't look like going through related_name is the answer. Using Django 3.2.6 btw. Here is my setup: class Quiz(models.Model): name = # char field class Question(models.Model): # a quiz…
for the current project that I am going to work on, I need to create many entities using the make:entity command. Each time a new entity is created it needs to have the following columns that need to be defined…
Alright, this might have been asked quite a lot of times but none of them gives me a solution. Here's my schema. { "_id" : ObjectId("23453453453453"), "title": "Item 01" "checkList" : [ { "ch_id" : "621eff4e0ed5c751adaa42fb", "status" : "statu", "dateMonthYear"…
I've got a function which interacts with a postgres DB. The function takes a parameter called pagination_data_required (boolean). If pagination_required is set to true, the function executes a query as well as a query.count() which according to the documentation docs.peewee…
I am very new to the laravel subqueries , i am trying to fetch another table data but it's showing an following error SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the…
I've been using latestOfmany() for my hasMany() relation to define them as hasOne() for quite a while now. Lately I've been in need of the similar application but for belongsToMany() relationships. Laravel doesn't have this feature unfortunately. My codebase as…
I have a model which which has fields like: class Vehicle(models.Model): car_name = models.CharField(max_length=255) car_color = models.CharField(max_length=255) This model has a lot of duplicate values too, I would like distinct to be shown The queryset gives an output like: <QuerySet…
So I have a Symfony 6.2 API, PHP 8.2 codebase. While trying to run composer install/update the following error is displaying and I'm wondering how to clear it: In CheckExceptionOnInvalidReferenceBehaviorPass.php line 83: The service "doctrine.orm.default_annotation_metadata_driver" has a dependency on a…
I want to get records that their titles contains "hello #12", so I used this query: Post::query()->where('title', 'LIKE', "%hello #12%"); Problem is it returns some records with titles like this: "hello #15", "hello you" and ... Is # have special…