%define pkg_data_name gcin-EdwardLiu
%define voice_pkg_db %{_datadir}/voicedata/voicedata-package.sqlite 
Name:       voicedata-zh_TW-gcin-EdwardLiu
Version:    20090221
Release:    3%{?dist}
License:    GPLv3
Group:      Applications/Multimedia
URL:        http://cle.linux.org.tw/trac/wiki/GcinDistros#gcinvoicedata
Source0:    http://www.calno.com/moto/gcin/ogg-gpl3-%{version}.tar.gz
Summary:    Chinese voice data from gcin project, recorded by Edward Der-Hua Liu
Summary(zh_TW): Gcin 中文語音檔，由劉德華 (Edward Der-Hua Liu) 錄製
BuildRoot:  %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
BuildRequires: sqlite >= 3.0
BuildArch:  noarch

%description
This voice data records voice of Edward Der-Hua Liu, the gcin's author,
for enabling "speak-as-you-type" functionality of gcin.

The voice data is now released under GPLv3+.

%description -l zh_TW
本中文語音檔由劉德華 (Edward Der-Hua Liu)，gcin的作者錄製，
以實現「輸入時唸出發音」功能。

本語音檔現已 GPLv3 釋出。

%prep
%setup -q -n ogg

%build 
ls -d [^A-Za-z]* | sed -e 's/^.*$/&,&\/3.ogg,,/' | sed -e 's/2,/ˊ,/' | sed -e 's/3,/ˇ,/' | sed -e 's/4,/ˋ,/' > phonemes.csv
sqlite3 voicedata.sqlite "CREATE TABLE 'phonemes_table' ('phonemes' PRIMARY KEY, 'file',  'archive', 'command');"
sqlite3 -separator , voicedata.sqlite ".import phonemes.csv phonemes_table"
rm phonemes.csv

%install
rm -rf $RPM_BUILD_ROOT
mkdir -p ${RPM_BUILD_ROOT}/%{_datadir}/voicedata/zh_TW/%{pkg_data_name}
cp -R * ${RPM_BUILD_ROOT}/%{_datadir}/voicedata/zh_TW/%{pkg_data_name}

%post
# This command will be moved to voice data main package.
sqlite3 %{voice_pkg_db} "CREATE TABLE 'package_table' ('package', 'locale', 'path',  'voice_format', 'archive_format', 'synthesizer');"

sqlite3 %{voice_pkg_db} "INSERT INTO 'package_table' ('package', 'locale', 'path', 'voice_format', 'archive_format','synthesizer') VALUES ('%{pkg_data_name}','zh_TW', 'zh_TW/%{pkg_data_name}', 'ogg', NULL, NULL);"

%postun
sqlite3 %{voice_pkg_db} "DELETE FROM 'package_table' WHERE package='%{pkg_data_name}';"


%clean
rm -rf $RPM_BUILD_ROOT


%files 
%defattr(-,root,root,-)
%doc LICENSE gpl-3.0.txt
%{_datadir}/voicedata/zh_TW/%{pkg_data_name}


%changelog
* Fri Aug 21 2009 Ding-Yi Chen <dchen at redhat dot com> - 20090221-3
- Update main voice data package information with post and postun scripts.

* Fri Aug 21 2009 Ding-Yi Chen <dchen at redhat dot com> - 20090221-2
- Add a sqlite db file which shows the relationship between phonemes and corresponding voice files.

* Fri Aug 14 2009 Ding-Yi Chen <dchen at redhat dot com> - 20090221-1
- Initial RPM packed.