Thank you, but I need to distinguish the errors in the except statement,
something like that:
try:
connection = connectionForURI('postgres://'+user+':'+password+'@
'+host+'/'+database?debug=True)
sqlhub.processConnection = connection
connection.query("SELECT 1")
except OperationalError, e:
if (user or password are incorrect):
show a message
elif (the server is not working):
to do another thing
...
How can I ask the OperationalError object 'e' to do that?
2013/9/12 Daniel Monteiro Basso <danielmba...@gmail.com>
> Add ?*debug*=True to the connection URL. Also, instead of adding strings,
> consider formatting one, such as:
> connection = connectionForURI('postgres://{user}:{password}@
> {host}/{database}?*debug*=True'.format(locals()))
>
> Cheers,
>
> Daniel
>
>
> On Thu, Sep 12, 2013 at 6:07 PM, Francisco Chiotta
> <franchio...@gmail.com>wrote:
>
>> Hello,
>> I have a question related with the connections. I am using the
>> following code for that:
>>
>> try:
>> connection = connectionForURI('postgres://'+user+':'+password+'@
>> '+host+'/'+database)
>> sqlhub.processConnection = connection
>> connection.query("SELECT 1")
>> except OperationalError:
>> print "error"
>>
>> but, I don't know if the error is because the user and password are wrong
>> or the sever is not working. How can I verify that? for example, maybe,
>> with a error code but I don't know how to get it.
>>
>> Cheers,
>>
>>
>>
>> ------------------------------------------------------------------------------
>> How ServiceNow helps IT people transform IT departments:
>> 1. Consolidate legacy IT systems to a single system of record for IT
>> 2. Standardize and globalize service processes across IT
>> 3. Implement zero-touch automation to replace manual, redundant tasks
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
>> _______________________________________________
>> sqlobject-discuss mailing list
>> sqlobject-discuss@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
>>
>
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
