/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.EngineeringModel"/>. /// </returns> public virtual CDP4Common.DTO.EngineeringModel MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempLastModifiedOn; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.EngineeringModel(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.EngineeringModelSetup = Guid.Parse(reader["EngineeringModelSetup"].ToString()); dto.CommonFileStore.AddRange(Array.ConvertAll((string[])reader["CommonFileStore"], Guid.Parse)); dto.LogEntry.AddRange(Array.ConvertAll((string[])reader["LogEntry"], Guid.Parse)); dto.Iteration.AddRange(Array.ConvertAll((string[])reader["Iteration"], Guid.Parse)); dto.Book.AddRange(Utils.ParseOrderedList <Guid>(reader["Book"] as string[, ])); dto.GenericNote.AddRange(Array.ConvertAll((string[])reader["GenericNote"], Guid.Parse)); dto.ModellingAnnotation.AddRange(Array.ConvertAll((string[])reader["ModellingAnnotation"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("LastModifiedOn", out tempLastModifiedOn)) { dto.LastModifiedOn = Utils.ParseUtcDate(tempLastModifiedOn); } return(dto); }
/// <summary> /// Update a database record from the supplied data transfer object. /// </summary> /// <param name="transaction"> /// The current transaction to the database. /// </param> /// <param name="partition"> /// The database partition (schema) where the requested resource will be updated. /// </param> /// <param name="engineeringModel"> /// The engineeringModel DTO that is to be updated. /// </param> /// <param name="container"> /// The container of the DTO to be updated. /// </param> /// <returns> /// True if the concept was successfully updated. /// </returns> public virtual bool Update(NpgsqlTransaction transaction, string partition, CDP4Common.DTO.EngineeringModel engineeringModel, CDP4Common.DTO.Thing container = null) { bool isHandled; var valueTypeDictionaryAdditions = new Dictionary <string, string>(); var beforeUpdate = this.BeforeUpdate(transaction, partition, engineeringModel, container, out isHandled, valueTypeDictionaryAdditions); if (!isHandled) { beforeUpdate = beforeUpdate && base.Update(transaction, partition, engineeringModel, container); using (var command = new NpgsqlCommand()) { var sqlBuilder = new System.Text.StringBuilder(); sqlBuilder.AppendFormat("UPDATE \"{0}\".\"EngineeringModel\"", partition); sqlBuilder.AppendFormat(" SET (\"EngineeringModelSetup\")"); sqlBuilder.AppendFormat(" = (:engineeringModelSetup)"); sqlBuilder.AppendFormat(" WHERE \"Iid\" = :iid;"); command.Parameters.Add("iid", NpgsqlDbType.Uuid).Value = engineeringModel.Iid; command.Parameters.Add("engineeringModelSetup", NpgsqlDbType.Uuid).Value = !this.IsDerived(engineeringModel, "EngineeringModelSetup") ? engineeringModel.EngineeringModelSetup : Utils.NullableValue(null); command.CommandText = sqlBuilder.ToString(); command.Connection = transaction.Connection; command.Transaction = transaction; this.ExecuteAndLogCommand(command); } } return(this.AfterUpdate(beforeUpdate, transaction, partition, engineeringModel, container)); }
/// <summary> /// Insert a new database record, or updates one if it already exists from the supplied data transfer object. /// This is typically used during the import of existing data to the Database. /// </summary> /// <param name="transaction"> /// The current <see cref="NpgsqlTransaction"/> to the database. /// </param> /// <param name="partition"> /// The database partition (schema) where the requested resource will be stored. /// </param> /// <param name="engineeringModel"> /// The engineeringModel DTO that is to be persisted. /// </param> /// <param name="container"> /// The container of the DTO to be persisted. /// </param> /// <returns> /// True if the concept was successfully persisted. /// </returns> public virtual bool Upsert(NpgsqlTransaction transaction, string partition, CDP4Common.DTO.EngineeringModel engineeringModel, CDP4Common.DTO.Thing container = null) { var valueTypeDictionaryAdditions = new Dictionary <string, string>(); base.Upsert(transaction, partition, engineeringModel, container); using (var command = new NpgsqlCommand()) { var sqlBuilder = new System.Text.StringBuilder(); sqlBuilder.AppendFormat("INSERT INTO \"{0}\".\"EngineeringModel\"", partition); sqlBuilder.AppendFormat(" (\"Iid\", \"EngineeringModelSetup\")"); sqlBuilder.AppendFormat(" VALUES (:iid, :engineeringModelSetup)"); command.Parameters.Add("iid", NpgsqlDbType.Uuid).Value = engineeringModel.Iid; command.Parameters.Add("engineeringModelSetup", NpgsqlDbType.Uuid).Value = !this.IsDerived(engineeringModel, "EngineeringModelSetup") ? engineeringModel.EngineeringModelSetup : Utils.NullableValue(null); sqlBuilder.Append(" ON CONFLICT (\"Iid\")"); sqlBuilder.Append(" DO UPDATE "); sqlBuilder.Append(" SET \"EngineeringModelSetup\""); sqlBuilder.Append(" = :engineeringModelSetup;"); command.CommandText = sqlBuilder.ToString(); command.Connection = transaction.Connection; command.Transaction = transaction; this.ExecuteAndLogCommand(command); } return(true); }
public void VerifyTopContainerCreationNotAllowedValidation() { this.mockedMetaInfoProvider.Setup(x => x.GetMetaInfo(It.IsAny <EngineeringModel>())).Returns(this.engineeringModelMetaInfo); this.mockedMetaInfoProvider.Setup(x => x.GetMetaInfo(It.Is <string>(y => y == "EngineeringModel"))).Returns(this.engineeringModelMetaInfo); var newEngineeringModel = new EngineeringModel(Guid.NewGuid(), 0) { Book = new List <OrderedItem>(), CommonFileStore = new List <Guid>(), Iteration = new List <Guid> { Guid.NewGuid() }, LogEntry = new List <Guid>() }; var postOperation = new CdpPostOperation(); postOperation.Create.Add(newEngineeringModel); Assert.Throws( typeof(InvalidOperationException), () => this.operationProcessor.ValidateCreateOperations(postOperation, this.fileStore)); }
public void VerifyThatMultipleIterationCanBeSynchronized() { var sitedir = new Dto.SiteDirectory(Guid.NewGuid(), 0); var srdl1 = new Dto.SiteReferenceDataLibrary(Guid.NewGuid(), 0); var srdl2 = new Dto.SiteReferenceDataLibrary(Guid.NewGuid(), 0); var category = new Dto.Category(Guid.NewGuid(), 0); var modeldto = new Dto.EngineeringModel(Guid.NewGuid(), 1); var iteration1dto = new Dto.Iteration(Guid.NewGuid(), 1); var iteration2dto = new Dto.Iteration(Guid.NewGuid(), 1); var element1dto = new Dto.ElementDefinition(Guid.NewGuid(), 1); element1dto.IterationContainerId = iteration1dto.Iid; element1dto.Category.Add(category.Iid); var element2dto = new Dto.ElementDefinition(element1dto.Iid, 1); element2dto.IterationContainerId = iteration2dto.Iid; element2dto.Category.Add(category.Iid); var usage1dto = new Dto.ElementUsage(Guid.NewGuid(), 1); usage1dto.IterationContainerId = iteration1dto.Iid; usage1dto.Category.Add(category.Iid); var usage2dto = new Dto.ElementUsage(usage1dto.Iid, 1); usage2dto.IterationContainerId = iteration2dto.Iid; usage2dto.Category.Add(category.Iid); sitedir.SiteReferenceDataLibrary.Add(srdl1.Iid); sitedir.SiteReferenceDataLibrary.Add(srdl2.Iid); srdl1.DefinedCategory.Add(category.Iid); modeldto.Iteration.Add(iteration1dto.Iid); modeldto.Iteration.Add(iteration2dto.Iid); iteration1dto.Element.Add(element1dto.Iid); iteration2dto.Element.Add(element2dto.Iid); element1dto.ContainedElement.Add(usage1dto.Iid); element2dto.ContainedElement.Add(usage2dto.Iid); var dtos = new List <Dto.Thing> { sitedir, srdl1, srdl2, category }; var assembler = new Assembler(this.uri); assembler.Synchronize(dtos); dtos = new List <Dto.Thing> { modeldto, iteration1dto, iteration2dto, element1dto, element2dto, usage1dto, usage2dto }; assembler.Synchronize(dtos); Assert.AreEqual(11, assembler.Cache.Count); }