sqlmockでEager loadingを利用したコードのテストを書く際の注意事項

 1CREATE TABLE `articles` (
 2  `id` int PRIMARY KEY AUTO_INCREMENT,
 3  `title` varchar(255) NOT NULL,
 4  `content` text NOT NULL,
 5  `published_at` datetime NOT NULL,
 6  `created_at` datetime NOT NULL,
 7  `updated_at` datetime NOT NULL,
 8  `deleted_at` datetime
 9);
10
11CREATE TABLE `draft_articles` (
12  `id` int PRIMARY KEY AUTO_INCREMENT,
13  `article_id` int NOT NULL UNIQUE,
14  `title` varchar(255) NOT NULL,
15  `content` text NOT NULL,
16  `created_at` datetime NOT NULL,
17  `updated_at` datetime NOT NULL
18);
19
20CREATE TABLE `tags` (
21  `id` int PRIMARY KEY AUTO_INCREMENT,
22  `name` varchar(10) NOT NULL
23);
24
25CREATE TABLE `articles_tags` (
26  `id` int PRIMARY KEY AUTO_INCREMENT,
27  `article_id` int NOT NULL,
28  `tag_id` int NOT NULL,
29  UNIQUE KEY `articles_tags_idx_00` (`article_id`, `tag_id`),
30  CONSTRAINT `articles_tags_article_id_fk` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE,
31  CONSTRAINT `articles_tags_tag_id_fk` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
32);

1// Go側の実装
2query := tx.Preload(clause.Associations).
3	Where("articles.id = ? AND deleted_at IS NULL", id).
4	Where("articles.published_at IS NOT NULL").
5	Take(&article)

1-- 発行されるSQL
2SELECT * FROM `articles` WHERE (articles.id = ? AND deleted_at IS NULL) AND articles.published_at IS NOT NULL LIMIT 1
3
4SELECT * FROM `draft_articles` WHERE `draft_articles`.`article_id` = ?
5
6SELECT * FROM `articles_tags` WHERE `articles_tags`.`article_id` = ?
7
8SELECT * FROM `tags` WHERE `tags`.`id` IN (?,?)

1-- 期待されるクエリすべてにmock.ExpectQuery()を書く
2SELECT * FROM `articles` WHERE (articles.id = ? AND deleted_at IS NULL) AND articles.published_at IS NOT NULL LIMIT 1
3
4SELECT * FROM `draft_articles` WHERE `draft_articles`.`article_id` = ?
5
6SELECT * FROM `articles_tags` WHERE `articles_tags`.`article_id` = ?
7
8SELECT * FROM `tags` WHERE `tags`.`id` IN (?,?)