Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Obtaining SQL updates for application to another database

by r34d0nl1 (Pilgrim)
on Apr 05, 2005 at 11:28 UTC ( #444936=note: print w/replies, xml ) Need Help??


in reply to Obtaining SQL updates for application to another database

Why not just warning or printing to somewhere the statements that are updates?
It's in your script, just echo it.
then the DBA can just copy and paste then or execute as an sql script.
maybe i didn't get the correct picture of what you intend to do... thx
  • Comment on Re: Obtaining SQL updates for application to another database

Replies are listed 'Best First'.
Re^2: Obtaining SQL updates for application to another database
by rinceWind (Monsignor) on Apr 05, 2005 at 11:52 UTC

    The script uses Class::DBI. Updates to individual columns consist of method calls. The whole idea behind Class::DBI is that it is an object persistence layer, and enables the developer to avoid writing SQL.

    If the script were using plain vanilla DBI, it would contain SQL, but probably be at least twice as long.

    --
    I'm Not Just Another Perl Hacker

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://444936]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2019-10-16 05:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?