Re: [CentOS] Vim scripting - cursor motion

On 06/09/2011 08:37 AM, Les Mikesell wrote:

I'd highly recommend perl for this because it can also do the SQL part directly via DBI without all of the intermediate contortions you'll have to do in files otherwise. It should take about half a page of your own code to connect to the DB, read the file, transform it line-by-line to sql and execute the sql statements. And unlike other approaches with a pipeline of different tools, you can generate sensible error messages in the right places that have something to do with the input.

*AND* by using prepared statements in Perl you don't have to worry about escaping the text to prevent accidental SQL injections. It is all handled for you.