async function test_queryBuilds()

in sonic-build/routes/kusto.js [18:46]


async function test_queryBuilds(){
    var url = "https://dev.azure.com/mssonic/build/_apis/build/definitions?api-version=6.0&includeAllProperties=true";
    var definitionsRes = await request('GET', url);
    var definitions = JSON.parse(definitionsRes);
    var results = {};
    //Sequence, DefinitionId, DefinitionName, Platform, SourceBranch
    var rows = [];
    for (var i=0; i<definitions.value.length; i++){
        var row = [];
        var definition = definitions.value[i];
        if (definition.path.startsWith("\\selftest") || definition.path.startsWith("\\fips")){
            continue;
        }

        var platform =definition.name.startsWith("Azure.sonic-buildimage.official.") ? definition.name.substring(32) : "";
        row.push(rows.length+1);
        row.push(definition.id);
        row.push(definition.name);
        row.push(platform);
        row.push(definition.repository.defaultBranch);
        rows.push(row);
    }
    rows.sort((a, b) => a[2].localeCompare(b[2]));
    for (var i=0; i<rows.length; i++){
        rows[i][0] = i+1;
    }
    results['_rows'] = rows;
    return results;
}