Ok a few people have recommended that I go with Elixir now, so I'm
going to give that a shot. I hope it works because I really want TG
to work out for me!
On Feb 14, 9:36 am, lorax <[EMAIL PROTECTED]> wrote:
> Ok I'm starting to wonder if I've found a bug in Turbogears and/or
> sqlalchemy. I decided to start with a fresh project and add only the
> required pieces so I could test this. I'm still getting an error when
> I execute session.flush().
>
> I started with the following:
> tg-admin quickstart --sqlalchemy -t tgbig snifflemap
>
> Then I added a 'widgets' folder with login_widgets.py containing the
> following:
>
> from turbogears import widgets,validators
>
> class registrationFields(widgets.WidgetsList):
> user_id = widgets.TextField('user_id', label="User ID")
> password = widgets.PasswordField('password', label="Password")
> password_verify = widgets.PasswordField('password_verify',
> label="Verify Password")
> first_name = widgets.TextField('first_name', label="First Name")
> last_name = widgets.TextField('last_name', label="Last Name")
> email = widgets.TextField('email', label="Email Address")
>
> class registrationFormSchema(validators.Schema):
> user_id = validators.UnicodeString(not_empty=True)
> password = validators.UnicodeString(not_empty=True)
> password_verify = validators.UnicodeString(not_empty=True)
> first_name = validators.UnicodeString(not_empty=True)
> last_name = validators.UnicodeString(not_empty=True)
> email = validators.Email(not_empty=True)
> chained_validators = [
> validators.FieldsMatch('password','password_verify')
> ]
>
> registration_form = widgets.TableForm(
> fields=registrationFields(),
> action="process_registration",
> validator=registrationFormSchema()
> )
>
> I added a register.kid to templates, containing:
>
> <body>
> <div id="content">
> ${form.display()}
> </div>
> </body>
>
> Finally, to root.py I added a couple imports and registration
> functions:
>
> from snifflemap.widgets import login_widgets
> from snifflemap.model import User
> from turbogears.database import session
>
> @expose(template="snifflemap.templates.register")
> def register(self):
> return (dict(form=login_widgets.registration_form))
>
> @expose()
> def process_registration(self, **data):
> user=User()
> user.user_name = data['user_id']
> user.email_address = data['email']
> user.password = data['password']
> session.save(user)
> try:
> session.flush()
> except:
> flash('There was an error!')
> raise redirect('/')
>
> When I include the flush as above, I get the following error in my
> browser:
> File "c:\python25\lib\site-packages\sqlalchemy-0.4.2p3-py2.5.egg
> \sqlalchemy\orm\session.py", line 489, in commit
> raise exceptions.InvalidRequestError("No transaction is begun.")
> InvalidRequestError: No transaction is begun
>
> If I do not include the flush, I cannot trap the exception
> (IntegrityError) which occurs after I duplicate a user record.
>
> Is this a bug?
>
> On Feb 13, 8:39 pm, lorax <[EMAIL PROTECTED]> wrote:
>
> > I converted my tables to innodb and no luck. I still miss the
> > exception without the session.flush() and get a 'no open transaction'
> > error if I add the session.flush().
>
> > On Feb 13, 1:20 pm, lorax <[EMAIL PROTECTED]> wrote:
>
> > > I'm having trouble trapping an IntegrityError with sqlalchemy. I have
> > > the following:
>
> > > from turbogears.database import session
> > > from myproject.model import User
>
> > > user = User()
> > > user.user_name = "Harry"
> > > user.password = "mypass"
>
> > > try:
> > > session.save(user)
> > > except:
> > > flash("Duplicate entry!")
> > > raise redirect ("register")
>
> > > ..but it doesn't catch the error and it comes back to me in the
> > > browser. I tried adding a session.flush() in the try block but there
> > > is an error about no transaction being created. I'm assuming that is
> > > because I'm using mysql myISAM
>
> > > Can anyone help? Thanks so much.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
