Ok Massimo. Ty

*from gluon.sql import DAL, Field*
*db = DAL('mysql:mydatabase')*

Done. But it seems to be empty, no tables remaining :(
Even if I select the auth_user table: "*KeyError: 'auth_user*'"
Should i get other information from gluon?

I thinked using 3 threads was the best way obtaining the hardware 
information, but I am getting a lot of troubles... Do you recomend me 
another way to deal with it?

El lunes, 7 de mayo de 2012 15:22:25 UTC+2, Massimo Di Pierro escribió:
>
> You cannot have multiple threads share the same db. That conflicts with 
> web2py thread pooling mechanism. Even if it did not, we do not know the db 
> driver it thread safe. Each thread must have it's own db=DAL() connection.
>
> On Monday, 7 May 2012 05:21:17 UTC-5, Samuel Mac wrote:
>>
>> First of all, I've been searching other google group theads and they help 
>> me doing all I wanted but now I'm stuck. 
>> I was looking for getting some hardware information from a computer using 
>> 3 threads. This threads save the info in the Database. To do that i follow 
>> the instructions founded in this two forum threads:
>>  - 
>> https://groups.google.com/forum/?fromgroups#!searchin/web2py/db$20module/web2py/HbZh7Bbk5RI/sWn0rZaQDRgJ
>>  -  http://osdir.com/ml/web2py/2012-02/msg01692.html 
>>
>> I tryed to pass the DB connection to the class using the __init__ and the 
>> other way, using the current.db method, but I'm getting the same error: 
>>     raise errorclass, errorvalue
>>     InterfaceError: (0, '')
>>
>> Despite my query is very simple: row = db(db.device).select()
>>
>> Are threads unable to use DB connection?
>>
>

Reply via email to