Re: [SQLObject] refreshing object list when db changes?

[Ksenia M. <kse...@gm...>]

2005/5/17, Eddie Corns <ed...@ho...>:
>    From: Stewart Midwinter <ste...@gm...>
>    Date: Tue, 17 May 2005 09:01:07 -0600
>=20
>    Each time I add a new record to my database (using phpMyAdmiin), my
>    SQLObject becomes out-of-date because it doesn't know about the new
>    record. (I'm in the process of developing my application, and so far I
>    only use SQLObject for extracting data from the database, not for
>    inserting data into the database).
>=20
>    The only way for me to get everything in sync right now is to stop my
>    web app (CherryPy) and then restart it, because that causes a fresh
>    import of SQLObject and a fresh read of the database.   Is there a
>    method I could use to force this refresh to happen whenever I want, so
>    that I don't have to re-start my webapp?

I am flushing connection cache at the end of every http request in
Quixote (probably custom filter is the right place for it in
CherryPy?). That way every time the page is requested fresh data is
fetched from the database, but caching during request of one page is
allowed.

def flush_conn(conn):
    for key in conn.cache.caches.keys():
        for id in conn.cache.caches[key].allIDs():
            conn.cache.caches[key].expire(id)


I am using quite old version of SQLObject and passing the "flushed"
connection object to every class method. I think connectionHub from
svn is even easier to manage, but I didn't try it yet.

--=20
Ksenia