NAME

SQL::Engine::Operation - SQL Statement Operation

ABSTRACT

SQL Statement Operation

SYNOPSIS

use SQL::Engine::Operation;

my $operation = SQL::Engine::Operation->new(
  statement => 'SELECT * FROM "tasks" WHERE "reporter" = ? AND "assigned" = ?',
  bindings => {
    0 => 'user_id',
    1 => 'user_id'
  }
);

# my @bindings = $operation->parameters({
#   user_id => 123
# });

DESCRIPTION

This package provides SQL Statement Operation.

LIBRARIES

This package uses type constraints from:

Types::Standard

ATTRIBUTES

This package has the following attributes:

bindings

bindings(HashRef)

This attribute is read-only, accepts (HashRef) values, and is required.

statement

statement(Str)

This attribute is read-only, accepts (Str) values, and is required.

METHODS

This package implements the following methods:

parameters

parameters(Maybe[HashRef] $values) : ArrayRef

The parameters method returns positional bind values for use with statement handlers.

parameters example #1

# given: synopsis

my $bindings = $operation->parameters({
  user_id => 123
});

# [123, 123]

AUTHOR

Al Newkirk, awncorp@cpan.org

LICENSE

Copyright (C) 2011-2019, Al Newkirk, et al.

This is free software; you can redistribute it and/or modify it under the terms of the The Apache License, Version 2.0, as elucidated in the "license file".

PROJECT

Wiki

Project

Initiatives

Milestones

Contributing

Issues

cpanm SQL::Engine

perl -MCPAN -e shell
install SQL::Engine