Skip to content

Instantly share code, notes, and snippets.

View bluethon's full-sized avatar
🤣
free

Haibo Jia bluethon

🤣
free
18 followers · 20 following
  • Beijing, China
View GitHub Profile
@bluethon
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
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
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
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
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
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
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
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
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
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])