5 use DBIx::Class::Optional::Dependencies ();
9 plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for ('test_rdbms_mssql_ado')
10 unless DBIx::Class::Optional::Dependencies->req_ok_for ('test_rdbms_mssql_ado');
12 # Example DSN (from frew):
13 # dbi:ADO:PROVIDER=sqlncli10;SERVER=tcp:172.24.2.10;MARS Connection=True;Initial Catalog=CIS;UID=cis_web;PWD=...;DataTypeCompatibility=80;
15 my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MSSQL_ADO_${_}" } qw/DSN USER PASS/};
17 plan skip_all => 'Set $ENV{DBICTEST_MSSQL_ADO_DSN}, _USER and _PASS to run this test'
18 unless ($dsn && $user);
20 my $schema = DBICTest::Schema->connect($dsn, $user, $pass);
21 $schema->storage->ensure_connected;
23 isa_ok( $schema->storage, 'DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server' );
25 my $ver = $schema->storage->_server_info->{normalized_dbms_version};
27 ok $ver, 'can introspect DBMS version';
29 is $schema->storage->sql_limit_dialect, ($ver >= 9 ? 'RowNumberOver' : 'Top'),
30 'correct limit dialect detected';
32 $schema->storage->dbh_do (sub {
33 my ($storage, $dbh) = @_;
34 eval { local $^W = 0; $dbh->do("DROP TABLE artist") };
37 artistid INT IDENTITY NOT NULL,
39 rank INT NOT NULL DEFAULT '13',
40 charfield CHAR(10) NULL,
46 my $new = $schema->resultset('Artist')->create({ name => 'foo' });
47 ok($new->artistid > 0, 'Auto-PK worked');
49 # make sure select works
50 my $found = $schema->resultset('Artist')->search({ name => 'foo' })->first;
51 is $found->artistid, $new->artistid, 'search works';
53 # test large column list in select
54 $found = $schema->resultset('Artist')->search({ name => 'foo' }, {
55 select => ['artistid', 'name', map \"'foo' foo_$_", 0..50],
56 as => ['artistid', 'name', map "foo_$_", 0..50],
58 is $found->artistid, $new->artistid, 'select with big column list';
59 is $found->get_column('foo_50'), 'foo', 'last item in big column list';
61 # create a few more rows
63 $schema->resultset('Artist')->create({ name => 'Artist ' . $_ });
66 # test multiple active cursors
67 my $rs1 = $schema->resultset('Artist')->search({}, { order_by => 'artistid' });
68 my $rs2 = $schema->resultset('Artist')->search({}, { order_by => 'name' });
71 ok eval { $rs2->next }, 'multiple active cursors';
74 # test bug where ADO blows up if the first bindparam is shorter than the second
75 is $schema->resultset('Artist')->search({ artistid => 2 })->first->name,
79 is $schema->resultset('Artist')->search({ artistid => 13 })->first->name,
87 my $warn_handler = $SIG{__WARN__} || sub { warn @_ };
88 local $SIG{__WARN__} = sub {
89 $warn_handler->(@_) unless $_[0] =~ /Not a Win32::OLE object/
91 if (my $dbh = eval { $schema->storage->_dbh }) {
92 eval { $dbh->do("DROP TABLE $_") }