Azure functions: Exception: TypeError: connection.query is not a function

Question

I have a simple Azure function trying to get all data from a SQL table. The connection is successful and I can connect to the database, but whenever I run the get request, I end up with an error

Exception: TypeError: connection.query is not a function
Stack: TypeError: connection.query is not a function

This is the line throwing the error

connection.query(query, (err, results, fields) => {

this is my index.js azure get function

const express = require('express')
const bodyParser = require('body-parser')
let connection = require('../configs/dbConfig')
const app = express()

app.use(bodyParser.json())
app.use(bodyParser.urlencoded({ extended: true }))

module.exports = async function (context, req, res) {
    const query = 'SELECT * FROM entrys'
    connection.query(query, (err, results, fields) => {
        if (err) {
            const response = { data: null, message: err.message, }
            res.send(response)
        }

        const pokemons = [...results]
        const response = {
            data: pokemons,
            message: 'All entrys successfully retrieved.',
        }
        res.send(response)
    })
}

Am using tedious as the connection driver. my dbconfig

let Connection = require('tedious').Connection;

let pool = {
    server: "localhost", // or "localhost"
    authentication: {
        type: "default",
        options: {
            userName: "sa",
            password: "root",
        }
    },
    options: {
        database: "testing",
        encrypt: false
    }
};

var connection = new Connection(pool);
connection.on('connect',function(err){
if(err){
console.log('Connection Failed');
throw err;
}
else{
console.log('Connected');
}
});
module.exports = connection

what am I doing wrong, thank you in advance

buymeacoffee · Accepted Answer · 2021-03-22 08:29:17Z

1

You should use `Request` to query.

In the official documentation, I did not see the usage of connection.query. It is not recommended that you use tedious when you are not very familiar with it. I have a sample code here, I hope it helps you.

You can download my Sample Code which use mssql package.

var express = require('express');
var router = express.Router();
let connection = require('../configs/dbConfig')
var Request = require('tedious').Request; 

/* GET users listing. */
router.get('/', function(req, res, next) {
  request = new Request("select 42, 'hello world'", function(err, rowCount) {
    if (err) {
      console.log(err);
    } else {
      console.log(rowCount + ' rows');
    }
  });

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

  connection.execSql(request);
  res.send('respond with a resource');
});

module.exports = router;

Test Result:

answered Mar 22, 2021 at 8:29

buymeacoffee

22.6k2 gold badges23 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

arriff Over a year ago

one small thing, how can do a put and create using your example

buymeacoffee Over a year ago

@arriff I don't understand what you mean, if you can, you can post a post clearly describing what you want.

arriff Over a year ago

Hi @Jason, how can I write other azure function to insert and update data in the database, CRUD, thank you in advance?

buymeacoffee Over a year ago

@arriff Sorry, it's a demo, I don't have the complete sqlhelper code.

buymeacoffee Over a year ago

@arriff github.com/erpragatisingh/node-api/blob/main/sample-CRUD-SQL/…

Collectives™ on Stack Overflow

Azure functions: Exception: TypeError: connection.query is not a function

1 Answer 1

You should use `Request` to query.

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

You should use Request to query.

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related

You should use `Request` to query.