<commit_before><commit_msg> r3635@agentz-office (orig r940):  agentzh | 2007-12-10 15:59:03 +0800  [openapi] added 09-sql-insert.t<commit_after>use lib 'lib';
use strict;
use warnings;

use Test::More tests => 4;
BEGIN { use_ok('SQL::Insert'); }

my $insert = SQL::Insert->new;
$insert->insert( 'models' )
       ->values( 'abc' => '"howdy"' );

is $insert->generate, <<_EOC_;
insert into models values (abc, "howdy");
_EOC_

is "$insert", <<_EOC_;
insert into models values (abc, "howdy");
_EOC_

$insert->cols('foo', 'bar');

is $insert->generate, <<_EOC_;
insert into models (foo, bar) values (abc, "howdy");
_EOC_

{'fraction_non_alphanumeric': 0.19579288025889968, 'fraction_numerical': 0.045307443365695796, 'mean_word_length': 5.128712871287129, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 11, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3577991', 'n_tokens_mistral': 257, 'n_tokens_neox': 234, 'n_words': 65}