Skip to content

Serverless function with tedious4 Express #10

@adblake

Description

@adblake

I can get this code working on a node.js express server ok.

For some reason, I can't get a response when I try to put it in a serverless Azure function...

const createHandler = require("azure-function-express").createHandler;
const express = require('express');
const bodyParser = require('body-parser');
const tediousExpress = require('express4-tedious');

const app = express();
app.use(function (req, res, next) {
    req.sql = tediousExpress({
        "server"  : process.env.sqlServer,
        "userName": process.env.sqlUserName,
        "password": process.env.sqlPassword,
        "options": { 
            "encrypt": true, 
            "database": process.env.sqlDatabase 
        }
    });
    next();
});

app.use(bodyParser.text()); 

app.use(function (req, res) {
    req.sql("select * from todo for json path")
        .into(res, '[]');
});

module.exports = createHandler(app);

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions