Esempio n. 1
0
    def test_insert_row(self):
        """Testing method / function insert_row."""
        # Add an entry to the database
        name = data.hashstring(str(random()))
        agent_group.insert_row(name)

        # Make sure it exists
        idx_agent_group = agent_group.exists(name)

        # Verify the index exists
        result = agent_group.idx_exists(idx_agent_group)
        self.assertTrue(result)
Esempio n. 2
0
def _process_agent(args):
    """Process agent cli arguments.

    Args:
        args: CLI arguments

    Returns:
        None

    """
    # Validate parameters
    if bool(agent_group.idx_exists(args.idx_agent_group)) is False:
        log_message = ('idx_agent_group "{}" not found.'.format(
            args.idx_agent_group))
        log.log2die(20068, log_message)
    if bool(agent.idx_exists(args.idx_agent)) is False:
        log_message = ('idx_agent "{}" not found.'.format(args.idx_agent))
        log.log2die(20060, log_message)

    # Assign
    agent.assign(args.idx_agent, args.idx_agent_group)
Esempio n. 3
0
def _process_agent_group(args):
    """Process agent_group cli arguments.

    Args:
        args: CLI arguments

    Returns:
        None

    """
    # Validate parameters
    if bool(pair_xlate_group.idx_exists(args.idx_pair_xlate_group)) is False:
        log_message = ('''\
idx_pair_xlate_group "{}" not found.'''.format(args.idx_pair_xlate_group))
        log.log2die(20058, log_message)
    if bool(agent_group.idx_exists(args.idx_agent_group)) is False:
        log_message = ('idx_agent_group "{}" not found.'.format(
            args.idx_agent_group))
        log.log2die(20067, log_message)

    # Assign
    agent_group.assign(args.idx_agent_group, args.idx_pair_xlate_group)
Esempio n. 4
0
def _process_agent_group(args):
    """Process agent_group cli arguments.

    Args:
        args: CLI argparse parser arguments

    Returns:
        None

    """
    # Initialize key variables
    exists = agent_group.idx_exists(args.idx_agent_group)
    if bool(exists) is True:
        if args.idx_agent_group != 1:
            agent_group.update_name(
                args.idx_agent_group, args.name)
        else:
            log_message = 'Cannot change Agent group 1'
            log.log2die(20054, log_message)
    else:
        log_message = (
            'Agent group  "{}" not found.'.format(args.idx_agent_group))
        log.log2die(20038, log_message)
