puppetdb_query - query puppetdb data from other sources

Just store and update your puppet facts also in another database and query nodes or facts from that other database. This can speed up your queries enormously and reduce the load on your puppet database.

General

The puppet database schema is not designed for complicated queries on numerous nodes. Here we provide an implementation for storing and querying node facts in a mongodb.

You must simply establish a sync job to read the data from your puppetdb and write it to a mongodb.

Currently the implementation supports only puppetdb api V 4.

Installation

Add this line to your application's Gemfile:

gem 'puppetdb_query'

And then execute:

$ bundle

Or install it yourself as:

$ gem install puppetdb_query

Usage within program

require "mongo"
require "puppetdb_query"
require "pp"

MONGO_HOSTS = ['mongo.myhost.org:27017']
MONGO_OPTIONS = { database: 'puppetdb', user: 'ops', password: 'very secret' }

pm = PuppetDBQuery::MongoQuery.new(MONGO_HOSTS, MONGO_OPTIONS)
pm.nodes({processorcount: '4', lvm_support: true})
pm.facts({processorcount: '4', lvm_support: true}, ["macaddress", "operatingsystem"])

mongo = PuppetDBQuery::ToMongo.new
query = mongo.query("processorcount='4' and lvm_support=true")
pp query
pm.nodes(query)
pm.facts(query, ["macaddress", "operatingsystem"])

Development

After checking out the repo, run bundle install to install dependencies.

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release to create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.

Contributing

  1. Fork it ( https://github.com/m-31/puppetdb_query/fork )
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request