[sqlalchemy] ...kill_hung_threads status...

2010-09-30 Thread dobrysmak
Hi guys. I keep getting this message: [paste.httpserver.ThreadPool] kill_hung_threads status: 10 threads (1 working, 9 idle, 0 starting) ave time 0.03sec, max time 0.03sec, killed 0 workers Do I have to close a connection every time i'm querying the db? -- You received this message because

[sqlalchemy] Re: double data insert in many-to-many relations

2010-09-17 Thread Dobrysmak
Okay, i have got a stupid question. i have got something like this: result = Session.query(Messages).filter( Messages.from_user == 1).filter( User.id != 1).all() This query is supposed to get all the messages ( Messages table) that have the senders id

[sqlalchemy] another many-to-many question

2010-09-17 Thread dobrysmak
Hi. I'm quering many-to-many tables (ex. User, User_Car, Car), as a result i'm getting a data like this: result: + id + name + street + car - list of users Cars Is it possible, if yes then how, to filter this result to math this variables ex. user.id = 1 and car.id = 3? So i can get User object

[sqlalchemy] double data insert in many-to-many relations

2010-09-01 Thread Dobrysmak
Hi. I'm building a db with many-to-many relations, ex. * Table Users * Table Messages * Table Messages_Users when the users sends a message to other users i'm inserting that message to the db like so, *Messages - insert 1 row with the message, values ( title, text , date, etc... )

[sqlalchemy] Re: double data insert in many-to-many relations

2010-09-01 Thread Dobrysmak
, Sep 1, 2010 at 5:14 AM, Dobrysmak lukasz.szyman...@gmail.comwrote: [...] ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1 Mabey there's a better way to do this? Anyone have a clue? Hi :) you should have to many-to-many relationships and two

[sqlalchemy] Re: begginers query question

2010-08-25 Thread Dobrysmak
be placed inside the class? On 24 Sie, 16:20, werner wbru...@free.fr wrote:   On 24/08/2010 15:53, werner wrote:  Hi, On 24/08/2010 10:14, Dobrysmak wrote: Hi guys. I've got a little problem with the sqlalchemy syntax. I've got two tables with relations: Table_Goups id int(4

[sqlalchemy] begginers query question

2010-08-24 Thread Dobrysmak
Hi guys. I've got a little problem with the sqlalchemy syntax. I've got two tables with relations: Table_Goups id int(4) PrimaryKey not null, name varchar(50) not null; and Table_User id int(4) Primary Key not null, login varchar(50) not null, id_group int(4) Foreign Key not null; i would