[Twisted-web] Twisted and SQLAlchemy Cache Problem

[Magnus Hult]

Hi,

When executing the following program, changes in the database (other
than those made by this program) aren't visible until it is restarted,
due to some form of SQLAlchemy caching:

from twisted.web import server, resource
import model # my database model

class MyRoot(resource.Resource):
  def render(self, request):
    m = model.MyModel.get(request.args['id'][0])
    return m.some_column

# Connect to database.
model.metadata.connect('some_dburi')

# Create site structure.
root = resource.Resource()
root.putChild('', MyRoot())
site = server.Site(root)

# Switch user, start service.
from twisted.application import service, strports
application = service.Application("myexample")
s = strports.service('tcp:8080', site)
s.setServiceParent(application)

So if I visit http://localhost:8080/?id=1, then alter the some_column
value for the row who's id is 1 and reload, the change is not
reflected.

Problem is, I need the update to be visible. How would I go about
implementing this?

Regards,
Magnus