Skip to content

Instantly share code, notes, and snippets.

View jamiesun's full-sized avatar
🍇
On vacation

Jett Wang jamiesun

🍇
On vacation
View GitHub Profile
@jamiesun
jamiesun / gensql.py
Created September 21, 2012 10:30
gensql
#coding:utf-8
def gensql(table,dicts):
with open("%s.table.sql"%table,'w') as buff:
for sqlobj in dicts:
ks,vs = '',''
for k,v in sqlobj.items():
ks += '%s,'%k
vs += '\'%s\','%v
sql = "insert into %s (%s) values(%s);"%(table,ks[:-1],vs[:-1])
print >> buff,sql
@jamiesun
jamiesun / export.py
Created September 21, 2012 10:21
oracle export data
#coding:utf-8
import sys
import cx_Oracle
import csv
print '请输入要导出的数据库地址,格式:user/passwd@host:port/sid :'.decode('utf-8')
db = len(sys.argv)>=2 and sys.argv[1] or raw_input('Enter db(user/passwd@host:port/sid):')
connection = cx_Oracle.Connection(db)
@jamiesun
jamiesun / gist:3741546
Created September 18, 2012 06:21
pyqt and gevent
# -*- coding: utf-8 -*-
"""The user interface for our app"""
import os,sys
import gevent
# Import Qt modules
from PyQt4 import QtCore,QtGui
@jamiesun
jamiesun / __init__.py
Created September 15, 2012 03:51 — forked from ipconfiger/__init__.py
OAuth包,实现了sina,QQ,网易,搜狐的OAuth认证
# -*- Encoding: utf-8 -*-
import base64
import binascii
import cgi
import hashlib
import hmac
import logging
import time
import urllib
import urlparse
@jamiesun
jamiesun / socks.py
Created September 10, 2012 09:53
SocksiPy - Python SOCKS module.
SocksiPy - Python SOCKS module.
@jamiesun
jamiesun / fock
Created September 9, 2012 15:02
python fork os.pipe()
#!/usr/bin/env python
import os, sys
print "I'm going to fork now - the child will write something to a pipe, and the parent will read it back"
r, w = os.pipe() # r,w是文件描述符, 不是文件对象
pid = os.fork()
if pid:
# 父进程
os.close(w) # 关闭一个文件描述符
r = os.fdopen(r) # 将r转化为文件对象
print "parent: reading"
#####################################################################
# COPY FROM http://www.gnome.org/~jdub/bzr/planet/2.0/planet/htmltmpl.py
# and inspired from http://www.python.org/pypi/zc.lockfile
# LICENSE: BSD
# Modified by: Limodou(limodou@gmail.com)
#####################################################################
__all__ = ['LOCK_EX', 'LOCK_SH', 'LOCK_UN', 'lock_file', 'unlock_file',
'LockFile', 'LockError']
@jamiesun
jamiesun / proxyserver
Created September 9, 2012 12:50
gevent实现基于端口转发的http代理服务器
import sys
import signal
import urlparse
import gevent
from gevent.server import StreamServer
from gevent.socket import create_connection, gethostbyname
class ProxyServer(StreamServer):
def __init__(self, listener, **kwargs):
@jamiesun
jamiesun / gevent-multiprocess
Created September 8, 2012 10:35
gevent wsgi服务器定义,可利用多进程
class GEventServer():
""" gevent wsgi服务器定义,可利用多进程
"""
def __init__(self,handler,host,port):
self.handler = handler
self.host = host
self.port = port
def start(self):
@jamiesun
jamiesun / batch2utf8.py
Created July 19, 2012 10:36
批量转换一个目录下的文件到utf8
#!/usr/bin/python
#codeing:utf-8
import os
from optparse import OptionParser
if __name__ == "__main__":
usage = "usage: %prog [options] arg"
parser = OptionParser(usage)