Nick Carboni carbonin

carbonin / scap.rb

Last active October 3, 2017 21:22

Ruby script for checking compliance with a specific set of rules

	require 'yaml'
	require 'nokogiri'
	require 'openscap'
	require 'tempfile'
	require 'pathname'
	require 'trollop'

	class ScapTest
	PROFILE_ID = "xccdf_org.ssgproject.content_profile_linux-admin-scap".freeze
	SSG_XML_PATH = Pathname.new("/usr/share/xml/scap/ssg/content/")

carbonin / parse_autovacuum.rb

Last active November 22, 2017 19:07

Parses the autovacuum stats out of postgres logs

	files = Dir.glob("postgresql.log").sort
	files << files.shift if files.first == "postgresql.log"

	regex = /(\d+-\d+-\d+ \d+:\d+:\d+ \w+).vacuum of table "(\w+)\.(\w+)\.(\w+)".\n.pages: (\d+) removed, (\d+) remain, (\d+) skipped due to pins\n.tuples: (\d+) removed, (\d+) remain, (\d+)/

	puts files
	files.each do \|log_file_name\|
	begin
	matches = File.read(log_file_name).scan(regex)
	rescue => e

carbonin / db_perf.rb

Created November 11, 2015 15:06

Script to test performance of db inserts like rubyrep

	require 'pg'
	require 'benchmark'
	require 'io/console'

	class DbPerf
	TEST_DB = 'timing_test_database'
	TEST_TABLE = 'timing_test_table'
	INSERT_QUERY = "insert into #{TEST_TABLE} (data) values ('#{"a" * 100}')"

	def initialize(host, db_user, password)