Method GetOwnedApp

src/Features/Apps/AppsController.cs:486–500

(string appId)

    }

    private async Task<Application?> GetOwnedApp(string appId)
    {
        var user = this.GetCurrentUserIdentity();
        return await _db.Connection.QueryFirstOrDefaultAsync<Application>(
            @"SELECT a.id, a.name, a.icon_path, a.app_key, true as has_ownership, 
                     a.has_events, u.lock_reason
              FROM apps a
              INNER JOIN users u
              ON u.id = a.owner_id
              WHERE a.id = @appId
              AND a.owner_id = @userId
              AND a.deleted_at IS NULL",
            new { appId, userId = user.Id }
        );
    }
}