kivanio

class EmailedZipFileExtractor
  # This class downloads an email from gmail and extracts a file out of a .zip attachment

  require 'google/apis/gmail_v1'
  require 'googleauth'
  require 'zip'

  # These credentials come from creating an OAuth Web Application client ID
  # in the Google developer console
  #

kivanio

require "net/https"
require "uri"

crt = File.read("client-2048.crt")
key = File.read("client-2048.key")

app_key = "YOUR_APP_KEY"
username = "YOUR_USERNAME"
password = "YOUR_PASSWORD"

kivanio

require 'net/http'
require 'openssl'

def test_connection(ip_address, uri, delays)
  Net::HTTP.start(ip_address, uri.port,
                    use_ssl: true,
                    verify_mode: OpenSSL::SSL::VERIFY_NONE,
                    keep_alive_timeout: 50
                 ) do |http|
    while true

kivanio

# Export data from Microsoft Access .mdb database into .csv files
# using  https://github.com/brianb/mdbtools 
# Install with homebrew - "brew install mdbtools"

class ConverterScript
  tables = `mdb-tables -d , your_db_name.mdb`.chop.split(",")

  tables.each do |table|
    exists = system("mdb-export your_db_name.mdb '#{table}'")
    `mdb-export your_db_name.mdb '#{table}' > #{table.gsub(" ", "_")}.csv` if exists

kivanio

library(dplyr)
library(ggplot2)
library(httr)


setwd("C:/Dropbox/Projects/20160206_Soccer_Scores")
if (!file.exists("20160206_Soccer_Scores.csv.gz")) {
  cat("must reread")
}

kivanio

class Customer < ActiveRecord::Base
    after_create :send_welcome_email, unless: :auto_registered?
    has_one :auto_created, dependent: :destroy

    private
    def send_welcome_email
        CustomerMailer.welcome_email(self).deliver
    end
    
    def auto_registered?

kivanio

class CustomersController < ApplicationController
    # …
    def create
        @customer = Customer.new(customer_params)
        
        respond_to do |format|
            if @customer.save
                format.html { redirect_to @customer, 
                                            notice: 'Customer was successfully created.' }
                format.json { render :show, status: :created, 

kivanio

class CustomersController < ApplicationController
    # …
    def create
        if auto_create_request?
            @customer = Customer.auto_create(customer_params)
        else
            @customer = Customer.register(customer_params)
        end     
        
        respond_to do |format|

kivanio

class Customer < ActiveRecord::Base
    has_one :auto_created, dependent: :destroy
    
    def self.register(params)
        new(params).tap do |customer|
            customer.save!
            customer.send_welcome_email
        end
    end
        

kivanio

Adding an audit log to your Rails app

If you have any sort of administrative interface on your web site, you can easily imagine an intruder gaining access and mucking about. How do you know the extent of the damage? Adding an audit log to your app is one quick solution. An audit log should record a few things:

• controller entry points with parameter values
• permanent information about the user, like user_id
• transient information about the user, like IP and user_agent

Using the Rails framework, this is as simple as adding a before_action to your admin controllers. Here’s a basic version that I’m using in production.