Added quote char test, supported quoting in S::A subclass for joins

[dbsrgits/DBIx-Class.git] / t / 14mssql.t

use lib qw(lib t/lib);\r
use DBICTest::Schema;\r
\r
use Test::More;\r
\r
my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MSSQL_${_}" } qw/DSN USER PASS/};\r
\r
#warn "$dsn $user $pass";\r
\r
plan skip_all, 'Set $ENV{DBICTEST_MSSQL_DSN}, _USER and _PASS to run this test'\r
  unless ($dsn);\r
\r
plan tests => 4;\r
\r
DBICTest::Schema->compose_connection( 'MSSQLTest' => $dsn, $user, $pass );\r
\r
my $dbh = MSSQLTest::Artist->storage->dbh;\r
\r
$dbh->do("IF OBJECT_ID('artist', 'U') IS NOT NULL\r
    DROP TABLE artist");\r
\r
$dbh->do("CREATE TABLE artist (artistid INT IDENTITY PRIMARY KEY, name VARCHAR(255));");\r
\r
MSSQLTest::Artist->load_components('PK::Auto::MSSQL');\r
\r
# Test PK\r
my $new = MSSQLTest::Artist->create( { name => 'foo' } );\r
ok($new->artistid, "Auto-PK worked");\r
\r
# Test LIMIT\r
for (1..6) {\r
    MSSQLTest::Artist->create( { name => 'Artist ' . $_ } );\r
}\r
\r
my $it = MSSQLTest::Artist->search( { },\r
    { rows     => 3,\r
      offset   => 2,\r
      order_by => 'artistid'\r
    }\r
);\r
\r
is( $it->count, 3, "LIMIT count ok" );\r
is( $it->next->name, "Artist 2", "iterator->next ok" );\r
$it->next;\r
$it->next;\r
is( $it->next, undef, "next past end of resultset ok" );\r
\r
1;\r