Cannot modify User.companies about stalker HOT 3 CLOSED

Your query is not correct in:

for user in User.query.filter_by(name='Peter Griffin'):
    user.companies = companies

User.query.filter_by(name='Peter Griffin') returns a query object not an array of User instances, you should use User.query.filter_by(name='Peter Griffin').all().

And in fact it is a weird query, do you have more than one user named "Peter Griffin"? If not you should be using somthing like:

peter = User.query.filter_by(name='Peter Griffin').first()
peter.companies = companies

from stalker.

User.query.filter_by(name='Peter Griffin') returns a query object not an array of User instances, you should use User.query.filter_by(name='Peter Griffin').all().

Yes, that syntax was a bit weird, perhaps. But if you disregard that syntax (which still demonstrates the issue) I'm getting the same error when using your suggested syntax:

from stalker import db, User, Project, Role, Client, DepartmentUser, ClientUser, ProjectUser
db.setup()

companies = []
for client in Client.query.all():
    companies.append(client)
print companies # returns: [<Acme (Client)>, <Quahog (Client)>]

user = User.query.filter_by(name='Peter Griffin').first()
print type(user) # returns: <class 'stalker.models.auth.User'>
print user.name # returns: Peter Griffin
print user.companies # returns: [<Acme (Client)>]
user.companies = companies
print user.companies # returns: [<Acme (Client)>, <Quahog (Client)>]

db.DBSession.commit() # <--- Causes an error "AssertionError: Dependency rule tried to blank-out primary key column 'Client_Users.uid' on instance '<ClientUser at 0x564d320>'"

If you comment db.DBSession.commit() out, there is no error (but then the change is also not saved).
I've upgraded to cbfa106.

from stalker.

This issue should not be closed.

It is not possible to commit a modification to User.companies, as described in my previous comment.

from stalker.