func()

in internal/database/mysql/mysql.go [111:132]

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

func (h mysqlHandler) ListTables(db *database.DB) ([]string, error) {
	query := "SHOW TABLES"

	rows, err := db.Query(query)
	if err != nil {
		return nil, fmt.Errorf("error querying tables: %w", err)
	}
	defer rows.Close()

	var tables []string
	for rows.Next() {
		var tableName string
		if err := rows.Scan(&tableName); err != nil {
			return nil, fmt.Errorf("error scanning table name: %w", err)
		}
		tables = append(tables, tableName)
	}
	if err := rows.Err(); err != nil {
		return nil, fmt.Errorf("error iterating table rows: %w", err)
	}
	return tables, nil
}