Apache::Session::Browseable::MySQL(3pm) 		User Contributed Perl Documentation		   Apache::Session::Browseable::MySQL(3pm)

NAME

       Apache::Session::Browseable::MySQL - Add index and search methods to Apache::Session::MySQL

SYNOPSIS

	 use Apache::Session::Browseable::MySQL;

	 my $args = {
	      DataSource => 'dbi:mysql:sessions',
	      UserName	 => $db_user,
	      Password	 => $db_pass,
	      LockDataSource => 'dbi:mysql:sessions',
	      LockUserName   => $db_user,
	      LockPassword   => $db_pass,

	      # Choose your browseable fileds
	      Index	     => 'uid mail',
	 };

	 # Use it like Apache::Session
	 my %session;
	 tie %session, 'Apache::Session::Browseable::MySQL', $id, $args;
	 $session{uid} = 'me';
	 $session{mail} = 'me@me.com';
	 $session{unindexedField} = 'zz';
	 untie %session;

	 # Apache::Session::Browseable add some global class methods
	 #
	 # 1) search on a field (indexed or not)
	 my $hash = Apache::Session::Browseable::MySQL->searchOn( $args, 'uid', 'me' );
	 foreach my $id (keys %$hash) {
	   print $id . ":" . $hash->{$id}->{mail} . "
";
	 }

	 # 2) Parse all sessions
	 # a. get all sessions
	 my $hash = Apache::Session::Browseable::MySQL->get_key_from_all_sessions();

	 # b. get some fields from all sessions
	 my $hash = Apache::Session::Browseable::MySQL->get_key_from_all_sessions('uid', 'mail')

	 # c. execute something with datas from each session :
	 #    Example : get uid and mail if mail domain is
	 my $hash = Apache::Session::Browseable::MySQL->get_key_from_all_sessions(
		     sub {
			my ( $session, $id ) = @_;
			if ( $session->{mail} =~ /mydomain.com$/ ) {
			    return { $session->{uid}, $session->{mail} };
			}
		     }
	 );
	 foreach my $id (keys %$hash) {
	   print $id . ":" . $hash->{$id}->{uid} . "=>" . $hash->{$id}->{mail} . "
";
	 }

DESCRIPTION

       Apache::Session::browseable provides some class methods to manipulate all sessions and add the capability to index some fields to make
       research faster.

SEE ALSO

       Apache::Session

AUTHOR

       Xavier Guimard, <x.guimard@free.fr>

COPYRIGHT AND LICENSE

       Copyright (C) 2009 by Xavier Guimard

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.10.1 or,
       at your option, any later version of Perl 5 you may have available.

perl v5.14.2							    2010-12-08				   Apache::Session::Browseable::MySQL(3pm)