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 - relationship

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

hasMany relationship with multiple models?

Here's the problem: /** * Get all of the clothes for the Selling * * @return \Illuminate\Database\Eloquent\Relations\HasMany */ public function clothes(): HasMany { return $this->hasMany(Cl...
test-img

Musamba

php

laravel

relationship

Votes: 0

Answers: 1

Latest Answer

I solved it just by defining another relationship in the model: /** * Get all of the accessories for the Selling * * @return \Illuminate\Database\Eloquent\Relations\HasMany */ public function acc...
test-img

Musamba

Laravel relationship throughout multiple tables

I have a "daisy chain" of tables. I managed to get three deep table query and i'm not sure how to go about further. I got through vehicles->complement->deliveries, but i'm not sure ho...
test-img

Veljko Stefanovic

laravel

foreign-keys

relationship

Votes: 0

Answers: 2

Latest Answer

Dot syntax is solution here. Simply "connect" models as you were connecting tables with foreign keys. But in models, you'll use relationship methods. Example: Vehicle has "Complements&q...
test-img

Veljko Stefanovic

Eloquent Relationships hasMany use loop

I have a database with multiple address records of a user. When I do "pluck()" and "join()" in the foreach path, I get results. But when I type $user->getAddress->address in ...
test-img

JFeel

php

laravel

relationship

Votes: 0

Answers: 1

Latest Answer

You can use the Collection 's implode method to make it look a bit less verbose. echo $user->getAdress->implode('address', ',');
test-img

IGP

Posts

Questions

Blogs

Jobs