Sha256: 32bae145161008697ef05d6b1cf9092107e6ec8114d21d6d34c0290842ee4ed0

Contents?: true

Size: 1.16 KB

Versions: 163

Compression:

Stored size: 1.16 KB

Contents

class AddInventoryServiceTables < ActiveRecord::Migration
  def self.up
    unless ActiveRecord::Base.connection.tables.include?("inventory_nodes")
      create_table :inventory_nodes do |t|
        t.column :name, :string, :null => false
        t.column :timestamp, :datetime, :null => false
        t.column :updated_at, :datetime
        t.column :created_at, :datetime
      end

      add_index :inventory_nodes, :name, :unique => true
    end

    unless ActiveRecord::Base.connection.tables.include?("inventory_facts")
      create_table :inventory_facts, :id => false do |t|
        t.column :node_id, :integer, :null => false
        t.column :name, :string, :null => false
        t.column :value, :text, :null => false
      end

      add_index :inventory_facts, [:node_id, :name], :unique => true
    end
  end

  def self.down
    unless ActiveRecord::Base.connection.tables.include?("inventory_nodes")
      remove_index :inventory_nodes, :name
      drop_table :inventory_nodes
    end

    if ActiveRecord::Base.connection.tables.include?("inventory_facts")
      remove_index :inventory_facts, [:node_id, :name]
      drop_table :inventory_facts
    end
  end
end

Version data entries

163 entries across 163 versions & 5 rubygems

Version Path
puppet-retrospec-0.12.2 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.7 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.7-x86-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.7-x64-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.6 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.6-x86-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.12.1 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.6-x64-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.12.0 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.5 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.5-x86-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.5-x64-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.4 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.4-x86-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-3.8.4-x64-mingw32 lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.11.0 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.10.0 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.9.1 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.9.0 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb
puppet-retrospec-0.8.1 vendor/gems/puppet-3.7.3/lib/puppet/rails/database/004_add_inventory_service_tables.rb