-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On July 9, 2003 10:00 am, Aubin Paul wrote:
> Actually, we don't do it inside xmltv.py, it's done in our code. But > we set it to midnight > prog.stop = timestr2secs_utc(p['start'][0:8] + '235900' + > p['start'][14:18]) > > But it works ok, because it only affects the last day in a set of > grabs; and only the last program. There is no way to be more accurate > then that. Actually, that is better. > > There is no need for a separate DB process, but you can use one if you > > want. ZODB is the database used in Zope, so it supports all of the > > storage types that Zope does, which are: > > I took a look at the ZODB stuff because it seemed very "big" But ZODB > does look powerful; I just don't know how worthwhile it'll be for our > purposes... I think sqlite can handle what we want... > > Ideally, I'd like us to match the MythTV tables, but they're actually > more limited in what they can do because MySQL lacks subselects and > foreign keys. I assume they've probably had to work around that, but I > prefer that this xmltv is normalized properly since there is a lot of > data. Be careful about how you use the data in your code. The changes in XMLTV 0.6 are major and it's going to be more structured with subelements. For one thing programme will be an optional element under timeslot. A timeslot may contain programme-ref instead, which refers to the id of a programme under another timeslot. It can get messy pretty quickly. The thing is, XML is designed to represent highly structured data and it's really good at it but the code to deal with it can get really ugly when we try to map it to more traditional simple structures without losing information. You've already noticed how ugly the output of xmltv.py is. Have you heard of SQLObject? You may find it interesting as it has SQLite support and it may make your job easier. - -- James Oakley [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/DKuXKtn0F7+/lLMRAgXyAJ40iX+3NVak28Bya1Idn83Tm6B+wwCePV1z EXxnU9d333YV8oHLvi3HG7Q= =xDlo -----END PGP SIGNATURE----- ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps _______________________________________________ Freevo-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-devel
