Open amangupta25 opened 11 months ago
Can you turn on boil.DebugMode
and share the generated queries for both?
These are the generated queries:
Generated Query: SELECT "user"."id" as "user.id", "user"."name" as "user.name", "user"."email_id" as "user.email_id" FROM "user" INNER JOIN contact ON user.contact_number = contact.contact_number;
select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number
).Bind(ctx, d.db, &info1) :Generated Query: select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number
The issue is not the Bind
the issue is the Join
When there is a join, the columns are aliased because it is assumed that you want to select values from multiple tables.
Try something like this:
type LimitedInfo struct {
ID string `boil:"id"`
Name string `boil:"name"`
EmailID string `boil:"email_id"`
}
var info []*Struct{
LimitedInfo `boil:"user,bind"`
}
err = db_models.NewQuery(qm.Select("user.id", "user.name", "user.email_id"), qm.From("user"), qm.InnerJoin("contact ON user.contact_number = contact.contact_number")).Bind(ctx, d.db, &info)
What version of SQLBoiler are you using (
sqlboiler --version
)?SQLBoiler v4.15.0
What is your database and version (eg. Postgresql 10)
psql (PostgreSQL) 15.4
If this happened at generation time what was the full SQLBoiler command you used to generate your models? (if not applicable leave blank)
If this happened at runtime what code produced the issue? (if not applicable leave blank)
What is the output of the command above with the
-d
flag added to it? (Provided you are comfortable sharing this, it contains a blueprint of your schema)Please provide a relevant database schema so we can replicate your issue (Provided you are comfortable sharing this)
Further information. What did you do, what did you expect?
I am trying to execute sql query using db_models.NewQuery(..).Bind(...) to select some specific columns (not all '*') from my psql table but it is returning me results with all fields set to the default value of their datatype and not the actual value fetched from the table. However, when i am using queries.Raw(..).Bind(..) with the same query, it is working as expected and returning correct results. Below is the struct and the code snippet that i am executing:
This results in:
In the above results, 'info' has not been bound properly (its fields are not populated), but 'info1' has been bound properly.