Python parse_mssql_databases Exemples

Exemple #1

Fichier : test_mssql_datafiles_transactionlogs.py Projet : gugas1nwork/checkmk

def test_discovery_mssql_transactionlogs(section):

    section_db = msdb.parse_mssql_databases([
        ['MSSQL46', 'master', 'ONLINE', 'SIMPLE', '0', '0'],
        ['MSSQL46', 'tempdb', 'ONLINE', 'SIMPLE', '0', '0'],
        ['MSSQL46', 'model', 'ONLINE', 'FULL', '0', '0'],
        ['MSSQL46', 'msdb', 'ONLINE', 'SIMPLE', '0', '0'],
        ['MSSQL46', 'NOC_CONFIG_T', 'ONLINE', 'FULL', '0', '0'],
        ['MSSQL46', 'DASH_CONFIG_T', 'ONLINE', 'FULL', '0', '0'],
        ['MSSQL46', 'NOC_ALARM_T', 'ONLINE', 'FULL', '0', '1'],
        ['MSSQL46', 'CorreLog_Report_T', 'ONLINE', 'FULL', '0', '0'],
        ['MSSQL46', 'test_autoclose', 'ONLINE', 'FULL', '1', '0'],
    ])

    assert sorted(
        msdt.discover_mssql_transactionlogs([Parameters({})], section,
                                            section_db),
        key=lambda s: s.item,  # type: ignore[attr-defined]
    ) == [
        Service(item='MSSQL46.CorreLog_Report_T.CorreLog_Report_T_log'),
        Service(item='MSSQL46.DASH_CONFIG_T.DASH_CONFIG_T_log'),
        Service(item='MSSQL46.NOC_ALARM_T.NOC_ALARM_T_log'),
        Service(item='MSSQL46.NOC_CONFIG_T.NOC_CONFIG_T_log'),
        Service(item='MSSQL46.model.modellog'),
        Service(item='MSSQL46.test_autoclose.test_autoclose_log'),
    ]

Exemple #2

Fichier : test_mssql_databases.py Projet : tboerger/checkmk

def _get_section():
    return parse_mssql_databases([
        ['MSSQL_MSSQL46', 'CorreLog_Report_T', 'ONLINE', 'FULL', '0', '0'],
        ['MSSQL_MSSQL46', 'master', 'ONLINE', 'SIMPLE', '0', '0'],
        ['MSSQL_MSSQL46', 'msdb', 'ONLINE', 'SIMPLE', '0', '0'],
        ['MSSQL_MSSQL46', 'NOC_ALARM_T', 'ONLINE', 'FULL', '0', '1'],
        ['MSSQL_MSSQL46', 'test_autoclose', 'ONLINE', 'FULL', '1', '0'],
        ['MSSQL_MSSQL46', 'test_autoclose', 'RECOVERY', 'PENDING', 'FULL', '1', '0'],
        ['MSSQL_Mouse', '-', 'ERROR: We are out of cheese!', '-', '-', '-'],
    ])

Exemple #3

Fichier : test_mssql_databases.py Projet : troelsarvin/checkmk

def _get_section():
    return parse_mssql_databases([
        ["MSSQL_MSSQL46", "CorreLog_Report_T", "ONLINE", "FULL", "0", "0"],
        ["MSSQL_MSSQL46", "master", "ONLINE", "SIMPLE", "0", "0"],
        ["MSSQL_MSSQL46", "msdb", "ONLINE", "SIMPLE", "0", "0"],
        ["MSSQL_MSSQL46", "NOC_ALARM_T", "ONLINE", "FULL", "0", "1"],
        ["MSSQL_MSSQL46", "test_autoclose", "ONLINE", "FULL", "1", "0"],
        [
            "MSSQL_MSSQL46", "test_autoclose", "RECOVERY", "PENDING", "FULL",
            "1", "0"
        ],
        ["MSSQL_Mouse", "-", "ERROR: We are out of cheese!", "-", "-", "-"],
    ])