in reply to MySQL Table Creation using DBI
Others have mentioned the need of meta-data to do so.
Lacking experience it is likely that you need to
hand write a table definition, or two, just to prepare
yourself to create the meta-data.
If you only have this one data structure it probably
is easiest to just hand write your table definitions.
If you do decide to use meta-data to create your code,
don't make the error of skimping on it. The more your
meta-data tells you about your data the more capable your
generation scheme will be.
_Advanced_Perl_Programming_, by Srinivasan, from
O'Reilly, has a very accessable introduction to code
generation. Note that the tool described there is not
completely implemented as described.
If you do decide to generate your code, I would suggest
that you use a simple config file or such for your
meta-data. Avoids the difficulties of fetching it from
a database.
|
|---|