ResultSetExtractor

jdbcTemplate.query(sql, new ResultSetExtractor() {
    Object extractData(ResultSet rs) {}
})
return Object

RowCallbackHandler

jdbcTemplate.query(sql, new RowCallbackHandler() {
    void processRow(ResultSet rs) {}
})
return void

RowMapper

jdbcTemplate.query(sql, new RowMapper() {
    Object mapRpw(ResultSet rs, int rowNum)
})
return List

sp_month_new_big_customer

todos

autojump-zsh not working

red

DECR, DECRBY, DEL, EXISTS, EXPIRE, GET, GETSET, HDEL, HEXISTS, HGET, HGETALL, HINCRBY, HKEYS, HLEN, HMGET, HMSET, HSET, HVALS, INCR, INCRBY, KEYS, LINDEX, LLEN, LPOP, LPUSH, LRANGE, LREM, LSET, LTRIM, MGET, MSET, MSETNX, MULTI, PEXPIRE, RENAME, RENAMENX, RPOP, RPOPLPUSH, RPUSH, SADD, SCARD, SDIFF, SDIFFSTORE, SET, SETEX, SETNX, SINTER, SINTERSTORE, SISMEMBER, SMEMBERS, SMOVE, SORT, SPOP, SRANDMEMBER, SREM, SUNION, SUNIONSTORE, TTL, TYPE, ZADD, ZCARD, ZCOUNT, ZINCRBY, ZRANGE, ZRANGEBYSCORE, ZRANK, ZREM, ZREMRANGEBYSCORE, ZREVRANGE, ZSCORE

generic

get
set
del
expire
ttl: -2 for deleted, -1 for never expire

list

RPUSH, LPUSH, LLEN, LRANGE, LPOP, ,RPOP

lrange: lrange key st end, end -1 for retrieve all elements

set

SADD, SREM, SISMEMBER, SMEMBERS SUNION

Sorted Set

similar to set

zadd zadd key score value

zadd hackers 1940 "alan kay"

zrange

zrange hackers 0 -1

Hash

Hashes are maps between string fields and string values

hset => hset key field value [field, value...]
hmset => hmset key field value [field, value...]
hgetall => hgetall key
hincrby
hdel

The linux command line

chapter2

date, cal, df, free

chapter3 file system

区分大小写

cd - => jump to last directory

ch4 os

command -options arguments

-options 包含长选项(两个-), 短选项(一个-)

ls
file => lookup file type
less

-a --alll
-d --directory
-h --human-readable
-l long
-t time
-r --reverse
-F --classify 区分

-rw-r--r-- 1 root root 47584 2007-04-03 11:05 logo-Edubuntu.png

(access auth) (hard link number) (file owner) (file group) (file size) (last modified time) (filename)

access auth: 文件所有者，文件组所有者，和其他人的读，写，执行权限

对于文件的访问权限。第一个字符指明文件类型。在不同类型之间，开头的“－”说明是一个普通文件，“d”表明是一个目录。其后三个字符是文件所有者的访问权限，再其后的三个字符是文件所属组中成员的访问权限，最后三个字符是其他所有人的访问权限

first letter 'l' stands for symbolic

ascii pronounce "As-Key"

ch5 os file and direcotry

cp => cp items... dist-directory
rm
mkdir
mv
ln

wildchars

* match zero or whatever
? match one
[chars]
[!chars]

ln

hard: ln item link, hard link has no difference than regular file

soft(symlink, symbolic): ln -s file link, write to symbolic will also add content to correspond file

hard link

当考虑到硬链接的时候，我们可以假设文件由两部分组成：包含文件内容的数据部分和持有文件名的名字部分. 创建文件硬链接的时候，实际上是为文件创建了额外的名字部分，并且这些名字都关系到相同的数据部分

blocks <= inode <= file-name

symbolic

建立符号链接的目的是为了克服硬链接的两个缺点：硬链接不能跨越物理设备，硬链接不能关联目录，只能是文件。符号链接是文件的特殊类型，它包含一个指向目标文件或目录的文本指针。

ch6

all about commands

type ==>
which
man
apropos
whatis
alias

ch7 redirection > for redirection and | for pipe line

