30:T54c,function table(result, display=100, filter=null, fields=null) { if (!result.fields) return result if (display === null) display = undefined const rows = filter ? result.rows.filter(filter) : result.rows fields = fields ? result.fields.filter(f => fields.indexOf(f.name) !== -1) : result.fields return html`

Displaying ${Math.min(display || rows.length, rows.length)} of ${rows.length} rows: ${fields.map(field => html``)} ${rows.slice(0, display).map(row => (html` ${fields.map(field => html` `)} `))}

${field.name}
${format(row[field.name], field)}

` }31:[] 2e:{"title":"Lever","cells":[{"id":0,"value":"md`# Lever\nAccess our synced Lever database. **You must be authenticated via Google on the Opendoor.com domain to access.** If you don't work at Opendoor, then you won't be able to get access.\n\n## Usage\nThis notebook is intended to be imported into other notebooks:\n\n\\`\\`\\`javascript\nimport { lever } from '@opendoor/lever'\n\\`\\`\\`\n\nAfter importing, you should be able to use the \\`lever\\` function to execute queries.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":157,"value":"md`## lever(sql, display=100)\nQuery the Lever DB with the specified SQL.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"async function lever(sql, display=100) {\n const url = `https://opendoor-lever.herokuapp.com/db?q=${encodeURIComponent(sql)}`\n const response = await fetch(url, {\n credentials: 'include',\n // headers: { Authorization: `Bearer ${Secret('LEVER_KEY')}` },\n })\n const json = await response.json()\n \n let h = html``\n debugger\n if (response.ok) {\n h = table(json, display)\n } else if (response.status === 401) {\n h = html`👋🏼 Sign in with Google to view`\n } else {\n let message = json.message.replace(`${sql} - `, '')\n message = message[0].toUpperCase() + message.slice(1)\n if ('position' in json)\n h = html`\n ${message}:
\n ${json.hint ? json.hint : ''}\n

${sql.slice(0, json.position-1)}‸${sql.slice(json.position-1)}\\n

\n `\n else\n h = html`${message}>`\n }\n\n h.value = json\n return h\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"md`### Results\nReturns an HTML table with the structured data stored on \\`value\\`, for use with \\`viewof\\`. The HTML table is limited to 100 rows by default, but you can pass another display limit or \\`null\\` for unlimited.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"viewof data = lever(`\n select *,\n age(ended_at, started_at) as duration,\n error::text as error\n from syncs\n where started_at > now() - interval '3 days'\n order by started_at desc\n`)","pinned":true,"hidden":false,"mode":"ojs"},{"id":15,"value":"vegaEmbed({\n data: { values: data.rows },\n transform: [{\n filter: 'datum.duration'\n }, {\n calculate: `\n (datum.duration.days ? datum.duration.days + 'd' : '') +\n (datum.duration.hours ? datum.duration.hours + 'h' : '') +\n (datum.duration.minutes ? datum.duration.minutes + 'm' : '')\n `,\n as: 'duration'\n }],\n width: width-210,\n mark: 'rect',\n encoding: {\n row: { field: 'field', type: 'nominal', header: { title: null, labelAngle: 0 } },\n x: { field: 'started_at', type: 'temporal' },\n x2: { field: 'ended_at', type: 'temporal' },\n color: { field: 'error', type: 'nominal' },\n detail: [{ field: 'id', type: 'ordinal' }, { field: 'duration', type: 'nominal' }],\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1525,"value":"data.rows.filter(d => d.error)","pinned":false,"hidden":false,"mode":"ojs"},{"id":293,"value":"md`### Errors\nErrors will return a debugging message:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":296,"value":"viewof error = lever('select * from foo')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1494,"value":"lever('select * from private.offers')","pinned":false,"hidden":false,"mode":"ojs"},{"id":300,"value":"md`Again, more detailed information is on \\`value\\`:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":306,"value":"error","pinned":true,"hidden":false,"mode":"ojs"},{"id":167,"value":"md`## table(result, display=100, filter=null, fields=null)\nGenerate a preview of the result, attaching the data to \\`value\\`. By default, only displays 100 rows. Pass \\`null\\` to display all rows.\n\nCan optionally pass a filter function and list of field names to display.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":94,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":481,"value":"viewof postings = lever(`\n select categories->>'department' as department,\n categories->>'team' as team,\n count(distinct p.id) as postings,\n count(a.id) as applications\n from postings p\n left join applications a on a.posting = p.id\n group by 1, 2\n order by 1, 2\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":508,"value":"md`## format(value, field)\n\nFormat for display the value given the field definition.\n\n- UUIDs are truncated (triple-click to select all to copy).\n- Dates are translated to the browser's time zone.\n- Numbers are right-aligned.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":501,"value":"function format(value, field) {\n switch(field.dataTypeID) {\n case 20: // integer\n case 23: // integer\n case 1700: // decimal\n return value\n case 1184: // timestamp\n return html`${value && new Date(value)}`\n case 2950: // UUID\n return html`${value}`\n case 1186: // interval?\n case 3802: // JSONB\n\t return html`${JSON.stringify(value)}`\n default:\n return value\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":510,"value":"viewof candidate = lever(`\n select\n id,\n name,\n phones,\n created_at,\n snoozed_until,\n 1234 as integer,\n 1.42 as decimal\n from candidates\n limit 1\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":513,"value":"candidate.fields","pinned":false,"hidden":false,"mode":"ojs"},{"id":1084,"value":"md`## Scratch`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1091,"value":"{\n const tables = ['applications', 'candidates', 'feedback', 'interviews', 'interviews_feedback']\n return lever(tables.map(t => `select '${t}' as table, count(*) from ${t}`).join(' union all '))\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1353,"value":"viewof textFeedback = lever(`\n with fields as (\n select created_at, jsonb_array_elements(fields) as json\n from feedback\n )\n select created_at\n from fields f\n where json->>'type' = 'textarea'\n and json->>'value' is not null\n`)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1428,"value":"vegaEmbed({\n data: { values: textFeedback.rows },\n mark: 'tick',\n width: width - 100,\n encoding: {\n x: { field: 'created_at', type: 'temporal' },\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1080,"value":"md`---\n## Vega-lite\n\nTo visualize`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1198,"value":"vegaEmbed = require('vega-embed')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}