# scf-serverlessdb-sdk-nodejs

**Repository Path**: mirrors_tencentyun/scf-serverlessdb-sdk-nodejs

## Basic Information

- **Project Name**: scf-serverlessdb-sdk-nodejs
- **Description**: serverlessdb sdk
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-18
- **Last Updated**: 2025-08-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 云函数serverless DB node SDK

## 概述
用于简化用户使用云函数时候连接DB和管理链接池的操作，利用云函数的的特性，提供便捷高效又接近mysql库的操作封装接口

## 用法
``` javascript
/*
环境变量(示例)：
process.env['DB_TESTDB2_HOST'] = 192.168.1.1
process.env['DB_TESTDB2_PORT'] = 3306
process.env['DB_TESTDB2_USER'] = ycp424c
process.env['DB_TESTDB2_PASSWORD'] = pwd123321123
process.env['DB_TESTDB2_DATABASE'] = db_name
*/

const database = require('scf-nodejs-serverlessdb-sdk').database

exports.main_handler = async (event, context) => {
  //use connection
  const connection = await database('TESTDB2').connection()
  const result = await connection.queryAsync('select * from coffee')
  connection.release() //must release before return
  console.log('db2 query result:',result)

  //use pool
  //如果使用pool会使用连接池，函数跟DB会维持一个长连接，在Node10+的runtime中需要关掉等待异步的机制
  context.callbackWaitsForEmptyEventLoop = false
  const pool = await database('TESTDB2').pool()
  const result2 = await pool.queryAsync('select * from coffee')
  // no need to release pool

  console.log('db2 query result:',result2)
}
```