Hi James,
it would be helpful if you posted the call stack where that error
occurs, and the code leading up to the failed query execution, which
database and driver (the first word in the engine URL).
Without further details, the first place I would look is where the
session (or connection) gets created. Are you sure it is getting the
same engine URL that you used in the python shell code (which you
replaced with "login-info" before posting)?
- Gulli
On Jan 29, 9:00 pm, James Sathre <[email protected]> wrote:
> I’ve been stuck trying to get the pylons application to connect to my
> database. I was able to connect to the database through a python
> shell in the “virtualenv” as you can see below. The app acts like it
> can connect to the database, but not to the table.
>
> I admit this is my first pylons project and I'm a little confused as
> to where to start looking for a problem. There seems to be a lot of
> outdated doc's on the web and I don't know what to believe is the
> current way of doing things.
>
> >>> import sqlalchemy as sa
> >>> engine = sa.create_engine("login-info")
> >>> from pwi import model
> >>> model.init_model(engine)
> >>> engine.has_table("pwi_wildcard")
>
> True
>
> OperationalError: (OperationalError) no such table: pwi_wildcard
> u'SELECT pwi_wildcard.wildcard_id AS pwi_wildcard_wildcard_id,
> pwi_wildcard.priority AS pwi_wildcard_priority, pwi_wildcard.name AS
> pwi_wildcard_name, pwi_wildcard.shot AS pwi_wildcard_shot,
> pwi_wildcard.scene AS pwi_wildcard_scene, pwi_wildcard.created_by AS
> pwi_wildcard_created_by, pwi_wildcard.expires AS pwi_wildcard_expires
> \nFROM pwi_wildcard' []
>
> thanks in advance,
>
> James
--
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.
