Joins 必须要写sql语句？好呆的设计啊

[chenyu1990]

db.Joins("Company", db.Where(&Company{Alive: true})).Find(&users) 的输出结果是 select ... from sometable Company

查了不少文章，chatgpt也试试了 有效果的就是 db.Joins("LEFT JOIN Company ON ...") 这个好呆 1、Company用字符串输入本身就很呆，不是应该用模型去解析表名吗？ 2、ON里的字段不是应该用.Where()方法来拼吗？用字符串来写，还不如.Raw()呢！！！

[github-actions[bot]]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[zzhaoh]

https://gorm.io/zh_CN/docs/preload.html 如果希望使用gorm的join自动拼接，需要你的相关表结构体有关联关系

[github-actions[bot]]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[kuangshp]

db.Joins("Company", db.Where(&Company{Alive: true})).Find(&users) 的输出结果是 select ... from sometable Company

查了不少文章，chatgpt也试试了 有效果的就是 db.Joins("LEFT JOIN Company ON ...") 这个好呆 1、Company用字符串输入本身就很呆，不是应该用模型去解析表名吗？ 2、ON里的字段不是应该用.Where()方法来拼吗？用字符串来写，还不如.Raw()呢！！！

你也可以用gen来实现，我代码里面就直接这样干过去

[github-actions[bot]]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