cat － concatenate files and print on the standard output: read one or more files, concat them and then copy to stdout ===> cat file1 file2 > concat_file.txt
sort － sort line ===> ls /bin /usr/bin | sort | less
uniq －报道或省略重复行 ===> ls /bin /usr/bin | sort | uniq | less
grep － grep pattern [file...]
wc －打印文件中换行符，字，和字节个数 lines, words, bytes ===> wc file1
head － print some first parts: 10 lines for default, -n to specify ====> head -n 5 file.txt
tail -- print some last parts ====> tail -n 5 file.txt. tail -f file : Prints the appended lines on the terminal as the file grows. (like top command)
tee: read from stdin, write to both file and stdout =====> ls /usr/bin | tee txt | grep zip

与 Unix 主题“任何东西都是一个文件”保持一致，程序， ls，实际上把他们的运行结果输送到一个叫做标准输出的特殊文件（经常用 stdout 表示），而它们的状态信息则送到另一个叫做标准错误的文件（stderr）。默认情况下，标准输出和标准错误都连接到屏幕，而不是保存到磁盘文件。除此之外，许多程序从一个叫做标准输入（stdin）的设备得到输入，默认情况下，标准输入连接到键盘。

I/O 重定向允许我们可以更改输出走向和输入来向。一般地，输出送到屏幕，输入来自键盘，但是通过 I/O 重定向，我们可以改变输入输出方向。

> and >> redirection

2> rediret stderr ====> ls /no/file 2> ls-output.txt

&> redirect both stdout and strerr

[stdin, stdout, sterr] => 0, 1, 2

ctrl-d : EOF

ch8 see world through shell

echo

* spread as wildchar
~ spread to home
$(()) suanshu expression
{} multiple string spread ===> echo Front-{A,B,C}-Back
parameter spread: echo $USER, echo $SHELL

rest remains.........

ch9 keyboard advanced

clear
history
C-a: to line start
C-e: to line end
C-f: forward a char
C-b: backward a char
Alt-f: forward a word
Alt-b: backward a word
C-w: cut to previous whitespace
C-l: same as clear
C-u: from cursor clip to line start
C-k: from cursor clip to line end
C-y: paste

history

C-r: reverse-search
C-n: next histroy
C-p: previous history
Alt-p
Alt-n
!num: copy history command to shell
!!: last history
C-g: cancel searching history

meta key: usually alt

ch10 authorization

id
chmod: change file mode bits, two ways for chmod, 1.octal and 2.char
umask: set default auth
su: in other user and group
sudo: in admin
chown : change file owner and group ==> chown [options]... [owner][:[group]] file... ==> chown bob:users a.txt
chgrp : change group ownership
passwd: passwd [user]
adduser(useradd)
groupadd

chmod way 1: octal way

octal mode: bit-bit-bit => r-w-x

chmod [user-oct][group-oct][other-oct] file ===> chmod 600 file

some frequently used: 7 (rwx) 6 (rw-) 5 (r-x) 4 (r--) 0 (---)

chmod way 2: char way

if not specify a char, default to -a, + means add , - means minus, = means add those and delete others(do not affect other two)

can be separated by ,: u+x, o-x

u user
g group
o others
a all: includes all ugo

command	desc
u+x	为文件所有者添加可执行权限。
u-x	删除文件所有者的可执行权限。
+x	为文件所有者，用户组，和其他所有人添加可执行权限。等价于 a+x。
o-rw	除了文件所有者和用户组，删除其他人的读权限和写权限。
go=rw	给群组的主人和任意文件拥有者的人读写权限。如果群组的主人或全局之前已经有了执行的权限，他们将被移除。
u+x,go=rw	给文件拥有者执行权限并给组和其他人读和执行的权限。多种设定可以用逗号分开。

ch11 process

tty: teletype, a control terminal

ps
- ps x ==> a "stat" column
- ps aux
top : monitoring system's process updating information
jobs: show current jobs(also show jobspec)
fg ==> fg %1
bg
kill ===> kill [-signal] PID
killall: killall [-u user] [-signal] name... ==> killall -9 PID
shutdown

note: [1] and %1 is jobspec

C-c terminate process C-z stop process

command & : run and put process to background =======> node &

signal

kill [-signal] PID

signals:

HUP 1 ==> kill -1 13546
INT 2 中断 C-c
QUIT 3
KILL 9
TERM 15
CONT 18
STOP 19
TSTP 20 终端停止 C-z

