Skip to content

Instantly share code, notes, and snippets.

cat ~/Users/user/Documents/dump1.sql | docker exec -i postgres psql --host=127.0.0.1 --username=postgres -d dataowl
10/15/2018 4:35:34 PM[2018-10-15T12:35:34.167Z] ERROR (hemera-01a48ac7a129-ec29cd50ab4c4cca9767f10399a7fd6d/63 on 01a48ac7a129): Business error
10/15/2018 4:35:34 PM BusinessError: Business error
10/15/2018 4:35:34 PM at Hemera._onClientPostRequestCompleted (/usr/src/app/node_modules/nats-hemera/lib/index.js:1331:29)
10/15/2018 4:35:34 PM at Hemera.self._series.err (/usr/src/app/node_modules/nats-hemera/lib/index.js:1288:21)
10/15/2018 4:35:34 PM at ResultsHolder.release (/usr/src/app/node_modules/fastseries/series.js:99:22)
10/15/2018 4:35:34 PM at onClientPostRequest (/usr/src/app/node_modules/nats-hemera/lib/extensions.js:137:3)
10/15/2018 4:35:34 PM at Hemera._clientExtIterator (/usr/src/app/node_modules/nats-hemera/lib/index.js:1246:17)
10/15/2018 4:35:34 PM at makeCall (/usr/src/app/node_modules/fastseries/series.js:113:10)
10/15/2018 4:35:34 PM at ResultsHolder.release (/usr/src/app/node_modules/fastseries/series.js:94:9)
10/15/2018 4:35:34 PM
pipelines:
default:
- step:
script:
- echo "I made a pipeline!"
tags: # add the 'tags' section
release-*: # specify the tag
- step: # define the build pipeline for the tag
#python image with aws-cli installed
image: atlassian/pipelines-awscli
#/bin/bash
#origin or upstream
REMOTE=${1-origin}
REPO_URL=`git remote -v | grep -m1 "^$REMOTE" | sed -Ene's#.*([email protected]:[^[:space:]]*).*#\1#p'`
if [ -z "$REPO_URL" ]; then
echo "-- ERROR: Could not identify Repo url."
echo " It is possible this repo is already using HTTPS instead of SSH."
exit
@vahanNasibyan
vahanNasibyan / gist:dce87e34982d4efa26fbd7ad9391d7ed
Created December 13, 2018 14:27
fix permissions for subaccounts
with qa as (
Select "Permissions".id as permission_id
from "public"."permission_user" as "PermissionMap"
LEFT JOIN "public"."permission" AS "Permissions"
ON "Permissions"."id" = "PermissionMap"."permission_id"
WHERE "PermissionMap"."user_id" = 124 and "Permissions".id not in
(50, 51, 52, 53, 54, 55, 56, 57, 2, 3, 4, 5, 44, 45, 46, 47, 48, 49, 43, 42, 6, 7, 8, 9, 10, 11, 12, 28, 29, 30, 31, 32, 33, 34, 35, 13, 14, 17, 18, 16, 15, 19, 20, 21, 27, 36, 37, 38, 39, 40, 41, 25, 22, 23, 26, 24, 111, 112)
), users_t as (select id as user_id from "user" where permission_group_id = 324 and role_id !=3)
pipelines:
custom: # Pipelines that can only be triggered manually
from-commit:
- step:
#python image with aws-cli installed
image: atlassian/pipelines-awscli
services:
- docker
script:
# aws login
@vahanNasibyan
vahanNasibyan / bulk.sh
Last active May 6, 2019 15:21
Bulk API curl
curl -X POST \
https://api.zipwhip.com/bulk-messaging \
-H 'Authorization: Bearer API_KEY' \
-H 'Content-Type: application/json' \
-H 'cache-control: no-cache' \
-d '{
"requestId": "60192740-0ff9-4f9a-cf79-572bafa3ebd5",
"from": "PROVISIONED PHONE NUMBER",
"messages": [
{
curl –X POST https://api.zipwhip.com/user/login -d username=USERNAME -d password=PASSWORD