如何按顺序执行谷歌可视化查询

Question

我必须按顺序执行几个查询，并比较第一个和第二个查询数据并相应地绘制表格。我真的不知道找出问题所在。我知道，查询执行是异步的。请帮忙。

//First Query
        function drawVisualization() {
            alert(" I am first");
            var sqlLastQuarterWeeks = "sql?tq=select MonthName, WeekStart, WeekEnd &sqlQueryID=last_quarter_weeks";
            var qryLastQuarterWeeks = new google.visualization.Query(sqlLastQuarterWeeks);
            qryLastQuarterWeeks.send(handleLastQuarterWeeksSqlQueryResponse);
        }
        function handleLastQuarterWeeksSqlQueryResponse(dataQueryLastQuarterWeeksResponse) {
            if (dataQueryLastQuarterWeeksResponse.isError()) {
                alert('Error in query: ' + dataQueryLastQuarterWeeksResponse.getMessage() + ' ' + dataQueryLastQuarterWeeksResponse.getDetailedMessage());
                return;
            }
            gblWeeksInformation = dataQueryLastQuarterWeeksResponse.getDataTable();
            drawLastQuarterWeeksAnalysis();
            //Second Query
            function drawLastQuarterWeeksAnalysis() {
                alert("I am second");
                var sqlLastQuarterWeeksAnalysis = "sql?tq=select Project, Passed, Failed, WeekStart, WeekEnd, WeekNumber &sqlQueryID=last_quarter_weeks_analysis";
                var qryLastQuarterWeeksAnalysis = new google.visualization.Query(sqlLastQuarterWeeksAnalysis);
                qryLastQuarterWeeksAnalysis.send(handleLastQuarterWeeksAnalysisSqlQueryResponse);
            }
            function handleLastQuarterWeeksAnalysisSqlQueryResponse(dataQueryLastQuarterWeeksAnalysisResponse) {
                if (dataQueryLastQuarterWeeksAnalysisResponse.isError()) {
                    alert('Error in query: ' + dataQueryLastQuarterWeeksAnalysisResponse.getMessage() + ' ' + dataQueryLastQuarterWeeksAnalysisResponse.getDetailedMessage());
                    return;
                }
                var dtLastQuarterWeeksAnalysis = dataQueryLastQuarterWeeksAnalysisResponse.getDataTable();
                alert(dtLastQuarterWeeksAnalysis.getNumberOfRows());
                var intNumberOfRows = dtLastQuarterWeeksAnalysis.getNumberOfRows();
                var intRowCounter;
                var tblWeekOverAnalysis = new google.visualization.DataTable();
                for (intRowCounter = 0; intRowCounter < WEEKLY_TESTS_TABLE_COLUMNS.length; intRowCounter++) {
                    if (WEEKLY_TESTS_TABLE_COLUMNS[intRowCounter] !== null) {
                        var colDataType = WEEKLY_TESTS_TABLE_COLUMNS[intRowCounter].split(':')[0];
                        var colDataValue = WEEKLY_TESTS_TABLE_COLUMNS[intRowCounter].split(':')[1];
                        tblWeekOverAnalysis.addColumn(colDataType, colDataValue);
                    }
                }
                var tblWeekOverAnalysisRow = new Array();
                for (intRowCounter = 0; intRowCounter < dtLastQuarterWeeksAnalysis.getNumberOfRows() ; intRowCount++) {
                    var strApplicationName = dtLastQuarterWeeksAnalysis.getValue(intRowCounter, 0);
                    tblWeekOverAnalysisRow[intRowCounter] = strApplicationName;
                    var strTestRunDates = dtLastQuarterWeeksAnalysis.getValue(intRowCounter, 3);
                    var arrTestRunDates = removeDuplicates(strTestRunDates);
                    var arrTestRunResults = getSortedTestRuns(strTestRunDates);
                    for (var intRowIterator = 0; intRowIterator < arrTestRunResults.length; intRowIterator++) {
                        var strTestRunDate = getTestRunOfDate(arrTestRunResults[intRowIterator], gblWeeksInformation);
                        tblWeekOverAnalysisRow[intRowCounter] = arrTestRunResults[intRowIterator];
                    }
                }
            }
        }

当我查询行数时，我得到的两次执行都得到了相同的答案。我在这里错过了什么？

根据我之前的问题尝试的解决方案：没有运气。

<script type="text/javascript">
        google.setOnLoadCallback(drawVisualization);
        function drawVisualization() {
            var sqlQuery = "sql?tq=select MonthName, WeekStart, WeekEnd &sqlQueryID=last_quarter_weeks";
            var query1 = new google.visualization.Query(sqlQuery);
            query1.send(function (queryResponse) {
                drawQuestions(queryResponse);
            });
            var sqlQuery2 = "sql?tq=select Project, Passed, Failed, WeekStart, WeekEnd, WeekNumber &sqlQueryID=last_quarter_weeks_analysis";
            var query2 = new google.visualization.Query(sqlQuery2);
            query2.send(function (queryResponse) {
                drawQuestions(queryResponse);
            });
        }
        function drawQuestions(response) {
            alert(response.getDataTable().getNumberOfRows());
            //answer is 11 & 11. expected is 11 & 180
        }
    </script> 

谢谢

Answer 1

我很抱歉。我整理了一下。

var sqlQuery2 = "sql?tq=select Project, Passed, Failed, WeekStart, WeekEnd, WeekNumber &sqlQueryID=last_quarter_weeks_analysis";

我被赋予了错误的列名，导致查询错误。此行为不允许执行第二个查询并始终返回第一个查询。