チェンジセット 132

差分発生行の前後
無視リスト:
コミット日時:
2010/10/25 18:21:47 (15 年前)
コミッタ:
sorshi
ログメッセージ:

チェンジセット130での更新がSQL直書きだったのを修正

ファイル:

凡例:

変更無し
追加
削除
更新
コピー
移動

  • trunk/install/perl/db/Pg.pl

    r124 r132  
    7474'updatem2pfiletable.4' => "INSERT into foltia_mp4files values (?, ?)", 
    7575 
    76 'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ? AND startdatetime > ?", 
     76'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ?", 
    7777'xmltv2foltia.replaceepg.2' => "SELECT * FROM foltia_epg WHERE startdatetime = ? AND enddatetime = ? AND ontvchannel = ? ", 
    7878'xmltv2foltia.commitdb.1' => "DELETE FROM foltia_epg WHERE epgid = ?", 

  • trunk/install/perl/xmltv2foltia.pl

    r130 r132  
    224224$foltiaendtime   = substr($foltiaendtime,0,12); # 12桁　200508072355 
    225225 
    226 #$sth = $dbh->prepare($stmt{'xmltv2foltia.replaceepg.1'}); 
    227 $sth = $dbh->prepare("SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ?"); 
    228  
     226$sth = $dbh->prepare($stmt{'xmltv2foltia.replaceepg.1'}); 
    229227my $now = &epoch2foldate(time()); 
    230 #$sth->execute($foltiastarttime , $foltiaendtime , $ontvepgchannel,$now); 
    231228$sth->execute($foltiastarttime , $foltiaendtime , $ontvepgchannel); 
    232229while (@data = $sth->fetchrow_array()) { 
track feed