Eclipse颜色不会改变(Eclipse color does not change)

 
 
 在D:\home\site\wwwroot下的Kudu远程执行控制台中运行npm install tedious命令。 
 
 
 在Azure函数中，所有的代码都应该放在module.exports函数中。 
 
 
 你应该使用context.log()而不是console.log() 。 
 
 
 您真的不必在函数的应用程序设置中设置连接设置字符串。 
 
 
 你应该通过调用context.done()来告诉运行时你的代码完成了。 
 
 
 以下代码适用于我： 
 
var Connection = require('tedious').Connection;
var Request = require('tedious').Request;

module.exports = function (context, req) {
    context.log('JavaScript HTTP trigger function processed a request.');

    var config = {
        userName: '<userName>',
        password: '<password>',
        server: '<AzureSQLDBName>.database.windows.net',

        // If you're on Windows Azure, you will need this:
    options:
        {
                database: 'your DB',
                  encrypt: true
        }
};

    var connection = new Connection(config);

    connection.on('connect', function(err) {

        if (err) {
            context.log(err);

            context.res = {
                status: 500,
                body: "Unable to establish a connection."
            };
            context.done();

        } else {
            executeStatement();
        }
    });

    function executeStatement() {

        request = new Request("select 42, 'hello world'", function(err, rowCount) {
            if (err) {
                context.log(err);

                context.res = {
                    status: 500,
                    body: "Failed to connect to execute statement."
                };
                context.done();

            } else {
                context.log(rowCount + ' rows');
            }
        });

        request.on('row', function(columns) {
            columns.forEach(function(column) {
                context.log(column.value);
            });

            context.done();
        });

        connection.execSql(request);
    }
};
 
 有关更多信息，请参阅Azure函数JavaScript开发人员指南 。 

 
 
Run the npm install tedious command in the Kudu remote execution console under D:\home\site\wwwroot.
 
 
In Azure Functions, all of your code should be put inside the module.exports function.
 
 
You should use context.log() instead of console.log().
 
 
You really don't have to set the connection settings string in Application settings of the function.
 
 
You should inform the runtime when your code has finished by calling context.done().
 
 
The following code works for me:
 
var Connection = require('tedious').Connection;
var Request = require('tedious').Request;

module.exports = function (context, req) {
    context.log('JavaScript HTTP trigger function processed a request.');

    var config = {
        userName: '<userName>',
        password: '<password>',
        server: '<AzureSQLDBName>.database.windows.net',

        // If you're on Windows Azure, you will need this:
    options:
        {
                database: 'your DB',
                  encrypt: true
        }
};

    var connection = new Connection(config);

    connection.on('connect', function(err) {

        if (err) {
            context.log(err);

            context.res = {
                status: 500,
                body: "Unable to establish a connection."
            };
            context.done();

        } else {
            executeStatement();
        }
    });

    function executeStatement() {

        request = new Request("select 42, 'hello world'", function(err, rowCount) {
            if (err) {
                context.log(err);

                context.res = {
                    status: 500,
                    body: "Failed to connect to execute statement."
                };
                context.done();

            } else {
                context.log(rowCount + ' rows');
            }
        });

        request.on('row', function(columns) {
            columns.forEach(function(column) {
                context.log(column.value);
            });

            context.done();
        });

        connection.execSql(request);
    }
};
 
For more information, see Azure Functions JavaScript developer guide.