Class: Houcho::Database
- Inherits:
-
Object
- Object
- Houcho::Database
- Defined in:
- lib/houcho/database.rb
Instance Attribute Summary collapse
-
#handle ⇒ Object
readonly
Returns the value of attribute handle.
Instance Method Summary collapse
- #create_tables ⇒ Object
-
#initialize ⇒ Database
constructor
A new instance of Database.
Constructor Details
Instance Attribute Details
#handle ⇒ Object (readonly)
Returns the value of attribute handle.
6 7 8 |
# File 'lib/houcho/database.rb', line 6 def handle @handle end |
Instance Method Details
#create_tables ⇒ Object
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 |
# File 'lib/houcho/database.rb', line 13 def create_tables @handle.execute_batch <<-SQL CREATE TABLE IF NOT EXISTS role ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL UNIQUE ); CREATE TABLE IF NOT EXISTS host ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL UNIQUE ); CREATE TABLE IF NOT EXISTS role_host ( role_id INTEGER NOT NULL, host_id INTEGER NOT NULL, UNIQUE(role_id, host_id), FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT, FOREIGN KEY (host_id) REFERENCES host (id) ON DELETE RESTRICT ); CREATE TABLE IF NOT EXISTS serverspec ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL UNIQUE ); CREATE TABLE IF NOT EXISTS role_serverspec ( role_id INTEGER NOT NULL, serverspec_id INTEGER NOT NULL, UNIQUE(role_id, serverspec_id), FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT, FOREIGN KEY (serverspec_id) REFERENCES serverspec (id) ON DELETE RESTRICT ); CREATE TABLE IF NOT EXISTS script ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL UNIQUE ); CREATE TABLE IF NOT EXISTS role_script ( role_id INTEGER NOT NULL, script_id INTEGER NOT NULL, UNIQUE(role_id, script_id), FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT, FOREIGN KEY (script_id) REFERENCES script (id) ON DELETE RESTRICT ); CREATE TABLE IF NOT EXISTS outerrole ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL UNIQUE, data_source VARCHAR NOT NULL ); CREATE TABLE IF NOT EXISTS outerrole_host ( outerrole_id INTEGER NOT NULL, host_id INTEGER NOT NULL, UNIQUE(outerrole_id, host_id), FOREIGN KEY (outerrole_id) REFERENCES outerrole (id) ON DELETE RESTRICT, FOREIGN KEY (host_id) REFERENCES host (id) ON DELETE RESTRICT ); CREATE TABLE IF NOT EXISTS role_outerrole ( role_id INTEGER NOT NULL, outerrole_id INTEGER NOT NULL, UNIQUE(role_id, outerrole_id), FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT, FOREIGN KEY (outerrole_id) REFERENCES outerrole (id) ON DELETE RESTRICT ); CREATE TABLE IF NOT EXISTS attribute ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR NOT NULL UNIQUE ); CREATE TABLE IF NOT EXISTS attribute_value ( id INTEGER NOT NULL PRIMARY KEY, attr_id INTEGER NOT NULL, element_type INTEGER NOT NULL, element_id INTEGER NOT NULL, value VARCHAR NOT NULL, COMMENT "element_type => {0:role, 1:outerrole, 2:host}", UNIQUE(attr_id, element_type, element_id), FOREIGN KEY (attr_id) REFERENCES attribute (id) ON DELETE RESTRICT ); SQL end |