I need to configure lambda function to access RDS db(mysql) using Ruby code. I found one blog which is doing same but it's in python. Can anyone help me how we can do it using Ruby code?
1
-
1Show your work plz sirjellycsc– jellycsc2021-04-15 14:31:32 +00:00Commented Apr 15, 2021 at 14:31
Add a comment
|
1 Answer
Assuming you've been doing your diligence work of creating a ruby project according to the lambda guidelines on Amazon (https://docs.aws.amazon.com/lambda/latest/dg/lambda-ruby.html) it's a matter of creating a Gemfile and in here add the gem mysql2.
An example of what you're looking for might be like this.
require 'json'
require 'mysql2'
$client = Mysql2::Client.new(
host: ENV["DB_HOST"],
username: ENV["DB_USER"],
password: ENV["DB_PASSWORD"],
database: ENV["DB_NAME"],
port: ENV["DB_PORT"]
)
def lambda_handler(event:, context:)
# Add your query here
results = $client.query("SELECT * FROM items;").to_a
{
statusCode: 200,
body: results.to_json
}
end
