aarondl
commented
7 years ago Hey there. I wasn't able to reproduce this on the master branch.
Here's the schema I used (I had to name it differently:
CREATE TABLE IF NOT EXISTS `videos` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `tags` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `settings` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`tag_id` INT UNSIGNED NULL,
`value` VARCHAR(45) NULL,
PRIMARY KEY (`id`),
INDEX `pk_setting_b_id_idx` (`tag_id` ASC),
CONSTRAINT `pk_setting_b_id`
FOREIGN KEY (`tag_id`)
REFERENCES `tags` (`id`)
);
CREATE TABLE IF NOT EXISTS `video_tags` (
`video_id` INT UNSIGNED NOT NULL,
`tag_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`video_id`, `tag_id`),
INDEX `pk_b_id_idx` (`tag_id` ASC),
CONSTRAINT `pk_a_id`
FOREIGN KEY (`video_id`)
REFERENCES `videos` (`id`),
CONSTRAINT `pk_b_id`
FOREIGN KEY (`tag_id`)
REFERENCES `tags` (`id`)
);
insert into videos () values ();
insert into videos () values ();
insert into tags () values ();
insert into tags () values ();
insert into tags () values ();
insert into video_tags (video_id, tag_id) values (1, 1);
insert into video_tags (video_id, tag_id) values (1, 2);
insert into video_tags (video_id, tag_id) values (2, 1);
insert into video_tags (video_id, tag_id) values (2, 3);
insert into settings (tag_id, value) values (1, 'hello');
insert into settings (tag_id, value) values (2, 'there');
insert into settings (tag_id, value) values (3, 'world');The meat of the code I used to test:
response, err := models.Videos(db,
qm.Where("id = ?", 1),
qm.Load("Tags.Settings"),
).One()
spew.Dump(response)Run gives this output:
SELECT * FROM `videos` WHERE (id = ?) LIMIT 1;
[1]
select `a`.*, `b`.`video_id` from `tags` as `a` inner join `video_tags` as `b` on `a`.`id` = `b`.`tag_id` where `b`.`video_id` in (?)
[1]
select * from `settings` where `tag_id` in (?,?)
[1 2]
(*models.Video)(0xc42000d4a0)({
ID: (uint) 1,
R: (*models.videoR)(0xc42000d580)({
Tags: (models.TagSlice) (len=2 cap=2) {
(*models.Tag)(0xc42000d620)({
ID: (uint) 1,
R: (*models.tagR)(0xc4200f9050)({
Settings: (models.SettingSlice) (len=1 cap=1) {
(*models.Setting)(0xc4200195c0)({
ID: (uint) 1,
TagID: (null.Uint) {
Uint: (uint) 1,
Valid: (bool) true
},
Value: (null.String) {
String: (string) (len=5) "hello",
Valid: (bool) true
},
R: (*models.settingR)(<nil>),
L: (models.settingL) {
}
})
},
Videos: (models.VideoSlice) <nil>
}),
L: (models.tagL) {
}
}),
(*models.Tag)(0xc42000d640)({
ID: (uint) 2,
R: (*models.tagR)(0xc4200f9080)({
Settings: (models.SettingSlice) (len=1 cap=1) {
(*models.Setting)(0xc420019600)({
ID: (uint) 2,
TagID: (null.Uint) {
Uint: (uint) 2,
Valid: (bool) true
},
Value: (null.String) {
String: (string) (len=5) "there",
Valid: (bool) true
},
R: (*models.settingR)(<nil>),
L: (models.settingL) {
}
})
},
Videos: (models.VideoSlice) <nil>
}),
L: (models.tagL) {
}
})
}
}),
L: (models.videoL) {
}
})At commit: 0b027fa01c78dcc2036564fb7dabbd1229509821 (current master, no code changes)
jfernstad
What version of SQLBoiler are you using (
sqlboiler --version)?v2.5.0
If this happened at runtime what code produced the issue? (if not applicable leave blank)
Please provide a relevant database schema so we can replicate your issue (Provided you are comfortable sharing this)
Using MySQL.
Further information. What did you do, what did you expect?
Hi, I'm trying to load all the information necessary for a "fat" response for a webservice and I want to Load data a few tables separated from the request. The tables above are hopefully equivalent to what I have (can't share, sorry).
I'm hoping to get
Settingsfor allBs that have a relationship withAbut this query generates the following runtime panic:interface conversion: interface {} is *models.BSlice, not *[]*models.BThis is happening deep in (again equivalent) function
models.bL.LoadBSetting.In my mind
*BSliceand*[]*Bare basically the same?Will gladly accept any suggestions to workarounds.