Thanks Adam, I'll look into that! 2016-11-23 21:14 GMT-02:00 Adam Herzog <a...@adamherzog.com>: > On Oct 23, 2016, at 14:55, Hector Azpurua <h3ct0r...@gmail.com> wrote: >> Is there a recommended way to access or modify session data stored in >> database with Store::DBI ? > > The session data is typically a hashref of data, serialized using Storable, > and converted to Base64 for storage in the database. Look at the > get_session_data() and store_session_data() in > Catalyst::Plugin::Session::Store::DBI to see how the data is retrieved and > stored: https://metacpan.org/source/Catalyst::Plugin::Session::Store::DBI#L24 > > You can do the same thing. From code outside Catalyst you can use DBI or > DBIx::Class or whatever to SELECT the data from the database, decode/thaw it, > work with it however you'd like, then freeze/encode it and UPDATE the db > record. You'll probably want to wrap that in a transaction. > > A separate problem is that the session data is keyed on the session id, not > the username, so you won't be able to directly SELECT the session data for a > particular username. You'd need to select and examine each session to find > the username in $session_data->{'__user'}. Or maybe create a subclass of > Catalyst::Plugin::Session::Store::DBI and store the username as a separate > column in the sessions table. I have no idea how difficult that would be, but > I bet it's manageable. > > -A > > > _______________________________________________ > List: Catalyst@lists.scsys.co.uk > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ > Dev site: http://dev.catalyst.perl.org/
_______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/