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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
