Skip to content

Instantly share code, notes, and snippets.

@allenyang79
allenyang79 / monitor-psql-db.py
Created October 27, 2017 02:23
monitor psql db
import sys
import psycopg2
import psycopg2.extras
conn = psycopg2.connect("host=localhost port=5433 dbname=keycloak user=keycloak password=keycloak")
with conn.cursor(cursor_factory=psycopg2.extras.DictCursor) as cur:
cur.execute('show pool_nodes')
result = cur.fetchall()
result = sorted(result, key=lambda x:x['hostname'])
#print result
@allenyang79
allenyang79 / KeepServerBusy.js
Last active November 2, 2017 02:25
keep mongod busy #mongo
db.monitoringTest.drop()
while(true) {
for(i = 0; i < 1000 ; i++) {
db.monitoringTest.insert({'i':i})
}
for(i = 0; i < 1000 ; i++) {
db.monitoringTest.update({'i':i}, {$set:{'text':'text'}})
}
cursor = db.monitoringTest.find()
while(cursor.hasNext()) {
@allenyang79
allenyang79 / flask-session.py
Created October 11, 2017 04:03
test flask session config
# -*- coding: utf-8 -*-
from flask import Flask, session
app = Flask(__name__)
app.config['SECRET_KEY']= 'session123'
app.config['SESSION_COOKIE_PATH'] = '/count/deep'
@allenyang79
allenyang79 / remove-end-empty-lines.vim
Last active November 2, 2017 02:26
vim remove end empty line #vim
function TrimEndLines()
let cursor = getpos(".")
:%s#\($\n\s*\)\+\%$##
call setpos('.', cursor)
endfunction
au BufWritePre *.py call TrimEndLines()
@allenyang79
allenyang79 / pipe-01.py
Last active October 12, 2017 06:02
message queue by pipe.
import time
import logging
from multiprocessing import Process, Pipe, Queue
logging.basicConfig(level=logging.DEBUG, format='%(asctime)s|%(levelname)-5.5s|%(processName)-10s| %(message)s')
logger = logging.getLogger()
def master():
logger.info('master start')
@allenyang79
allenyang79 / wrapt-usage.py
Last active September 23, 2017 04:42
practice decorate by wrapt
import wrapt
import inspect
@wrapt.decorator
def pass_through(wrapped, instance, args, kwargs):
print "call pass_through", wrapped, instance
return wrapped(*args, **kwargs)
@allenyang79
allenyang79 / job-queue.py
Last active September 23, 2017 04:43
job/worker pattern of python
# -*- coding: utf-8 -*-
import os
import time
import random
import logging
from multiprocessing import Process, Queue
#formatter = logging.Formatter('%(asctime)s %(levelname)s %(message)s')
logging.basicConfig(level=logging.DEBUG, format='%(asctime)s|%(levelname)4s|%(processName)-10s| %(message)s')
logger = logging.getLogger()

docker stack deploy a multi overlay network with mutli service.

@allenyang79
allenyang79 / 0_openpyxl.md
Last active September 13, 2017 08:45
openpyxl partice

動態render cells 透用style, merged.

@allenyang79
allenyang79 / memorize.py
Last active November 2, 2017 02:18
python memorize function for cache
import functools
import inspect
import time
import random
def memorize(keyfn, scenario='default', timeout=300):
def wrapper(fn):
_cached = {}