Sha256: 6b4e00a3e004d072d77447b8293a6b331f32b1afd88918532adc9202bcaccfb7

Contents?: true

Size: 623 Bytes

Versions: 75

Compression:

Stored size: 623 Bytes

Contents

query = <<-EOF
  select count(id) from users;
EOF

# pick a non-critical db if possible
source = Rubber.instances.for_role("db").first
source ||= Rubber.instances.for_role("db", "primary" => true).first
db_host = source ? source.full_name : 'localhost'

command = "psql -U#{Rubber.config.db_slave_user}"
command << " -h #{db_host}"
command << " #{Rubber.config.db_name} --tuples-only --no-align"

# execute a sql query to get some data
data = `echo "#{query}" | #{command}`
fail "Couldn't execute command" if $?.exitstatus > 0

# print graph data values
puts "PUTVAL #{HOSTNAME}/users/total interval=#{INTERVAL} N:#{data}"

Version data entries

75 entries across 75 versions & 1 rubygems

Version Path
rubber-3.2.2 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-3.2.1 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-3.2.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-3.1.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-3.0.1 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-3.0.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.16.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.15.2 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.15.1 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.15.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.14.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.13.1 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.13.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.12.2 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.12.1 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.12.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.11.0 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.10.2 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.10.1 templates/collectd/script/collectd/role/examples/example_db_query.rb
rubber-2.10.0 templates/collectd/script/collectd/role/examples/example_db_query.rb