How to use the RDSDataService function from aws-sdk

README.md?plain=1

GitHub: jeremydaly/data-api-client

82
83
84
85
86
87
88
89
90
91
## Why do I need this?
The [Data API](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html) requires you to specify data types when passing in parameters. The basic `INSERT` example above would look like this using the native `AWS.RDSDataService` class:

```javascript
const AWS = require('aws-sdk')
const data = new AWS.RDSDataService()

/*** Assuming we're in an async function ***/

// INSERT with named parameters

56

434

16

Lambda_TradeInventory.js

GitHub: aws-samples/building-frog-junction-technical-guide

0
1
2
3
4
5
6
7
8
9
// Copyright 2020 Amazon.com, Inc. or its affiliates. All Rights Reserved.

// Handles trading an inventory item from one player to another player
const AWS = require('aws-sdk');
const docClient = new AWS.DynamoDB.DocumentClient();
const rdsDataService = new AWS.RDSDataService();
const CONFIGURATION_DATA = {
    inventoryDB_ARN: "arn:aws:rds:us-east-1:012345678901:cluster:frogjunction-inventory",
    inventoryDBSecret_ARN: "arn:aws:secretsmanager:us-east-1:012345678901:secret:frogjunction-inventory-database-1-a0aAAA",
};

2

5

5

appSync-rds-walkthrough.js

GitHub: Iannes/amplify-cli

128
129
130
131
132
133
134
135
136
137
 * @param {*} clusterArn
 * @param {*} secretArn
 */
async function selectDatabase(inputs, clusterArn, secretArn) {
  // Database Name Question
  const DataApi = new AWS.RDSDataService();
  const params = new DataApiParams();
  params.awsSecretStoreArn = secretArn;
  params.dbClusterOrInstanceArn = clusterArn;
  params.sqlStatements = 'SHOW databases';

770

0

2

index.md?plain=1

GitHub: aws-samples/amazon-aurora-labs-for-mysql

108
109
110
111
112
113
114
115
116
117
==[SecretARN]== | The ARN of the secret used to store the database credentials. RDS Data API will access this secret and connect to the database using those credentials. | See the previous lab: [Create an Aurora Serverless DB Cluster](/serverless/create/) at step *2. Create a secret to store the credentials*.

```
// require the AWS SDK
const AWS = require('aws-sdk')
const rdsDataService = new AWS.RDSDataService()

exports.handler = (event, context, callback) => {
  // prepare SQL command
  let sqlParams = {

40

76

11

server.js

GitHub: cmanikandan/auroraserverless-dataapi-fargate

22
23
24
25
26
27
28
29
30
31
  AWS.config.update({
    region: 'us-east-1'
  });
}

var RDS = new AWS.RDSDataService();

var params = {
 awsSecretStoreArn: 'arn:aws:secretsmanager:us-east-1:xxxxxxx:secret:test/dataapi/mysql1-BuztkC',
 dbClusterOrInstanceArn: 'arn:aws:rds:us-east-1:xxxxxxx:cluster:test-aurora-mysql-dataapi',

0

3

3

connectToDatabase.js

GitHub: liaocanada/online-bookstore

1
2
3
4
5
6
7
8
9
10
AWS.config.update({region: 'us-east-1'});

const createClient = require('data-api-client');

// require('dotenv').config();
// const rdsDataService = new AWS.RDSDataService();

const getDatabaseName = async () => {
    const ssm = new AWS.SSM({region: 'us-east-1'});
    const dbParamKey = '/bookstore/db/name';

0

2

1

migration.ts

GitHub: milltechfx/rds-migrate

2
3
4
5
6
7
8
9
10
11
const AWS = require('aws-sdk');

const log = console;

export class Migration {
  private client: typeof AWS.RDSDataService;
  private readonly engine: string;
  private readonly sqlFolder: string;
  private rdsParams: {
    database: string;

2

0

1

addUser.router.js

GitHub: AceCFox/ez-onboard-2

0
1
2
3
4
5
6
7
8
9
const express = require("express");
const pool = require("../modules/pool");
const router = express.Router();
const {rejectUnauthenticated} = require("../modules/authentication-middleware");
const AWS =  require('aws-sdk');
const RDS = new AWS.RDSDataService({region: 'us-east-2'});

router.get("/:id", rejectUnauthenticated, (req, res) => {
    let params = {
      resourceArn: 'arn:aws:rds:us-east-2:635402171575:cluster:aurora-serverless-trial2',

0

0

1

contract.repository.js

GitHub: mauriciottc/startup-home-equity

-3

0

0

2

handler.js

GitHub: smallriver0316/event-collector

-2

0

0

1