#!flask/bin/python
from app import db, models
from app import tools
q = tools.DBQuery()
u = models.User.query.get(4)
p = models.Portfolio.query.get(1)
print (q.get_users(p))
print (q.has_access(u,p))
print (q.can_read(u,p))
print (q.can_write(u,p))
a = models.AccessRight.query.join(models.AccessRight.album).all()
#print(a)
acls = models.AccessRight.query.filter_by(user = u)
for acl in acls:
    print(acl)
    a = models.AccessRight.query.join(models.AccessRight.album).filter(acl == acl.id)
    print(a)