eWeKPK3D

1#!/usr/bin/env python
2
3'''
4Create a SQLite database for storing dynamic host variable values.
5'''
6
7import sqlite3
8conn = sqlite3.connect('dynamic_vars.db')
9curs = conn.cursor()
10
11
12
13# Create host variables table
14
15curs.execute('''
16CREATE TABLE IF NOT EXISTS host_vars (
17    host_name text,
18    var_name text,
19    var_value text,
20    CONSTRAINT pk_host_vars PRIMARY KEY ( host_name, var_name )
21)''')
22
23conn.commit()
24
25
26
27conn.close()