support deleting old sessions

Ticket

+commit
 

old sessions can pile up. 

 

for now I think we just need a rake task (presumably one that many folks will use via cron jobs).  Also think we should set it up so cloudstore calls this on updates.

 

 

admin/delete_old_sessions. (there is also an admin/delete_old_revisions and admin/repair_references)

--Ethan McCutchen.....2013-04-09 20:52:31 +0000

What is a "session" ?

--John Abbe.....2013-04-20 20:31:47 +0000

wagn's current db structure:

mysql> show tables;
+-------------------------+
| Tables_in_en_copy       |
+-------------------------+
| card_references         |
| card_revisions          |
| cards                   |
| schema_migrations       |
| schema_migrations_cards |
| sessions                |
| users                   |
+-------------------------+
7 rows in set (0.00 sec)
 
The first three are core and are there to stay.  The others:
  • schema_migrations: a rails table for tracking whether the db structure is up to date with the code
  • schema_migrations_cards: a Wagn clone of the above for tracking whether card data is up to date with the code
  • sessions: another Railsy table for handling session data.  We don't store any real valuable information in a cookie; all we store is the session id, and we keep the real data in the table.  See http://guides.rubyonrails.org/security.html#session-storage.   The present ticket is about being able to empty out stale data from that table.
  • users: a Wagn table, but one that will soon be integrated into cards.
--Ethan McCutchen.....2013-04-20 21:01:38 +0000

So sessions refers to browser sessions, thx...

--John Abbe.....2013-04-20 21:41:48 +0000