bluethon’s gists

bluethon / install-oh-my-zsh.sh

Created September 7, 2018 08:09 — forked from hewerthomn/install-oh-my-zsh.sh

Offline install of oh-my-zsh on Ubuntu

	main() {
	# Use colors, but only if connected to a terminal, and that terminal
	# supports them.
	if which tput >/dev/null 2>&1; then
	ncolors=$(tput colors)
	fi
	if [ -t 1 ] && [ -n "$ncolors" ] && [ "$ncolors" -ge 8 ]; then
	RED="$(tput setaf 1)"
	GREEN="$(tput setaf 2)"
	YELLOW="$(tput setaf 3)"

bluethon / ttc2ttf.py

Created July 17, 2018 09:21 — forked from johnko/ttc2ttf.py

ttc2ttf

	#!/usr/bin/env python3
	# -- coding: utf-8 --

	#First released as C++ program by Hiroyuki Tsutsumi as part of the free software suite “Beer”
	#I thought porting it to Python could be both a challenge and useful

	from sys import argv, exit, getsizeof
	from struct import pack_into, unpack_from

	def ceil4(n):

bluethon / alembic_添加列自动产生Mysql的AFTER.py

Created September 5, 2017 16:01

From https://graycarl.me/wiki/alembic

	# in env.py
	from sqlalchemy.ext.compiler import compiles
	from alembic.ddl.base import AddColumn, alter_table, add_column

	@compiles(AddColumn)
	def visit_add_column(element, compiler, **kw):
	sql = "%s %s" % (
	alter_table(compiler, element.table_name, element.schema),
	add_column(compiler, element.column, **kw)
	)

bluethon / git_proxy_socks5.sh

Created January 18, 2017 08:25

设置git使用socks5代理

	git config --global http.proxy 'socks5://127.0.0.1:1080'

	git config --global https.proxy 'socks5://127.0.0.1:1080'

bluethon / git 设置和取消代理

Created December 12, 2016 13:04 — forked from laispace/git 设置和取消代理

	git config --global https.proxy http://127.0.0.1:1080

	git config --global https.proxy https://127.0.0.1:1080

	git config --global --unset http.proxy

	git config --global --unset https.proxy


	npm config delete proxy

bluethon / custom_admin_add_foreignkey_order.py

Created November 25, 2016 10:01

From http://stackoverflow.com/questions/8992865/django-admin-sort-foreign-key-field-list 自定义admin中add下拉对象的顺序

	class MyModelAdmin(admin.ModelAdmin):
	def formfield_for_foreignkey(self, db_field, request, **kwargs):
	if db_field.name == "school":
	kwargs["queryset"] = School.objects.order_by('name')
	return super(MyModelAdmin, self).formfield_for_foreignkey(db_field, request, **kwargs)

bluethon / django_admin_all_fields_readonly.py

Created November 3, 2016 06:44

From http://stackoverflow.com/questions/13817525/django-admin-make-all-fields-readonly 使admin中所有字段只读

	class CustomAdmin(admin.ModelAdmin):
	def get_readonly_fields(self, request, obj=None):
	# ...

	return [f.name for f in self.model._meta.fields]

bluethon / django_migration_cannot_cast_type.py

Created November 1, 2016 03:22

From http://stackoverflow.com/questions/22311427/django-south-migration-cant-cast-the-column-type-wants-me-to-use-using 修改CASE 到END部分从`sqlmigrate app 0003`中获取sql语句

	# Changing field 'MyTable.associated'
	# db.alter_column(u'data_mytable', 'associated',
	# self.gf('django.db.models.fields.IntegerField')()
	# )
	db.execute(
	'ALTER TABLE "data_mytable" '
	'ALTER COLUMN "associated" DROP DEFAULT, '
	'ALTER COLUMN "associated" DROP NOT NULL, '
	'ALTER COLUMN "associated" TYPE INTEGER '
	'USING '

bluethon / django_sentry_settings.py

Last active October 30, 2016 08:16

From https://micropyramid.com/blog/using-sentry-to-track-django-live-events/ add these to the settings.py

	RAVEN_CONFIG = {
	'dsn': '<your-dsn-here>',
	}

	LOGGING = {
	'version': 1,
	'disable_existing_loggers': True,
	'root': {
	'level': 'WARNING',
	'handlers': ['sentry'],

bluethon / django_execute_sql.py

Created October 16, 2016 04:58

django执行SQL语句

	from django.db import connection, transaction

	cursor = connection.cursor() # 获得一个游标(cursor)对象
	cursor.execute('update order_invoiceinfo set type = 1')
	transaction.commit() # 提交到数据库
	# # 更新操作
	# cursor.execute('update other_other2 set name ="李四" where id=%s', [3]) # 执行sql语句
	# transaction.commit_unless_managed() # 提交到数据库
	# # 查询操作
	# cursor.execute('select * from other_other2 where id>%s', [1])

Haibo Jia bluethon