NAME

SQL::Engine::Operation - SQL 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