Na gut, weil das nur 2 Codezeilen sind
cmd = "DELETE FROM T_Event WHERE changed < datetime(?, 'unixepoch')"
self.cursor.execute(cmd,self.epoch_time)
Wobei das delete über die Trigger gar nicht so schlecht performed, obwohl man dann die indizes behalten muss.
Danke Gutemine und Ich dachte das es nicht wirken wurde mit die code die oben steht aber es geht einfach.
Es dauerte gestern Abend was langer weil ich mich "Urban Priol: TILT! - Tschüssikowski 2014" angesehen hat und andere Dingen gemacht.
I have some findings and I made a clean import and when examining the epg.db I noticed that the T_source was expanded with source 5 and secondly I had the following message when starting:
Jan 02 00:53:21 dm7080 enigma2[1329]: [EPGDB] is located at /media/9016-4EF8/XMLTV-EPG/epg.db
Jan 02 00:53:21 dm7080 enigma2[1329]: [EPGDB] %s not found, sorry
This without any epg.db present and then T_Source contains only the four standard lines
Jan 02 00:55:04 dm7080 enigma2[1432]: [EPGDB] is located at /media/9016-4EF8/XMLTV-EPG/epg.db
Jan 02 00:55:04 dm7080 enigma2[1432]: [EPGDB] ADDED Rytex XMLTV with source_id 5
Jan 02 00:55:04 dm7080 enigma2[1432]: [EPGDB] starting cleaning of events from /media/9016-4EF8/XMLTV-EPG/epg.db
Jan 02 00:55:04 dm7080 enigma2[1432]: [EPGDB] cleaning outdated events ...
Jan 02 00:55:04 dm7080 enigma2[1432]: [EPGDB] connect failed
This was with a epg.db present and now line 5 is added XMLTV also the "connect failed" puzzles me.
update: I inserted an "eEPGCache.load(epginstance)" when os.path.exists(epgdb_path) (file: epg.dat) is not found) and removed the following False. I don't know if that will disturb the rest of the import or the next import because of your warning # DMM has to fix that save is not synchronous.
def start_process(self, epgdb_path=None, retry=False):
self.connection = None
epginstance = eEPGCache.getInstance()
eEPGCache.save(epginstance)
if epgdb_path is None:
epgdb_path=config.misc.epgcache_filename.value
if not os.path.exists(epgdb_path):
# DMM has to fix that save is not synchronous
print "[EPGDB] %s not found, sorry"
eEPGCache.load(epginstance)