Styjun

Character Frequency in a String

Film where a boy turns into a princess

What is the spanish equivalent of "the boys are sitting"?

Historicity doubted by Romans

how to add 1 milliseconds on a datetime string?

Is it okay to paraphrase other authors' literature reviews?

Why does the salt in the oceans not sink to the bottom?

Issue with ContourPlot

Impact of throwing away fruit waste on a peak > 3200 m above a glacier

Span command across LaTeX environments

Why are angular mometum and angular velocity not necessarily parallel, but linear momentum and linear velocity are always parallel?

In a script how can I signal who's winning the argument?

What happens when two cards both modify what I'm allowed to do?

Monty Hall Problem with a Fallible Monty

Where is this photo of a group of hikers taken? Is it really in the Ural?

Raw curve25519 public key points

Why did modems have speakers?

When were "acrobatics" introduced at weddings?

Is it possible to build or embed the SMILES representation of compounds in 3D?

"It is what it is" in French

What is the purpose of this "red room" in "Stranger Things"?

Are rockets faster than airplanes?

Is it possible to eat quietly in Minecraft?

Why are there not any MRI machines available in Interstellar?

Filtering a query with a has_many relationship with GORM?

Golang assign values to multidimensional struct from sql queryGolang database manager api concept, error with type assertionOptimizing SQL data access in goHow to do a one-to-one relationship in GORM?Gorm and relationshipsGet nested object in structure in gormOne-to-many recursive relationship in GORMgorm having query with ORGolang GORM has many relationshipInserting and selecting PostGIS Geometry with Gorm

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

Having an issue with a super simple Gorm query on a simple many_to_many relationship, I have 3 tables in a MYSQL DB modelled like so:

type Product struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`
 Ingredients []Ingredient `gorm:"many2many:product_ingredients;" json:"ingredients"`


type Ingredient struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`

(And a joining table)

I want a query which fetches all products where the ingredient is included in a certain product:

I can get general queries with all data doing this:

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Find(&products)

But trying to do something like this

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Where(IngredientName: "Chicken").Find(&products)

Gives me
Error 1054: Unknown column 'ingredients.name' in 'where clause'

I'm expecting to only return products that have chicken as an ingredient.

Anyone able to help?

This should be fairly simple but I can't find any use cases like this and the docs are quite confusing.

go go-gorm

share|improve this question

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges

add a comment | 

1

Having an issue with a super simple Gorm query on a simple many_to_many relationship, I have 3 tables in a MYSQL DB modelled like so:

type Product struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`
 Ingredients []Ingredient `gorm:"many2many:product_ingredients;" json:"ingredients"`


type Ingredient struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`

(And a joining table)

I want a query which fetches all products where the ingredient is included in a certain product:

I can get general queries with all data doing this:

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Find(&products)

But trying to do something like this

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Where(IngredientName: "Chicken").Find(&products)

Gives me
Error 1054: Unknown column 'ingredients.name' in 'where clause'

I'm expecting to only return products that have chicken as an ingredient.

Anyone able to help?

This should be fairly simple but I can't find any use cases like this and the docs are quite confusing.

go go-gorm

share|improve this question

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges

add a comment | 

Having an issue with a super simple Gorm query on a simple many_to_many relationship, I have 3 tables in a MYSQL DB modelled like so:

type Product struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`
 Ingredients []Ingredient `gorm:"many2many:product_ingredients;" json:"ingredients"`


type Ingredient struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`

(And a joining table)

I want a query which fetches all products where the ingredient is included in a certain product:

I can get general queries with all data doing this:

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Find(&products)

But trying to do something like this

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Where(IngredientName: "Chicken").Find(&products)

Gives me
Error 1054: Unknown column 'ingredients.name' in 'where clause'

I'm expecting to only return products that have chicken as an ingredient.

Anyone able to help?

This should be fairly simple but I can't find any use cases like this and the docs are quite confusing.

go go-gorm

share|improve this question

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges

type Product struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`
 Ingredients []Ingredient `gorm:"many2many:product_ingredients;" json:"ingredients"`


type Ingredient struct 
 ID uint `gorm:"unique" json:"id"`
 Name string `gorm:"name" json:"name"`

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Find(&products)

db.Debug().Preload("Ingredients").Limit(limit).Offset(offset).Where(IngredientName: "Chicken").Find(&products)

share|improve this question

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges

share|improve this question

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges

asked Mar 26 at 15:17

Chris GChris G

15911 gold badge11 silver badge1313 bronze badges