Table: host,group,childgroups,hostgroups
How I insert my host list data into the tables?

In yaml inventroy, we can define a absolute host

mail.example.com

[webservers]
foo.example.com
bar.example.com

[dbservers]
one.example.com
two.example.com
three.example.com

like mail.example.com above.

but in Dynamic Inventory, the host must be in a group?

Do you have any advice, how to initially import data from yml files to mysql tables?

Hello,

The key word VIEW is missing to create the view named children.

Regards

Hi,

Can somebody help me with any example of host.variables filling? I use this excellent script to pull all my switches from MySQL and it works perfect with Python 3 but I have several switches that use different username/password and I can't understand how to fill variables to use other name/password combination for these specific switches.
Please, help.

Roman

Issue Description

Hi,

I got a exception on line:189 when 'vars' not in self.inventory[groupname].

Fixes a bug where a group might not have variables(8b71929)

Maybe self.inventory[group] should be dict, not list.
Is that right? @terwey @tanji

Environment

1. Python 2.7.5

Steps to reproduce

1. git clone https://github.com/productsupcom/ansible-dyninv-mysql.git
2. Prepare the table schema: tables.sql
3. Insert data to MySQL:

insert into `host` (id,host,hostname,variables,enabled) values (1,'10.128.0.1','node1','',1);
insert into `group` (id,name,variables,enabled) values (1,'group_A','',1);
insert into `hostgroups` (host_id,group_id) values (1,1);

4. Execute command:

python mysql.py --list

5. Expected result:

$ python mysql.py --list
Traceback (most recent call last):
  File "mysql.py", line 254, in <module>
    MySQLInventory()
  File "mysql.py", line 57, in __init__
    self.update_cache()
  File "mysql.py", line 189, in update_cache
    if not self.inventory[group]['hosts']:
TypeError: list indices must be integers, not str