mikepaszkiewicz

##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

##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

--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

mikepaszkiewicz

https://s3.amazonaws.com/downloads.metabase.com/v0.33.3/metabase-aws-eb.zip

mikepaszkiewicz

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:

• Get quote by pickup time (https://dispatch-dsp.readme.io/v1.0/reference#request-quote)
• Get quote by dropoff time (https://dispatch-dsp.readme.io/v1.0/reference#request-quote)
• Make sure a delivery goes all the way through to completion
• Ensure we get all required status updates (https://dispatch.dsp.readme.io/v1.0/reference#status-updates)

mikepaszkiewicz

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)

mikepaszkiewicz

mikepaszkiewicz

{
    "deliveryAreas": [
        {
            "features": [
                {
                    "geometry": {
                        "coordinates": [
                            [
                                [
                                    -73.685302734375,

mikepaszkiewicz

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

mikepaszkiewicz

{
  "Ansi 2 Color" : {
    "Green Component" : 0.73333334922790527,
    "Red Component" : 0,
    "Blue Component" : 0
  },
  "Tags" : [

  ],
  "Ansi 12 Color" : {