hello_wac hellowac

## test.txt
这是我测试的Gist

## multiple_ssh_setting.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                hellowac
                / multiple_ssh_setting.md
            
            
              Created
              May 14, 2017 15:30
                — forked from jexchan/multiple_ssh_setting.md
            
              
                Multiple SSH keys for different github accounts
              
          
    Multiple SSH Keys settings for different github account

create different public key

create different ssh key according the article Mac Set-Up Git
$ ssh-keygen -t rsa -C "your_email@youremail.com"


## Git_mergetool_tutorial.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                hellowac
                / Git_mergetool_tutorial.md
            
            
              Created
              August 31, 2017 11:34
                — forked from karenyyng/Git_mergetool_tutorial_with_Vim.md
            
              
                How to use `git mergetool` to resolve conflicts 
              
          
    Table Of Content

Skip to the relevant sections if needed.

2-min tutorial to do it the quick-and-dirty-way
Concepts for resolving Git conflicts
Setting up different editors / tool for using git mergetool

Finding out what mergetool editors are supported


mergetool simple code example for vimdiff

Resolving conflict from a Git pull


Other great references and tutorials


## dango-send-file.py
from django.http import FileResponse

def get(self, request, *args, **kwargs):
    """ download file """

    zip_file = get_zip_file()
    response = FileResponse(open(zip_file, 'rb'), content_type=mimetypes.guess_type(zip_file)[0])
    response['Content-Length'] = os.path.getsize(zip_file)
    response['Content-Disposition'] = "attachment; filename=%s" % os.path.basename(zip_file)
    return response

## python-zip-files.py
import os
from os import path
import zipfile

def get_zip_files(phone):
    """ get ziped file path """

    files_dir = get_file_dir(phone)
    ziped = path.join(path.dirname(files_dir), '{}.zip'.format(phone))

## mysql.sql
-- 从另一个表中更新字段.
UPDATE tableB
  INNER JOIN tableA ON tableB.name = tableA.name
SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
WHERE tableA.name = 'Joe'

-- 更细log表中没有version的字段.
UPDATE pdv_user_crawl_statistic_log AS log
INNER JOIN triple_applicant_user_info as info
	ON log.user_phone = info.phone

## python-MySQLdb.py
# 使用SQLAlchemy的连接池
import MySQLdb
import MySQLdb.cursors
from sqlalchemy import pool

def get_read_conn():
    '''
        mysql 读的连接
    '''
    conn = MySQLdb.connect(

## mysql.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                hellowac
                / mysql.md
            
            
              Last active
              August 31, 2023 11:42
            
              
                mysql操作注意事项
              
          
多列作为唯一键时，最好指定所有的列都是不能为Null的，因为两个Null值默认是不一样的，所以会导致即使多个列除了Null值以外其他列的值相同，还是会插入数据成功.
参考: https://stackoverflow.com/questions/429805/mysql-question-unique-key-not-functioning-correctly-or-am-i-misunderstanding


## ocr.markdown

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                hellowac
                / ocr.markdown
            
            
              Created
              March 8, 2018 09:07
                — forked from henrik/ocr.markdown
            
              
                OCR on OS X with tesseract
              
          
    Install ImageMagick for image conversion:
brew install imagemagick

Install tesseract for OCR:
brew install tesseract --all-languages

Or install without --all-languages and install them manually as needed.

  
## webshell.py
#!/usr/bin/env python

import subprocess
from flask import Flask, render_template
from flask_socketio import SocketIO, send, emit

HTML = '''
<html>
    <head>
        <title>WEBSHELL</title>
	from django.http import FileResponse

	def get(self, request, args, *kwargs):
	""" download file """

	zip_file = get_zip_file()
	response = FileResponse(open(zip_file, 'rb'), content_type=mimetypes.guess_type(zip_file)[0])
	response['Content-Length'] = os.path.getsize(zip_file)
	response['Content-Disposition'] = "attachment; filename=%s" % os.path.basename(zip_file)
	return response
	import os
	from os import path
	import zipfile

	def get_zip_files(phone):
	""" get ziped file path """

	files_dir = get_file_dir(phone)
	ziped = path.join(path.dirname(files_dir), '{}.zip'.format(phone))
	-- 从另一个表中更新字段.
	UPDATE tableB
	INNER JOIN tableA ON tableB.name = tableA.name
	SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
	WHERE tableA.name = 'Joe'

	-- 更细log表中没有version的字段.
	UPDATE pdv_user_crawl_statistic_log AS log
	INNER JOIN triple_applicant_user_info as info
	ON log.user_phone = info.phone
	# 使用SQLAlchemy的连接池
	import MySQLdb
	import MySQLdb.cursors
	from sqlalchemy import pool

	def get_read_conn():
	'''
	mysql 读的连接
	'''
	conn = MySQLdb.connect(
	#!/usr/bin/env python

	import subprocess
	from flask import Flask, render_template
	from flask_socketio import SocketIO, send, emit

	HTML = '''
	<html>
	<head>
	<title>WEBSHELL</title>