Skip to content

Instantly share code, notes, and snippets.

View allthesignals's full-sized avatar
🥑
coding lotsa code

Matt Gardner allthesignals

🥑
coding lotsa code
View GitHub Profile
SELECT *, (t2.historic_comparison_sum - t1.sum) as delta_sum, (t2.historic_comparison_m - t1.m) as delta_m FROM ( SELECT regexp_replace(lower(variable), '[^A-Za-z0-9]', '_', 'g') as variable, regexp_replace(lower(profile), '[^A-Za-z0-9]', '_', 'g') as profile, regexp_replace(lower(category), '[^A-Za-z0-9]', '_', 'g') as category, sum, base, m FROM ( SELECT SUM(e), SQRT( SUM( POWER(m, 2) ) ) AS m, variable FROM support_fact_finder WHERE geoid IN ('4056100','4053900','4053100','4066701','4061301','3027900') AND year = 'Y2011-2015' GROUP BY variable) support_fact_finder INNER JOIN support_fact_finder_meta_update ON support_fact_finder_meta_update.variablename = support_fact_finder.variable) t1 INNER JOIN ( SELECT sum AS historic_comparison_sum, m AS historic_comparison_m, variable as t2_var FROM ( SELECT regexp_replace(lower(variable), '[^A-Za-z0-9]', '_', 'g')
SELECT *,
(t2.historic_comparison_sum - t1.sum) as delta_sum,
(t2.historic_comparison_m - t1.m) as delta_m
FROM
(
SELECT
regexp_replace(lower(support_fact_finder.variable), ‘[^A-Za-z0-9]’, ‘_’, ‘g’) as variable,
regexp_replace(lower(support_fact_finder.profile), ‘[^A-Za-z0-9]’, ‘_’, ‘g’) as profile,
regexp_replace(lower(support_fact_finder.category), ‘[^A-Za-z0-9]’, ‘_’, ‘g’) as category,
sum,
@allthesignals
allthesignals / type.js
Created November 21, 2017 17:32 — forked from kirilloid/type.js
getType
function getType (value) {
let type = typeof value;
if (type === 'object') {
return value ? Object.prototype.toString.call(value).slice(8, -1) : 'null';
}
return type;
}
[NaN, 0, 1, Infinity, // numbers
null, undefined, false, 'str', // other primitives
@allthesignals
allthesignals / example_controller_blog.js
Last active November 27, 2017 15:17
example_controller
// app/controller/users.js
import Ember from ‘ember’;
const { inject: { service },
computed: { alias } } = Ember;
export default Ember.Controller.extend({
date: service(),
dateFrom: alias(‘date.start’),
dateTo: alias(‘date.from’),
import Ember from 'ember';
const { service } = Ember.inject;
export default Ember.Controller.extend({
date: service(),
queryParams: [‘date.dateFrom’, ‘date.dateTo’]
});
import Ember from 'ember';
export default Ember.Service.extend({
housingType: 'multi',
zoning: {
residential: true,
commercial: true,
},
});
@allthesignals
allthesignals / haxxxxx.js
Created December 15, 2017 19:26
Carto Script to autoset the privacy of every dataset in /datasets view to "with link" - just run in console
$('.is-private').each(node => {
$('.is-private')[node].click();
setTimeout(function() { }, 1000);
$('.is-private')[node].click();
$('.IllustrationIcon--alert').click();
setTimeout(function() { }, 1000);
$(".ok").click()
});
@allthesignals
allthesignals / components.my-component.js
Created December 28, 2017 19:31
Component Instance Hooks
import Ember from 'ember';
export default Ember.Component.extend({
didReceiveAttrs() {
alert('did receive attrs', this.get('id'));
}
});
import Ember from 'ember';
export default Ember.Route.extend({
model() {
return {
postsTask: this.store.findAll('post')
};
}
});
export default Ember.Route.extend({
//...
afterModel({ taskInstance }) {
this.get('setSelectedTask').perform(taskInstance);
},
setSelectedTask: task(function* (taskInstance) {
const model = yield taskInstance;
this.set('mainMap.selected', model);
}).restartable().cancelOn('deactivate'),