How do I clear the database session? I thought sacontext took care of
that?
Jose
On Aug 6, 9:12 am, askel <[EMAIL PROTECTED]> wrote:
> let me guess, you do not clear database session before/after each
> request
>
> On Aug 6, 12:02 pm, jose <[EMAIL PROTECTED]> wrote:
>
> > I have a perplexing problem and I'm really hopping that there is a
> > setting or something stupid that I've missed. Here is the issue, I
> > have an application most of my page data is coming from a postgres
> > database. I've designed an admin interface which allows you to edit
> > the database, however, when I leave the admin interface and look at
> > the page as a normal user, I see old data, not the new data. If I
> > look at the database directly with pgadmin the new data has been
> > entered. I am using postgres, python 2.4 pylons 0.9.6 rc2. Here is
> > some example code:
>
> > ini file:
> > sqlalchemy.default.url = postgres://user:[EMAIL PROTECTED]/epathology
>
> > model:
> > from sqlalchemy import *
> > from sqlalchemy.orm import *
> > form sqlalchemy.ext.assignmapper import assign_mapper
> > from sacontext import PylonsSAContext
>
> > sac = PylonsSAContext()
> > sac.add_engine_from_config('default')
> > ctx = sac.session_context
>
> > table1 = Table('table1', sac.metadata, autoload=True)
> > class Table1(object):
> > pass
> > assign_mapper(ctx, Table1, table1, extension=sac.ext)
>
> > to set data I do:
> > rec = model.Table1.get(id)
> > rec.someattribute = "new value"
> > rec.save() # I has not been doing this initially, I just added this
> > to see if it would help, it did not
> > model.sac.session.flush()
>
> > to get data I do:
> > data = model.rec.select()
>
> > This seems to work, however like I said when I edit the data more
> > often then not the application reflects old data, like its getting
> > data from a cache or using an old session to retrieve data from. What
> > am I doing wrong? this is really frustrating. Well thanks for any and
> > all help
>
> > Jose
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
