Skip to content

Instantly share code, notes, and snippets.

@zealinux
zealinux / mysql-to-csv.py
Last active January 9, 2019 04:02
mysql data to csv
# requirement: python-mysqldb
import MySQLdb as dbapi
import sys
import csv
QUERY = 'SELECT * FROM mydb.people;'
db = dbapi.connect(host='localhost', user='root', passwd='password', db='dbname')
@zealinux
zealinux / install-docker.sh
Created January 4, 2019 10:09 — forked from brianz/install-docker.sh
Install docker on Amazon Linux
#!/bin/bash
#
# steps taken verbatim from:
# http://docs.aws.amazon.com/AmazonECS/latest/developerguide/docker-basics.html#install_docker
#
sudo yum update -y
sudo yum install -y docker
sudo service docker start
sudo usermod -a -G docker ec2-user
# log out and log in to pickup the added group
@zealinux
zealinux / checkUrlExists.m1.py
Created December 18, 2018 06:51 — forked from fedir/checkUrlExists.m1.py
Check if URL exists via Python
from urllib2 import urlopen
code = urlopen("http://example.com/").code
if (code / 100 >= 4):
print "Nothing there."
# via http://stackoverflow.com/questions/1966086/how-can-i-determine-if-anything-at-the-given-url-does-exist
@zealinux
zealinux / ml-utils.py
Created December 18, 2018 04:08
机器学习中的常用的函数
import numpy as np
def sigmoid(x):
return 1.0 / (1 + np.exp(-float(x)));
@zealinux
zealinux / convert_utils.py
Last active December 27, 2018 05:58
Python 里的各种转换
import numpy as np
def tuple_to_dict(t):
return dict([t])
def get_first(d):
t = sorted(d.items())[0]
return tuple_to_dic(t)
def combine_to_dict(keys, values):
@zealinux
zealinux / f2f-first.log
Created December 16, 2018 05:47
8764aa
best simi is: 0.97
**** other image compare to base_center_vector ****
[('610703da-0eeb-42f7-99a8-f01634379847.jpg', 0.95584446),
('7156d573-8db5-4ab4-ab0f-cf9cb1d9aaba.jpg', 0.9364199),
('1b0f9271-d199-4585-99f6-b474856f94fa.jpg', 0.74257964),
('28c1dd5e-65ac-4b8b-887e-0ade5492da22.jpg', 0.71596545),
('3a53ad92-3f77-47cc-926f-3f8af1537c0d.jpg', 0.6548833),
('3a1c4638-762a-4ae4-b00c-dc5c71b9eb89.jpg', 0.6441053),
('2ea2b9a8-2fbd-495b-95d0-26781efd059a.jpg', 0.63781774),
@zealinux
zealinux / homebrew_opencv_245.sh
Created May 29, 2018 04:25 — forked from tstellanova/homebrew_opencv_245.sh
Install a specific version of OpenCV on OSX with homebrew
# 20131214
# switch to the relevant keg directory
cd /usr/local/Library/Taps/homebrew-science
brew versions opencv
# look for the version you want, eg:
# 2.4.5 git checkout ae74fe9 opencv.rb
# checkout the version you want
git checkout ae74fe9 opencv.rb
@zealinux
zealinux / README.md
Created May 11, 2018 07:42 — forked from magnetikonline/README.md
Bash getopts usage template.

Bash getopts usage template

#!/bin/bash -e

function usage {

	cat <<EOM
Usage: $(basename "$0") [OPTION]...
@zealinux
zealinux / db.rake
Created April 21, 2018 03:57 — forked from hopsoft/db.rake
Rails rake tasks for dump & restore of PostgreSQL databases
# lib/tasks/db.rake
namespace :db do
desc "Dumps the database to db/APP_NAME.dump"
task :dump => :environment do
cmd = nil
with_config do |app, host, db, user|
cmd = "pg_dump --host #{host} --username #{user} --verbose --clean --no-owner --no-acl --format=c #{db} > #{Rails.root}/db/#{app}.dump"
end
puts cmd
@zealinux
zealinux / linux-http-tcp.md
Created March 2, 2018 02:43 — forked from v5tech/linux-http-tcp.md
linux下查看http 并发和 tcp连接数

linux查看httpd进程数

ps -ef | grep httpd | wc -l

查看Apache的并发请求数及其TCP连接状态

netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'