Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /usr/bin/awk -f
- BEGIN {
- sql_cmd = "/bin/sqlite3 /mnt/onboard/.kobo/KoboReader.sqlite " ;
- #著者不明のデータを探す
- cmd = sql_cmd "'SELECT RowID,Title FROM content WHERE Attribution=\"著者不明\"'";
- print "### 著者不明のデータレコードのRowIDとタイトルを取得 " ;
- while ( cmd | getline line){
- split(line,Val,"|") ;
- title[Val[1]] = Val[2]
- print Val[1] "=" Val[2] ;
- }
- #著者不明のタイトルから著者名を取得、著者名を除いたタイトルを生成
- print "### 著者名を抽出" ;
- for( v in title ){
- if ( match(title[v],/\[.+\]/) == 1){
- Attr[v] = substr(title[v],RSTART+1,RLENGTH-2) ;
- split(title[v],NewT,Attr[v]"]") ;
- NewTitle[v] = NewT[2] ;
- sub(/^[ \t]+/, "",NewTitle[v] );
- }
- }
- #著者名、タイトルを変更
- print "### 著者名を変更" ;
- for( v in Attr ){
- cmd = sql_cmd "'UPDATE content SET Title=\"" NewTitle[v] "\",Attribution=\"" Attr[v] "\" WHERE RowId=" v "'"
- print cmd ;
- system(cmd) ;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement