+ ORDER BY name`)
+
+fun listOwnedBalances () =
+ C.map (getDb ()) mkBalanceRow ($`SELECT Balance.id, Balance.name, amount
+ FROM Balance JOIN WebUser
+ ON Balance.name = WebUser.name
+ AND WebUser.bal = Balance.id
+ JOIN Membership
+ ON Membership.grp = 1
+ AND Membership.usr = WebUser.id
+ ORDER BY Balance.name`)
+
+fun listUnownedBalances () =
+ C.map (getDb ()) mkBalanceRow ($`SELECT Balance.id, Balance.name, amount
+ FROM Balance LEFT OUTER JOIN WebUser
+ ON Balance.name = WebUser.name
+ AND WebUser.bal = Balance.id
+ LEFT OUTER JOIN Membership
+ ON Membership.grp = 1
+ AND Membership.usr = WebUser.id
+ WHERE WebUser.id IS NULL
+ OR Membership.grp IS NULL
+ ORDER BY Balance.name`)