Skip to content

Instantly share code, notes, and snippets.

View cosven's full-sized avatar
🍊

Shaowen Yin cosven

🍊
View GitHub Profile
@cosven
cosven / bench_result_analysis.py
Created June 28, 2019 05:29
sysbench 结果统计
import os
import re
from collections import defaultdict
def get_query_per_sec(line):
"""
>>> s = 'queries: 17493427 (58309.95 per sec.)'
>>> get_query_per_sec(s)
@cosven
cosven / .fuorc
Last active July 2, 2019 09:45
简单的让 feeluown 支持下载 DEMO(请自行安装 feeluown-download)
# -*- mode: Python; -*-
# vi: ft=python
import os
# 自定义配置
# config.THEME = 'dark'
config.COLLECTIONS_DIR = '~/Dropbox/public/music'
config.AUDIO_SELECT_POLICY = '>>>'
@cosven
cosven / iterm2-profile-fuo-lyrics-window.json
Created July 24, 2019 06:42
iTerm2 window as a FeelUOwn Client Window
{
"Working Directory" : "\/Users\/yinshaowen",
"Prompt Before Closing 2" : false,
"Selected Text Color" : {
"Green Component" : "0",
"Red Component" : "0",
"Blue Component" : "0"
},
"Rows" : 2,
"Ansi 11 Color" : {
@cosven
cosven / extract_sql.py
Created November 14, 2019 13:38
parse sql statements from general logs
#!/usr/bin/env python3
import re
def get_key_value(key, line):
"""get key's value in log line"""
p = re.compile(r'\[{}\='.format(key))
m = p.search(line)
if m is None:
@cosven
cosven / t.py
Last active October 28, 2020 05:15
导出网易云音乐歌单到 fuo 文件
"""
Usage:
1. 在 FeelUOwn 中登录网易云
2. fuo exec < t.py
"""
from fuo_netease import provider
from fuocore.models.uri import reverse
from fuocore.cmds.helpers import show_song
@cosven
cosven / youtube_provider.py
Created February 6, 2020 06:45
FeelUOwn YouTube provider
import os
import time
import json
import subprocess
from fuocore.provider import AbstractProvider
from fuocore.models import SongModel
no_proxy_list = [
@cosven
cosven / test.py
Last active February 10, 2020 07:53
profiling playlist_add fuocore.SongModel
import cProfile
from fuocore.models import SongModel
songs_10k = [SongModel(identifier=i) for i in range(0, 4000)]
songs = []
def playlist_add(song):
if song not in songs:
songs.append(song)
@cosven
cosven / test.markdown
Created February 15, 2020 04:12
cmd 支持不同格式输出 - 方案性能对比

简单的测试了下时间,目前 4k 首歌曲,大概是这么个情况。

In [16]: start = time.time()
    ...: get_dumper('json').dump(songs)
    ...: print(time.time() - start)
0.3063631057739258

In [17]: start = time.time()
 ...: get_dumper('json').dump(songs)
@cosven
cosven / run_sql.py
Last active February 25, 2020 09:01
一个方便测试 sql 的脚本,配合 ipython notebook 使用味道更佳...
"""
这个脚本的好处:运行 sql 并能看到 sql 的输出,输出格式类似 mysql client。
比如,运行下面这个脚本,会有如下输出。
```
i j
1 3
(1062, "Duplicate entry '1' for key 'PRIMARY'")
i j
1 2
@cosven
cosven / .fuorc.py
Created May 13, 2020 16:41
example
# -*- mode: Python; -*-
# vi: ft=python
import json
import os
import threading
from functools import partial
config.AUDIO_SELECT_POLICY = 'sq>>>'