Hey all!
I am considering BaseX to hold event information for a broadcast graphics play out system. This system gets a lot of event data from the planning system. Each segment can have up to 12 events, and a day in a typical commercial tv-channel has about 120-160 segments. The commercial breaks not included.
Every time a full day of programming is made for a channel, an xml file is produced containing a lot of (badly formatted) EVENT nodes, below a typical "coming next" event:
<EVENT IDdeko="109213416" DATE="2012-09-21" CHANNEL_ID="123" VIDEOFORMAT="2"> <SCENARIO ID="29"> <METADATA pos="0" value="00:20"/> <METADATA pos="1" value="The Godfather pt III"/> <METADATA pos="2" value="American drama from 1990 with Al Pacino and Andy Garcia"/> </SCENARIO> </EVENT>
I have manually created a database from one of these export xml files and manged to call a BaseXClient dll that I compiled from your examples to retrieve data from the database. All is well with that. Now to my question, since I'm not really familiar with databases in general...
Is it possible to set up a "watch folder" for the incoming xml files that will add them to a specified database or would I have to create an application for this?
The second question is about housekeeping, since we are handling about 20 channels with this database, the number of events in the database will increase quite fast. Is it possible to specify an xpath search that would match all events with a date more than X days back in time and delete them from the database, i.e delete data from the database without calling the exact file the data was imported with?
Best regards
SamTheSwede Stockholm