mikepaszkiewicz

//NOTE: Connection = promisified wrapper around RPC calls...methods map directly to RPC 'action' parameter
import Rai from '../server/util/rai'
const Connection = Rai('http://000.000.000.000', 7076) //node IP and port

const SENDER_XRB_WALLET_ADDRESS = 'xrb_...'
const RECEIVING_WALLET = 'xrb_...'
const SENDER_PUBLIC_WALLET_KEY = '....'

async function sendBlock() {
  try {

mikepaszkiewicz

create index concurrently on transactions (order_number) USING GIN(order_number::text gin_trgm_ops)

mikepaszkiewicz

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

  ],
  "Ansi 12 Color" : {

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

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

mikepaszkiewicz

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

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

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

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