Skip to content

Instantly share code, notes, and snippets.

View llowder's full-sized avatar

Lee Lowder llowder

View GitHub Profile

#Project Requirements / Goals

##Calculate Weekly averages

  • Rolling weekly average of the last 7 days
  • This is easy to do.
  • Week To Date Average
  • Sunday just uses Sunday for the average
  • Monday uses Sunday and Monday
  • Tuesday uses Sunday - Tuesday
  • ...
2015-05-15 18:02:09,078 ERROR [c.p.p.c.services] Error while sweeping reports
java.sql.BatchUpdateException: Batch entry 0 DELETE FROM reports WHERE end_time < '2015-05-01 18:02:08.982000 +02:00:00' was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:457) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405) ~[puppetdb.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893) ~[puppetdb.jar:na]
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[puppetdb.jar:na]
at clojure.java.jdbc.internal$do_prepared_STAR_$fn__6350.invoke(internal.clj:356) ~[na:na]
at clojure.java.jdbc.i
---
Zinnarath:
Title: Apprentice Mailsmith
Level: 60
Class: Great Weapon Fighter
Paragon Path: Swordmaster
Feats:
General:
Unstoppable Action:
rank: 1/5
console=# select count(*), pg_size_pretty(pg_total_relation_size('"public"."reports"')), pg_size_pretty(pg_total_relation_size('"public"."reports"')/count(*)) as avg_size from reports ; count | pg_size_pretty | avg_size
-------+----------------+-----------
125 | 104 kB | 851 bytes
(1 row)
#(on a Macbook Air)
$ sudo gem install ./showoff-*.gem
Password:
Fetching: rack-1.6.0.gem (100%)
Successfully installed rack-1.6.0
Fetching: tilt-1.4.1.gem (100%)
Successfully installed tilt-1.4.1
Fetching: rack-protection-1.5.3.gem (100%)
Successfully installed rack-protection-1.5.3
Fetching: sinatra-1.4.5.gem (100%)
(ns callofmylittlepuppet.core
(:gen-class))
(defn transform
[words]
(->> words
(partition 4 1)
(reduce (fn [acc [w next-w]]
(update-in acc
[w next-w]
(ns run-nerd-miner.core
(:require [edn-config.core :refer [env]])
(:require [clojure.java.io :as io])
(:require [clojure.data.xml :as xml])
(:require [clojure.zip :as zip])
(:require [clojure.data.zip.xml :as xz])
(:gen-class))
(defn only-files
zipper-demo.core> (def pokemon
(-> "pokemon.xml"
clojure.java.io/resource
clojure.java.io/input-stream
xml/parse))
[main]
server = pe-370-master.puppetdebug.vlan
port = 4435
certificate_name = pe-370-master.puppetdebug.vlan
[root@pe-370-master puppetlabs]# cat puppet/puppetdb.conf
[main]
server = pe-370-master.puppetdebug.vlan
port = 8081
soft_write_failure = false
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi tempor libero metus, a feugiat metus tincidunt et. Quisque ac ultricies lectus. Duis aliquet mi purus, sed lobortis est dignissim quis. Aliquam tempus euismod odio, eget tincidunt sem vestibulum eget. Sed at lectus ut dui varius suscipit nec in arcu. Aenean efficitur augue orci, placerat venenatis nunc ullamcorper in. Morbi vehicula accumsan ipsum, ac ornare quam ornare eu. Vivamus vel elit imperdiet, tincidunt metus in, fermentum velit. Etiam congue, est id vestibulum commodo, lorem lorem finibus urna, ut volutpat tortor metus quis libero. In consectetur, tellus eget ornare aliquam, enim dolor rhoncus sem, mattis ullamcorper dui odio in ipsum.
Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Phasellus dictum mollis mi, a pulvinar ligula placerat id. Nullam mi mauris, tincidunt quis pharetra facilisis, interdum eu neque. Etiam elementum lacus tellus, ac vehicula metus consequat eu. Phasellus fermentum, p