39 lines
1.6 KiB
C#
39 lines
1.6 KiB
C#
|
using YKanBan.Storage.Workspace;
|
||
|
|
using YKanBan.Tests.TestUtilities;
|
||
|
|
|
||
|
|
namespace YKanBan.Tests.Storage.Workspace;
|
||
|
|
|
||
|
|
/// <summary>Tests for seeding preset workspace content.</summary>
|
||
|
|
[TestClass]
|
||
|
|
public class WorkspacePresetTests
|
||
|
|
{
|
||
|
|
[TestMethod]
|
||
|
|
public void SeedAddsThreeDistinctPresetColumns()
|
||
|
|
{
|
||
|
|
using var directory = new TempDirectory();
|
||
|
|
WorkspaceInitializer.Initialize(directory.FullPath);
|
||
|
|
WorkspacePreset.SeedColumns(directory.FullPath);
|
||
|
|
|
||
|
|
using var connection = SqliteTestHelper.OpenWorkspace(directory.FullPath);
|
||
|
|
List<string> titles = SqliteTestHelper.GetColumnTitles(connection);
|
||
|
|
|
||
|
|
Assert.AreEqual(3, titles.Count);
|
||
|
|
Assert.AreEqual(titles.Count, titles.Distinct().Count());
|
||
|
|
Assert.IsTrue(titles.All(title => title.Length > 0));
|
||
|
|
}
|
||
|
|
|
||
|
|
[TestMethod]
|
||
|
|
public void SeedPresetColumnsShareOneTimestamp()
|
||
|
|
{
|
||
|
|
using var directory = new TempDirectory();
|
||
|
|
WorkspaceInitializer.Initialize(directory.FullPath);
|
||
|
|
WorkspacePreset.SeedColumns(directory.FullPath);
|
||
|
|
|
||
|
|
using var connection = SqliteTestHelper.OpenWorkspace(directory.FullPath);
|
||
|
|
|
||
|
|
// Creation writes created_at = updated_at; all three columns share one moment.
|
||
|
|
Assert.AreEqual(0L, SqliteTestHelper.ScalarLong(connection, "SELECT COUNT(*) FROM columns WHERE created_at <> updated_at;"));
|
||
|
|
Assert.AreEqual(3L, SqliteTestHelper.ScalarLong(connection, "SELECT COUNT(*) FROM columns WHERE created_at > 0;"));
|
||
|
|
Assert.AreEqual(1L, SqliteTestHelper.ScalarLong(connection, "SELECT COUNT(DISTINCT created_at) FROM columns;"));
|
||
|
|
}
|
||
|
|
}
|