Go言語を使って高性能なMySQLデータ自動生成を作成する方法

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `content` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id_idx` (`user_id`),
  CONSTRAINT `user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id_idx` (`user_id`),
  KEY `post_id_idx` (`post_id`),
  CONSTRAINT `user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `post_id_fk` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
);

type User struct {
    ID    int64    `db:"id"`
    Name  string   `db:"name"`
    Email string   `db:"email"`
}

type Post struct {
    ID        int64      `db:"id"`
    Title     string     `db:"title"`
    Content   string     `db:"content"`
    UserID    int64      `db:"user_id"`
    CreatedAt time.Time  `db:"created_at"`
}

type Comment struct {
    ID        int64      `db:"id"`
    Content   string     `db:"content"`
    UserID    int64      `db:"user_id"`
    PostID    int64      `db:"post_id"`
    CreatedAt time.Time  `db:"created_at"`
}

func (p *Post) Insert(db *sql.DB) error {
    stmt, err := db.Prepare("INSERT INTO posts (title, content, user_id, created_at) VALUES (?, ?, ?, ?)")
    if err != nil {
        return err
    }
    defer stmt.Close()

    _, err = stmt.Exec(p.Title, p.Content, p.UserID, p.CreatedAt)
    if err != nil {
        return err
    }

    return nil
}

type MySqlDB struct {
    db *sql.DB
}

var mysqlDB *MySqlDB

func main() {
    // 连接到MySQL数据库
    db, err := sql.Open("mysql", "user:password@tcp(localhost:3306)/blog")
    if err != nil {
        log.Fatal(err)
    }

    mysqlDB := &MySqlDB{db}

    // 创建一篇新文章
    p := &Post{
        Title:     "Hello, world!",
        Content:   "This is my first blog post",
        UserID:    1,
        CreatedAt: time.Now(),
    }

    err = p.Insert(mysqlDB.db)
    if err != nil {
        log.Fatal(err)
    }
}

SELECT * FROM users;
SELECT * FROM posts;
SELECT * FROM comments;