Esempio n. 5
0
def insertions():
    """Insert the necessary table ForeignKey values to satisfy defaults.

    Args:
        None

    Returns:
        None

    """
    # Initialize key variables
    default_name = 'Pattoo Default'
    idx_agent_groups = {}
    idx_pair_xlate_groups = {}
    language_dict = {}
    agent_xlate_data = [
        ('en', 'pattoo_agent_os_autonomousd',
         'Pattoo Standard OS Autonomous Agent'),
        ('en', 'pattoo_agent_os_spoked', 'Pattoo Standard OS Spoked Agent'),
        ('en', 'pattoo_agent_snmpd', 'Pattoo Standard SNMP Agent'),
        ('en', 'pattoo_agent_snmp_ifmibd', 'Pattoo Standard IfMIB SNMP Agent'),
        ('en', 'pattoo_agent_modbustcpd', 'Pattoo Standard Modbus TCP Agent'),
        ('en', 'pattoo_agent_opcuad', 'Pattoo Standard OPC UA Agent'),
        ('en', 'pattoo_agent_bacnetipd', 'Pattoo Standard BACnet IP Agent')
    ]
    pair_xlate_data = [
        ('OPC UA Agents', [('en', 'pattoo_agent_opcuad_opcua_server',
                            'OPC UA Server', '')]),
        ('IfMIB Agents',
         [('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.9',
           'Interface Broadcast Packets (HC inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.8',
           'Interface Multicast Packets (HC inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.6',
           'Interface Traffic (HC inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.7',
           'Interface Unicast Packets (inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.13',
           'Interface Broadcast Packets (HC outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.12',
           'Interface Multicast Packets (HC outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.10',
           'Interface Traffic (HC outbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.11',
           'Interface Unicast Packets (HC outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.3',
           'Interface Broadcast Packets (inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.13',
           'Interface Discard Errors (inbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.14',
           'Interface Errors (inbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.2',
           'Interface Multicast Packets (inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.10',
           'Interface Traffic (inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.11',
           'Interface Traffic (inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.5',
           'Interface Broadcast Packets (outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.19',
           'Interface Discard Errors (outbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.20',
           'Interface Errors (outbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.31.1.1.1.4',
           'Interface Multicast Packets (outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.16',
           'Interface Traffic (outbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmpd_.1.3.6.1.2.1.2.2.1.17',
           'Interface Unicast Packets (outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifalias', 'Interface Alias', ''),
          ('en', 'pattoo_agent_snmp_ifmibd_ifdescr', 'Interface Description',
           ''),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcinbroadcastpkts',
           'Interface Broadcast Packets (HC inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcinmulticastpkts',
           'Interface Multicast Packets (HC inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcinoctets',
           'Interface Traffic (HC inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcinucastpkts',
           'Interface Unicast Packets (HC inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcoutbroadcastpkts',
           'Interface Broadcast Packets (HC outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcoutmulticastpkts',
           'Interface Multicast Packets (HC outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcoutoctets',
           'Interface Traffic (HC outbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifhcoutucastpkts',
           'Interface Unicast Packets (HC outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifinbroadcastpkts',
           'Interface Broadcast Packets (inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifinmulticastpkts',
           'Interface Multicast Packets (inbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifinoctets',
           'Interface Traffic (inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifname', 'Interface Name', ''),
          ('en', 'pattoo_agent_snmp_ifmibd_ifoutbroadcastpkts',
           'Interface Broadcast Packets (outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifoutmulticastpkts',
           'Interface Multicast Packets (outbound)', 'Packets / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_ifoutoctets',
           'Interface Traffic (outbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_snmp_ifmibd_oid', 'SNMP OID', ''),
          ('en', 'pattoo_agent_snmpd_ifalias', 'Interface Alias', ''),
          ('en', 'pattoo_agent_snmpd_ifdescr', 'Interface Description', ''),
          ('en', 'pattoo_agent_snmpd_ifname', 'Interface Name', ''),
          ('en', 'pattoo_agent_snmpd_oid', 'SNMP OID', '')]),
        ('OS Agents',
         [('en', 'pattoo_agent_os_autonomousd_processor',
           'Processor Type', ''),
          ('en', 'pattoo_agent_os_autonomousd_release', 'OS Release', ''),
          ('en', 'pattoo_agent_os_autonomousd_type', 'OS Type', ''),
          ('en', 'pattoo_agent_os_autonomousd_version', 'OS Version', ''),
          ('en', 'pattoo_agent_os_autonomousd_cpus', 'OS CPU Count', ''),
          ('en', 'pattoo_agent_os_autonomousd_hostname', 'Hostname', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_device',
           'Disk Partition', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_fstype',
           'Filesystem Type', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_mountpoint',
           'Mount Point', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_opts',
           'Partition Options', ''),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_user',
           'User (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_nice',
           'Nice (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_system',
           'System (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_idle',
           'Idle (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_iowait',
           'IO Wait (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_irq',
           'IRQ (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_softirq',
           'Soft IRQ (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_steal',
           'Steal (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_guest',
           'Guest (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_percent_guest_nice',
           'Guest / Nice (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_user',
           'User (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_nice',
           'Nice (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_system',
           'System (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_idle',
           'Idle (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_iowait',
           'IO Wait (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_irq',
           'IRQ (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_softirq',
           'Soft IRQ (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_steal',
           'Steal (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_guest',
           'Guest (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_times_guest_nice',
           'Guest / Nice (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_stats_ctx_switches',
           'CPU (Context Switches)', 'Events / Second'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_stats_interrupts',
           'CPU (Context Switches)', 'Events / Second'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_stats_soft_interrupts',
           'CPU (Soft Interrupts)', 'Events / Second'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_stats_syscalls',
           'CPU (System Calls)', 'Events / Second'),
          ('en', 'pattoo_agent_os_autonomousd_memory_total', 'Memory (Total)',
           'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_available',
           'Memory (Available)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_percent',
           'Memory (Percent)', 'Percentage Utilization'),
          ('en', 'pattoo_agent_os_autonomousd_memory_used', 'Memory (Used)',
           'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_free', 'Memory (Free)',
           'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_active',
           'Memory (Active)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_inactive',
           'Memory (Inactive)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_buffers',
           'Memory (Buffers)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_cached',
           'Memory (Cached)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_shared',
           'Memory (Shared)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_memory_slab', 'Memory (Slab)',
           'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_swap_memory_total',
           'Swap Memory (Total)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_swap_memory_used',
           'Swap Memory (Used)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_swap_memory_free',
           'Swap Memory (Free)', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_swap_memory_percent',
           'Swap Memory (Percent)', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_swap_memory_sin',
           'Swap Memory (In)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_autonomousd_swap_memory_sout',
           'Swap Memory (Out)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_disk_usage_total',
           'Disk size', 'Bytes'),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_disk_usage_used',
           'Disk Utilization', 'Percent'),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition_disk_usage_free',
           'Disk Free', 'Bytes'),
          ('en',
           'pattoo_agent_os_autonomousd_disk_partition_disk_usage_percent',
           'Disk Percentage Utilization', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_read_count',
           'Disk I/O (Read Count)', 'Reads / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_partition',
           'Disk Partition', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_write_count',
           'Disk I/O (Write Count)', 'Writes / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_read_bytes',
           'Disk I/O (Bytes Read)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_write_bytes',
           'Disk I/O (Bytes Written)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_read_time',
           'Disk I/O (Read Time)', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_write_time',
           'Disk I/O (Write Time)', ''),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_read_merged_count',
           'Disk I/O (Read Merged Count)', 'Reads / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_write_merged_count',
           'Disk I/O (Write Merged Count)', 'Writes / Second'),
          ('en', 'pattoo_agent_os_autonomousd_disk_io_busy_time',
           'Disk I/O (Busy Time)', ''),
          ('en', 'pattoo_agent_os_autonomousd_network_io_bytes_sent',
           'Network I/O (Bandwidth Inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_interface',
           'Network Interface', ''),
          ('en', 'pattoo_agent_os_autonomousd_network_io_bytes_recv',
           'Network I/O (Bandwidth Outbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_packets_sent',
           'Network I/O (Packets Sent)', 'Packets / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_packets_recv',
           'Network I/O (Packets Received)', 'Packets / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_errin',
           'Network I/O (Errors Inbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_errout',
           'Network I/O (Errors Outbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_dropin',
           'Network I/O (Drops Inbound)', 'Drops / Second'),
          ('en', 'pattoo_agent_os_autonomousd_network_io_dropout',
           'Network I/O (Drops Outbound)', 'Drops / Second'),
          ('en', 'pattoo_agent_os_autonomousd_cpu_frequency', 'CPU Frequency',
           'Frequency'),
          ('en', 'pattoo_agent_os_spoked_processor', 'Processor Type', ''),
          ('en', 'pattoo_agent_os_spoked_release', 'OS Release', ''),
          ('en', 'pattoo_agent_os_spoked_type', 'OS Type', ''),
          ('en', 'pattoo_agent_os_spoked_version', 'OS Version', ''),
          ('en', 'pattoo_agent_os_spoked_cpus', 'OS CPU Count', ''),
          ('en', 'pattoo_agent_os_spoked_hostname', 'Hostname', ''),
          ('en', 'pattoo_agent_os_spoked_disk_partition_device',
           'Disk Partition', ''),
          ('en', 'pattoo_agent_os_spoked_disk_partition_fstype',
           'Filesystem Type', ''),
          ('en', 'pattoo_agent_os_spoked_disk_partition_mountpoint',
           'Mount Point', ''),
          ('en', 'pattoo_agent_os_spoked_disk_partition_opts',
           'Partition Options', ''),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_user',
           'User (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_nice',
           'Nice (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_system',
           'System (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_idle',
           'Idle (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_iowait',
           'IO Wait (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_irq',
           'IRQ (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_softirq',
           'Soft IRQ (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_steal',
           'Steal (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_guest',
           'Guest (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_percent_guest_nice',
           'Guest / Nice (Percent CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_user', 'User (CPU Usage)',
           'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_nice', 'Nice (CPU Usage)',
           'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_system',
           'System (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_idle', 'Idle (CPU Usage)',
           'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_iowait',
           'IO Wait (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_irq', 'IRQ (CPU Usage)',
           'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_softirq',
           'Soft IRQ (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_steal', 'Steal (CPU Usage)',
           'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_guest', 'Guest (CPU Usage)',
           'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_times_guest_nice',
           'Guest / Nice (CPU Usage)', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_cpu_stats_ctx_switches',
           'CPU (Context Switches)', 'Events / Second'),
          ('en', 'pattoo_agent_os_spoked_cpu_stats_interrupts',
           'CPU (Context Switches)', 'Events / Second'),
          ('en', 'pattoo_agent_os_spoked_cpu_stats_soft_interrupts',
           'CPU (Soft Interrupts)', 'Events / Second'),
          ('en', 'pattoo_agent_os_spoked_cpu_stats_syscalls',
           'CPU (System Calls)', 'Events / Second'),
          ('en', 'pattoo_agent_os_spoked_memory_total', 'Memory (Total)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_available',
           'Memory (Available)', 'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_percent', 'Memory (Percent)',
           ''),
          ('en', 'pattoo_agent_os_spoked_memory_used', 'Memory (Used)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_free', 'Memory (Free)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_active', 'Memory (Active)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_inactive', 'Memory (Inactive)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_buffers', 'Memory (Buffers)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_cached', 'Memory (Cached)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_shared', 'Memory (Shared)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_memory_slab', 'Memory (Slab)',
           'Bytes'),
          ('en', 'pattoo_agent_os_spoked_swap_memory_total',
           'Swap Memory (Total)', 'Bytes'),
          ('en', 'pattoo_agent_os_spoked_swap_memory_used',
           'Swap Memory (Used)', 'Bytes'),
          ('en', 'pattoo_agent_os_spoked_swap_memory_free',
           'Swap Memory (Free)', 'Bytes'),
          ('en', 'pattoo_agent_os_spoked_swap_memory_percent',
           'Swap Memory (Percent)', ''),
          ('en', 'pattoo_agent_os_spoked_swap_memory_sin', 'Swap Memory (In)',
           'Bytes / Second'),
          ('en', 'pattoo_agent_os_spoked_swap_memory_sout',
           'Swap Memory (Out)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_partition_disk_usage_total',
           'Disk size', 'Bytes'),
          ('en', 'pattoo_agent_os_spoked_disk_partition_disk_usage_used',
           'Disk Utilization', 'Percent'),
          ('en', 'pattoo_agent_os_spoked_disk_partition_disk_usage_free',
           'Disk Free', 'Bytes'),
          ('en', 'pattoo_agent_os_spoked_disk_partition_disk_usage_percent',
           'Disk Percentage Utilization', ''),
          ('en', 'pattoo_agent_os_spoked_disk_io_read_count',
           'Disk I/O (Read Count)', 'Reads / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_partition', 'Disk Partition',
           ''),
          ('en', 'pattoo_agent_os_spoked_disk_io_write_count',
           'Disk I/O (Write Count)', 'Writes / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_io_read_bytes',
           'Disk I/O (Bytes Read)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_io_write_bytes',
           'Disk I/O (Bytes Written)', 'Bytes / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_io_read_time',
           'Disk I/O (Read Time)', ''),
          ('en', 'pattoo_agent_os_spoked_disk_io_write_time',
           'Disk I/O (Write Time)', ''),
          ('en', 'pattoo_agent_os_spoked_disk_io_read_merged_count',
           'Disk I/O (Read Merged Count)', 'Reads / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_io_write_merged_count',
           'Disk I/O (Write Merged Count)', 'Writes / Second'),
          ('en', 'pattoo_agent_os_spoked_disk_io_busy_time',
           'Disk I/O (Busy Time)', ''),
          ('en', 'pattoo_agent_os_spoked_network_io_bytes_sent',
           'Network I/O (Bandwidth Inbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_interface',
           'Network Interface', ''),
          ('en', 'pattoo_agent_os_spoked_network_io_bytes_recv',
           'Network I/O (Bandwidth Outbound)', 'Bits / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_packets_sent',
           'Network I/O (Packets Sent)', 'Packets / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_packets_recv',
           'Network I/O (Packets Received)', 'Packets / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_errin',
           'Network I/O (Errors Inbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_errout',
           'Network I/O (Errors Outbound)', 'Errors / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_dropin',
           'Network I/O (Drops Inbound)', 'Drops / Second'),
          ('en', 'pattoo_agent_os_spoked_network_io_dropout',
           'Network I/O (Drops Outbound)', 'Drops / Second'),
          ('en', 'pattoo_agent_os_spoked_cpu_frequency', 'CPU Frequency', '')])
    ]

    print('??: Attempting to insert default database table entries.')

    # Insert into Language
    if language.idx_exists(1) is False:
        language.insert_row('en', 'English')

    # Insert into PairXlateGroup
    if pair_xlate_group.idx_exists(1) is False:
        # Create the default PairXlateGroup
        pair_xlate_group.insert_row(default_name)

        # Create PairXlateGroup for some pattoo agents
        for name, rows in pair_xlate_data:
            # Get PairXlateGroup index value after creating an entry
            pair_xlate_group.insert_row(name)
            idx_pair_xlate_group = pair_xlate_group.exists(name)
            idx_pair_xlate_groups[name] = idx_pair_xlate_group

            # Insert values into the PairXlate table for PairXlateGroup
            for row in rows:
                if len(row) != 4:
                    log_message = (
                        'Translation line "{}" is invalid.'.format(row))
                    log.log2die_safe(20140, log_message)
                (code, _key, _value, _units) = row
                idx_language = language_dict.get(language)
                if bool(idx_language) is False:
                    idx_language = language.exists(code)
                    language_dict[code] = idx_language
                pair_xlate.insert_row(_key, _value, _units, idx_language,
                                      idx_pair_xlate_group)

    # Insert into AgentGroup
    if agent_group.idx_exists(1) is False:
        agent_group.insert_row(default_name)
        for name, _ in pair_xlate_data:
            agent_group.insert_row(name)
            index = agent_group.exists(name)
            idx_agent_groups[name] = index

    # Assign agent groups to pair_xlate_groups
    for name, idx_agent_group in idx_agent_groups.items():
        index = idx_pair_xlate_groups.get(name)
        if bool(index) is True:
            agent_group.assign(idx_agent_group, index)

    # Insert into AgentXlate
    if agent_xlate.agent_xlate_exists(1,
                                      'pattoo_agent_os_autonomousd') is False:
        for row in agent_xlate_data:
            _key = row[1]
            _value = row[2]
            agent_xlate.insert_row(_key, _value, 1)

    print('OK: Database table entries inserted.')