チェンジセット 113: trunk

コミット日時:

2010/09/13 19:44:00 (14 年前)

コミッタ:

sorshi

ログメッセージ:

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

ファイル:

• trunk/install/mktable.txt (更新) (1 diff)
• trunk/install/perl/db/Pg.pl (更新) (1 diff)
• trunk/install/perl/db/SQLite.pl (更新) (1 diff)

trunk/install/mktable.txt

@@ -62 +62 @@
-drop table foltia_epg;
-create table foltia_epg (
-int8   PRIMARY KEY SERIAL
+BIGSERIAL PRIMARY KEY 
-startdatetime int8,
-enddatetime int8,

trunk/install/perl/db/Pg.pl

@@ -75 +75 @@
-'xmltv2foltia.replaceepg.1' => "SELECT * FROM foltia_epg WHERE enddatetime > ? AND startdatetime < ? AND ontvchannel = ?",
-'xmltv2foltia.commitdb.1' => "DELETE FROM foltia_epg WHERE epgid = ?",
-
-
+
-'epgimport.1' => "SELECT count(*) FROM foltia_station WHERE stationid = ?" ,
-'epgimport.2' => "SELECT digitalch,ontvcode FROM foltia_station WHERE stationid = ?" ,

trunk/install/perl/db/SQLite.pl

@@ -4 +4 @@
-$stmt{'foltialib.changefilestatus.1'} = "UPDATE foltia_subtitle SET filestatus = ?, lastupdate = datetime('now', 'localtime') WHERE pid = ?";
-
+$stmt{'xmltv2foltia.commitdb.2'} ="INSERT INTO foltia_epg VALUES (NULL, ?, ?, ?, ?, ?, ?, ?)";
+
+
-1;