Function checkForUpdates

src/updateCheck.ts:28–120

(context?: sqlops.ObjectExplorerContext)

export let disposable_spblitzversion = vscode.commands.registerCommand('extension.sp_blitzversion', getblitzversion);

async function checkForUpdates(context?: sqlops.ObjectExplorerContext): Promise<string> {
    let baseUrl = "https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/releases/latest";
    let apitoken = 'token ' + apiconfig.token;
    
    try {
        var connectId;
        if (context) {
            let connection = context.connectionProfile;
            connectId = connection.id;
            let connectionMaybe = await sqlops.connection.getCurrentConnection();
            if (!connectionMaybe) {
                throw("Connect to server before checking First Responder Kit version.");
            }
        } else {
            let connection = await sqlops.connection.getCurrentConnection();
            if (!connection) {
                throw("Connect to server before checking First Responder Kit version.");
            }
            connectId = connection.connectionId;
        }
        vscode.window.showInformationMessage("Checking First Responder Kit for Updates");

        let query = `declare @versionno datetime
        DECLARE @VERSION VARCHAR(30)
        
        IF OBJECT_ID('dbo.sp_Blitz') IS NULL
        set @versionno = '1/1/1900'
        ELSE
        BEGIN
            BEGIN TRY
                exec sp_blitz @VERSIONCHECKMODE = 1, @VERSION = @VERSION OUTPUT, @versiondate = @versionno output;
            END TRY
            BEGIN CATCH
                exec sp_blitz @help = 1, @versiondate = @versionno output
            END CATCH
        END
        
        select convert(varchar(10),@versionno,112) as versionno`;

        let connectionUri = await sqlops.connection.getUriForConnection(connectId);
        let queryProvider = sqlops.dataprotocol.getProvider<sqlops.QueryProvider>(context.connectionProfile.providerName, sqlops.DataProviderType.QueryProvider);
        let results = await queryProvider.runQueryAndReturn(connectionUri, query);
        let cell = results.rows[0][0];
        let currentVersion = cell.displayValue;

        //get live most recent version from github
        var options = {
            uri: baseUrl,
            headers: {
                'Authorization': apitoken,
                'User-Agent': 'Request-Promise'
            },
            json: true,
            simple: false
        };
        var scriptText = await request.get(options);
        let recentVersion = scriptText.tag_name;