<< LotusScript: Lazy Coder Tricks | Home | Experiment: Theoretical Math>>
LotusScript: NotesDAO
Thu 27 Apr 2006
I've been twiddling with this and adding to it as seemed good and at this point I think there's enough to it to make it worth distributing. This is sort of an all in one data access layer for those of you who like the tiered approach to writing agents and scripted events. You can read more about tiered architecture here and here.
As the comment header says, it's just a wrapper for a bunch of notes data access methods, like db.search, view.getDocumentByKey and so on. There's also a script version of @dblookup as well as one that simply returns a view column. It's still a long way from the "end all" of DAOs, but it's a nice start and makes a lot of common data access tasks a bit easier. For example, instead of having to get a handle to a database, then a view and then a document, you can just ask for the document and pass the view name as a parameter. The database is passed when you instantiate the DAO class. There are a few other shortcuts as well. Hopefully other people will have their own additions to share! Feel free to post them here and I'll update the library as we go along.
Version History: NotesDAO 1.3.1