Skip to content

Instantly share code, notes, and snippets.

View IanWhitney's full-sized avatar

Ian Whitney IanWhitney

View GitHub Profile
module.exports = {
env: {
browser: true,
es2020: true
},
extends: [
'standard'
],
parser: 'babel-eslint',
parserOptions: {
  • Head to the confluent directory, prep
    • cd /Users/Ian/Downloads/confluent-3.3.0
    • export PATH=/Users/Ian/Downloads/confluent-3.3.0/bin:$PATH
  • Start up the relevant Confluent stuff
    • clear && ./bin/connect-standalone ./etc/schema-registry/connect-avro-standalone.properties ./etc/kafka-connect-jdbc/source-dors.properties
  • Run your standalone connector
    • clear && ./bin/connect-standalone ./etc/schema-registry/connect-avro-standalone.properties ./etc/kafka-connect-jdbc/source-dors.properties
  • Wait a minute or two for the connector to get up & running
  • You can run a console consumer just to see if there's stuff in the topic
    • --bootstrap-server localhost:9092 --topic test-dors-jdbc-v_reg_total --from-beginning
[
{
"text": "Hi there, new person! Some tips now that you've joined this fantastic Slack.\n• Introduce yourself on #general so that we can say Hi.\n• Check out our growing Channel list. Big ones will be #code-people, #net-people or #web-people. #random is good for...randomness.\n• If you’re an IT manager & want to talk people-skill stuff, ask @codyh for an invite to #people-people\n• Channels are free. Create one if you want to talk about some topic! Let us know about the new channel in #general\n• Fill out your profile with where you work/what you do\n • https://get.slack.help/hc/en-us/articles/204092246-Edit-your-profile"
}
]
@IanWhitney
IanWhitney / 01_summary.md
Last active May 28, 2017 13:36
Testing the removal of the single-column etl_audit_id indexes in FAC_CR tables

Testing the removal of the the single-column index E_AUDITS_F_CR_DA_FK_1 because the column it indexes etl_audit_id is also the first column in a multi-column index.

Plan

select * from fac_cr_degree_applicable where etl_audit_id = '13869193';

With the single-column index on, the single-column index is used and the cost is 3.

With the single-column index disabled, the multi-column indexx is used and the cost is 3.

@IanWhitney
IanWhitney / faculty_roles.sql
Last active March 1, 2017 18:34
To satisfy INC1581454.
/*
I am preparing a communication to send out to graduate faculty in the following colleges:
CEHD (06GRD, 06DMS)
CFANS (30GRD)
CVM (03GRD)
CSOM (02GRD)
Would it be possible to query the Faculty Role List database to get a list of graduate faculty from the above colleges including
active faculty, name, program (college), and email address?
*/
@IanWhitney
IanWhitney / classify_jobs.rb
Last active May 9, 2017 02:32
sidekiq job classification
def classify_jobs(queue = 'default')
hsh = Hash.new{|hsh, key| hsh[key] = 0}
Sidekiq::Queue.new(queue).each do |j|
hsh[j.klass] += 1
end
puts hsh if hsh.values.any?(&:present?)
end
module DataViews
def self.root
@root ||= File.expand_path(File.join("..", ".."), __FILE__)
end
def self.environment
@environment ||= Rails.env || "development"
end
def self.environment=(other)
Clojure
Empty board
Board comparison
Attacking
C++
Can't occupy same space
Attacking
ECMA