nornir_csv
Use CSV files as a Nornir Inventory source with hosts, groups and defaults. This can be used as an equivalent to the Simple Inventory plugin but using CSV files instead of YAML. This does not generate any new files, but instead reads host data from three files:
- hosts.csv
- groups.csv
- defaults.csv
Installation
As of right now, the code hasn't been published to PyPi, so it must be installed from source. Be sure to clone the repository locally:
cd /directory/where/you/clone/git/stuff/
git clone https://github.com/matman26/nornir_csv.git
The nornir_csv directory can then be copied to your project root and added as an external library.
cp nornir_csv/nornir_csv /destination/project/root
Usage
Since this is an external plugin for Nornir 3.0+, it must be registered before usage. The main project file must therefore contain something similar to:
from nornir import InitNornir
from nornir_csv.plugins.inventory.csv_inventory import CsvInventory
from nornir.core.plugins.inventory import InventoryPluginRegister
InventoryPluginRegister.register("CsvInventoryPlugin", CsvInventory)
nr = InitNornir(config_file='sample_config.yaml')
By default, the plugin will look for the files hosts.csv, groups.csv and defaults.csv inside the ./inventory/ directory, but the directory can be changed by specifying the plugin option inventory_dir_path. A sample file such as below can be used:
inventory:
plugin: CsvInventoryPlugin
options:
inventory_dir_path: /path/to/inventory/dir/
runner:
plugin: threaded
options:
num_workers: 20
The name of the csv files to be read for hosts, groups and defaults can also be customized by setting the options hosts_file, groups_file and defaults_file, respectively. These should correspond to the file's basenames (no paths) with extension, if any.
CSV Syntax
Hosts
The hosts_file follows a specific syntax to make it nornir-compatible, see sample below:
name,hostname,username,password,port,platform,groups,custom_var
R1,192.168.122.10,cisco,cisco,22,cisco_ios,core main,foo
R2,192.168.122.20,cisco,cisco,22,cisco_xr,,bar
Note that name, hostname, username, password, port, platform and groups are nornir base attributes. This means they are hosts attributes directly, such that
nr.inventory.hosts['R1'].password
will yield the return value of 'cisco' as expected. Any custom variables that are added will be put inside the 'data' dictionary on the target host. So
nr.inventory.hosts['R1'].data['custom_var']
will return 'foo'.
Notice also that to specify the list of groups to which a host belongs the list must be specified one group at a time, separated by spaces. In the csv above, R1 belongs to the groups 'core' and 'main'. A hosts file is mandatory.
Groups
The groups_file is optional. It can be used to set default values for the base attributes of each host (for example, if every host of the same group uses the same credentials). Any attributes that are non-base attributes will be added to the 'data' container inside the generated group, similar to how it behaves with hosts. If no groups are specified in the csv file, hosts can still be assigned to groups but these will hold no data.
name,username,password,dns_server
core,cisco,cisco,8.8.8.8
main,,,,
Notice that the groups csv does not have any mandatory fields other than name.
Defaults
The defaults_file specifies any default variables. This file is also free-form, but is only composed of two lines: a header with the name of the variable and a second line with its value. The defaults file is optional.
message_of_the_day,foo,port
hello world!,bar,22
6 Jun 26, 2022
52 Dec 29, 2022
8 Oct 6, 2022
9 Feb 20, 2022
4 Oct 21, 2022
4 Nov 13, 2022
10 Nov 25, 2022
2 Sep 11, 2022
17 Nov 12, 2022
![[Bug] Default value handling for Hosts](https://avatars.githubusercontent.com/u/44414944?v=4)
2 Jan 02, 2022
26 May 28, 2022
17 Jan 13, 2022
2 Nov 10, 2021
54 Dec 18, 2022
6 Apr 11, 2022
6 Dec 18, 2021
1 Jan 24, 2022
69 Jan 01, 2023
2 May 24, 2022
3 Mar 07, 2022
63 Dec 24, 2022
148 Dec 09, 2022
4 Aug 30, 2022
21 Dec 30, 2022
20 Dec 29, 2021
3 Aug 11, 2021
4 Sep 29, 2022
229 Jan 07, 2023
2 Feb 14, 2022