I provide you with 3 jq lib functions that will help you in converting between snake_case and CamelCase.
I want to change keys in my json from camelcase to snake_case.
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| CI=drone | |
| CI_BUILD_CREATED=1538244194 | |
| CI_BUILD_EVENT=pull_request | |
| CI_BUILD_FINISHED=1538244196 | |
| CI_BUILD_LINK=https://github.com/rchain-drone/droneci-test/pull/2 | |
| CI_BUILD_NUMBER=2 | |
| CI_BUILD_STARTED=1538244194 | |
| CI_BUILD_STATUS=success | |
| CI_COMMIT_AUTHOR=woky | |
| CI_COMMIT_AUTHOR_AVATAR=https://avatars0.githubusercontent.com/u/620147?v=4 |
| package ciphers | |
| import ( | |
| "crypto/rand" | |
| "crypto/rsa" | |
| "crypto/sha512" | |
| "crypto/x509" | |
| "encoding/pem" | |
| "log" | |
| ) |
The standard names for indexes in PostgreSQL are:
{tablename}_{columnname(s)}_{suffix}
where the suffix is one of the following:
pkeyfor a Primary Key constraint;keyfor a Unique constraint;exclfor an Exclusion constraint;idxfor any other kind of index;
| package main | |
| import ( | |
| "crypto/tls" | |
| "encoding/json" | |
| "fmt" | |
| "log" | |
| "net" | |
| "net/http" | |
| ) |
| SHELL := /bin/bash | |
| REV := $(shell git rev-parse HEAD) | |
| CHANGES := $(shell test -n "$$(git status --porcelain)" && echo '+CHANGES' || true) | |
| TARGET := packer-provisioner-itamae-local | |
| VERSION := $(shell cat VERSION) | |
| OS := darwin freebsd linux openbsd | |
| ARCH := 386 amd64 |
| #!/bin/sh | |
| ### | |
| # SOME COMMANDS WILL NOT WORK ON macOS (Sierra or newer) | |
| # For Sierra or newer, see https://github.com/mathiasbynens/dotfiles/blob/master/.macos | |
| ### | |
| # Alot of these configs have been taken from the various places | |
| # on the web, most from here | |
| # https://github.com/mathiasbynens/dotfiles/blob/5b3c8418ed42d93af2e647dc9d122f25cc034871/.osx |