given a database named db:
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname='db'
AND state = 'idle in transaction'
# use ImageMagick convert | |
# the order is important. the density argument applies to input.pdf and resize and rotate to output.pdf | |
convert -density 90 input.pdf -rotate 0.5 -attenuate 0.2 +noise Multiplicative -colorspace Gray output.pdf |
# based on https://gist.github.com/blueyed/4fb0a807104551f103e6 | |
# and on https://gist.github.com/TauPan/aec52e398d7288cb5a62895916182a9f (gistspection!) | |
from django.core.management import call_command | |
from django.db import connection | |
from django.db.migrations.executor import MigrationExecutor | |
import pytest | |
#!/bin/bash | |
# This is free and unencumbered software released into the public domain. | |
# | |
# This script is designed to be run daily by cron. Please run it with randomness in its timing to | |
# avoid load spikes at Let's Encrypt. One example, running between midnight at 2 AM, would be: | |
# | |
# 0 0 * * * sleep $[(RANDOM % 115)+5]m ; /usr/sbin/letsencrypt-renew.sh | |
# | |
# If you aren't using Nginx, adjust the startServer and stopServer methods to suit. Also, you could | |
# use the webroot method. |
# -*- coding: utf-8 -*- | |
import codecs | |
import subprocess | |
from fdfgen import forge_fdf | |
from django.core.exceptions import ImproperlyConfigured | |
from django.template import engines | |
from django.template.backends.base import BaseEngine | |
from django.template.engine import Engine, _dirs_undefined |
# Hello, and welcome to makefile basics. | |
# | |
# You will learn why `make` is so great, and why, despite its "weird" syntax, | |
# it is actually a highly expressive, efficient, and powerful way to build | |
# programs. | |
# | |
# Once you're done here, go to | |
# http://www.gnu.org/software/make/manual/make.html | |
# to learn SOOOO much more. |
set realname = "Scott Burlington" | |
set from = "[email protected]" | |
set imap_user = "[email protected]" | |
set imap_pass = "XXX" | |
set smtp_url = "smtp://[email protected]@smtp.gmail.com:587/" | |
set smtp_pass = "XXX" | |
set folder = imaps://imap.gmail.com/ | |
set spoolfile = "+INBOX" | |
set postponed = "+[Gmail]/Drafts" |
given a database named db:
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname='db'
AND state = 'idle in transaction'
class FieldSelectionMixin(object): | |
""" | |
add ability to Resource to query specific fields. This works by | |
removing any fields not in the fields list provided by the fields | |
query parameter. | |
Programming Use: | |
class MyResource(FieldSelectionMixin, ModelResource): | |
... | |
(as with any normal resource) |
# maybe.py - a Pythonic implementation of the Maybe monad | |
# Copyright (C) 2014. Senko Rasic <[email protected]> | |
# | |
# Permission is hereby granted, free of charge, to any person obtaining a copy | |
# of this software and associated documentation files (the "Software"), to deal | |
# in the Software without restriction, including without limitation the rights | |
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
# copies of the Software, and to permit persons to whom the Software is | |
# furnished to do so, subject to the following conditions: | |
# |