Instantly share code, notes, and snippets.

Carl-Erik Kopseng fatso83

View GitHub Profile
View gist:3eaa9afa9e8120c68254f27b80bffd60
-- ref https://dba.stackexchange.com/questions/229725/how-to-utilize-an-index-when-filtering-a-view?noredirect=1#comment453204_229725
-- the comment from Akina seems to indicate that creating the view through this syntax should somehow
-- affect the result? Very unsure if I understand the suggestion correctly.
Drop table form2;
CREATE TABLE form2 (
id INT,
encounter_id INT NOT NULL,
type TEXT NOT NULL,
View Background.txt
while we all know that using warm faucet water is not recommended in cooking,
I just heard my mother-in-law state that you should only cook water and then mix
it with cold water. The context was mixing water amd a baby porridge mix.
I find this peculiar.
What is difference in heating cold faucet water from just mixing cold faucet water and cooked water?
They should be equally inviting to bacteria, AFAIK, but as it is for making something that is to
be immediately consumed, I can't see any danger.
View format-code.gs
// is called by google docs when a document is open
// adds a menu with a menu item that applies a style to the currently selected text
function onOpen() {
DocumentApp.getUi()
.createMenu('Extras')
.addItem('Apply code style', 'applyCodeStyle')
.addToUi();
}
var backgroundColor = "#DDDDDD";
View prototype session
$ node
> class A{ constructor(){ console.log('A normal super class'); } }
undefined
> class B extends A{}
undefined
> new B
A normal super class
B {}
> sinon = require('sinon')
...
View edit_sinon_docs.sh
#!/bin/sh
# Usage example: ./edit_sinon_docs.sh stubs 4.1.1
# Will open stubs.md from 4.1.1 for editing and propagate the changes to later versions.
# Make sure you have SINON_HOME pointing to the repository root.
# You'll need git and the npm "semver" package installed (npm i -g semver)
cd $SINON_HOME/docs
FILENAME=$1.md
View Sinon doc issues.md

Create an article on how ES2015 classes relate to stubbing/spying

https://github.com/sinonjs/sinon/issues/1121

Show how to stub ES6 constructor #1265

https://github.com/sinonjs/sinon/issues/1265 What: Feature request to automatically call stubbed/spied constructors with new. Why: Often asked for. People get confused about Function#constructor and the constructor keyword. Should either make a small tutorial to document how to "stub" (make a new) constructor and/or introduce a small Sinon NPM plugin to do so (in the article).

View bug-tips.md

Bug reporting

Extracted from the internal jira issue tracker to keep a smaller footprint on the bug template.

Before you report

  • Check if you can reproduce the bug on the latest deployment of the development branch.
  • Search the list of existing bugs to see if this has been already been reported.

Nice tips and tricks

View 2018-06-19-syslog_err.txt
Jun 19 17:20:46 e6330 wpa_supplicant[915]: wlp2s0: WPA: Group rekeying completed with ec:08:6b:ff:d3:bc [GTK=CCMP]
Jun 19 17:28:26 e6330 pulseaudio[31070]: W: [pulseaudio] sink-input.c: Failed to create sink input: sink is suspended.
Jun 19 17:28:41 e6330 NetworkManager[914]: <info> [1529422121.5642] manager: sleep: sleep requested (sleeping: no enabled: yes)
Jun 19 17:28:41 e6330 NetworkManager[914]: <info> [1529422121.5710] manager: NetworkManager state is now ASLEEP
Jun 19 17:28:41 e6330 gnome-shell[31045]: Screen lock is locked down, not locking
Jun 19 17:28:41 e6330 gnome-shell[31045]: Failed to set power save mode for output LVDS-1: Permission denied
Jun 19 17:28:41 e6330 NetworkManager[914]: <info> [1529422121.7631] device (wlp2s0): state change: activated -> deactivating (reason 'sleeping', sys-iface-state: 'managed')
Jun 19 17:28:41 e6330 NetworkManager[914]: <info> [1529422121.7950] device (wlp2s0): state change: deactivating -> disconnected (reason 'sleeping', sys-iface-state: 'managed')
Jun 1
View test-module-is-runnable.js
const puppeteer = require("puppeteer");
const http = require("http");
const fs = require("fs");
const port = 3876;
const scriptContent = `
import sinon from '/sinon-esm.js';
console.log('sinon is here', typeof sinon);
View hubic.log.md

After failing to download any large files from HubiC using either the desktop or the web client, I decided to try clients using the REST API. The most mature one seems to be rclone, but even that (which supports retries) couldn't retrieve a given file after trying for more than 3 hours!

This is the last hours worth of logs from running rclone copy -vv Hubic:HubiC-DeskBackup_Pictures/Lightroom/Main.lrcat .

Elapsed time:     2h41m1s
Transferring:
 *                                    Main.lrcat: 40% done, 321.944 kBytes/s, ETA: 14m20s