[OPEN-ILS-GENERAL] ***SPAM*** Re: Question about Bookbags and Server Space

[Dan Scott]

On Fri, 2010-06-04 at 12:16 -0400, Melissa Lefebvre wrote:
> Hi Everyone,
> 
>  
> 
> Does anyone know if Bookbags remain on the patron’s record forever if
> they don’t delete them (I’m assuming yes)?

Yes, they do.

>   If so do Bookbags take up much space in the database?

A trivially small amount of space; just a few bytes per bookbag entry.

>   Does anyone restrict the number of bookbags or the number of items
> patrons/staff can have in a bookbag (is that even possible)? 

We don't, and I don't think it's currently possible to restrict them.
Development effort would be needed.

>  Can bookbags expire after a certain length of time based on type of
> patron (staff bookbags last forever where as patron bookbags expire
> after so many months)? 

If I wanted to expire bookbags (with criteria like patron type / active
account, etc), I would write an SQL statement that deleted the offending
bookbags based on the criteria. The "create_time" column of the
container.biblio_record_entry_bucket table is what you would use to
determine the expiry date. Then I would just add a cron entry to have
the SQL statement issued on a nightly basis.

Note that if you choose to expire a patron's bookbag by deleting it from
the container.biblio_record_entry_bucket table (and the associated
bookbag entries from the container.biblio_record_entry_bucket_item
table), then there's no way for them to get it back. This could be
pretty surprising for patrons who decided to share a feed of the items
they've most thoroughly enjoyed, only to find it magically disappear a
year down the road (bringing their recommendation service business
empire to ruins!).