1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/model/system_application.lua	Sun Jul 15 14:07:29 2018 +0200
     1.3 @@ -0,0 +1,28 @@
     1.4 +SystemApplication = mondelefant.new_class()
     1.5 +SystemApplication.table = 'system_application'
     1.6 +
     1.7 +
     1.8 +function SystemApplication:by_client_id(client_id)
     1.9 +  local system_application = self:new_selector()
    1.10 +    :add_where{ "client_id = ?", client_id }
    1.11 +    :optional_object_mode()
    1.12 +    :exec()
    1.13 +  return system_application
    1.14 +end
    1.15 +
    1.16 +function SystemApplication:by_origin(origin)
    1.17 +  local system_applications = self:new_selector()
    1.18 +    :set_distinct()
    1.19 +    :left_join("system_application_redirect_uri", nil, "system_application_redirect_uri.system_application_id = system_application.id")
    1.20 +    :add_where{ "lower(regexp_replace(system_application.default_redirect_uri, '^([^:]+://[^/]+)/.*', E'\\\\1', 'i')) = lower(?) OR lower(regexp_replace(system_application_redirect_uri.redirect_uri, '^([^:]+://[^/]+)/.*', E'\\\\1', 'i')) = lower(?)", origin, origin }
    1.21 +    :exec()
    1.22 +  return system_applications
    1.23 +end
    1.24 +
    1.25 +function SystemApplication:get_all()
    1.26 +  local system_application = self:new_selector()
    1.27 +    :exec()
    1.28 +  return system_application
    1.29 +end
    1.30 +
    1.31 +