You're missing the point. When you have to write another script that deals with connecting to this MySQL database, but does not have to deal with the CSV files, then you can just use the database connectivity code without having to deal with the overhead of the CSV stuff. Your other task is the perfect example of this. You simply use the DB connectivity code cause that's all you need.

As for "letting the user override" stuff ... YOU are the user of the module. The module doesn't know, nor care, about your end users. Maybe I should've used the term "client" or "caller", instead.

The functions you need in both scripts should also be broken about into functional areas. Think about this not in terms of your current task, but in terms of tasks you don't know about yet.

Here's another spin on it - why do we organize our kitchens? I mean, we're done with the task at hand, which is making today's dinner. Why put the silverware in one drawer and the dishes in another and the pots in a cupboard? Because - being organized and having functional areas defined makes things easier the next time.

------
We are the carpenters and bricklayers of the Information Age.

The idea is a little like C++ templates, except not quite so brain-meltingly complicated. -- TheDamian, Exegesis 6

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

In reply to Re3: variables / consts for different scripts by dragonchild
in thread variables / consts for different scripts by Skeeve

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.