gcin 同好會 - Linux/FreeBSD/MacOS 新一代中文輸入法 gcin

filter: sqlite 資料庫查詢

By guest at 06-10-04 22:23

呼叫 sqlite 查詢的 filter script：

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

sqlite 範例檔（將「UTF-8 日文」轉換為「Big5 日文」）：

BEGIN TRANSACTION;
CREATE TABLE sakura (
Gfrom text,
Gto text
);
INSERT INTO sakura VALUES('ぁ','');
INSERT INTO sakura VALUES('あ','');
INSERT INTO sakura VALUES('ぃ','');
INSERT INTO sakura VALUES('い','');
INSERT INTO sakura VALUES('ぅ','');
COMMIT;

目前沒有討論