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); }