in reply to
Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI
in thread Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI
Yes, because it's probably working by mind control.
Uh, more seriously, the only way that you could reliably (and this probably needs several levels of qualification) avoid this breaking your code would be to interrogate the database prior to each select (and this still wouldn't save you in the event that the database is changed in the time between your first 'interrogation' select and your second 'data' select).
What you'd need to do is either:
- Use DBI to return a list of the table's field names (this would help you determine if your hashref query would break) -- I'm not sure if this is even possible, but the $dbh->table_info looks like it might offer something of value
- Create a table of 'meta' information -- one whose field names might be something along the lines of table_name, column_name, column_type and so on. If you are writing a complete interface for an extensible system then this would probably be a much better way to go because you can force people to use your scripts to modify the tables and, at the same time, update the meta information in the meta table. That way, your scripts could turn to a reliable source for information about the tables they are querying while still permitting the tables to change.
Obviously, I lean towards the latter solution, but it requires that you be able to restrict modifications to the tables to the tools that you provide.