April 2018
Intermediate to advanced
280 pages
8h 37m
English
An application can have many database instances. The describe_db_instances() function will fetch all the database instances into a Python list. This list can then be iterated to determine the database instance information of all the available instances.
The following Python code demonstrates how this is done:
#!/usr/bin/env pythonimport boto3rds = boto3.client('rds')try: # Fetch the list of all database instances dbs = rds.describe_db_instances() for db in dbs['DBInstances']: print ("MasterUser : %s Endpoint : %s:%s Status:%s") % ( db['MasterUsername'], db['Endpoint']['Address'], db['Endpoint']['Port'], db['DBInstanceStatus'])except Exception as error: print error
Let's now see how we can connect to the database ...