Skip to content

Instantly share code, notes, and snippets.


Mike Paszkiewicz mikepaszkiewicz

View GitHub Profile
View gist:13fcfb104ba6f52ec0c6e16b35b1c80a
with x as (select, transactions.runner_id, transactions.runner_obj, transactions.created_at from transactions
left outer join users
on = transactions.runner_id
where transactions.runner_id is not null
and is null)
select distinct runner_id from x
View gist:2c2829efd08d16cd3637f9310829d82a
"Ansi 2 Color" : {
"Green Component" : 0.73333334922790527,
"Red Component" : 0,
"Blue Component" : 0
"Tags" : [
"Ansi 12 Color" : {
mikepaszkiewicz / gist:073440a413f71b37b1160db892ff9705
Created Jan 4, 2018
Snips: PostgreSQL - Create searchable text index on integer field
View gist:073440a413f71b37b1160db892ff9705
create index concurrently on transactions (order_number) USING GIN(order_number::text gin_trgm_ops)
mikepaszkiewicz / send.js
Created Jan 3, 2018
Raiblocks add send block to account
View send.js
//NOTE: Connection = promisified wrapper around RPC calls...methods map directly to RPC 'action' parameter
import Rai from '../server/util/rai'
const Connection = Rai('', 7076) //node IP and port
const RECEIVING_WALLET = 'xrb_...'
async function sendBlock() {
try {

Keybase proof

I hereby claim:

  • I am mikepaszkiewicz on github.
  • I am mikepasz ( on keybase.
  • I have a public key whose fingerprint is A22A 9F13 58D2 57B8 10CE 9584 3A0D 55B7 3902 58E4

To claim this, I am signing this object:

View gist:fd7023dc6c6f0c60203dcd7e78ee825c
python 2.7, pip 8.1.1, Ubuntu 16.04
pip install as jenkins user throws:
Command /usr/bin/python -c "import setuptools, tokenize;__file__='/tmp/pip_build_root/cryptography/';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /tmp/pip-eHn5Qu-record/install-record.txt --single-version-externally-managed --compile failed with error code 1 in /tmp/pip_build_root/cryptography
Storing debug log for failure in /root/.pip/pip.log
The command '/bin/sh -c cd /src; pip install -r requirements.txt' returned a non-zero code: 1
Build step 'Execute shell' marked build as failure
View gist:e118d90d751ade830d8aaf5e80e8b4dc
Staffjoy Suite Cron Docs:
curl --user API_KEY:
Server Error on cron run:
ERROR Exception on /api/v2/organizations/1/locations/2/roles/3/users/182
[GET] Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/flask/", line 1473, in full_dispatch_request rv = self.preprocess_request()
File "/usr/local/lib/python2.7/dist-packages/flask/", line 1666, in preprocess_request rv = func()
curl -XPOST '' -H "Content-type: application/json" -d '{
"externalId": 1876,
"externalVendorId": 101,
"sellerId": "gRWS4txHe3g43AtNm",
"method": "Delivery",
"deliveryAddress": "2198 N Broad St",
"status": "pending_runner",
"name": "Tyler Wiest",
"phone": "2169052356",
mikepaszkiewicz /
Created Jul 11, 2017
Installing docker on fresh server
curl -fsSL | sudo apt-key add - &&
sudo add-apt-repository "deb [arch=amd64] $(lsb_release -cs) stable" &&
sudo apt-get update &&
apt-cache policy docker-ce &&
sudo apt-get install -y docker-ce &&
sudo systemctl status docker &&
sudo usermod -aG docker jenkins &&
su - jenkins
View dispatch.rates.get
curl -X GET \
-H 'cache-control: no-cache' \
-H 'Content-Type: application/json' \
-d '{ "api_key": "YOUR_API_KEY",
"vendorId": "VENDOR_ID",
"destination": "ADDRESS_OR_COORDS"
"allowedTransport": "[Walk,Skate,Bike,DeliveryBike,Car,Van]"
You can’t perform that action at this time.