filter: sqlite database

shell script 原始檔

#!/bin/bash
  read -r aa
  $result=`sqlite /usr/share/gcin/script/gcinfilter.db "select Gto from nobopomofo where Gfrom='$aa';"`
  if [ $result = "_" ]; then
     $result = ''
  else
     $result = $aa
  fi
  echo -n "$result"
  exit 0

sqlite 原始檔

BEGIN TRANSACTION;
CREATE TABLE nobopomofo (
	Gfrom text,
	Gto text
);
INSERT INTO nobopomofo VALUES('ㄅ','_');
INSERT INTO nobopomofo VALUES('ㄆ','_');
INSERT INTO nobopomofo VALUES('ㄇ','_');
INSERT INTO nobopomofo VALUES('ㄈ','_');
INSERT INTO nobopomofo VALUES('ㄉ','_');
INSERT INTO nobopomofo VALUES('ㄊ','_');
INSERT INTO nobopomofo VALUES('ㄋ','_');
INSERT INTO nobopomofo VALUES('ㄌ','_');
INSERT INTO nobopomofo VALUES('ㄍ','_');
INSERT INTO nobopomofo VALUES('ㄎ','_');
INSERT INTO nobopomofo VALUES('ㄏ','_');
INSERT INTO nobopomofo VALUES('ㄐ','_');
INSERT INTO nobopomofo VALUES('ㄑ','_');
INSERT INTO nobopomofo VALUES('ㄒ','_');
INSERT INTO nobopomofo VALUES('ㄓ','_');
INSERT INTO nobopomofo VALUES('ㄔ','_');
INSERT INTO nobopomofo VALUES('ㄕ','_');
INSERT INTO nobopomofo VALUES('ㄖ','_');
INSERT INTO nobopomofo VALUES('ㄗ','_');
INSERT INTO nobopomofo VALUES('ㄘ','_');
INSERT INTO nobopomofo VALUES('ㄙ','_');
INSERT INTO nobopomofo VALUES('ㄧ','_');
INSERT INTO nobopomofo VALUES('ㄨ','_');
INSERT INTO nobopomofo VALUES('ㄩ','_');
INSERT INTO nobopomofo VALUES('ㄚ','_');
INSERT INTO nobopomofo VALUES('ㄛ','_');
INSERT INTO nobopomofo VALUES('ㄜ','_');
INSERT INTO nobopomofo VALUES('ㄝ','_');
INSERT INTO nobopomofo VALUES('ㄞ','_');
INSERT INTO nobopomofo VALUES('ㄟ','_');
INSERT INTO nobopomofo VALUES('ㄠ','_');
INSERT INTO nobopomofo VALUES('ㄡ','_');
INSERT INTO nobopomofo VALUES('ㄢ','_');
INSERT INTO nobopomofo VALUES('ㄣ','_');
INSERT INTO nobopomofo VALUES('ㄤ','_');
INSERT INTO nobopomofo VALUES('ㄥ','_');
INSERT INTO nobopomofo VALUES('ㄦ','_');
COMMIT;