SputterPuttRedux

Keybase proof

I hereby claim:

• I am sputterputtredux on github.
• I am dstanfield (https://keybase.io/dstanfield) on keybase.
• I have a public key ASAcMmxLBThZOC2En0z5KPy98xaeYwMSeGVMU2lttRenHwo

To claim this, I am signing this object:

SputterPuttRedux

// ==UserScript==
// @name         See YouTube ViewCount Inline
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  A small script to allow one to see the number of views a youtube search result 
//               has in a google search results set.  To use this script, obtain a YouTube API key,
//               then on line 40 below paste your API key over the YOUR_API_KEY_STRING text.
// @author       SputterPuttRedux
// @match        https://www.google.com/search?*
// @grant        none

SputterPuttRedux

CREATE VIEW v_dynamic_pricing_for_accounts AS
SELECT
  dynamic_pricing_bid_infos.account_id,
  dynamic_pricing_bid_infos.exclusive_lead_status,
  dynamic_pricing_bid_infos.call_status,
  array_agg(profiles.id) profile_ids,
  accounts.pfp_start_date pfp_inception_date,
  accounts.rep_user_id,
  accounts.pfp_budget pfp_budget,
  max_activity_prices.shared_lead_buyers

SputterPuttRedux

UPDATE call_source_partners
SET affiliate_slug = params_table.affiliate_slug, category_id = params_table.category_id
FROM (
  SELECT id, params->'affiliate_slug' AS affiliate_slug, to_json(params->'category_id')::text::int AS category_id
  FROM call_source_partners 
) AS params_table
WHERE call_source_partners.id = params_table.id;

SputterPuttRedux

CallSourcePartner.all.each do |partner| 
  partner.update(
    affiliate_slug: partner.params['affiliate_slug'],
    category_id: partner.params['category_id']
  ) 
end

SputterPuttRedux

<div id="search-results">

  <% if (@searched_stories + @searched_snippets).empty? %>
   <br>
    <h3> We couldn't find any content Containing "<%= params[:search] %>"</h3>
  <% elsif !@searched_stories.empty? %>
    <h3> Stories with "<%= params[:search] %> in the title: " </h3>
    <% @searched_stories.each do |story| %>
      <% display_string = story.title %>
      <% x = params[:search].upcase %>