Trouble writing to database: RSS-reader

[Arne]

Hi!

I try to make a rss-reader in python just for fun, and I'm almost
finished. I don't have any syntax-errors, but when i run my program,
nothing happends.

This program is supposed to download a .xml-file, save the contents in
a buffer-file(buffer.txt) and parse the file looking for start-tags.
When it has found a start tag, it asumes that the content (between the
start-tag and the end-tag) is on the same line, so then it removes the
start-tag and the end-tag and saves the content and put it into a
database.

The problem is that i cant find the data in the database! If i watch
my program while im running it, i can see that it sucsessfuly
downloads the .xml-file from the web and saves it in the buffer.

But I dont think that i save the data in the correct way, so it would
be nice if someone had some time to help me.

Full code: http://pastebin.com/m56487698
Saving to database: http://pastebin.com/m7ec69e1b
Retrieving from database: http://pastebin.com/m714c3ef8

And yes, I know that there is rss-parseres already built, but this is
only for learning.

[Bruno Desthuilliers]

Dennis Lee Bieber a écrit :

On Mon, 21 Jan 2008 08:12:43 -0800 (PST), Arne <ar******@gmail.com>
declaimed the following in comp.lang.python:

>The problem is that i cant find the data in the database! If i watch
my program while im running it, i can see that it sucsessfuly
downloads the .xml-file from the web and saves it in the buffer.

Did you COMMIT the transaction with the database?

Did you READ the code ?-)

NB : Yes, he did. The problem*s* are elsewhere.

[Arne]

On 21 Jan, 19:15, Bruno Desthuilliers <bruno.
[e-mail]:

This should not prevent you from learning how to properly parse XML
(hint: with an XML parser). XML is *not* a line-oriented format, so you
just can't get nowhere trying to parse it this way.

HTH

Do you think i should use xml.dom.minidom for this? I've never used
it, and I don't know how to use it, but I've heard it's useful.

So, I shouldn't use this techinicke (probably wrong spelled) trying to
parse XML? Should i rather use minidom?

Thank you for for answering, I've learnt a lot from both of you,
Desthuilliers and Genellina! :)

[Bruno Desthuilliers]

MRAB a écrit :

On Jan 21, 9:15 pm, Bruno Desthuilliers
<[e-mail]:

>Arne a écrit :

(snip)

>>So, I shouldn't use this techinicke (probably wrong spelled)

May I suggest "technic" ?-)

That should be "technique"; just ask a Francophone! :-)

<mode="the usual frenchy">
My bad :(
</mode>