Calvin Metcalf calvinmetcalf
calvinmetcalf
/ marbles.csv
Created
June 12, 2020 18:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Team | Marble | Role | |
|---|---|---|---|
| Mellow Yellow | Yellow | Captain | |
| Mellow Yellow | Yelley | Member | |
| Mellow Yellow | Yellah | Member | |
| Mellow Yellow | Yellup | Member | |
| Mellow Yellow | Yellim | Reserve | |
| Savage Speeders | Speedy | Captain | |
| Savage Speeders | Rapidly | Member | |
| Savage Speeders | Swifty | Member | |
| Savage Speeders | Velocity | Member |
calvinmetcalf
/ w10fix.geojson
Created
April 13, 2020 18:31
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
calvinmetcalf
/ wards1876_1894.geojson
Created
April 10, 2020 16:08
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
calvinmetcalf
/ class.js
Created
April 2, 2020 15:20
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Class MyStream extends stream.Writable { | |
| constructor() { | |
| super({objectMode: true}) | |
| } | |
| _write(chunk, _, next) { | |
| next(); | |
| } | |
| _final(done) { | |
| done(); | |
| } |
calvinmetcalf
/ csv-to-postgres.js
Created
April 2, 2020 13:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const fs = require('fs'); | |
| const stream = require('stream') | |
| const {Transform, Writable} = stream; | |
| const util = require('util'); | |
| const pipeline = util.promisify(stream.pipeline); | |
| const csvParser = = require('csv-parser'); // best csv parser | |
| const db = require('./connection'); | |
| const readStream = fs.createReadStream('./path/to.csv'); | |
| const csv = csvParser(); // turns binary stream into object stream |
calvinmetcalf
/ knexDeferAllForeignKeys.js
Last active
January 30, 2020 12:56
— forked from scf4/knexDeferAllForeignKeys.js
More info: https://github.com/tgriesser/knex/issues/1830
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| export default async (knex) => { | |
| const foreignKeys = await knex('pg_constraint') | |
| .select('pg_constraint.conname', 'pg_class.relname') | |
| .where('contype', '=', 'f') | |
| .join('pg_class').on('pg_class.oid', 'pg_constraint.conrelid'); | |
| return Promise.all(foreignKeys.map(({relname, conname}) => | |
| knex.schema.raw(` | |
| ALTER TABLE ?? | |
| ALTER CONSTRAINT ?? | |
| DEFERRABLE INITIALLY DEFERRED; |
calvinmetcalf
/ quote.js
Created
May 21, 2019 15:37
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Dollar-Quoted String Constants: see 4.1.2.4 https://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html | |
| function tagRegex(tag) { | |
| return new RegExp('\\$' + tag + '\\$'); | |
| } | |
| function getBase(input) { | |
| var tagBase = 'cartodb'; | |
| if (!input.toString().match(tagRegex(tagBase))) { | |
| return tagBase; | |
| } | |
| var i = 0; |
calvinmetcalf
/ spoiler.js
Created
May 23, 2018 13:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let x = 'foo' | |
| async function test() { | |
| console.log('top of func', x); | |
| x+= await 'baz' | |
| console.log('bottom of func', x) | |
| } | |
| test() | |
| x = 'bar'; |
calvinmetcalf
/ index.html
Created
May 9, 2018 12:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta name='viewport' content='width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no' /> | |
| <title>FazMaraneyRGB_transparent_mosaic_group1</title> | |
| <!-- Leaflet --> | |
| <link rel="stylesheet" href=/home/gabrielschubert/Documents/hawkit_app/guis/pyqt_gui/leaflet/leaflet.css /> | |
| <script src=/home/gabrielschubert/Documents/hawkit_app/guis/pyqt_gui/leaflet/leaflet.js ></script> |
calvinmetcalf
/ index.html
Created
November 3, 2017 13:48
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset='utf-8' /> | |
| <title>Display buildings in 3D</title> | |
| <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' /> | |
| <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.41.0/mapbox-gl.js'></script> | |
| <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.41.0/mapbox-gl.css' rel='stylesheet' /> | |
| <style> | |
| body { margin:0; padding:0; } |
NewerOlder