Ministack: Free, open-source local AWS emulator - 60+ services, Terraform compatible, real databases. Free forever. MIT licensed.
Python awsaws-emulatoraws-localaws-sdkdevtoolsdockerdynamodbec2emulatorlambdalocalstacklocalstack-alternativeministackmock-awsopen-sourcepythons3sqsterraform
import logging
from ministack.services import rds_mysql_compat as compat
class FakeCursor:
def __init__(self, routines=()):
self.routines = routines
self.executed = []
self.closed = False
def execute(self, statement, params=None):
self.executed.append((statement, params))
def fetchall(self):
return [(name,) for name in self.routines]
def close(self):
self.closed = True
class FailingObjectCursor(FakeCursor):
def execute(self, statement, params=None):
super().execute(statement, params)
if statement == compat._CONFIG_TABLE_SQL:
raise RuntimeError("table failed")
class FakeConnection:
def __init__(self, routines=()):
self.cursor_value = FakeCursor(routines)
self.closed = False
def cursor(self):
return self.cursor_value
def close(self):
self.closed = True
def test_rds_compatibility_procedures_create_complete_family():
connection = FakeConnection()
assert compat.ensure_rds_compatibility_procedures(
lambda: connection,
"cluster-1",
"aurora-mysql",
"8.0",
) is True
statements = [statement for statement, _params in connection.cursor_value.executed]
assert statements[0] == "SET SESSION sql_log_bin = 0"
assert statements[1] == compat._CONFIG_TABLE_SQL
assert statements[2] == compat._CONFIG_DEFAULT_SQL
assert statements[3:5] == [
f"CREATE ROLE IF NOT EXISTS `{role}`@'%'"
for role in compat._PREDEFINED_ROLES
]
assert statements[5].startswith("SELECT ROUTINE_NAME")
assert statements[6:] == list(compat._PROCEDURES.values())
assert connection.cursor_value.closed is True
assert connection.closed is True
def test_rds_compatibility_procedures_are_idempotent():
connection = FakeConnection(compat._PROCEDURES)
assert compat.ensure_rds_compatibility_procedures(
lambda: connection,
"cluster-1",
"aurora-mysql",
"8.4",
) is True
statements = [statement for statement, _params in connection.cursor_value.executed]
assert statements[:3] == [
"SET SESSION sql_log_bin = 0",
compat._CONFIG_TABLE_SQL,
compat._CONFIG_DEFAULT_SQL,
]
assert statements[3:5] == [
f"CREATE ROLE IF NOT EXISTS `{role}`@'%'"
for role in compat._PREDEFINED_ROLES
]
assert len(statements) == 6
assert statements[5].startswith("SELECT ROUTINE_NAME")
def test_rds_compatibility_procedure_failure_warns_and_does_not_escape(caplog):
def fail_connection():
raise RuntimeError("database unavailable")
with caplog.at_level(logging.WARNING, logger="rds"):
assert compat.ensure_rds_compatibility_procedures(
fail_connection,
"cluster-1",
"aurora-mysql",
"8.0",
) is False
assert len(caplog.records) == 1
assert "failed to ensure Aurora compatibility objects" in caplog.text
def test_rds_compatibility_procedures_skip_roles_before_mysql_8():
connection = FakeConnection()
assert compat.ensure_rds_compatibility_procedures(
lambda: connection,
"cluster-1",
"aurora-mysql",
"5.7",
) is True
statements = [statement for statement, _params in connection.cursor_value.executed]
assert not any(statement.startswith("CREATE ROLE") for statement in statements)
assert statements[:3] == [
"SET SESSION sql_log_bin = 0",
compat._CONFIG_TABLE_SQL,
compat._CONFIG_DEFAULT_SQL,
]
assert statements[3].startswith("SELECT ROUTINE_NAME")
assert statements[4:] == list(compat._PROCEDURES.values())
def test_rds_compatibility_procedures_skip_roles_for_standalone_mysql_8():
connection = FakeConnection()
assert compat.ensure_rds_compatibility_procedures(
lambda: connection,
"instance-1",
"mysql",
"8.4",
) is True
statements = [statement for statement, _params in connection.cursor_value.executed]
assert not any(statement.startswith("CREATE ROLE") for statement in statements)
assert statements[:3] == [
"SET SESSION sql_log_bin = 0",
compat._CONFIG_TABLE_SQL,
compat._CONFIG_DEFAULT_SQL,
]
assert statements[3].startswith("SELECT ROUTINE_NAME")
assert statements[4:] == list(compat._PROCEDURES.values())
def test_rds_compatibility_object_failure_does_not_abort_later_objects(caplog):
connection = FakeConnection()
connection.cursor_value = FailingObjectCursor()
with caplog.at_level(logging.WARNING, logger="rds"):
assert compat.ensure_rds_compatibility_procedures(
lambda: connection,
"cluster-1",
"aurora-mysql",
"8.0",
) is False
statements = [statement for statement, _params in connection.cursor_value.executed]
assert compat._CONFIG_DEFAULT_SQL in statements
assert statements[-4:] == list(compat._PROCEDURES.values())
assert "mysql.ministack_rds_configuration table" in caplog.text