Skip to content

Instantly share code, notes, and snippets.

@zenbro
zenbro / example.sql
Last active June 27, 2017 02:05
PostgreSQL INSERT IGNORE example
CREATE OR REPLACE RULE insert_ignore_on_report_types AS
ON INSERT TO report_types
WHERE EXISTS (SELECT 1 FROM report_types WHERE id = NEW.id)
DO INSTEAD NOTHING;
INSERT INTO report_types (id, name, system_name, created_at, updated_at)
VALUES
(20, 'question', 'Иное', now(), now()),
(21, 'administration', 'Администрирование образовательной организации', now(), now()),
(22, 'administration', 'Проблемы с отчетами и выгрузками', now(), now()),
@zenbro
zenbro / crontab
Created August 16, 2016 15:05
Rake Task for Errbit: clear problems older than 7 days
30 4 * * * /bin/bash -l -c 'RAILS_ENV=production cd /home/errbit/current && rvm 2.2.1 do bundle exec rake custom:delete_old_problems >> log/clear_old_problems.log 2>> log/clear_old_problems.log'
@zenbro
zenbro / full_gem_path.rb
Created January 26, 2016 13:03
Find gem path by gem name
Gem::Specification.find_by_name('GEM_NAME').full_gem_path
@zenbro
zenbro / xdefaults_reload.sh
Created May 31, 2015 21:14
Reload .Xdefaults
xrdb ~/.Xdefaults
@zenbro
zenbro / redis_del.sh
Created May 27, 2015 14:44
Clear redis keys by specific pattern
# -n - database number
redis-cli -n 0 KEYS 'your_pattern*' | xargs redis-cli -n 0 DEL
#!/bin/bash
URL='https://duckduckgo.com/?q='
QUERY=$(echo '' | dmenu -p "Search:" -fn "-xos4-terminus-medium-r-*-*-14-*" -b)
if [ -n "$QUERY" ]; then
xdg-open "${URL}${QUERY}" 2> /dev/null
exec i3-msg [class="^Firefox$"] focus # use xprop to find class of your browser
fi
function coerceToString(val) {
return String((val === null || val === undefined) ? '' : val);
}
var rAmp = /&/g,
rLt = /</g,
rGt = />/g,
rApos = /\'/g,
rQuot = /\"/g,
hChars = /[&<>\"\']/;
openssl req -new -newkey rsa:2048 -nodes -keyout yourdomain.key -out yourdomain.csr
White:
<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7">
Black:
<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAUEBAAAACwAAAAAAQABAAACAkQBADs=">
@zenbro
zenbro / base64_to_blob.js
Created July 18, 2014 05:56
Convert Base64 string to Blob.
function base64ToBlob(b64String, callback) {
var contentType = b64String.split(',')[0].split(':')[1].split(';')[0];
var byteCharacters = atob(b64String.split(',')[1]);
var sliceSize = 512;
var byteArrays = [];
for (var offset = 0; offset < byteCharacters.length; offset += sliceSize) {
var slice = byteCharacters.slice(offset, offset + sliceSize);
var byteNumbers = new Array(slice.length);
for (var i = 0; i < slice.length; i++) {