Hi all,
Today I get an error as title.
I use sqlalchemy + mysql.
Here is my code snippet:
def dbquery(_table,whereclause):
try:
#_table=Table(tablename, metadata, autoload=True)
#_table = tables[tablename]
i=_table.select().where(whereclause)
if direct_engine: #direct_engine is True
res = engine.execute(i)
return res
else:
session = scoped_session(sessionmaker(bind=engine))
res = session.execute(i)
return res
session.close()
except Exception,e:
#dba_logger.log(40,'Exception when dbwriter:%s' % str(e))
#dba_logger.log(20,'Exception detail:%s' % str(kwargs))
exctrace('db','1','Error happened when querying
db',dba_logger,'Exception when dbquery:%s' % str(e),'Exception detail:%s' %
str(whereclause))
#session.rollback()
if not direct_engine:
session.close()
Here is snippet in another file involving dbquery:
try:
res = dbquery(tables[*'sessions_details'*],whereclause=and_(tables[
*'sessions_details'*].c.app_key==*self*.app_key,tables[*'sessions_details'*
].c.device_token==*self*._devicetoken))
except Exception,e:
exctrace(*'db'*,*'1'*,*'Error happened when querying
db'*,dba_logger,*'Exception
when query session_details:%s'* % str(e),*'Exception detail:appkey is
%s,devicetoken is %s'* % (*self*.app_key,*self*._devicetoken))
*self*.read_message()
return
if res is None:
logger.log(40,*'When query connection,mysql has gone or something, just
skip db and go-on'*)
#here need to justify 0 or 1, later on
*self*.status=*'0'*
*self*.read_message()
return
if res.first() is None:
if json_obj[*'action'*] == *'reg'*:
So, the line in pink above raises the exception.
Could anyone give some suggestion how this happened?
Thanks.
Wesley
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
