Go框架如何使用数据库触发器和存储过程？

db.Exec("CREATE TRIGGER trigger_name BEFORE INSERT ON table_name FOR EACH ROW BEGIN ... END")

_, err := db.Exec(
    "CREATE TRIGGER trigger_insert_users BEFORE INSERT ON users FOR EACH ROW " +
        "BEGIN " +
        "  SELECT NEW.id, NEW.name, 'New user inserted'; " +
        "END",
)
if err != nil {
    log.Fatalf("Error creating trigger: %v", err)
}

db.Exec("CREATE PROCEDURE procedure_name () BEGIN ... END")

_, err := db.Exec(
    "CREATE PROCEDURE get_user_details (IN id INT) " +
        "BEGIN " +
        "  SELECT * FROM users WHERE id = id; " +
        "END",
)
if err != nil {
    log.Fatalf("Error creating stored procedure: %v", err)
}

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/go-sql-driver/mysql"
)

const (
    dbUser = "root"
    dbPass = "password"
)

func main() {
    // Connect to MySQL
    db, err := sql.Open("mysql", fmt.Sprintf("%s:%s@tcp(127.0.0.1:3306)/employees", dbUser, dbPass))
    if err != nil {
        log.Fatalf("Error connecting to database: %v", err)
    }
    defer db.Close() // Close database connection at the end of the program

    // Create employee trigger
    if _, err := db.Exec("CREATE TRIGGER employee_id_trigger BEFORE INSERT ON employees FOR EACH ROW SET NEW.id = UUID()"); err != nil {
        log.Fatalf("Error creating employee_id_trigger: %v", err)
    }

    // Create get_employees stored procedure
    if _, err := db.Exec("CREATE PROCEDURE get_employees() BEGIN SELECT * FROM employees; END"); err != nil {
        log.Fatalf("Error creating get_employees stored procedure: %v", err)
    }

    // Create add_employee stored procedure
    if _, err := db.Exec("CREATE PROCEDURE add_employee(IN name VARCHAR(255), IN email VARCHAR(255)) BEGIN INSERT INTO employees (name, email) VALUES (name, email); END"); err != nil {
        log.Fatalf("Error creating add_employee stored procedure: %v", err)
    }

    // Create update_employee stored procedure
    if _, err := db.Exec("CREATE PROCEDURE update_employee(IN id INT, IN name VARCHAR(255), IN email VARCHAR(255)) BEGIN UPDATE employees SET name = name, email = email WHERE id = id; END"); err != nil {
        log.Fatalf("Error creating update_employee stored procedure: %v", err)
    }
}