view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

0.11  Wed Feb  7 12:38:38 2007
       Sub-queries can refer to tables in the outer scope.
       Translate "lc" and "uc" to "lower" and "upper", respectively.
       Added support to EXISTS-style sub-queries.
       Added support for SELECT DISTINCT.
       Added support for special labels syntax.

0.10  Tue Feb  6 09:46:58 2007
       Added support for simple funcalls.
       PadWalker module is now optional.
       Terms can stand by themselves.

0.09  Mon Feb  5 14:27:52 2007
       Added db_update().

0.08  Mon Feb  5 12:16:22 2007
       Added support of subselects on threaded perls.
       Regexes on older versions of SQLite made to work.
       Implemented db_insert().

t/50.sqlite-real.t  view on Meta::CPAN

use warnings;
use strict;
use lib '.';
use Test::More;
use DBIx::Perlish qw/:all/;
use t::test_utils;

eval "use DBD::SQLite;";
plan skip_all => "DBD::SQLite cannot be loaded" if $@;

eval "use PadWalker;";
plan skip_all => "PadWalker cannot be loaded" if $@;

plan tests => 104;

my $dbh = DBI->connect("dbi:SQLite:");
ok($dbh, "db connection");
ok($dbh->do("create table names (id integer, name text)"), "table create");
is(DBIx::Perlish::_get_flavor($dbh), "sqlite", "correct flavor");

my $o = DBIx::Perlish->new(dbh => $dbh);