Method GetAppById

src/Features/Apps/AppsController.cs:129–152

(string appId)

    }

    [HttpGet("/api/_apps/{appId}")]
    public async Task<IActionResult> GetAppById(string appId)
    {
        var user = this.GetCurrentUserIdentity();

        var app = await _db.Connection.QueryFirstOrDefaultAsync<Application>(
            @"SELECT a.id, a.name, a.icon_path, a.app_key, 
                     a.owner_id = @userId as has_ownership, a.has_events,
                     u.lock_reason
              FROM apps a
              LEFT JOIN app_shares s
              ON s.app_id = a.id
              INNER JOIN users u
              ON u.id = a.owner_id
              WHERE a.id = @appId
              AND (a.owner_id = @userId OR s.email = @userEmail)
              AND a.deleted_at IS NULL
              GROUP BY a.id, a.name, a.icon_path, a.app_key, u.lock_reason
              ORDER by a.name",
            new { appId, userId = user.Id, userEmail = user.Email }
        );

        return Ok(app);
    }

    [HttpPut("/api/_apps/{appId}")]
    public async Task<IActionResult> Update(string appId, [FromBody] UpdateAppRequestBody body, CancellationToken cancellationToken)