Skip to content

Instantly share code, notes, and snippets.

View SputterPuttRedux's full-sized avatar

Dionne Stanfield SputterPuttRedux

View GitHub Profile
<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 %>
CallSourcePartner.all.each do |partner|
partner.update(
affiliate_slug: partner.params['affiliate_slug'],
category_id: partner.params['category_id']
)
end
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;
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
// ==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

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: