A big problem is that, as I proceeded, I had no idea what I was doing for a lot of it. What I know about writing Perl modules, I know due to this workflow. Well, I knew "start with
Package and end with 1 ;", but beyond that, not a whole lot. The web has helped this process a lot, and now I'm not too ashamed at what I have.(Object orientation. Moose. It could use improvement and I would learn from the experience. But that isn't today's topic.)
So, by and large, I have modules handling the SQL queries, then passing hashes or hashrefs, depending on what I want. But, as I said, I was figuring out what I'm doing as I go along. I'd get the problem, think "I need these tables", write modules to interface with the tables, write programs that use the modules, fail to write tests for the modules because what tests I could imagine are either trivially stupid or highly dependent on the state of the database (I have Perl Testing on my desk and have worked through the first two chapters, so I know it's a failing, but see the note on object orientation.)
In a practical sense, if I'm dealing with a foo, I will have a table
foo and maybe foo_attributes connecting with it. Then I'd write the module Foo.pm with create_foo, update_foo, delete_foo, read_foo and get_foo_list for a list of all the foos in the table. I can tell which tables I'm dealing with from the function name, for the most part. When it gets to the interaction of foos, bars and blees, it gets hairy, but that's why I get paid the big bucks, right?Right now, I'm looking to document the schema and
DROP TABLE cruft before adding a few more features, which means what I'd like to do is look through my code base for all the modules I'm responsible for, search for all the functions I'm calling in each, and give me a list that might look something like this:list_foo.cgiVarLogRant::Fooget_foo_listread_foo
Sounds like you're looking for an ORM like DBIx::Class?
ReplyDeleteMaybe?
ReplyDeleteI perhaps didn't help myself by mentioning the DB. Right now, and I've gone ahead and and started developing what I think I need right now, is this:
Get a list of modules I'm looking at.
Get a list of functions in each module.
Get a list of programs, and a comment-removed dump of each program.
For each program, check each function of each module to see if it's called.
Of course, the crucial step is knowing which functions are never called, which I've failed to account for in that pseudocode above.
Which is again why I'm hoping for something that exists, because then someone might've thought through all the way.
Ah, it looks like I didn't read your post very well there; I thought you were suggesting that what you've written to interact with the database sounds like a solved problem and asking for recommendations; upon re-reading, I see you're actually asking how to get a list of modules and methods, along with which ones get called.
ReplyDeleteSorry for the confusion. I see by your follow-up post that you've now sorted something out to do it :)
Absolutely not a problem. I don't know if the problem falls to your comprehension or my writing, and either way, it's not too much of a problem. Thanks for reading!
ReplyDelete