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:
Extended [Convertchars] needed (1997)
Logging users (1998)
webcat NT (1998)
WebCat for Site Search? (1997)
Date format problems (1997)
Newbie problem blah blah blah (1997)
Database Program (1997)
Auto-email upon restart? (2001)
Which [index]? (1997)
[OT] Xserve (2002)
Falsifying [BROWSERNAME] (1998)
DON'T use old cart file! (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
How to search for fields with 10 or more characters? (2004)
More news on 5.0 (2003)
Newbie Help Needed (1998)
Fun with Dates - any progress? (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
using showpage and showcart commands (1996)
Not really WebCat (1997)