use strict;
use warnings;
use lib 't/lib';
use Util;
use Test::More;

my $test = mk_test 'insert_multi';

$test->(
    desc    => 'basic',
    input   => [
        foo => [qw/bar baz/],
        [ [qw/hoge fuga/], [qw/fizz buzz/] ],
    ],
    expects => {
        stmt => 'INSERT INTO `foo` (`bar`, `baz`) VALUES (?, ?), (?, ?)',
        bind => [qw/hoge fuga fizz buzz/],
    },
);

$test->(
    desc    => 'mismatch params',
    input   => [
        foo => [qw/bar baz/],
        [ [qw/hoge fuga/], [qw/fizz buzz fizzbuzz/], [qw//] ],
    ],
    expects => {
        stmt => 'INSERT INTO `foo` (`bar`, `baz`) VALUES (?, ?), (?, ?), (?, ?)',
        bind => [qw/hoge fuga fizz buzz/, undef, undef],
    },
);

$test->(
    desc    => 'complex',
    input   => [
        foo => [qw/bar baz/],
        [ ['hoge', \'NOW()'], ['fuga', \['UNIX_TIMESTAMP(?)', '2012-12-12'] ] ],
    ],
    expects => {
        stmt => 'INSERT INTO `foo` (`bar`, `baz`) VALUES (?, NOW()), (?, UNIX_TIMESTAMP(?))',
        bind => [qw/hoge fuga 2012-12-12/],
    },
);

$test->(
    desc    => 'insert ignore',
    input   => [
        foo => [qw/bar baz/],
        [ [qw/hoge fuga/], [qw/fizz buzz/] ],
        { prefix => 'INSERT IGNORE INTO' },
    ],
    expects => {
        stmt => 'INSERT IGNORE INTO `foo` (`bar`, `baz`) VALUES (?, ?), (?, ?)',
        bind => [qw/hoge fuga fizz buzz/],
    },
);

$test->(
    desc => 'on duplicate key update',
    input   => [
        foo => [qw/bar baz/],
        [ [qw/hoge fuga/], [qw/fizz buzz/] ],
        { update => { bar => 'piyo' } },
    ],
    expects => {
        stmt => 'INSERT INTO `foo` (`bar`, `baz`) VALUES (?, ?), (?, ?) ON DUPLICATE KEY UPDATE `bar` = ?',
        bind => [qw/hoge fuga fizz buzz piyo/],
    },
);

done_testing;