Re: How to execute file containing sql statements using dbi.
On 19/09/02, Arvind Raina ([EMAIL PROTECTED]) wrote: My requirement is to execute a set of sql statements which are stored in a file . I wanted to know if there is any method of doing the same using dbi . If not can you suggest some methods of doing the same. For postgres: psql -U user -d database file.sql from the command line on Unix. -- Rory Campbell-Lange [EMAIL PROTECTED] www.campbell-lange.net
Re: How to execute file containing sql statements using dbi.
There's also the DBI shell: dbish. dbish dsn user pass file.sql Tim. On Sun, Sep 22, 2002 at 12:09:06AM +0200, Bart Lateur wrote: On Thu, 19 Sep 2002 15:10:50 -0700 (PDT), Arvind Raina wrote: My requirement is to execute a set of sql statements which are stored in a file . I wanted to know if there is any method of doing the same using dbi . If not can you suggest some methods of doing the same. What database? If it's mysql, the easiest way would be to do mysql mydb myfile from the command line (likely with command line options -u for username and -p for password). I don't understand why you'd need the involvement of DBI, at all. -- Bart.
Re: How to execute file containing sql statements using dbi.
On Thu, 19 Sep 2002 15:10:50 -0700 (PDT), Arvind Raina wrote: My requirement is to execute a set of sql statements which are stored in a file . I wanted to know if there is any method of doing the same using dbi . If not can you suggest some methods of doing the same. What database? If it's mysql, the easiest way would be to do mysql mydb myfile from the command line (likely with command line options -u for username and -p for password). I don't understand why you'd need the involvement of DBI, at all. -- Bart.
How to execute file containing sql statements using dbi.
Hi , My requirement is to execute a set of sql statements which are stored in a file . I wanted to know if there is any method of doing the same using dbi . If not can you suggest some methods of doing the same. Thanks , Arvind - Do you Yahoo!? New DSL Internet Access from SBC Yahoo!
Re: How to execute file containing sql statements using dbi.
On 19 Sep 2002 at 15:10, Arvind Raina wrote: My requirement is to execute a set of sql statements which are stored in a file . I wanted to know if there is any method of doing the same using dbi . Sure, open the file with 'open', read the commands and pass them to dbi. If you are using taint-checking (you are using taint-checking, aren't you?), then you'll need to untaint the data before passing to dbi if you are inserting data into the db (I'm not sure if other operations with tainted data will cause an error or not...). See perlsec for details on untainting. Good luck, William -- Lead Developer Knowmad Services Inc. || Internet Applications Database Integration http://www.knowmad.com