Skip to content

Instantly share code, notes, and snippets.

Mike Paszkiewicz mikepaszkiewicz

Block or report user

Report or block mikepaszkiewicz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View geocoder_comparison.ts
import axios from 'axios'
interface GeocodeFeature {
"type": "Feature",
"geometry": {
"type": string,
"coordinates": number[]
},
"properties": {
@mikepaszkiewicz
mikepaszkiewicz / .sh
Created Oct 23, 2019
DevOps Cheat Sheet
View .sh
##HEROKU
#view running processes
heroku ps -a habitat-api-express
#kill running pid/stuck release
heroku ps:kill release.6104 -a habitat-api-express-staging
@mikepaszkiewicz
mikepaszkiewicz / .sh
Last active Nov 25, 2019
Bash Cheat Sheet
View .sh
##FILESYSTEM
# append all .csv files in only one and ignore headers in subsequent files.
#!/bin/bash
OutFileName="X.csv" # Fix the output name
i=0 # Reset a counter
for filename in ./*.csv; do
if [ "$filename" != "$OutFileName" ] ; # Avoid recursion
then
if [[ $i -eq 0 ]] ; then
@mikepaszkiewicz
mikepaszkiewicz / .sql
Last active Dec 16, 2019
PostgreSQL Cheat Sheet
View .sql
--CONNECTIONS
--check all active connections
SELECT * FROM pg_stat_activity;
--kill all other active connections
SELECT
pg_terminate_backend(pg_stat_activity.pid)
FROM
pg_stat_activity
View gist:30c2aacbf6f583a3ddee0c8a54f3a98c
https://s3.amazonaws.com/downloads.metabase.com/v0.33.3/metabase-aws-eb.zip
@mikepaszkiewicz
mikepaszkiewicz / olo.md
Created Apr 9, 2018
Olo integration steps
View olo.md

Docs: https://dispatch-dsp.readme.io/docs Sandbox: https://vanilla.olosandbox.com/menu/dispatch-tryhabitat/

  • Make sure 26 Broadway New York, NY 10004 is in your coverage area to be able to accept orders.

OLO will test the following before turning on integration:

View gist:69d4556172c2d8aa2a3b5e90f677eb39
Docs: https://dispatch-dsp.readme.io/docs
Sandbox: https://vanilla.olosandbox.com/menu/dispatch-tryhabitat/
- _Make sure 26 Broadway New York, NY 10004 is in your coverage area to be able to accept orders._
OLO will test the following before turning on integration:
- [x] Get quote by pickup time (https://dispatch-dsp.readme.io/v1.0/reference#request-quote)
- [x] Get quote by dropoff time (https://dispatch-dsp.readme.io/v1.0/reference#request-quote)
- [x] Make sure a delivery goes all the way through to completion
- [x] Ensure we get all required status updates (https://dispatch.dsp.readme.io/v1.0/reference#status-updates)
View example.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View gist:1531fc6cec601c4faa5cda94fc6cc0af
{
"deliveryAreas": [
{
"features": [
{
"geometry": {
"coordinates": [
[
[
-73.685302734375,
View gist:13fcfb104ba6f52ec0c6e16b35b1c80a
with x as (select users.id, transactions.runner_id, transactions.runner_obj, transactions.created_at from transactions
left outer join users
on users.id = transactions.runner_id
where transactions.runner_id is not null
and users.id is null)
select distinct runner_id from x
You can’t perform that action at this time.