サーバー:Nodejs 16.0 + サーバーレスフレームワーク + serverless-layersプラグイン + sequelize
##アクセス構成
AWS Api -> Lambda(sequelize) -> DBアクセス
DBの構築 Test用テーブル追加
CREATE TABLE IF NOT EXISTS `member` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
`first_name` VARCHAR(255) NOT NULL,
`last_name` VARCHAR(255) NOT NULL,
`age` INTEGER,
`createdAt` DATETIME ,
`updatedAt` DATETIME ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
insert into member(first_name,last_name,age) value("fname1","lname2",33);
AWS 設定
AWS-cliをインストール（aws --versionでインストールしたaws-cliのバージョン情報を確認できる。)
C:\Users\ユーザー名.aws\credentials を開き、以下の項目を追加
[default]
aws_access_key_id=自分のキーを設定
aws_secret_access_key=自分のキーを設定
role_arn=自分のロールARN
source_profile=default
sls deployを実行できるように設定
cmdでコマンドプロンプトを開き
set AWS_PROFILE=default
開発用Nodejsのパッケージインストール(インストール済みパス)
Nodejsをインストール
サーバーレスフレームワークでの開発
npm install -g serverless
sls create -t aws-nodejs -p server-app(プロジェクト名)
cd server-app
serverless-layersプラグインを追加
npm init
npm install --save serverless
npx sls plugin install --name serverless-layers
必要なパッケージインストール 今回主にsequelizeを利用する(利点:Data Injectionを防げる, 楽観的排他が容易に)
npm install --save sequelize-cli -g(一回限りのInstall)
npm install --save sequelize
npm install --save mysql2
sequelize設定
今回例：メーカー側の受注一覧
コマンドライン上で以下のコマンドを(Windows:コマンドプロンプト)
sequelize init
sequelize model:generate --name member --attributes id:integer,first_name:text,last_name:text,age:integer
/models/member.jsを開き、以下のように修正
idの修正
freezeTableName:trueを追加(追加箇所は下記引用を参照)
修正後
--member.js
'use strict';
const {
Model
} = require('sequelize');
module.exports = (sequelize, DataTypes) => {
class member extends Model {
/**
* Helper method for defining associations.
* This method is not a part of Sequelize lifecycle.
* The `models/index` file will call this method automatically.
*/
static associate(models) {
// define association here
}
}
member.init({
id: {type:DataTypes.INTEGER,primaryKey: true,autoIncrement: true},
first_name: DataTypes.TEXT,
last_name: DataTypes.TEXT,
age: DataTypes.INTEGER
}, {
sequelize,
modelName: 'member',
freezeTableName:true
});
return member;
};
/config/config.jsonを開き、自分の環境を設定
"development": {
"username": "自分のユーザー名",
"password": "自分のパスワード",
"database": "自分のDB",
"host": "自分のホスト",
"dialect": "mysql",
"connectTimeout ": 30000
handler.js を下記のように書き変え
'use strict';
const { resolve } = require("path");
let member_json = "";
let db = require('./models/');
const show_member_list = () =>{
return new Promise((resolve)=> {
db.member.findAll().then(member=>{
member_json = member;
resolve(console.log("showed table t_order_management"));
});
});
}
module.exports.hello = async (event) => {
try{
await show_member_list();
}catch(e){
console.log("message sending error e=",e);
}
return {
statusCode: 200,
body: JSON.stringify(member_json)
}
// Use this code if you don't use the http event with the LAMBDA-PROXY integration
// return { message: 'Go Serverless v1.0! Your function executed successfully!', event };
};
serverless.yml以下のように設定する
# Welcome to Serverless!
#
# This file is the main config file for your service.
# It's very minimal at this point and uses default values.
# You can always add more config options for more control.
# We've included some commented out config examples here.
# Just uncomment any of them to get that config option.
#
# For full config options, check the docs:
# docs.serverless.com
#
# Happy Coding!
service: test
# app and org for use with dashboard.serverless.com
#app: your-app-name
#org: your-org-name
# You can pin your service to only deploy with a specific Serverless version
# Check out our docs for more details
frameworkVersion: '3'
provider:
name: aws
runtime: nodejs16.x
# you can overwrite defaults here
stage: dev
# region: us-east-1
region: ap-northeast-1
role: 自分のロール
vpc:
securityGroupIds:
- 自分がセキュリティグループID
subnetIds:
-自分のsubnetID
-自分のsubnetID
# you can add statements to the Lambda function's IAM Role here
# iam:
# role:
# statements:
# - Effect: "Allow"
# Action:
# - "s3:ListBucket"
# Resource: { "Fn::Join" : ["", ["arn:aws:s3:::", { "Ref" : "ServerlessDeploymentBucket" } ] ] }
# - Effect: "Allow"
# Action:
# - "s3:PutObject"
# Resource:
# Fn::Join:
# - ""
# - - "arn:aws:s3:::"
# - "Ref" : "ServerlessDeploymentBucket"
# - "/*"
# you can define service wide environment variables here
# environment:
# variable1: value1
# you can add packaging information here
#package:
# patterns:
# - '!exclude-me.js'
# - '!exclude-me-dir/**'
# - include-me.js
# - include-me-dir/**
functions:
member_list:
handler: handler.hello
# The following are a few example events you can configure
# NOTE: Please make sure to change your handler code to work with those events
# Check the event documentation for details
events:
- httpApi:
path: /get_member
method: get
custom:
serverless-layers:
layersDeploymentBucket: AWS上の自分のバケット
# - websocket: $connect
# - s3: ${env:BUCKET}
# - schedule: rate(10 minutes)
# - sns: greeter-topic
# - stream: arn:aws:dynamodb:region:XXXXXX:table/foo/stream/1970-01-01T00:00:00.000
# - alexaSkill: amzn1.ask.skill.xx-xx-xx-xx
# - alexaSmartHome: amzn1.ask.skill.xx-xx-xx-xx
# - iot:
# sql: "SELECT * FROM 'some_topic'"
# - cloudwatchEvent:
# event:
# source:
# - "aws.ec2"
# detail-type:
# - "EC2 Instance State-change Notification"
# detail:
# state:
# - pending
# - cloudwatchLog: '/aws/lambda/hello'
# - cognitoUserPool:
# pool: MyUserPool
# trigger: PreSignUp
# - alb:
# listenerArn: arn:aws:elasticloadbalancing:us-east-1:XXXXXX:listener/app/my-load-balancer/50dc6c495c0c9188/
# priority: 1
# conditions:
# host: example.com
# path: /hello
# Define function environment variables here
# environment:
# variable2: value2
# you can add CloudFormation resource templates here
#resources:
# Resources:
# NewResource:
# Type: AWS::S3::Bucket
# Properties:
# BucketName: my-new-bucket
# Outputs:
# NewOutput:
# Description: "Description for the output"
# Value: "Some output value"
plugins:
- serverless-layers
deploy 一回目 layerまで作られる
sls deploy
deploy 二回目以降 sls deploy function -f lambdaファンクション名
sls deploy function -f member_list
結果のリンクをChromeでアクセスすれば、memberテーブルの一覧が表示される。