2015-10-21
- jennifer
- martym
version: 2.1 | |
orbs: | |
jira: circleci/jira@1.0.5 | |
workflows: | |
build_test_check_deploy: | |
jobs: | |
- test: | |
context: development |
ARG PYTHON_VERSION=3.7.2-alpine | |
FROM python:${PYTHON_VERSION} as base | |
WORKDIR /app | |
RUN apk add --no-cache \ | |
build-base | |
COPY Pipfile Pipfile.lock ./ |
def label_datapoints(axes, percent=False): | |
if percent: | |
precision = 2 | |
extra = '%' | |
else: | |
precision = 0 | |
extra = '' | |
for patch in axes.patches: | |
axes.text(x=patch.get_x() + patch.get_width() / 2., | |
y=patch.get_height(), |
def label_datapoints(axes, percent=False): | |
if percent: | |
precision = 2 | |
extra = '%' | |
else: | |
precision = 0 | |
extra = '' | |
for patch in axes.patches: | |
axes.text(x=patch.get_x() + patch.get_width() / 2., | |
y=patch.get_height(), |
from sqlalchemy.dialects import postgresql | |
query.statement.compile( | |
dialect=postgresql.dialect(), | |
compile_kwargs={"literal_binds": True})) |
I hereby claim:
To claim this, I am signing this object:
** Find commmonly accessed tables and their use of indexes: | |
SELECT relname,seq_tup_read,idx_tup_fetch,cast(idx_tup_fetch AS numeric) / (idx_tup_fetch + seq_tup_read) AS idx_tup_pct FROM pg_stat_user_tables WHERE (idx_tup_fetch + seq_tup_read)>0 ORDER BY idx_tup_pct; | |
Returns output like: | |
relname | seq_tup_read | idx_tup_fetch | idx_tup_pct | |
----------------------+--------------+---------------+------------------------ | |
schema_migrations | 817 | 0 | 0.00000000000000000000 | |
user_device_photos | 349 | 0 | 0.00000000000000000000 |
# usage: create_sftp_user <username> | |
function create_sftp_user() { | |
# create user | |
sudo adduser --disabled-password --gecos "" $1 | |
# prevent ssh login & assign SFTP group | |
sudo usermod -g sftpaccess $1 | |
sudo usermod -s /bin/nologin $1 | |
# chroot user (so they only see their directory after login) |