Re: Updating a database once per day - An example
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17966
interpreted = N
texte = Thanks Ken,As you point out, this situation would be for after a database file hasbeen manually changed. Often an organization will have a legacy database,and their IT department will be able to easily export a tab-delimiteddatabase to the Web server on a regular basis (i.e. once per hour, or onceper day). After each new export of the database to the Web server,WebCatalog must be issued the [closedatabase] command for each applicablefile.[CloseDatabase mydatabase.db] does two things: 1) It writes all changes to disk (in this example, there are nochanges so nothing happends) 2) It then flushes the database from RAMNow, what I am trying to accomplish, mydatabase.db (which happens to becopied from the MainFrame to the Web Server at 3:03AM each night with thename mydatabase.db) will be closed at 3:10am, and then re-openned withfresh contents the next time it is needed.Stevesteve@pop-art.com>>Here's an example of how I implemented a solution for making sure that>>Webcatalog is using the most recent copy of mydatabase.db:>>>>Rather than issuing an Applescript to tell Webcatalog to close databases at>>a certain time each day, I generated some WEBDNA that will close a specific>>database the first time it is needed after 3:10am.>>>>Here's the code:>>>>>>[SHOWIF [LOOKUP>>DB=flush.db&value=[url][date][/url]&lookinfield=DATE1&returnfield=TIME1¬fou>>nd>>=NOT_FOUND]=NOT_FOUND]>>>>[SHOWIF [time %H]>2]>>[SHOWIF [time %M]>9]>>[CLOSEDATABASE ../mydatabase.db] >>[CLOSEDATABASE FLUSH.DB] >>[APPEND flush.db]DATE1=[URL][date][/URL]&TIME1=[URL][TIME][/URL][/APPEND]>>[/SHOWIF][/SHOWIF][/SHOWIF]>>>>--------------------->>flush.db:>>>>DATE1 TIME1>>05/28/1998 14:48:50>>05/29/1998 07:18:43>>>>---------------------->>I welcome all questions and suggestions.>>>Hi Steve,>>I din't understand what you're trying to accomplish here. Your code closes>the mydatabase.db file, but it doesn't change anything in that db,and it>doesn;t replace that file with another file. You never have to close the>db just to make sure WebCat's using the most recent data, because the most>recent data is always in RAM -- unless you're thinking about manually>replacing that file with another more recent one. Is that what you're>trying to accomplish here? Sorry I don't understand ...>>Sincerely,>Ken Grome>808-737-6499>WebDNA Solutions>mailto:ken@webdna.net>http://www.webdna.net
Associated Messages, from the most recent to the oldest:
Thanks Ken,As you point out, this situation would be for after a database file hasbeen manually changed. Often an organization will have a legacy database,and their IT department will be able to easily export a tab-delimiteddatabase to the Web server on a regular basis (i.e. once per hour, or onceper day). After each new export of the database to the Web server,WebCatalog must be issued the
[closedatabase] command for each applicablefile.[CloseDatabase mydatabase.db] does two things: 1) It writes all changes to disk (in this example, there are nochanges so nothing happends) 2) It then flushes the database from RAMNow, what I am trying to accomplish, mydatabase.db (which happens to becopied from the MainFrame to the Web Server at 3:03AM each night with thename mydatabase.db) will be closed at 3:10am, and then re-openned withfresh contents the next time it is needed.Stevesteve@pop-art.com>>Here's an example of how I implemented a solution for making sure that>>Webcatalog is using the most recent copy of mydatabase.db:>>>>Rather than issuing an Applescript to tell Webcatalog to close databases at>>a certain time each day, I generated some WEBDNA that will close a specific>>database the first time it is needed after 3:10am.>>>>Here's the code:>>>>>>[SHOWIF [LOOKUP>>DB=flush.db&value=
[url][date][/url]&lookinfield=DATE1&returnfield=TIME1¬fou>>nd>>=NOT_FOUND]=NOT_FOUND]>>>>[SHOWIF [time %H]>2]>>[SHOWIF [time %M]>9]>>[CLOSEDATABASE ../mydatabase.db] >>[CLOSEDATABASE FLUSH.DB] >>[APPEND flush.db]DATE1=
[url][date][/URL]&TIME1=
[url][time][/URL][/APPEND]>>[/SHOWIF][/SHOWIF][/SHOWIF]>>>>--------------------->>flush.db:>>>>DATE1 TIME1>>05/28/1998 14:48:50>>05/29/1998 07:18:43>>>>---------------------->>I welcome all questions and suggestions.>>>Hi Steve,>>I din't understand what you're trying to accomplish here. Your code closes>the mydatabase.db file, but it doesn't change anything in that db,and it>doesn;t replace that file with another file. You never have to close the>db just to make sure WebCat's using the most recent data, because the most>recent data is always in RAM -- unless you're thinking about manually>replacing that file with another more recent one. Is that what you're>trying to accomplish here? Sorry I don't understand ...>>Sincerely,>Ken Grome>808-737-6499>WebDNA Solutions>mailto:ken@webdna.net>http://www.webdna.net
Steve Rosenbaum
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
unitshipcost vs shipcosts (1997)
IP Address (2001)
Chown www:wheel Almost There WebCat 5 on itools 7 (2003)
NT 4.0/IIS WebCat Installation (1998)
TCP Connect/send and CGI (2003)
[referrer] tag (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)
Resume Catalog ? (1997)
Search with Special Chars (1997)
Who is John Jakovich? (1999)
Poll using WebCat (1998)
NT considerations (1997)
Next X hits (1996)
Running 2 two WebCatalog.acgi's (1996)
can WC render sites out? (1997)
Just Testing (1997)
Sorting Numbers (1997)
The IBC root beer has arrived! (1997)
select multiple (1997)
Simple Database close connection (2001)