Luisoto’s gists

Luisoto / consumo.json

Created June 29, 2018 16:47

	parse-dashboard --appId Fpt6qU5NBrTfXX8igAmRuKJqHfPQODTS3dAk8H4s --masterKey CBVQ4c2r3zV4xW2VtQQzvQj2HdPsHQzF3l8ONSDA --serverURL "http://0.0.0.0:1337/parse/" --appName AQHJ --allowInsecureHTTP true


	parse-server --appId Fpt6qU5NBrTfXX8igAmRuKJqHfPQODTS3dAk8H4s --masterKey CBVQ4c2r3zV4xW2VtQQzvQj2HdPsHQzF3l8ONSDA --databaseURI 'mongodb://userbad4ae:ebfbd0Ra8TpzA1007d7@cluster-pgrs1000-0-us-east-1-scalabledbs.cloudstrap.io:29000,cluster-pgrs1000-1-us-east-1-scalabledbs.cloudstrap.io:29000,cluster-pgrs1000-2-us-east-1-scalabledbs.cloudstrap.io:29000/pg-app-2-us-8x3xr2lw78svljyki0depcssvud9u9?replicaSet=pgrs1000&ssl=true' --serverURL 'http://0.0.0.0:1337/parse/' --cloud '/Users/luisoto/Documents/AQHJ/pg-app-8x3xr2lw78svljyki0depcssvud9u9/cloud/main.js'


	[
	{
	"table_id": 544,
	"name": "Grupo H - Fecha 3",

Luisoto / gist:617f6bd549350bb37d47531997c7c406

Created April 20, 2018 20:46

Chats since 2018 were users have not been blocked or reported in any other chat

	SELECT
	idCandidate,
	idEmployer
	FROM
	`merlin_analysis_v2.Chat`
	WHERE
	timestamp > timestamp ("2018-01-01 00:00:00")
	GROUP BY
	idCandidate,
	idEmployer EXCEPT DISTINCT

Luisoto / gist:2c5fc5297f0fe86cb25e4ca8a2b72b62

Created April 20, 2018 20:10

Chats were users have been blocked or reported

	SELECT
	value AS idCandidate,
	idUserEmployer AS idEmployer
	FROM
	`merlin_events.Event`,
	UNNEST(properties)
	WHERE
	eventName = "block-user-chat"
	AND idUserEmployer IS NOT NULL
	AND key = "id_user_blocked"

Luisoto / gist:748ecfef8217d304993b230d89034f1a

Created April 20, 2018 20:09

Users that have been blocked or reported in any chat

	SELECT
	value AS idCandidate
	FROM
	`merlin_events.Event`,
	UNNEST(properties)
	WHERE
	eventName = "block-user-chat"
	AND idUserEmployer IS NOT NULL
	AND key = "id_user_blocked"
	GROUP BY

Luisoto / gist:b212ea4fa20173c810906d2b732d519f

Created April 20, 2018 20:07

Chats were both parties text

	SELECT
	idChat
	FROM
	`merlin_analysis_v2.Chat`
	WHERE
	idSender = idEmployer
	AND timestamp >= TIMESTAMP("2018-01-01 00:00:00") INTERSECT DISTINCT
	SELECT
	idChat
	FROM

Luisoto / gist:859c18c5119a8924fec2d8d88861beed

Last active April 20, 2018 20:06

Chats since 2018

	SELECT
	idChat
	FROM
	`merlin_analysis_v2.Chat`
	WHERE
	timestamp > timestamp ("2018-01-01 00:00:00")
	GROUP BY
	idChat

Luisoto / gist:dc895a3e1c8a96b5cf575938f6191968

Created April 20, 2018 19:51

Approved jobs with at least one shortlist

	SELECT
	idJob
	FROM
	`merlin_events.Event`
	WHERE
	eventName = "Shortlist"
	AND idJob IN (
	SELECT
	idJob
	FROM

Luisoto / gist:80d378f35fc6b7b7009016b9a0542905

Last active April 20, 2018 17:04

Num. text chats started by anyone per jobs with at least one shortlist (Removed reported users)

	SELECT
	percentile_cont(totalChats,
	0.25) OVER()
	FROM (
	SELECT
	idJob,
	COUNT(idJob) AS totalChats
	FROM (
	SELECT
	idChat,

Luisoto / gist:90add66dc9b39ad8fe57a49e6c19a79e

Created April 20, 2018 17:00

Num. Shortlists job with at least one shortlist (Removed reported users)

	SELECT
	percentile_cont(totalShortlist,
	0.75) OVER()
	FROM (
	SELECT
	idJob,
	COUNT(idJob) AS totalShortlist
	FROM
	`merlin_events.Event`
	WHERE

Luisoto / gist:0a77f8728db9c9a38763e715fd5f2df0

Created April 20, 2018 15:49

Num. text chats where non-shortlisted candidate texts first and employers texts next and then candidate is shortlisted per job with at least one shortlist

	SELECT
	percentile_cont(totalChats,
	0.25) OVER()
	FROM (
	SELECT
	idJob,
	COUNT(idJob) AS totalChats
	FROM (
	SELECT
	t3.*,

luisoto92 Luisoto