チェンジセット 113: trunk/install/perl/db

差分発生行の前後
無視リスト:
コミット日時:
2010/09/13 19:44:00 (14 年前)
コミッタ:
sorshi
ログメッセージ:

PostgreSQLでEPG周りが動いていなかった部分を対応

ファイル:

凡例:

変更無し
追加
削除
更新
コピー
移動
  • trunk/install/perl/db/Pg.pl

    r111 r113  
    7575'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ?", 
    7676'xmltv2foltia.commitdb.1' => "DELETE FROM foltia_epg WHERE epgid = ?", 
    77 'xmltv2foltia.commitdb.2' => "INSERT INTO foltia_epg VALUES (NULL, ?, ?, ?, ?, ?, ?, ?)" , 
    78  
     77'xmltv2foltia.commitdb.2' => "INSERT INTO foltia_epg VALUES ( nextval('foltia_epg_epgid_seq'), ?, ?, ?, ?, ?, ?, ?)" , 
    7978'epgimport.1' => "SELECT count(*) FROM foltia_station WHERE stationid = ?" , 
    8079'epgimport.2' => "SELECT digitalch,ontvcode FROM foltia_station WHERE stationid = ?" , 
  • trunk/install/perl/db/SQLite.pl

    r94 r113  
    44$stmt{'foltialib.changefilestatus.1'} = "UPDATE foltia_subtitle SET filestatus = ?, lastupdate = datetime('now', 'localtime') WHERE pid = ?"; 
    55 
     6$stmt{'xmltv2foltia.commitdb.2'} ="INSERT INTO foltia_epg VALUES (NULL, ?, ?, ?, ?, ?, ?, ?)"; 
     7 
     8 
    691; 
track feed