如何连接到Moto MySQL实例？

Question

我使用模拟的BOTO3 RDS客户端创建了RDS DB实例。以下是我在conftest.py中设置它的方式

@pytest.fixture
def aws_credentials():
    """Mocked AWS Credentials for moto."""
    os.environ["AWS_ACCESS_KEY_ID"] = "testing"
    os.environ["AWS_SECRET_ACCESS_KEY"] = "testing"
    os.environ["AWS_SECURITY_TOKEN"] = "testing"
    os.environ["AWS_SESSION_TOKEN"] = "testing"

@pytest.fixture
def rds_client(aws_credentials, aws_region):
    with mock_rds():
        client = boto3.client("rds", region_name=aws_region)
        yield client

（ https://docs.aws.amazon.com/amazonrds/latest/latest/userguide/usingwithrds.iamdbauth.connecting.python.html ）我设置了我的mysql连接器

db_instance = rds_client.create_db_instance(DBInstanceIdentifier="TestDBInstanceIdentifier",
                                            DBInstanceClass="db.m4.large", Engine="mysql",
                                            MasterUsername="root", DBName="TestDBName")
print("RDS Instance-----------------------------------------------------")
print(db_instance)

host = db_instance['DBInstance']['Endpoint']['Address']
port = db_instance['DBInstance']['Endpoint']['Port']
user = db_instance['DBInstance']['MasterUsername']
dbname = db_instance['DBInstance']['DBName']
print("Starting connection")
token = rds_client.generate_db_auth_token(DBHostname=host, Port=port, DBUsername=user, Region=aws_region)

mydb = mysql.connector.connect(host=host, database=dbname, user=user, passwd=token, port=port)

：连接器找不到DB：

FAILED test_read_rds_db - mysql.connector.errors.DatabaseError: 2005 (HY000): Unknown MySQL server host 'TestDBInstanceIdentifier.aaaaaaaaaa.us-east-1.rds.amazonaws.com' (8)

有人以前能够设置它吗？

Answer 1

Moto不提供此功能。它嘲笑AWS API，但没有暴露任何RDBMS功能。

您可以改用LocalStack。它在后台使用Moto来模拟对AWS的呼叫，但除此之外提供了功能，例如连接到RDS实例的功能。
请参阅此处的文档： https://docs.localstack.cloud/aws/aws/rds/rds/rds/