public ExecuteProcedure(IDbEnvironment dbEnvironment, String procedureName, int errorCode)
{
this.procedureName = procedureName;
this.dbEnvironment = dbEnvironment;
expectException = true;
this.errorCode = errorCode;
}
public ExecuteProcedure(IDbEnvironment dbEnvironment, String procedureName, bool expectException)
{
this.procedureName = procedureName;
this.dbEnvironment = dbEnvironment;
this.expectException = expectException;
errorCode = null;
}
public static DataTable GetDataTable(String query,IDbEnvironment environment)
{
DbCommand dc = environment.CreateCommand(query, CommandType.Text);
if (Options.ShouldBindSymbols())
environment.BindFixtureSymbols(dc);
DbDataAdapter oap = environment.DbProviderFactory.CreateDataAdapter();
oap.SelectCommand = dc;
var ds = new DataSet();
oap.Fill(ds);
dc.Dispose();
return ds.Tables[0];
}
public static DbParameterAccessor Clone(DbParameterAccessor dbacc, IDbEnvironment environment)
{
DbParameter cloneP=environment.DbProviderFactory.CreateParameter();
cloneP.ParameterName=dbacc.DbParameter.ParameterName;
cloneP.DbType= dbacc.DbParameter.DbType;
cloneP.Direction= dbacc.DbParameter.Direction;
cloneP.Size= dbacc.DbParameter.Size;
cloneP.SourceColumn = dbacc.DbParameter.SourceColumn;
cloneP.Value=dbacc.DbParameter.Value;
DbParameterAccessor clone=new DbParameterAccessor(cloneP, dbacc.dotNetType,dbacc.position, dbacc.actualSqlType);
clone.dbFieldName=dbacc.dbFieldName;
clone.isBoundToCheckOperation=dbacc.isBoundToCheckOperation;
return clone;
}
public DataTableFixture(IDbEnvironment environment, String query, bool isOrdered)
:base(environment, query, isOrdered){}
public QueryStats(IDbEnvironment environment)
{
this.environment = environment;
}
public DatabaseTest(IDbEnvironment environment)
{
this.environment = environment;
}
public ExecuteProcedure()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
/// <summary>
/// Constructor that will use the default environment (from DbEnvironmentFactory) and
/// read the DataTable objects to compare from symbols contained in the first
/// two fixture arguments. Intended for use in standalone mode.
/// </summary>
public CompareStoredQueries()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public Insert(IDbEnvironment dbEnvironment, String tableName) {
this.tableName= tableName;
this.dbEnvironment = dbEnvironment;
}
public Update(IDbEnvironment dbEnvironment)
{
this.dbEnvironment=dbEnvironment;
}
public SetTableParameter(IDbEnvironment dbEnvironment)
{
this.dbEnvironment = dbEnvironment;
}
public Update()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public InsertFixture(IDbEnvironment environment,
String statement)
: base(environment, statement)
{
}
public SetTableParameter()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public StoredProcedureFixture(IDbEnvironment environment,
String statement)
: base(environment, statement)
{
}
public DataTableFixture(IDbEnvironment environment, String query, bool isOrdered)
: base(environment, query, isOrdered)
{
}
public QueryStats(IDbEnvironment environment)
{
this.environment = environment;
}
public InsertFixture(IDbEnvironment environment,
String statement)
: base(environment, statement) { }
public Update(IDbEnvironment dbEnvironment)
{
this.dbEnvironment = dbEnvironment;
}
public Insert()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public Update(IDbEnvironment dbEnvironment, String tableName)
{
this.tableName = tableName;
this.dbEnvironment = dbEnvironment;
}
public QueryStats()
{
environment = DbEnvironmentFactory.DefaultEnvironment;
}
public Inspect()
{
this.environment = DbEnvironmentFactory.DefaultEnvironment;
}
public Query(){
this.environment=DbEnvironmentFactory.DefaultEnvironment;
this.isOrdered = false;
}
public Inspect(IDbEnvironment dbEnvironment, String mode, String objName)
{
this.objectName = objName;
this.mode = mode;
this.environment = dbEnvironment;
}
/// <summary>
/// Constructor that allows the caller to pass an IDbEnvironment instance and two symbol names
/// that will be used to retrieve DataTable objects for comparison. Intended for use in flow mode.
/// </summary>
/// <param name="environment"></param>
/// <param name="symbol1">Symbol name for the fixture symbol containing the first DataTable</param>
/// <param name="symbol2">Symbol name for the fixture symbol containing the second DataTable</param>
public CompareStoredQueriesHideMatchingRows(IDbEnvironment environment, String symbol1, String symbol2)
{
this.dbEnvironment = environment;
this.symbol1 = symbol1;
this.symbol2 = symbol2;
}
public Execute()
{
environment = DbEnvironmentFactory.DefaultEnvironment;
}
/// <summary>
/// Constructor that will use the default environment (from DbEnvironmentFactory) and
/// read the DataTable objects to compare from symbols contained in the first
/// two fixture arguments. Intended for use in standalone mode.
/// </summary>
public CompareStoredQueriesHideMatchingRows()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public Execute(IDbEnvironment environment, String statement)
{
this.environment = environment;
this.statement = statement;
}
public static DataTable GetDataTable(Symbols symbols, String query, IDbEnvironment environment)
{
return GetDataTable(symbols, query, environment, 1);
}
public Query()
{
this.environment = DbEnvironmentFactory.DefaultEnvironment;
this.isOrdered = false;
}
public IdRetrievalAccessor(IDbEnvironment environment, Type expectedType, String tableName)
{
this.environment = environment;
this.expectedType = expectedType;
this.tableName = tableName;
}
public Query(IDbEnvironment environment, String query, bool isOrdered)
{
this.environment = environment;
this.isOrdered = isOrdered;
this.dataTable = GetDataTable(query);
}
public StoredProcedureFixture(IDbEnvironment environment,
String statement)
: base(environment, statement) { }
public static DataTable GetDataTable(Symbols symbols, String query, IDbEnvironment environment)
{
return(GetDataTable(symbols, query, environment, 1));
}
public IdRetrievalAccessor(IDbEnvironment environment, Type expectedType):base(expectedType)
{
this.environment = environment;
this.expectedType = expectedType;
}
public StoreQuery(IDbEnvironment environment, String query, String symbolName)
{
this.dbEnvironment = environment;
this.query = query;
this.symbolName = symbolName;
}
public Insert(IDbEnvironment dbEnvironment)
{
this.dbEnvironment=dbEnvironment;
}
public Inspect(IDbEnvironment dbEnvironment, String mode, String objName)
{
this.objectName= objName;
this.mode=mode;
this.environment = dbEnvironment;
}
public Query(IDbEnvironment environment, String query, bool isOrdered)
: base(GetDataTable(query, environment).Rows.GetEnumerator())
{
this.isOrdered = isOrdered;
}
public DatabaseTest(IDbEnvironment environment)
{
this.environment = environment;
}
public StoreQuery()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public ExecuteProcedure()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public Inspect()
{
this.environment = DbEnvironmentFactory.DefaultEnvironment;
}
public ExecuteProcedure(IDbEnvironment dbEnvironment, String procedureName)
: this(dbEnvironment, procedureName, false)
{
}
public Update()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public Insert(IDbEnvironment dbEnvironment, String tableName)
{
this.tableName = tableName;
this.dbEnvironment = dbEnvironment;
}
public Update(IDbEnvironment dbEnvironment, String tableName)
{
this.tableName= tableName;
this.dbEnvironment = dbEnvironment;
}
public Query(IDbEnvironment environment, String query, bool isOrdered, int rsNo)
: base(GetDataTable(query, environment, rsNo).Rows.GetEnumerator())
{
this.isOrdered = isOrdered;
}
public Query(IDbEnvironment environment, String query, bool isOrdered)
{
this.environment = environment;
this.isOrdered = isOrdered;
this.dataTable = GetDataTable(query);
}
public static DataTable GetDataTable(String query, IDbEnvironment environment)
{
return(GetDataTable(query, environment, 1));
}
public Insert()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
public Insert(IDbEnvironment dbEnvironment)
{
this.dbEnvironment = dbEnvironment;
}
public ExecuteProcedure(IDbEnvironment dbEnvironment, String procedureName)
: this(dbEnvironment, procedureName, false)
{
}
public QueryStats()
{
environment = DbEnvironmentFactory.DefaultEnvironment;
}
/// <summary>
/// Constructor that allows the caller to pass an IDbEnvironment instance and two symbol names
/// that will be used to retrieve DataTable objects for comparison. Intended for use in flow mode.
/// </summary>
/// <param name="environment"></param>
/// <param name="symbol1">Symbol name for the fixture symbol containing the first DataTable</param>
/// <param name="symbol2">Symbol name for the fixture symbol containing the second DataTable</param>
public CompareStoredQueries(IDbEnvironment environment, String symbol1, String symbol2)
{
this.dbEnvironment = environment;
this.symbol1 = symbol1;
this.symbol2 = symbol2;
}
/// <summary>
/// Constructor that will use the default environment (from DbEnvironmentFactory) and
/// read the DataTable objects to compare from symbols contained in the first
/// two fixture arguments. Intended for use in standalone mode.
/// </summary>
public CompareStoredQueries()
{
dbEnvironment = DbEnvironmentFactory.DefaultEnvironment;
}
