func()

in internal/database/mysql/mysql.go [470:491]

• 20 lines of code
• 5 McCabe index (conditional complexity)

func (h mysqlHandler) GetTableComment(ctx context.Context, db *database.DB, tableName string) (string, error) {
	query := `
        SELECT table_comment
        FROM information_schema.tables
        WHERE table_name = ?
          AND table_schema = DATABASE();
    `

	var comment sql.NullString
	err := db.QueryRowContext(ctx, query, tableName).Scan(&comment)
	if err != nil {
		if err == sql.ErrNoRows {
			return "", nil // No comment, return empty string.
		}
		return "", fmt.Errorf("failed to retrieve table comment: %w", err)
	}

	if comment.Valid {
		return comment.String, nil
	}
	return "", nil // Comment is NULL.
}