Skip to content

Instantly share code, notes, and snippets.

Avatar

Mike Paszkiewicz mikepaszkiewicz

View GitHub Profile
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
View gist:2c2829efd08d16cd3637f9310829d82a
{
"Ansi 2 Color" : {
"Green Component" : 0.73333334922790527,
"Red Component" : 0,
"Blue Component" : 0
},
"Tags" : [
],
"Ansi 12 Color" : {
@mikepaszkiewicz
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
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('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 {
View keybase.md

Keybase proof

I hereby claim:

  • I am mikepaszkiewicz on github.
  • I am mikepasz (https://keybase.io/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
Bug:
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/setup.py';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: https://github.com/mikepaszkiewicz/staffing.tryhabitat.com#required-and-optional-services
curl --user API_KEY: http://staffing.tryhabitat.com/api/v2/internal/cron/
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/app.py", line 1473, in full_dispatch_request rv = self.preprocess_request()
File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1666, in preprocess_request rv = func()
@mikepaszkiewicz
mikepaszkiewicz / docker_install.sh
Created Jul 11, 2017
Installing docker on fresh server
View docker_install.sh
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add - &&
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(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 https://dispatch.tryhabitat.com/api/v1/rates/ \
-H 'cache-control: no-cache' \
-H 'Content-Type: application/json' \
-d '{ "api_key": "YOUR_API_KEY",
"vendorId": "VENDOR_ID",
"destination": "ADDRESS_OR_COORDS"
"bagCount": "NUMBER_OF_DELIVERY_BAGS"
"allowedTransport": "[Walk,Skate,Bike,DeliveryBike,Car,Van]"
}'
@mikepaszkiewicz
mikepaszkiewicz / dispatch.menus.get
Last active Jun 26, 2017
Fetch a vendor menu from habitat
View dispatch.menus.get
// vendorId is optional, and will return an array of all menus if not present
curl -X GET https://dispatch.tryhabitat.com/api/v1/menus/ \
-H 'cache-control: no-cache' \
-H 'Content-Type: application/json' \
-d '{ "api_key": "YOUR_API_KEY", "vendorId": "VENDOR_ID" }'
// returns the following:
{
"_id" : "qkfHaEFiL2oTDgJts",
You can’t perform that action at this time.