| #!/bin/bash | |
| apt-get update -y | |
| apt-get install -y apt-transport-https ca-certificates curl gnupg-agent software-properties-common | |
| curl -fsSL https://download.docker.com/linux/ubuntu/gpg | apt-key add - | |
| add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" | |
| apt-get update -y | |
| apt-get install -y docker-ce docker-ce-cli containerd.io | |
| usermod -aG docker ubuntu |
| <?php | |
| /** | |
| * Grab the url of a publicly embeddable video hosted on vimeo | |
| * @param str $video_url The "embed" url of a video | |
| * @return str The url of the thumbnail, or false if there's an error | |
| */ | |
| function grab_vimeo_thumbnail($vimeo_url){ | |
| if( !$vimeo_url ) return false; | |
| $data = json_decode( file_get_contents( 'http://vimeo.com/api/oembed.json?url=' . $vimeo_url ) ); |
| import λ from "apex.js"; | |
| import { Pool } from "pg"; | |
| // connection details inherited from environment | |
| const pool = new Pool({ | |
| max: 1, | |
| min: 0, | |
| idleTimeoutMillis: 120000, | |
| connectionTimeoutMillis: 10000 | |
| }); |
| const doNecessaryKeysExist = (obj) => { | |
| const neededKeys = ['GID', 'day_part', 'day'] | |
| let expectedTrueValues = neededKeys.length | |
| let trueValues = neededKeys.reduce((a, prop) => { | |
| return a + (prop in obj && obj[prop] !== null) | |
| }, 0); | |
| return expectedTrueValues === trueValues | |
| } |
This script is intended to automatically fix the sequence numbers for all tables in the current database.
This is accomplished through the use of the setval() command, which we provide with the next ID value we wish to make use of.
We use the setval(sequence, number, is_called) overload
and set is_called = false in conjunction with COALESCE(MAX + 1, 1) to ensure that, with an empty table, the next sequence
value is 1 as expected.
| declare global { | |
| interface Array<T> { | |
| groupBy(prop: T): Array<T>; | |
| } | |
| } | |
| if (!Array.prototype.groupBy) { | |
| Array.prototype.groupBy = (prop: string) => { | |
| return this.reduce(function(groups, item) { | |
| const val = item[prop]; |
| function groupBy(list, props) { | |
| return list.reduce((a, b) => { | |
| (a[b[props]] = a[b[props]] || []).push(b); | |
| return a; | |
| }, {}); | |
| } | |
| // Usage. | |
| groupBy([{ | |
| id: 1, |
mv ~/Whatever/ngrok /Applications/
ln -s /Applications/ngrok /usr/local/bin
| curl -LJO https://file/master |
| #!/bin/bash | |
| for i in *.m4a; do | |
| ffmpeg -i "$i" -codec:a libmp3lame -qscale:a 2 `basename "$i" .m4a`.mp3 | |
| done |