NAME

SYNOPSIS

    package My::QueryBuilder;
    use parent qw/SQL::Maker/;
    __PACKAGE__->load_plugin('InsertOnDuplicate');

    package main;
    my $qb = My::QueryBuilder->new(driver => 'mysql');
    $qb->insert_on_duplicate('member', { email => 'foo@exapmle.com', name => $name }, { name => $name });

DESCRIPTION

METHODS

$query_builder->insert_on_duplicate($table_name:Str, $insert_values:HashRef, $update_values:HashRef)

Generate "INSERT ... ON DUPLICATE KEY UPDATE ...".

$table_name is table name to operate.

$insert_values is values to insert.

$table_name and $insert_values are passing to "SQL::Maker#insert"

$update_values is SET part for ON DUPLICATE KEY UPDATE. It's processed by "SQL::Maker#make_set_clause".

SEE ALSO