チェンジセット 121: trunk

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

PostgreSQL使用時の不具合を解消。

ファイル:

凡例:

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

    r113 r121  
    7373'updatem2pfiletable.4' => "INSERT into foltia_mp4files values (?, ?)", 
    7474 
    75 'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ?", 
     75'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ? AND startdatetime > ?", 
    7676'xmltv2foltia.commitdb.1' => "DELETE FROM foltia_epg WHERE epgid = ?", 
    7777'xmltv2foltia.commitdb.2' => "INSERT INTO foltia_epg VALUES ( nextval('foltia_epg_epgid_seq'), ?, ?, ?, ?, ?, ?, ?)" , 
     
    7979'epgimport.2' => "SELECT digitalch,ontvcode FROM foltia_station WHERE stationid = ?" , 
    8080'epgimport.3' => "SELECT digitalch,ontvcode FROM foltia_station WHERE ontvcode is not NULL AND digitalch >= 13 AND digitalch <= 62 ORDER BY digitalch ASC" , 
    81 'epgimport.4' => "SELECT count(*) FROM foltia_station WHERE ontvcode is not NULL AND digitalch >= 100 AND digitalch <= 222 ORDER BY digitalch ASC" , 
    82 'epgimport.5' => "SELECT count(*) FROM foltia_station WHERE ontvcode is not NULL AND digitalch >= 223 ORDER BY digitalch ASC" , 
     81'epgimport.4' => "SELECT count(*) FROM foltia_station WHERE ontvcode is not NULL AND digitalch >= 100 AND digitalch <= 222" , 
     82'epgimport.5' => "SELECT count(*) FROM foltia_station WHERE ontvcode is not NULL AND digitalch >= 223" , 
    8383'epgimport.6' => "SELECT  
    8484 foltia_program.tid, stationname, foltia_program.title, 
  • trunk/install/perl/xmltv2foltia.pl

    r120 r121  
    1616# 
    1717 
    18 use LWP::Simple; 
     18#use LWP::Simple; 
    1919#use Encode qw(from_to); 
    2020#use encoding 'euc-jp', STDIN=>'utf8', STDOUT=>'euc-jp' ; # 標準入力:utf8  
    2121# http://www.lr.pi.titech.ac.jp/~abekawa/perl/perl_unicode.html 
    2222use Jcode; 
    23 use Data::Dumper;  
     23#use Data::Dumper;  
    2424use Time::Local; 
    2525use DBI; 
     
    224224$foltiaendtime   = substr($foltiaendtime,0,12); # 12桁 200508072355 
    225225 
    226 #$sth = $dbh->prepare($stmt{'xmltv2foltia.replaceepg.1'}); 
     226$sth = $dbh->prepare($stmt{'xmltv2foltia.replaceepg.1'}); 
    227227my $now = &epoch2foldate(time()); 
    228 $sth = $dbh->prepare( "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ? AND startdatetime > ?"); 
    229228$sth->execute($foltiastarttime , $foltiaendtime , $ontvepgchannel,$now); 
    230229 
     
    281280sub commitdb{ 
    282281$dbh->{AutoCommit} = 0; 
    283 $dbh->do('BEGIN'); 
    284282#print Dumper(\@dbarray); 
    285283my $loopcount = @foltiastarttime; 
     
    298296#&writelog("xmltv2foltia DEBUG : INSERT INTO foltia_epg VALUES ( NULL , $foltiastarttime[$i],$foltiaendtime[$i], $lengthmin[$i], $channel[$i], $title[$i], $desc[$i], $category[$i])"); 
    299297}# end for 
    300 $dbh->do('COMMIT')
     298$dbh->commit
    301299$dbh->{AutoCommit} = 1; 
    302300}#end sub commitdb 
track feed