If you're using CGI::Session::MySQL, you can alter it to put the expiration time in a column.
sub store {
my ($self, $sid, $options, $data) = @_;
my $dbh = $self->MySQL_dbh($options);
my $lck_status = $dbh->selectrow_array(qq|SELECT GET_LOCK("$sid",
+10)|);
unless ( $lck_status == 1 ) {
$self->error("Couldn't acquire lock on id '$sid'. Lock status:
+ $lck_status");
return undef;
}
$dbh->do(qq|REPLACE INTO $TABLE_NAME (id, expires, a_session) VALU
+ES(?,FROM_UNIXTIME(?),?)|,
undef, $sid, $self->expire(), $self->freeze($data));
return $dbh->selectrow_array(qq|SELECT RELEASE_LOCK("$sid")|);
}
And the schema just needs to be updated:
CREATE TABLE sessions (
id CHAR(32) NOT NULL UNIQUE,
expires datetime,
a_session TEXT NOT NULL
);
Now in order to find all active sessions, run the query:
select id from sessions where expires <= NOW() or expires is null
...or something like that ;-P
antirice
The first rule of Perl club is - use Perl
The ith rule of Perl club is - follow rule i - 1 for i > 1
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.