I have a model like that:
#models.py
import sqlalchemy.mods.threadlocal
from sqlalchemy import *
metadata =
BoundMetaData('mysql://root:[EMAIL PROTECTED]@localhost/django')
metadata.engine.echo = True
wikis = Table('wiki_wiki', metadata,
Column('id', Integer, primary_key=True),
Column('pagename', String(20), unique=True),
Column('content', TEXT))
# These are the classes that will become our data classes
class Wiki(object):
@classmethod
def by_pagename(cls, pagename):
return
objectstore.context.current.query(cls).select_by(pagename=pagename)
@classmethod
def firstby_pagename(cls, pagename):
return
objectstore.context.current.query(cls).selectfirst_by(pagename=pagename)
def save(self):
return objectstore.context.current.save(self)
def flush(self):
return objectstore.context.current.flush([self, ])
mapper(Wiki, wikis)
then I write a web application to viewmodify wiki's contents, the code
like that:
#view
pages = Wiki.by_pagename(pagename)
if pages:
return pages[0].content
#edit
pages = Wiki.by_pagename(pagename)
if pages:
pages[0].content = content
pages[0].flush()
I configure apache + mod_python for run the web application, i meet a
very strange problem, I have a wiki which contents is test, then I
modify it contents to test2, I also print the current process id, I
found that distinct apache process show diffrent result, some show
test, some show test2, but the right should be 'test2, is
objectstore has cache or some other reason?
thanks!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---