>
> Produce the simplest program you can that causes the error, then post
> both the code and full exception here.
>
> Paul
Sorry about the wrong subject in the last post. Google groups are quite
annoying.
This is the minimal program that causes the error:
db = sa.create_engine('mysql://myuser:[EMAIL PROTECTED]/mydatabase')
metadata = sa.BoundMetaData(db)
def user_mapper():
'''Create the object/relational link for users'''
users_table = sa.Table('Users', metadata, autoload=True)
sa.orm.clear_mappers()
sa.mapper(User, users_table)
session = sa.create_session(bind_to=db)
query = session.query(User)
return session, query
def authenticate(req, username, password):
'''Grant access if password matches the one stored in the db'''
dbsession, query = user_mapper()
try:
user = query.get_by(Uid=username)
except sa.exceptions.SQLError, details:
return "Database error: %s" % details
else:
if user == None:
return print_error(req, "That user does not exist!")
The error I get is:
Database error: (InterfaceError) (0, '') u'SELECT `Users`.`Uid` AS `Users_Uid`,
`Users`.`Country` AS `Users_Country`, `Users`.`LName` AS `Users_LName`,
`Users`.`Credits` AS `Users_Credits`, `Users`.`Pwd` AS `Users_Pwd`,
`Users`.`PhoneNumber` AS `Users_PhoneNumber`, `Users`.`FName` AS `Users_FName`,
`Users`.`MoneyBalance` AS `Users_MoneyBalance`, `Users`.`Email` AS
`Users_Email` \nFROM `Users` \nWHERE `Users`.`Uid` = %s ORDER BY `Users`.`Uid`
\n LIMIT 1' ['testuser']
Notice this sometimes works and sometime it doesn't.
This is under mod_python with SQLAlchemy 0.3.7 in case it matters.
Thanks!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
