/***=====================================================================
:: created by: Alex Kriegel
:: created on: 05/17/2010
:: file: exec.sql
:: dependency: none
:: dependency: hardcoded files for inc. script files; 
:: could potentially be moved into config include
:: parameters: none
:: output: creates all database objects
::=======================================================================
***/
USE [master]
GO
SET NOCOUNT ON

:On Error exit
PRINT 'installing TEST database...'
-- include all configuration parameters
:r C:\hudson\jobs\db\workspace\test\constants.config
--------------------------------------------------------------------------------------------------------
-- backup existing database
--------------------------------------------------------------------------------------------------------
PRINT 'running script: [backupDB.sql]'
:r C:\hudson\jobs\db\workspace\test\backupDB.sql

PRINT 'the TESTdatabase was backed up'
-------------------------------------------------------------------------------------------------------
-- create database
-------------------------------------------------------------------------------------------------------
PRINT 'running script: [createDB.sql]'
:r C:\hudson\jobs\db\workspace\test\createDBt.sql

GO
------------------------------------------------------------------------------------------------------
-- executing GO commund flushes batch buffer
-- all context is lost to subsequent commands
------------------------------------------------------------------------------------------------------

PRINT 'the TEST database was created'
------------------------------------------------------------------------------------------------------
-- switch context
------------------------------------------------------------------------------------------------------
USE [test]
------------------------------------------------------------------------------------------------------
-- tables
------------------------------------------------------------------------------------------------------
PRINT 'running script: [createTables.sql]'
:r C:\hudson\jobs\db\workspace\test\createTablessql
PRINT 'finished creating tables...'
-----------------------------------------------------------------------------------------------------
-- functions
-----------------------------------------------------------------------------------------------------
PRINT 'running script:[createFunctions.sql]'
:r C:\hudson\jobs\db\workspace\test\createFunctions.sql
PRINT 'finished creating UDF'
-----------------------------------------------------------------------------------------------------
-- views
-----------------------------------------------------------------------------------------------------
PRINT 'running script:[createViews.sql]'
:r C:\hudson\jobs\db\workspace\test\createViews.sql
PRINT 'finished creating views...'
----------------------------------------------------------------------------------------------------
-- stored procedures
----------------------------------------------------------------------------------------------------
PRINT 'running script: [createProcedures.sq]l'
:r C:\hudson\jobs\db\workspace\test\createProcedures.sql
PRINT ' finished creating procedures'
----------------------------------------------------------------------------------------------------
-- users
----------------------------------------------------------------------------------------------------
PRINT 'running script:[createUsers.sql]'
:r C:\hudson\jobs\db\workspace\test\createUsers.sq
PRINT ' users created'
----------------------------------------------------------------------------------------------------
-- permissions
----------------------------------------------------------------------------------------------------
PRINT 'running script:[grantPermissions.sql]'
:r C:\hudson\jobs\db\workspace\test\grantPermissions.sq
PRINT ' permissions granted'
----------------------------------------------------------------------------------------------------
-- constraints
----------------------------------------------------------------------------------------------------
PRINT 'running script: [createConstraints.sql]'
:r C:\hudson\jobs\db\workspace\test\createConstraints.sql
PRINT ' constraints created'
----------------------------------------------------------------------------------------------------
-- data
----------------------------------------------------------------------------------------------------
PRINT  'importing data...'
:r C:\hudson\jobs\db\workspace\test\data.sql
PRINT  'data imported...'
--------------------------------------------------------------------------------------------------------------------------------
PRINT 'creating TEST database objects and importing data is completed'