Hi I implemented simple form to edit user table. Suppose we have user2, [EMAIL PROTECTED] Change name to user222 and click submit. Pgamin shows that now we have user222 as expected. But if I visit 'users/edit/2' many times I see sometimes old value 'user2' and another time new value 'user222'.
Now I configure models in this way: #models/__init__.py from pylons.database import session_context from elixir import metadata from sqlalchemy import Table, BoundMetaData engine = session_context.current.bind_to import pyoner.models.user #base.py class BaseController(WSGIController): def __call__(self, environ, start_response): del model.session_context.current model.metadata.connect(model.engine) return WSGIController.__call__(self, environ, start_response) My users.py controller: from pyoner.lib.base import * from pyoner.models.user import * class UsersController(BaseController): def index(self): c.users = User.select() return render_response('/user_list.html') def edit(self, id): c.user = User.get_by(id=id) print(c.user.name) return render_response('/user_edit.html') def apply(self, id): user = User.get(id) user.name = request.params.get('username', '').strip() user.email = request.params.get('email', '').strip() objectstore.flush() redirect_to(controller='users', action='index') and models/user.py: from elixir import * from sqlalchemy import * from datetime import datetime #from pyoner.models import UserEntity class User(Entity): has_field('id', Integer, primary_key=True) has_field('name', Unicode(50), unique=True) has_field('email', Unicode(255), unique=True) has_field('password', Unicode(40)) has_field('created', DateTime, default=datetime.now) using_options(tablename='user') [app:main] sqlalchemy.dburi = postgres://user:[EMAIL PROTECTED]:5432/pyoner sqlalchemy.echo = false Is there any error in my config of SQLAlchemy? -- Best regards, Antipin Aleksei --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---