Users.coffee 866 B

1234567891011121314151617181920212223242526272829303132
  1. class Users extends Class
  2. constructor: ->
  3. @user_address = {}
  4. getAddress: (usernames, cb) ->
  5. unknown_address = (username for username in usernames when not @user_address[username]?)
  6. if unknown_address.length == 0
  7. cb(@user_address)
  8. return
  9. query = """
  10. SELECT value, directory
  11. FROM keyvalue
  12. LEFT JOIN json USING (json_id)
  13. WHERE ?
  14. """
  15. Page.cmd "dbQuery", [query, {"key": "cert_user_id", "value": unknown_address}], (rows) =>
  16. for row in rows
  17. @user_address[row["value"]] = row["directory"]
  18. cb(@user_address)
  19. getAll: (cb) ->
  20. Page.cmd "dbQuery", ["SELECT value, directory FROM keyvalue LEFT JOIN json USING (json_id) WHERE key = 'cert_user_id'"], (rows) =>
  21. if rows.error then return false
  22. @user_address = {}
  23. for row in rows
  24. @user_address[row["value"]] = row["directory"]
  25. cb @user_address
  26. window.Users = Users