more command about process

pstree
vmstat 系统资源使用快照，包括内存，交换分区和磁盘 I/O

ch12 shell environment

two types in shell: 环境变量和 shell 变量

$PS1(prompt string one), $SHELL, $HOME, $EDITOR are shell vars

USER, TERM, PWD are enviroment vars

printenv: enviroment variable ==> printenv(show all), printenv USER
set: shell variable ==> set(show all) , echo $SHELL, echo $PS1
export: export path: shell's subprocess can use PATH
alias

command lines stored in $PATH, echo $PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

ch14 homemade shell prompt string one

all about $PS1 preference

ch15 package manager

dist	ground tool	app tool
debian-style	dpkg	apt-get, aptitude
redhat	rpm	yum

ch17 network system

ping
traceroute
netstat
wget
ssh(Secure Shell)

...remains

ch18 find files

find
locate
xargs
stat
touch

find tests

some heavily used tests:

-type: b, c, d, l, f block device character device directory symbolic file

-name
-iname: case-insensitive name
-user
-size

find /etc -type f -iname "nginx.*" -user root -size +1M

operators

-and
-or
-not

pre-defined operation

-ls
-print
-quit
-delete

-exec [command] '{}'

examples:

find ~ -type f -name "*.JPG" -size +1M | wc -l

find ~ ( -type f -not -perm 0600 ) -or ( -type d -not -perm 0700 )

find ~ -type f -name '*.BAK' -delete

find ~ -type f -and -name '*.BAK' -and -print

About inode (index node)

stat, ls -i: lookup inode

inode marked by a series of number: 132536

inode标识文件, 文件名标识inode filename => inode => blocks

random notes

find out distribution release: lsb_release -a

/etc/*-release file.
lsb_release command. lsb_release -a
/proc/version file.

vim

% => go to pair
#, * => next(pevious) occurrance of the word
v, C-v => expand section, (C-w in jetbrains)
gu[], gU[] ===> guw, gue, gUw, gUe, gU$, gU2w
:bn, :bp => buffer-next, buffer-previous
C-v, then select lines, then [I, A] [words] [Esc] ======> insert/append to multiple lines
C-n, C-p ======> completion
/\c case insensitive search =====> /\cfoo

Git

3 file status

committed(unmodified)
modified
staged

3 areas

working directory
staging area: file infos to be submitted
.git directory (repository)

git config level

global
current user
repository

ch2 basic

git add *.c

file status cycle: untracked unmodified modified staged

git status -s (git status --short)

git diff:

unstaged modification git diff
staged modification: git diff --cached | git diff --staged

rm

untrack file: git rm --cached file

log

git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit

cancel

git commit --amend: submit all staged files
cancel staging: git reset HEAD [file]
restore to last commit: git checkout -- [file]

remote repository

git remote: list remote repo
git remote -v: list verbose
git remote show [remote-branch-name] => git remote show origin

add remote

git remote add [shortname] [url] : add remote repo

git remote add pb https://github.com/paulboone/ticgit, after add remote repo, we can fetch: git fetch pb, then all pb's branchs will be located at remotes/pb/... , E.G: pb/master, pb/ticgit (listing command: git branch -r)

fetch

if clone a repo, by default a origin remote will be added as remote repo

rename and mv

git remote rename pb paul git remote rm paul

ch3 branch

Actually, git branch is just pointers pointing at commit object

A pointer called HEAD pointing at branches

git branch [new-branch]
git checkout [branch]
git checkout -b [new-branch]: combine above two

merge

two merging ways:

fast-forward merge , direct point master to [branch]
diverged from common ancestor merge, auto make a new commit

git merge [branch]: merge current-branch to [branch]
git add conflict-file: mark file as conflict solved
git mergetool: using gui to solve conflict

branch

git branch
git branch -v: every branch's last commit
git branch -r: list remote branch
git branch -d [branch]: delete branch
git branch --merged, git branch --no-merged

remote branch

remote branch name as: remote/[branch]

git remote show [branch]: get remote branch infos
git fetch [remote]: update remote-branch
git push origin serverfix: git push origin serverfix: serverfix : serverfix spread to : refs/heads/serverfix:refs/heads/serverfix
- git push [remote-name] [local-branch]: [remote-branch]

c1pyerten / first-repo Goto Github PK

first-repo's Introduction