def getconn()

in reference-architectures/automated-password-rotation/terraform/code/main.py [0:0]


def getconn(instance_connection_name, user, password, db):
    """Function to establish connection with CloudSQl.
    Args:
         instance_connection_name(string) : instance connection name
         user (string)                    : postgressql user
         password(string)                 : user password
         db(string.                       : database
    Returns:
        conn : connection
    """
    with Connector(ip_type=IPTypes.PRIVATE) as connector:
        conn = connector.connect(
            instance_connection_name,
            "pg8000",
            user=user,
            password=password,
            db=db,
        )
        return conn