And yes, unfortunately, you will have to take care of quoting the data yourself.
...that's half the point of my question, and being forced to use 'generate' defeats the benefit of using SQL::Abstract.
Nonetheless, thanks. I'd glossed over the generate function in the first place, and the following is sufficient for simple inserts:
my $dbh = DBI->Connect(@params); # initialized elsewhere
my $sqlgen = SQL::Abstract->new;
my %data = (a => undef, b => 1, c => q/'string and string'/);
$_ = $dbh->quote($_) for values %data;
print scalar $sqlgen->generate('insert into',\'atable',\%data);
__END__
# prints:
INSERT INTO atable SET a = NULL, b = '1', c = '\'string and string\''
(Not sure whether the way it's quoting might cause trouble with, e.g., ZIP codes, where '08540' <> 8540...)
Still interested in a broader solution.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|