Sequel Sessions is not reflected in DB

Running :session_store: sequel # no joy
Running :session_store: active_record # do reflect in DB

Dear raid

You need to describe your errors more closely. Please read http://www.chiark.greenend.org.uk/~sgtatham/bugs.html (among others) and restate your bugreport.

Until then, I invalidate this ticket. By that I am not saying your error is invalid, it might be very real and I thank you for reporting it, but the report per se is not up to par. Please appreciate that precise reporting is needed for this (potential) bug to be removed. When you redescribe the bug, just reopen the ticket.

All the best. Jon Egil Strand

Ahhhh formal Diligent way to reproduce :

Lets create a merb skeleton app with sequel ORM plugin support.

svn co http://svn.devjavu.com/merb/trunk merb_svn
cd merb_svn
svn info
Revision: 640

rake install

cd ..
merb -g sequelsessionstestfordilligentMERBers
svn co http://svn.devjavu.com/merb/plugins/merb_sequel merb_sequel_svn
cd merb_sequel_svn
rake gem
gem install pkg/gem -i {your-path-to}/sequelsessionstestfordilligentMERBers/deps

cd {into-your}/sequelsessionstestfordilligentMERBers

mate . # or open your favorite editor
edit file config/database.yml to reflect your liking
edit file config/dependencies.rb to include dependency "merb_sequel"
edit file config/merb.yml to use :session_store: sequel

create file models/sessions.rb with http://pastie.caboo.se/97690 code
create file controllers/sessionstest.rb with http://pastie.caboo.se/97688 code

back in console cd to lib svn co http://svn.devjavu.com/merb/apps/marble/trunk/lib/

finally You can now cd .. back to sequelsessionstestfordilligentMERBers and issue

merb

finally browse to localhost:4000

then browse to localhost:4000/set_session

use back button => evaluate ... reload => evaluate ...

The above is from memory more or less YMMV ...

Cheers ...

ohhh You need the URL's :

http://localhost:4000/

http://localhost:4000/sessionstest/

http://localhost:4000/sessionstest/set_session

you can use this magic_scaffold.rb to not have to set routes
http://pastie.caboo.se/97695

Another tool for instant visual feedback :

http://pastie.caboo.se/97744

updated --Another tool for instant visual feedback : --

http://pastie.caboo.se/97914

Patch to Create Sessions Table for Sequel

I've attached a patch that creates the necessary sessions table when one doesn't exist. It only gets triggered when the appropriate config properties are set. So if you aren't using Sequel for sessions then it won't autocreate the table.

(In [659]) patch for creating sessions table in merb_sequel, closes #177

Very good to create session table if it do not exist . but sessions are still not stored in the session table and therefore using sequel sessions is not functional.

Removes a module declaration that was blocking sessions from appearing in database.

It appears that this patch now fixes the problem sessions appear in my table now.

thanxs james

added require "base64" to Your diff at the top of the sequel_session.rb file ...

now i have sessions in my session table ...

again thanxs

(In [668]) Fixed merb_sequel plugin (thanks James) [closes #177]