>>> print(request.dbsession.query(GlobalACL))
SELECT acl.role_id AS acl_role_id, acl.permission_id AS acl_permission_id, acl.resource_id AS acl_resource_id, acl.allow AS acl_allow, acl.weight AS acl_weight, acl.created AS acl_created, acl.content_id AS acl_content_id, role_1.id AS role_1_id, role_1.name AS role_1_name, role_1.created AS role_1_created, role_1.enabled AS role_1_enabled, role_1.locked AS role_1_locked, role_1.description AS role_1_description, role_1.virtual AS role_1_virtual, permission_1.id AS permission_1_id, permission_1.name AS permission_1_name, permission_1.created AS permission_1_created, permission_1.enabled AS permission_1_enabled, permission_1.description AS permission_1_description, permission_1.content_type_id AS permission_1_content_type_id, resource_1.id AS resource_1_id, resource_1.name AS resource_1_name
FROM acl JOIN role AS role_1 ON role_1.id = acl.role_id JOIN permission AS permission_1 ON permission_1.id = acl.permission_id JOIN resource AS resource_1 ON resource_1.id = acl.resource_id
WHERE acl.resource_id IN (%(resource_id_1)s)

>>> request.dbsession.query(GlobalACL).update({'weight': 2})
2019-05-15 13:12:59,970 INFO  [sqlalchemy.engine.base.Engine][MainThread] UPDATE acl SET weight=%(weight)s
2019-05-15 13:12:59,970 INFO  [sqlalchemy.engine.base.Engine][MainThread] {'weight': 2}
10