public string BuildComplexSelectQuery(StringBuilder query)
{
StringBuilder sqlComplexSelectQueryBuilder = StoredProcedureTesterTestsConsts.ComplexSelectQuery();
sqlComplexSelectQueryBuilder.Replace("{query}", query.ToString());
return(sqlComplexSelectQueryBuilder.ToString());
}
public string BuildDropStoredProcedureQuery(string storedProcedureName)
{
StringBuilder sqlQueryBuilder = StoredProcedureTesterTestsConsts.DropStoredProcedure();
sqlQueryBuilder.Replace("{TestName}", storedProcedureName);
return(sqlQueryBuilder.ToString());
}
public string BuildSelectQuery(string value, string column)
{
StringBuilder sqlSelectQueryBuilder = StoredProcedureTesterTestsConsts.SelectQuery();
sqlSelectQueryBuilder.Replace("{Value}", value);
sqlSelectQueryBuilder.Replace("{Column}", column);
return(sqlSelectQueryBuilder.ToString());
}
public string BuildCreateStoredProcedureQuery(string storedProcedureName, string parameters, string query)
{
StringBuilder sqlQueryBuilder = StoredProcedureTesterTestsConsts.CreateStoredProcedure();
sqlQueryBuilder.Replace("{TestName}", storedProcedureName);
sqlQueryBuilder.Replace("{Parameters}", parameters);
sqlQueryBuilder.Replace("{Query}", query);
return(sqlQueryBuilder.ToString());
}
public string BuildCreateSchemaQuery()
{
return(StoredProcedureTesterTestsConsts.CreateSchema().ToString());
}
