python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - orm

Serializing RAW SQL query Django

Hope you doing well. I need to serialize my RAW SQL query: SELECT nn.*,nm.*FROM notifications_newsletter nn LEFT JOIN notifications_message nm ON nn.id=nm.newsletter_id_id ORDER by nm.status DESC mod...
test-img

barelydrown

python

django

django-rest-framework

orm

Votes: 0

Answers: 1

Latest Answer

You can use nested model serializers from Django REST Framework for your purposes like this: from rest_framework import serializers class MessageSerializer(serializers.ModelSerializer): class Met...
test-img

Oleksii Tambovtsev

EF Core Foreign Key: incompatible types

I looked through many similar questions, but I find no applicable solution. I get the following error message during tests: System.InvalidOperationException : The relationship from 'Product.FeatureTy...
test-img

Balázs Börcsök

c#

orm

entity-framework-core

foreign-keys

ef-core-3.1

Votes: 0

Answers: 3

Latest Answer

You can model this in EF by using a value conversion. The first step is to change the type of Product.Type: public class Product { public Guid Id { get; set; } public string Name { get; set; }...
test-img

Gert Arnold

SQLAlchemy: Counting multiple relationships - best way?

Imagine the following (example) datamodel: class Organization(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) friendly_name = db.Column(db.Text, nullable=False) ...
test-img

E.ws

sqlalchemy

count

orm

relationship

Votes: 0

Answers: 1

Latest Answer

b: You can try a window function to count users and groups with good performance: query = db.session.query( Organization.friendly_name, func.count().over(partition_by=(User.id, Organ...
test-img

jorzel

Generated types in Prisma do not have optional fields as defined in the schema

Using Prisma v 3.8.1 My User Model is model User { id Int @id @default(autoincrement()) createdAt DateTime? @default(now()) email String ...
test-img

Subhendu Pratap Singh

orm

prisma

prisma2

Votes: 0

Answers: 1

Latest Answer

This type is not intended to use with create or similar methods. It's return type of find* methods and such. It's supposed to match DB table and table does not have undefined or optional rows, only nu...
test-img

Danila

Posts

Questions

Blogs

Jobs