TIP: Click on subject to list as thread! ANSI
echo: xml.dbms
to: Jesper S?rensen
from: Dale Ross
date: 2002-12-20 16:51:52
subject: Re: xml.dbms echo

MB>>> Do the GNU diff and patch utilities work? If so, then why not use
 MB>>> them.

 DR>> Good question that I currently do not have the answer to!

 JS> They will work for updating the XML file, but it won't help the poor
 JS> guys (e.g. me :) who keep the nodelist in a SQL database. I want to
 JS> generate INSERT/UPDATE/DELETE statements directly from the diff, not
 JS> update the XML file and then "truncate table" and load the entire
 JS> nodelist from file again... :-(

 JS> We need to list the full address of the changed nodes, and specify what
 JS> kind of action is to be taken for it (add, delete or modify). I'll try
 JS> to do some experimenting during the holidays, if noone else figures
 JS> something out first. :-)

I understand your concern. This could be an attribute of the node:

sqlupdate="add"
sqlupdate="delete"
sqlupdate="modify"

Or something like that. Is that what you mean?

With best regards, Dale Ross.  E-mail: Dale.Ross{at}p1.f1.n379.z1.fidonet.org

--- Fidolook Lite FTN stub 
* Origin: FidoHub Point 1 (1:379/1.1)
SEEN-BY: 633/267 270
@PATH: 379/1 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.