zealinux

# https://www.studytonight.com/post/converting-xlsx-file-to-csv-file-using-python
# pip install openpyxl

## XLSX TO CSV
import openpyxl

filename = 'appending.xlsx'

## opening the xlsx file
xlsx = openpyxl.load_workbook(filename)

zealinux

# https://github.com/scanny/python-pptx/issues/281
paragraph = text_frame.paragraphs[0]
paragraph.text = text
font = paragraph.font
font.color.rgb = RGBColor(...)

zealinux

Ruby の HTTP クライアントライブラリ Faraday が便利そう

Ruby の HTTP クライアントライブラリ Faraday が便利そう

API ラッパの開発には [RestClient gem][rest_client_gem] だとか
OAuth の必要なものは [Net/HTTP][net_http] + [OAuth gem][oauth_gem] を使ってた

[Twitter gem][twitter_gem] や [Instagram gem][instagram_gem] など API ライブラリのソースを読んでみると
[Faraday gem][faraday_gem] というものがよく使われてた

zealinux

# <类型>: (类型的值见下面描述) <主题> (最多50个字)

# 解释为什么要做这些改动
# |<----  请限制每行最多72个字   ---->|

# 提供相关文章和其它资源的链接和关键字
# 例如: Github issue #23

# --- 提交 结束 ---
# 类型值包含

zealinux

import io

from PIL import Image  # https://pillow.readthedocs.io/en/4.3.x/
import requests  # http://docs.python-requests.org/en/master/


# example image url: https://m.media-amazon.com/images/S/aplus-media/vc/6a9569ab-cb8e-46d9-8aea-a7022e58c74a.jpg
def download_image(url, image_file_path):
    r = requests.get(url, timeout=4.0)
    if r.status_code != requests.codes.ok:

zealinux

CREATE OR REPLACE FUNCTION random_int_array(dim integer, min integer, max integer) RETURNS integer[] AS $BODY$
begin
	return (select array_agg(round(random() * (max - min)) + min) from generate_series (0, dim));
end
$BODY$ LANGUAGE plpgsql;

-- usage example
select random_int_array(15, 6, 40);

-- return example

zealinux

The basic idea here is to substantiate the claims made by this square post:
http://corner.squareup.com/2011/06/postgresql-data-is-important.html

In PostgreSQL, and MySQL (MyISAM and InnoDB) I create millions of rows and then add 
and remove columns and add and remove indexes.  For columns without defaults this is
basically free in PostgreSQL and O(n) in MySQL.  For adding indexes its at best O(n) 
everywhere, but with PostgreSQL it claims not to do any locking that would otherwise
prevent table interaction.

Also, PostgreSQL has _awsome_ documentation (it has real examples!). I always get 

zealinux

Org-mode Org-mode Reference Card

Org mode reference card

Created from the plain text reference card on orgmode.org Download this file, and open it in Emacs org-mode!

zealinux

注意：本文内容适用于 Tmux 2.3 及以上的版本，但是绝大部分的特性低版本也都适用，鼠标支持、VI 模式、插件管理在低版本可能会与本文不兼容。

Tmux 快捷键 & 速查表

启动新会话：

tmux [new -s 会话名 -n 窗口名]

恢复会话：

zealinux

def merge_dicts(*dict_args):
    """
    Given any number of dicts, shallow copy and merge into a new dict,
    precedence goes to key value pairs in latter dicts.
    """
    result = {}
    for dictionary in dict_args:
        result.update(dictionary)
    return result