Skip to content

Instantly share code, notes, and snippets.

@youqingkui
youqingkui / urlparse.py
Last active September 17, 2015 06:39 — forked from zhenyi2697/urlparse.py
Python: urlparse demo
#!/usr/bin/python
# The urlparse module provides functions for breaking URLs down into their
# component parts, as defined by the relevant RFCs.
from urlparse import urlparse
# PARSING
parsed = urlparse('http://user:pass@NetLoc:80/path;parameters?query=argument#fragment')
@youqingkui
youqingkui / order_by_count.py
Created August 14, 2015 01:43
MySQL按照记录条数排序
# SELECT * , count(desire_id) AS num
# FROM desire_tran
# GROUP BY desire_id
# ORDER BY num DESC
q = q.filter(DesireInfo.desire_id == DesireTran.desire_id).filter(DesireTran.is_real == 1)\
.group_by(DesireInfo.desire_id).distinct()
@youqingkui
youqingkui / socket.nginx
Last active August 29, 2015 14:27
nginx代理websocket
server {
listen 80;
server_name your domain name;
location / {
proxy_pass http://localhost:3002; #填写程序端口地址
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header Host $host;
@youqingkui
youqingkui / readImage.coffee
Last active August 29, 2015 14:27
node保存远程图片到本地
async.waterfall [
(callback) ->
op = {
url:self.url
encoding:'binary'
}
request.get op, (err, res, body) ->
return console.log err if err
mimeType = res.headers['content-type']
@youqingkui
youqingkui / hd_info.py
Last active November 14, 2017 04:15
使用Python查看磁盘大小信息
import os
def disk_stat(folder):
"""
查看文件夹占用磁盘信息
:param folder: 文件夹路径
:return:
"""
hd={}
@youqingkui
youqingkui / web_img.py
Last active August 29, 2015 14:25
访问路由,读取本地图片文件并返回
import os
from flask make_response
file_path = os.path.join(os.getcwd(), 'app/templates/email/shadow_img.png')
img_content = 'image/png'
log_debug(file_path)
img = open(file_path).read()
response = make_response(img)
response.headers['Content-Type'] = img_content
return response
@youqingkui
youqingkui / SQLALCHEMY LEFT JOIN.py
Last active August 29, 2015 14:25
SQLALCHEMY 外联结
# SQLALCHEMY LEFT JOIN
db.session.query(PushHistory, CronPublish).\
outerjoin(CronPublish, and_(CronPublish.tid == PushHistory.id, CronPublish.ttype == 4))
@youqingkui
youqingkui / 连接印象笔记.py
Last active August 29, 2015 14:25
个人token连接印象笔记
# 从源代码看,连接印象笔记是需要设置service_host,这个在官方文档上门没有指出。
from evernote.api.client import EvernoteClient
token = "your dev token"
client = EvernoteClient(token=dev_token,sandbox=False)
client.service_host = 'app.yinxiang.com'
userStore = client.get_user_store()
user = userStore.getUser()
print user