[dbsrgits/DBIx-Class.git] / t / 19quotes.t

use strict;
use Test::More;
use IO::File;

BEGIN {
    eval "use DBD::SQLite";
    plan $@
        ? ( skip_all => 'needs DBD::SQLite for testing' )
        : ( tests => 3 );
}

use lib qw(t/lib);

use_ok('DBICTest');

use_ok('DBICTest::HelperRels');

DBICTest->schema->storage->sql_maker->{'quote_char'} = q!'!;
DBICTest->schema->storage->sql_maker->{'name_sep'} = '.';

my $rs = DBICTest::CD->search(
           { 'me.year' => 2001, 'artist.name' => 'Caterwauler McCrae' },
           { join => 'artist' });

cmp_ok( $rs->count, '==', 1, "join with fields quoted");
Commit	Line	Data
2a816814	1	use strict;
	2	use Test::More;
	3	use IO::File;
	4
	5	BEGIN {
	6	eval "use DBD::SQLite";
	7	plan $@
	8	? ( skip_all => 'needs DBD::SQLite for testing' )
22b15c96	9	: ( tests => 3 );
2a816814	10	}
	11
	12	use lib qw(t/lib);
	13
	14	use_ok('DBICTest');
	15
22b15c96	16	use_ok('DBICTest::HelperRels');
22b15c96	17
66d9ef6b	18	DBICTest->schema->storage->sql_maker->{'quote_char'} = q!'!;
66d9ef6b	19	DBICTest->schema->storage->sql_maker->{'name_sep'} = '.';
2a816814	20
2a816814	21	my $rs = DBICTest::CD->search(
54540863	22	{ 'me.year' => 2001, 'artist.name' => 'Caterwauler McCrae' },
2a816814	23	{ join => 'artist' });
	24
	25	cmp_ok( $rs->count, '==', 1, "join with fields quoted");
	26