| 141 | | namespace :sqlserver do |
|---|
| 142 | | desc 'Build the SQL Server test databases' |
|---|
| 143 | | task :build_databases do |
|---|
| 144 | | # Define a user named 'rails' in SQL Server with all privileges granted |
|---|
| 145 | | # Use an empty password for user 'rails', or alternatively use the OSQLPASSWORD environment variable |
|---|
| 146 | | # which allows you to set a default password for the current session. |
|---|
| 147 | | %x( osql -S localhost -U rails -Q "create database activerecord_unittest" -P ) |
|---|
| 148 | | %x( osql -S localhost -U rails -Q "create database activerecord_unittest2" -P ) |
|---|
| 149 | | %x( osql -S localhost -U rails -d activerecord_unittest -Q "exec sp_grantdbaccess 'rails'" -P ) |
|---|
| 150 | | %x( osql -S localhost -U rails -d activerecord_unittest2 -Q "exec sp_grantdbaccess 'rails'" -P ) |
|---|
| 151 | | %x( osql -S localhost -U rails -d activerecord_unittest -Q "grant BACKUP DATABASE, BACKUP LOG, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW to 'rails';" -P ) |
|---|
| 152 | | %x( osql -S localhost -U rails -d activerecord_unittest2 -Q "grant BACKUP DATABASE, BACKUP LOG, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW to 'rails';" -P ) |
|---|
| 153 | | %x( osql -S localhost -U rails -d activerecord_unittest -i #{File.join(SCHEMA_PATH, 'sqlserver.sql')} -n -P ) |
|---|
| 154 | | %x( osql -S localhost -U rails -d activerecord_unittest2 -i #{File.join(SCHEMA_PATH, 'sqlserver2.sql')} -n -P ) |
|---|
| 155 | | end |
|---|
| 156 | | |
|---|
| 157 | | desc 'Drop the SQL Server test databases' |
|---|
| 158 | | task :drop_databases do |
|---|
| 159 | | %x( osql -S localhost -U rails -Q "drop database activerecord_unittest" -P ) |
|---|
| 160 | | %x( osql -S localhost -U rails -Q "drop database activerecord_unittest2" -P ) |
|---|
| 161 | | end |
|---|
| 162 | | |
|---|
| 163 | | desc 'Rebuild the SQL Server test databases' |
|---|
| 164 | | task :rebuild_databases => [:drop_databases, :build_databases] |
|---|
| 165 | | end |
|---|
| 166 | | |
|---|
| 167 | | task :build_sqlserver_databases => 'sqlserver:build_databases' |
|---|
| 168 | | task :drop_sqlserver_databases => 'sqlserver:drop_databases' |
|---|
| 169 | | task :rebuild_sqlserver_databases => 'sqlserver:rebuild_databases' |
|---|
| 170 | | |
|---|
| 171 | | |
|---|