Skip to content

Instantly share code, notes, and snippets.

@movEAX
movEAX / gist:d128a9602cf93e3dba2e
Created August 31, 2014 16:21
Postgresql: PL/Python trigger for logging row changes.
CREATE EXTENSION plpython2u;
-- TODO:
-- 1) Кэш соединения с ZMQ
-- 2) Найти оптимальный способ сериализаци данных
-- 3) Рассмотреть вариант с LISTEN/NOTIFY и PGQ
CREATE OR REPLACE FUNCTION row_trigger()
RETURNS TRIGGER
AS $$
import json, zmq
@movEAX
movEAX / ipython_load_django_model
Created July 11, 2014 20:59
Расширение для IPython, позволяющее подгружать модели на лету, без импортов.
from IPython import Magics, magics_class, line_magic
from django.db.models import get_model
@magics_class
class ModelSearchMagics(Magics):
@line_magic
def model(self, app_label, model_name):
model_class = get_model(app_label, model_name)
self.shell.user_ns[model_class.__name__] = model_class
@movEAX
movEAX / gist:b8c9e6b83acc44dc5c80
Created June 15, 2014 21:12
Asyncio interactive subprocess communication, where subprocess is python script.
'''
test.py look like this::
msg = 'prompt'
for i in range(1, 4):
msg = input(msg * i + '\n')
'''
import sys
import asyncio
@movEAX
movEAX / demixer
Created March 6, 2014 19:06
demixer note
#!/usr/bin/env python3
import re
def demixer(iid, p):
return ''.join(re.findall(r'[\da-f]+',p)[::iid%1or-1])[::3]
if __name__ == '__main__':
print(demixer(291703670, 'b538f45188e082b038dad37e22466097861cef6sd4ff355e16dd279e973ddb1esce7adad83bb220e081s06fac1187c06a42'))
~
@movEAX
movEAX / gist:7794950
Last active December 30, 2015 07:19
Hg 'commit' hook implementation for auto comment link of changeset to redmine./path/to/project/.hg/hgrc[hooks]commit.autocomment = python:path/to/script.py:comment_to_redmine[redmine]url = https://...key = note = some note https://.../changeset/{rev}
# coding: utf-8
#------------------------------------------------------------------------------
# Imports
#------------------------------------------------------------------------------
# Stdlib
import os
import re
# 3rdparty