HarryMcCarney

private void NextStep()
{
    switch(PreviousStep())
    {
    case Status.Pending:
    IWorkFlowStep = new CreatePeopleCountHit(Release, TurkSource);
    break;
    case Status.SentForPeopleCount: 
    IWorkFlowStep = new FetchPeopleCountHitResult(Release, TurkSource);
    break;

HarryMcCarney

from pyramid.httpexceptions import HTTPBadRequest
from scotty import DBSession
from scotty.cms.models import CmsContent

__author__ = 'Harry'


def set_content(params):
    if not isinstance(params, list):
        raise HTTPBadRequest("Must submit list of keys as root level.")

HarryMcCarney

if exists(select * from sys.columns 
            where Name = N'seven_day_impressions' and Object_ID = Object_ID(N'pub.article'))
begin
	alter table pub.article
	drop column seven_day_impressions
end
 
go
alter table pub.article
add  seven_day_impressions int 

HarryMcCarney

CREATE OR REPLACE FUNCTION cn_candidate_search(term varchar(255), employer_id uuid)
  RETURNS table (candidate_id uuid) AS $$
    BEGIN
	if employer_id is not null then

HarryMcCarney

DROP VIEW IF EXISTS public.v_candidate_search;
        CREATE VIEW public.v_candidate_search
        AS

        SELECT
            c.id,
            cs.name as status,
            to_tsvector(cast(c.id AS VARCHAR(34)) || ', ' ||
            c.first_name || ' ' || c.last_name || ', ' || x.skills || ', ' || y.countries
            || ', ' || y.cities) AS search_index,

HarryMcCarney

 
 using System.Collections.Generic;
using Newtonsoft.Json;

namespace FCJobs.StorylineSuggest
{
    public class ArticleIndex
    {
        [JsonProperty(PropertyName = "name")]
        public string Name { get; set; }

HarryMcCarney

// ==UserScript==
// @name        PlacementCode
// @grant       none
// @require http://code.jquery.com/jquery-latest.js
// ==/UserScript==
 
 
function autoPlaceWidget(widget){
  var $root = $( '.entry-content,.entry-inner,.entry,#article,.sociable,.post_text,.post-content,.td-post-text-content,#match-report-left,.post-entry,#article_content,.pf-content' );
  if(!$root.length){return widget;}

HarryMcCarney

select t.impression_date as date, isnull(total_avg_pages, 0) avg_pages_per_session,
isnull(wd_avg_pages, 0) wd_avg_pages_per_session,
isnull(dwd_avg_pages, 0) dwd_avg_pages_per_session
            from (select top 90 cast(getutcdate()- n as date) impression_date from pub.tally) t
            left join (
                        select avg(cast(y.total_impresions as float)) total_avg_pages, 
						avg(cast(y.wd_impresions as float)) wd_avg_pages, 
						avg(cast(y.dwd_impresions as float)) dwd_avg_pages,
						y.session_date
                        from (

HarryMcCarney

if exists ( select  *
            from    sys.objects
            where   object_id = object_id('pub.auto_assign_storyline')
                    and type in ( 'p', 'pc' ) 
					)			
 drop proc pub.auto_assign_storyline
 go
 
create proc pub.auto_assign_storyline
@blog_id int,

HarryMcCarney

name: Users
connection: data source=psjlbac9vm.database.windows.net,1433;Initial Catalog=dfg;User Id=thefc;Password=sfdg;Encrypt=true;Trusted_Connection=false;" providerName="System.Data.SqlClient"
sql: select name, email, created from user where created @from and @to
params:
     - name:created
       type:DateRange
       field:created
     - name:email
       type:filter
       field:email