perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Vanasco <modperl-l...@2xlp.com>
Subject Re: Apache::Session: can I have a "date" in session
Date Thu, 27 Apr 2006 16:02:11 GMT

On Apr 27, 2006, at 11:38 AM, Cees Hek wrote:
> You can have the database do all that for you using a trigger (if your
> database suports it).  I have used PostgreSQL in the past to do the
> following:
>
> CREATE TABLE sessions (
>    id varchar(32) NOT NULL PRIMARY KEY,
>    a_session text NOT NULL,
>    lm timestamp with time zone DEFAULT now()
> );
thats actually in the docs to some perl mod somewhere.  maybe  
cgi::session?


> CREATE FUNCTION update_session_lm() RETURNS "trigger"
>    AS '
>    BEGIN
>      NEW.lm := ''now'';
>      RETURN NEW;
>    END;
>  '
>    LANGUAGE plpgsql;
>
> CREATE TRIGGER update_session_lm_trig
>    BEFORE UPDATE ON sessions
>    FOR EACH ROW
>    EXECUTE PROCEDURE update_session_lm();

you could also just have apache::session update that column as well  
on the data store by overrideing the store mechanism

Mime
View raw message