2022年7月11日星期一

linux alias

1. alias lla='ls -la' 

[root@ip-xxx ~]$ lla

total 112
drwx------ 18 root  root   4096 Jul  8 11:20 .
drwxr-xr-x  5 root  root        47 May 19 09:47 ..

2. unalias lla # delete alias lla


3.  function findjssp () { find $1 -type f  -name "*.js" -o -name "*.html" | xargs grep -ine "$2" 2>/dev/null; }

     $  findjssp  "imart/WEB-INF/jssp/src/"  "test" 

4. unset findjssp  # delete function findjssp 


2022年7月8日星期五

git branch upstream

git branch --set-upstream-to remotename/branchname

git branch -u remotename  # same branch name


# delete upstream between remote andd local

git branch -d -r origin/<remote branch name>

2022年7月7日星期四

git commit comment 整理

======git  history: ======

commit: comment1 

commit: comment2 

commit: comment3 

commit: comment4 

commit: comment5 

commit: comment6 

commit: comment7 

commit: comment8 

commit: comment9 

commit: comment10 

commit: comment11 

======git  history: ======

目標: 

comment1 ~comment5:  commit => project1

comment6 ~comment10: commit => project2

方法:

git rebase -i HEAD~10

--edit commit: comment1 

--edit commit: comment2 

--edit commit: comment3 

--edit commit: comment4 

--edit commit: comment5 

--edit commit: comment6 

--edit commit: comment7 

--edit commit: comment8 

--edit commit: comment9 

--edit commit: comment10 

git commit --amend 

commit: comment1  -> project1: comment1  

git rebase --continue 

git commit --amend 

commit: comment2 -> project1: comment2 

git rebase --continue 

git commit --amend 

... 

git rebase --continue 

git commit --amend 

commit: comment10 -> project2: comment10

Successfully rebased and updated refs/heads/$branchname


=================

pick -そのまま保留

edit -コメント編集へ

squash - 前のcommitにマージする,コメント変更可

fixup - 前のcommitにマージする,コメントも前のコメントに従う

drop -該当commitを削除





2022年6月30日星期四

Tomcat X-server

1. x-server2.7  :odcaw2_servlet 

    ref: javax.servlet*;


2. tomcat 9: servlet-api.jar: javax.servlet*

3. tomcat 10: servlet-api.jar: jakarta.servlet*


Correct Env:  Tomcat9 +  X-server2.7 

Comfirm url: http://localhost:8080/oxs/odcaw2_servlet



2022年6月21日星期二

Oracle Tablename/Columns comments

1.  get all table comments

SELECT TABLE_NAME
,COMMENTS
FROM USER_TAB_COMMENTS

2.  get sql for tables comments

SELECT 'COMMENT ON TABLE ' || TABLE_NAME || ' IS ''' || COMMENTS  ||  ''';' AS SQL
FROM USER_TAB_COMMENTS

3. get sql for columns comments 
SELECT T.TABLE_NAME,
C.COLUMN_NAME
,C.COMMENTS
, 'COMMENT ON COLUMN ' || T.TABLE_NAME || '.' || C.COLUMN_NAME || ' IS ''' || C.COMMENTS || ''';' AS SQL
FROM USER_TAB_COMMENTS T, USER_COL_COMMENTS C
where T.TABLE_NAME = C.TABLE_NAME

2022年6月17日星期五

2022年6月13日星期一

linux stat file


$  stat /etc/passwd
  File: ‘/etc/passwd’
  Size: 1596            Blocks: 8          IO Block: 4096   regular file
Device: ca01h/51713d    Inode: 19293210    Links: 1
Access: (0644/-rw-r--r--)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2022-06-03 09:21:07.905548960 +0900
Modify: 2022-06-03 09:21:07.909549008 +0900
Change: 2022-06-03 09:21:07.909549008 +0900
 Birth: -
$  stat -c "%Y" /etc/passwd   # time of last modification, seconds since Epoch
1654215667
stat --help
Usage: stat [OPTION]... FILE...
Display file or file system status.

Mandatory arguments to long options are mandatory for short options too.
  -L, --dereference     follow links
  -f, --file-system     display file system status instead of file status
  -c  --format=FORMAT   use the specified FORMAT instead of the default;
                          output a newline after each use of FORMAT
      --printf=FORMAT   like --format, but interpret backslash escapes,
                          and do not output a mandatory trailing newline;
                          if you want a newline, include \n in FORMAT
  -t, --terse           print the information in terse form
      --help     display this help and exit
      --version  output version information and exit

The valid format sequences for files (without --file-system):

  %a   access rights in octal
  %A   access rights in human readable form
  %b   number of blocks allocated (see %B)
  %B   the size in bytes of each block reported by %b
  %C   SELinux security context string
  %d   device number in decimal
  %D   device number in hex
  %f   raw mode in hex
  %F   file type
  %g   group ID of owner
  %G   group name of owner
  %h   number of hard links
  %i   inode number
  %m   mount point
  %n   file name
  %N   quoted file name with dereference if symbolic link
  %o   optimal I/O transfer size hint
  %s   total size, in bytes
  %t   major device type in hex, for character/block device special files
  %T   minor device type in hex, for character/block device special files
  %u   user ID of owner
  %U   user name of owner
  %w   time of file birth, human-readable; - if unknown
  %W   time of file birth, seconds since Epoch; 0 if unknown
  %x   time of last access, human-readable
  %X   time of last access, seconds since Epoch
  %y   time of last modification, human-readable
  %Y   time of last modification, seconds since Epoch
  %z   time of last change, human-readable
  %Z   time of last change, seconds since Epoch

Valid format sequences for file systems:

  %a   free blocks available to non-superuser
  %b   total data blocks in file system
  %c   total file nodes in file system
  %d   free file nodes in file system
  %f   free blocks in file system
  %i   file system ID in hex
  %l   maximum length of filenames
  %n   file name
  %s   block size (for faster transfers)
  %S   fundamental block size (for block counts)
  %t   file system type in hex
  %T   file system type in human readable form

NOTE: your shell may have its own version of stat, which usually supersedes
the version described here.  Please refer to your shell's documentation
for details about the options it supports.

GNU coreutils online help: <http://www.gnu.org/software/coreutils/>
For complete documentation, run: info coreutils 'stat invocation'