public void FirebirdDatabaseService_ValidParams_CreateNewObject()
{
var process = new FirebirdDatabaseService(logger, connectionString);
Assert.IsNotNull(process,
"FirebirdDatabaseService object is expected to be not null.");
}
/// <summary>
/// Get the summary list Number fields grouped by field
/// </summary>
/// <param name="field">Requested field</param>
/// <returns>The summary list</returns>
///
/// <exception cref="DataAccessException">
/// If error accessing database
/// </exception>
private IList <IList <string> > GetSummary(string field)
{
// Summary to return
var summary = new List <IList <string> >();
logger.LoggingWrapper(() =>
{
// Get columns names that are numbers except field
var columns = Helper.Columns
.Where(a => a.Value.Equals(true) && !a.Key.Equals(field))
.Select(dict => dict.Key)
.ToList();
summary.Add(columns);
// Build the summary clause
columns = columns.Select(s => "SUM(" + s + "),").ToList();
string commandStr = string.Join(" ", columns);
commandStr = commandStr.Remove(commandStr.Length - 1);
commandStr = "SELECT " + commandStr + " FROM T_CUSTOMER GROUP BY " + field;
using (var service = new FirebirdDatabaseService(logger, connectionString))
{
try
{
var fbConnection = service.CreateConnection();
var fbCommand = new FbCommand(commandStr, fbConnection);
var reader = fbCommand.ExecuteReader();
// Get all number field summary values
while (reader.Read())
{
var row = new List <string>();
for (int i = 0; i < reader.FieldCount; i++)
{
row.Add(reader[i].ToString());
}
summary.Add(row);
}
reader.Close();
}
catch (Exception ex)
{
throw new DataAccessException("FieldSummary", ex);
}
}
}, field);
return(summary);
}
public void FirebirdDatabaseService_EmptyConnectionString_ThrowException()
{
var process = new FirebirdDatabaseService(logger, string.Empty);
}
public void FirebirdDatabaseService_NullConnectionString_ThrowException()
{
var process = new FirebirdDatabaseService(logger, null);
}
public void FirebirdDatabaseService_NullLogger_ThrowException()
{
var process = new FirebirdDatabaseService(null, connectionString);
}
public override void SetUp()
{
base.SetUp();
service = new FirebirdDatabaseService(logger, connectionString);
}
