续集选择太多列
似乎 Sequel 的默认选择是“select *”，当您添加一些连接时，这会导致各种问题。 至少你最终会在对象中得到错误的 id（因为随后将返回多个“id”列）。 做类似的事情
.select("people.*")
似乎可行，但这会将传入的字符串视为列并引用它。 到目前为止，我不得不恢复到纯 SQL 来解决这个问题，但我知道必须有更好的方法。
It seems like the default select for Sequel is "select *", which causes all kinds of problems when you add some joins. At the very least you end up with the wrong ids in your objects (because there will then be more than one "id" column returned). Doing something like
.select("people.*")
would seem to work, but that treats the string passed in as a column and quotes it. So far I've had to revert back to bare SQL to solve this, but I know there has to be a better way.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Sequel 的默认行为是选择所有列，但很容易覆盖。 如果您只想选择单个表中的所有列：
如果您想使用文字 SQL 字符串：
The default behavior for Sequel is to select all columns, but it is easy to override. If you want to select only all columns from a single table:
If you want to use a literal SQL string:
.select('people.*'.lit)