Zero To One Cloud

Here's a sample code to connect to your relational database, with your db-credentials stored in

import mysql.connector
import boto3
import json

client = boto3.client('secretsmanager')

response = client.get_secret_value(
SecretId='dev/myapp/secret'
)

secretDict = json.loads(response['SecretString'])

mydb = mysql.connector.connect(
host=secretDict['host'],
user=secretDict['username'],
password=secretDict['password'],
database=secretDict['dbname']
)

mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM Persons")
myresult = mycursor.fetchall()

for x in myresult:
print(x)

Prerequisite:
Use the AWS Management Console to create and store your database secret, in Secrets Manager. Also, Boto3 will work with minimum Python 3.7 (Refer: https://lnkd.in/dW9r7YTc)

Note:
Use the AWS managed KMS key for Secrets Manager (aws/secretsmanager) to encrypt your secret. There is no cost for using this default KMS key.

Wishing You and Your Family

Regards,
Team -

In order to increase the Quality of Software we go for multiple levels of Testing instead of conducting single stage of Testing.

Test Levels identify missing areas and prevent overlap and repetition.

There are four levels of software testing:

1) Unit Testing
2) Integration Testing
3) System Testing
4) Acceptance Testing

Amazon Elastic File System (Amazon EFS) provides a simple, serverless elastic file system for use with AWS cloud services and on-premises resources.

A full stack web developer is a person who can develop both client and server software. In addition to mastering and , he/she also knows how to program a browser (like using , , , or ), program a (like using , , , or ) and program a database (like using , , or )