File Coverage

blib/lib/LINQ/Database.pm

Criterion	Covered	Total	%
statement	31	35	88.5
branch	3	6	50.0
condition	2	6	33.3
subroutine	10	10	100.0
pod	0	5	0.0
total	46	62	74.1

use 5.008003;
use strict;
use warnings;


our $AUTHORITY = 'cpan:TOBYINK';
our $VERSION   = '0.001';

use Class::Tiny qw( dbh );
use Scalar::Util ();

	my ( $self ) = ( shift );

	if ( @_ == 1 and Scalar::Util::blessed( $_[0] ) ) {
		return { dbh => $_[0] };
	}
	else {
		require DBI;
		return { dbh => 'DBI'->connect( @_ ) };
	}
}

	my ( $self ) = ( shift );
	my %args;
	if ( @_ == 1 and ref($_[0]) eq 'HASH' ) {
		%args = %{ $_[0] };
	}
	elsif ( @_ % 2 == 1 ) {
		%args = ( name => @_ );
	}
	else {
		%args = @_;
	}

	require LINQ::Database::Table;
	'LINQ::Database::Table'->new( { database => $self, %args } );
}

	my ( $self, $sql ) = ( shift, @_ );
	$self->{last_sql} = $sql;
	$self->dbh->prepare( $sql );
}

	my ( $self ) = ( shift );
	$self->dbh->quote( @_ );
}

	my ( $self ) = ( shift );
	$self->dbh->quote_identifier( @_ );
}

1;


=pod

=encoding utf-8

=head1 NAME

LINQ::Database - LINQ extension for working with databases

=head1 SYNOPSIS

  use LINQ;
  use LINQ::Util -all;
  use LINQ::Database;
  use DBI;

  my $db = 'LINQ::Database'->new( 'DBI'->connect( ... ) );

  $db
    ->table( 'pet' )
    ->where( check_fields 'name', -like => 'P%', -nocase )
    ->select( fields 'name', 'species' )
    ->foreach( sub {
      printf( "%s is a %s\n", $_->name, $_->species );
    } );

Or:

  use LINQ::DSL ':default_safe';
  use LINQ::Database;
  use DBI;

  my $db = 'LINQ::Database'->new( 'DBI'->connect( ... ) );

  my $collection = Linq {
    From $db->table( 'pet' );
    WhereX 'name', -like => 'P%', -nocase;
    SelectX 'name', 'species';
  };

  printf "Found %d results.\n", $collection->count;

  $collection->foreach( sub {
    printf( "%s is a %s\n", $_->name, $_->species );
  } );

=head1 DESCRIPTION

L<LINQ::Database> provides a L<LINQ::Collection>-compatible interface for
accessing SQL databases. It's basically B<< DLinq for Perl >>.

=head1 BUGS

Please report any bugs to
L<http://rt.cpan.org/Dist/Display.html?Queue=LINQ-Database>.

=head1 SEE ALSO

L<LINQ>.

=head1 AUTHOR

Toby Inkster E<lt>[e-mail]<gt>.

=head1 COPYRIGHT AND LICENCE

This software is copyright (c) 2021-2022 by Toby Inkster.

This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.

=head1 DISCLAIMER OF WARRANTIES

THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.