chucknorris/roundhouse — pull request #126 by kolupaev (2013-10-01 23:58:13+00:00)
Title: NSpec integration tests for MSSQL and MySQL

Hi, I've prototyped nspec style integration tests for the project.
The tests cover basic scenarios of sequential runs of roundhouse on 2 databases.

Please let me know what do you think.

Here is an example of the spec:

describe roundhouse spec
when mssql
rh executed with v2 scripts
should create table timmy
should create table SampleItems
get assert database one time scripts run should be Convert 3
have v1 database
should create table timmy
should not create table SampleItems
get assert database one time scripts run should be Convert 1
rh executed v2 in dry run mode
should not create table SampleItems
get assert database one time scripts run should be Convert 1
rh executed v2 in normal mode
should create table SampleItems
get assert database one time scripts run should be Convert 3
rh executed v2 in baseline mode
should not create table SampleItems
get assert database one time scripts run should be Convert 3
rh executed v2 in normal mode
should not create table SampleItems
get assert database one time scripts run should be Convert 3
rh executed v2 in normal mode
should create table SampleItems
get assert database one time scripts run should be Convert 3
when mysql
rh executed with v2 scripts
should create table timmy
should create table SampleItems
get assert database one time scripts run should be Convert 3
have v1 database
should create table timmy
should not create table SampleItems
get assert database one time scripts run should be Convert 1
rh executed v2 in dry run mode
should not create table SampleItems
get assert database one time scripts run should be Convert 1
rh executed v2 in normal mode
should create table SampleItems
get assert database one time scripts run should be Convert 3
rh executed v2 in baseline mode
should not create table SampleItems
get assert database one time scripts run should be Convert 3
rh executed v2 in normal mode
should not create table SampleItems
get assert database one time scripts run should be Convert 3
rh executed v2 in normal mode
should create table SampleItems
get assert database one time scripts run should be Convert 3

32 Examples, 0 Failed, 0 Pending

C:\Users\valera\Documents\GitHub\roundhouse>