* Persist and expose Umbraco system dates as UTC (#19705) * Updated persistence DTOs defining default dates to use UTC. * Remove ForceToUtc = false from all persistence DTO attributes (default when not specified is true). * Removed use of SpecifyKind setting dates to local. * Removed unnecessary Utc suffixes on properties. * Persist current date time with UtcNow. * Removed further necessary Utc suffixes and fixed failing unit tests. * Added migration for SQL server to update database date default constraints. * Added comment justifying not providing a migration for SQLite default date constraints. * Ensure UTC for datetimes created from persistence DTOs. * Ensure UTC when creating dates for published content rendering in Razor and outputting in delivery API. * Fixed migration SQL syntax. * Introduced AuditItemFactory for creating entries for the backoffice document history, so we can control the UTC setting on the retrieved persisted dates. * Ensured UTC dates are retrieved for document versions. * Ensured UTC is returned for backoffice display of last edited and published for variant content. * Fixed SQLite syntax for default current datetime. * Apply suggestions from code review Co-authored-by: Laura Neto <12862535+lauraneto@users.noreply.github.com> * Further updates from code review. --------- Co-authored-by: Laura Neto <12862535+lauraneto@users.noreply.github.com> * Migrate system dates from local server time to UTC (#19798) * Add settings for the migration. * Add migration and implement for SQL server. * Implement for SQLite. * Fixes from testing with SQL Server. * Fixes from testing with SQLite. * Code tidy. * Cleaned up usings. * Removed audit log date from conversion. * Removed webhook log date from conversion. * Updated update date initialization on saving dictionary items. * Updated filter on log queries. * Use timezone ID instead of system name to work cross-culture. --------- Co-authored-by: Laura Neto <12862535+lauraneto@users.noreply.github.com>
70 lines
2.4 KiB
C#
70 lines
2.4 KiB
C#
// Copyright (c) Umbraco.
|
|
// See LICENSE for more details.
|
|
|
|
using NUnit.Framework;
|
|
using Umbraco.Cms.Core.Models;
|
|
using Umbraco.Cms.Tests.Common.Builders;
|
|
using Umbraco.Cms.Tests.Common.Builders.Extensions;
|
|
|
|
namespace Umbraco.Cms.Tests.UnitTests.Umbraco.Tests.Common.Builders;
|
|
|
|
[TestFixture]
|
|
public class RelationBuilderTests
|
|
{
|
|
[Test]
|
|
public void Is_Built_Correctly()
|
|
{
|
|
// Arrange
|
|
const int parentId = 9;
|
|
const int childId = 8;
|
|
const int id = 4;
|
|
var key = Guid.NewGuid();
|
|
var createDate = DateTime.UtcNow.AddHours(-1);
|
|
var updateDate = DateTime.UtcNow;
|
|
const string comment = "test comment";
|
|
const int relationTypeId = 66;
|
|
const string relationTypeAlias = "test";
|
|
const string relationTypeName = "name";
|
|
var parentObjectType = Guid.NewGuid();
|
|
var childObjectType = Guid.NewGuid();
|
|
|
|
var builder = new RelationBuilder();
|
|
|
|
// Act
|
|
var relation = builder
|
|
.BetweenIds(parentId, childId)
|
|
.WithId(id)
|
|
.WithComment(comment)
|
|
.WithCreateDate(createDate)
|
|
.WithUpdateDate(updateDate)
|
|
.WithKey(key)
|
|
.AddRelationType()
|
|
.WithId(relationTypeId)
|
|
.WithAlias(relationTypeAlias)
|
|
.WithName(relationTypeName)
|
|
.WithIsBidirectional(false)
|
|
.WithIsDependency(true)
|
|
.WithParentObjectType(parentObjectType)
|
|
.WithChildObjectType(childObjectType)
|
|
.Done()
|
|
.Build();
|
|
|
|
// Assert
|
|
Assert.AreEqual(parentId, relation.ParentId);
|
|
Assert.AreEqual(childId, relation.ChildId);
|
|
Assert.AreEqual(id, relation.Id);
|
|
Assert.AreEqual(createDate, relation.CreateDate);
|
|
Assert.AreEqual(updateDate, relation.UpdateDate);
|
|
Assert.AreEqual(key, relation.Key);
|
|
Assert.AreEqual(comment, relation.Comment);
|
|
Assert.AreEqual(relationTypeId, relation.RelationType.Id);
|
|
Assert.AreEqual(relationTypeAlias, relation.RelationType.Alias);
|
|
Assert.AreEqual(relationTypeName, relation.RelationType.Name);
|
|
Assert.IsFalse(relation.RelationType.IsBidirectional);
|
|
|
|
Assert.IsTrue((relation.RelationType as IRelationTypeWithIsDependency).IsDependency);
|
|
Assert.AreEqual(parentObjectType, relation.RelationType.ParentObjectType);
|
|
Assert.AreEqual(childObjectType, relation.RelationType.ChildObjectType);
|
|
}
|
|
}
|