Calvin Metcalf calvinmetcalf

## marbles.csv

          
            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

## w10fix.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                calvinmetcalf
                / w10fix.geojson
            
            
              Created
              April 13, 2020 18:31
            
          
      View w10fix.geojson
  
    
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## wards1876_1894.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                calvinmetcalf
                / wards1876_1894.geojson
            
            
              Created
              April 10, 2020 16:08
            
          
      View wards1876_1894.geojson
  
    
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## class.js
Class MyStream extends stream.Writable {
  constructor() {
    super({objectMode: true})
  }
 _write(chunk, _, next) {
   next();
  }
  _final(done) {
    done();
  }

## csv-to-postgres.js
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

## knexDeferAllForeignKeys.js
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;

## quote.js
// 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;

## spoiler.js
let x = 'foo'

async function test() {
  console.log('top of func', x);
  x+= await 'baz'
  console.log('bottom of func', x)
}

test()
x = 'bar';

## index.html
<!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>

## index.html
<!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; }
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
	Class MyStream extends stream.Writable {
	constructor() {
	super({objectMode: true})
	}
	_write(chunk, _, next) {
	next();
	}
	_final(done) {
	done();
	}
	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
	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;
	// 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;
	let x = 'foo'

	async function test() {
	console.log('top of func', x);
	x+= await 'baz'
	console.log('bottom of func', x)
	}

	test()
	x = 'bar';
	<!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>
	<!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; }