Split front and back end.

9 files changed, 0 insertions, 328 deletions

diff --git a/Timeline/Entities/DataEntity.cs b/Timeline/Entities/DataEntity.cs
deleted file mode 100644
index b21e2dbf..00000000
--- a/Timeline/Entities/DataEntity.cs
+++ /dev/null
@@ -1,23 +0,0 @@
-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-

-namespace Timeline.Entities

-{

-    [Table("data")]

-    public class DataEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Column("tag"), Required]

-        public string Tag { get; set; } = default!;

-

-        [Column("data"), Required]

-#pragma warning disable CA1819 // Properties should not return arrays

-        public byte[] Data { get; set; } = default!;

-#pragma warning restore CA1819 // Properties should not return arrays

-

-        [Column("ref"), Required]

-        public int Ref { get; set; }

-    }

-}

diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs
deleted file mode 100644
index ecadd703..00000000
--- a/Timeline/Entities/DatabaseContext.cs
+++ /dev/null
@@ -1,34 +0,0 @@
-using Microsoft.EntityFrameworkCore;

-

-namespace Timeline.Entities

-{

-    public class DatabaseContext : DbContext

-    {

-        public DatabaseContext(DbContextOptions<DatabaseContext> options)

-            : base(options)

-        {

-        }

-

-        protected override void OnModelCreating(ModelBuilder modelBuilder)

-        {

-            modelBuilder.Entity<UserEntity>().Property(e => e.Version).HasDefaultValue(0);

-            modelBuilder.Entity<UserEntity>().HasIndex(e => e.Username).IsUnique();

-            modelBuilder.Entity<UserEntity>().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))");

-            modelBuilder.Entity<UserEntity>().Property(e => e.UsernameChangeTime).HasDefaultValueSql("datetime('now', 'utc')");

-            modelBuilder.Entity<UserEntity>().Property(e => e.CreateTime).HasDefaultValueSql("datetime('now', 'utc')");

-            modelBuilder.Entity<UserEntity>().Property(e => e.LastModified).HasDefaultValueSql("datetime('now', 'utc')");

-            modelBuilder.Entity<DataEntity>().HasIndex(e => e.Tag).IsUnique();

-            modelBuilder.Entity<TimelineEntity>().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))");

-

-            modelBuilder.ApplyUtcDateTimeConverter();

-        }

-

-        public DbSet<UserEntity> Users { get; set; } = default!;

-        public DbSet<UserAvatarEntity> UserAvatars { get; set; } = default!;

-        public DbSet<TimelineEntity> Timelines { get; set; } = default!;

-        public DbSet<TimelinePostEntity> TimelinePosts { get; set; } = default!;

-        public DbSet<TimelineMemberEntity> TimelineMembers { get; set; } = default!;

-        public DbSet<JwtTokenEntity> JwtToken { get; set; } = default!;

-        public DbSet<DataEntity> Data { get; set; } = default!;

-    }

-}

diff --git a/Timeline/Entities/JwtTokenEntity.cs b/Timeline/Entities/JwtTokenEntity.cs
deleted file mode 100644
index 40cb230a..00000000
--- a/Timeline/Entities/JwtTokenEntity.cs
+++ /dev/null
@@ -1,17 +0,0 @@
-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-

-namespace Timeline.Entities

-{

-    [Table("jwt_token")]

-    public class JwtTokenEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Required, Column("key")]

-#pragma warning disable CA1819 // Properties should not return arrays

-        public byte[] Key { get; set; } = default!;

-#pragma warning restore CA1819 // Properties should not return arrays

-    }

-}

diff --git a/Timeline/Entities/TimelineEntity.cs b/Timeline/Entities/TimelineEntity.cs
deleted file mode 100644
index 3e592673..00000000
--- a/Timeline/Entities/TimelineEntity.cs
+++ /dev/null
@@ -1,58 +0,0 @@
-using System;

-using System.Collections.Generic;

-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-using Timeline.Models;

-

-namespace Timeline.Entities

-{

-#pragma warning disable CA2227 // Collection properties should be read only

-    // TODO: Create index for this table.

-    [Table("timelines")]

-    public class TimelineEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Column("unique_id"), Required]

-        public string UniqueId { get; set; } = default!;

-

-        /// <summary>

-        /// If null, then this timeline is a personal timeline.

-        /// </summary>

-        [Column("name")]

-        public string? Name { get; set; }

-

-        [Column("title")]

-        public string? Title { get; set; }

-

-        [Column("name_last_modified")]

-        public DateTime NameLastModified { get; set; }

-

-        [Column("description")]

-        public string? Description { get; set; }

-

-        [Column("owner")]

-        public long OwnerId { get; set; }

-

-        [ForeignKey(nameof(OwnerId))]

-        public UserEntity Owner { get; set; } = default!;

-

-        [Column("visibility")]

-        public TimelineVisibility Visibility { get; set; }

-

-        [Column("create_time")]

-        public DateTime CreateTime { get; set; }

-

-        [Column("last_modified")]

-        public DateTime LastModified { get; set; }

-

-        [Column("current_post_local_id")]

-        public long CurrentPostLocalId { get; set; }

-

-        public List<TimelineMemberEntity> Members { get; set; } = default!;

-

-        public List<TimelinePostEntity> Posts { get; set; } = default!;

-    }

-#pragma warning restore CA2227 // Collection properties should be read only

-}

diff --git a/Timeline/Entities/TimelineMemberEntity.cs b/Timeline/Entities/TimelineMemberEntity.cs
deleted file mode 100644
index e76f2099..00000000
--- a/Timeline/Entities/TimelineMemberEntity.cs
+++ /dev/null
@@ -1,24 +0,0 @@
-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-

-namespace Timeline.Entities

-{

-    [Table("timeline_members")]

-    public class TimelineMemberEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Column("user")]

-        public long UserId { get; set; }

-

-        [ForeignKey(nameof(UserId))]

-        public UserEntity User { get; set; } = default!;

-

-        [Column("timeline")]

-        public long TimelineId { get; set; }

-

-        [ForeignKey(nameof(TimelineId))]

-        public TimelineEntity Timeline { get; set; } = default!;

-    }

-}

diff --git a/Timeline/Entities/TimelinePostEntity.cs b/Timeline/Entities/TimelinePostEntity.cs
deleted file mode 100644
index 07367fba..00000000
--- a/Timeline/Entities/TimelinePostEntity.cs
+++ /dev/null
@@ -1,43 +0,0 @@
-using System;

-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-

-namespace Timeline.Entities

-{

-    [Table("timeline_posts")]

-    public class TimelinePostEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Column("local_id")]

-        public long LocalId { get; set; }

-

-        [Column("timeline")]

-        public long TimelineId { get; set; }

-

-        [ForeignKey(nameof(TimelineId))]

-        public TimelineEntity Timeline { get; set; } = default!;

-

-        [Column("author")]

-        public long? AuthorId { get; set; }

-

-        [ForeignKey(nameof(AuthorId))]

-        public UserEntity? Author { get; set; } = default!;

-

-        [Column("content_type"), Required]

-        public string ContentType { get; set; } = default!;

-

-        [Column("content")]

-        public string? Content { get; set; }

-

-        [Column("extra_content")]

-        public string? ExtraContent { get; set; }

-

-        [Column("time")]

-        public DateTime Time { get; set; }

-

-        [Column("last_updated")]

-        public DateTime LastUpdated { get; set; }

-    }

-}

diff --git a/Timeline/Entities/UserAvatarEntity.cs b/Timeline/Entities/UserAvatarEntity.cs
deleted file mode 100644
index 3c2720f7..00000000
--- a/Timeline/Entities/UserAvatarEntity.cs
+++ /dev/null
@@ -1,29 +0,0 @@
-using System;

-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-

-namespace Timeline.Entities

-{

-    [System.Diagnostics.CodeAnalysis.SuppressMessage("Performance", "CA1819:Properties should not return arrays", Justification = "This is data base entity.")]

-    [Table("user_avatars")]

-    public class UserAvatarEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Column("data_tag")]

-        public string? DataTag { get; set; }

-

-        [Column("type")]

-        public string? Type { get; set; }

-

-        [Column("last_modified"), Required]

-        public DateTime LastModified { get; set; }

-

-        [Column("user"), Required]

-        public long UserId { get; set; }

-

-        [ForeignKey(nameof(UserId))]

-        public UserEntity User { get; set; } = default!;

-    }

-}

diff --git a/Timeline/Entities/UserEntity.cs b/Timeline/Entities/UserEntity.cs
deleted file mode 100644
index 0cfaa335..00000000
--- a/Timeline/Entities/UserEntity.cs
+++ /dev/null
@@ -1,56 +0,0 @@
-using System;

-using System.Collections.Generic;

-using System.ComponentModel.DataAnnotations;

-using System.ComponentModel.DataAnnotations.Schema;

-

-namespace Timeline.Entities

-{

-    public static class UserRoles

-    {

-        public const string Admin = "admin";

-        public const string User = "user";

-    }

-

-    [System.Diagnostics.CodeAnalysis.SuppressMessage("Usage", "CA2227:Collection properties should be read only", Justification = "This is an entity class.")]

-    [Table("users")]

-    public class UserEntity

-    {

-        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

-        public long Id { get; set; }

-

-        [Column("unique_id"), Required]

-        public string UniqueId { get; set; } = default!;

-

-        [Column("username"), Required]

-        public string Username { get; set; } = default!;

-

-        [Column("username_change_time")]

-        public DateTime UsernameChangeTime { get; set; }

-

-        [Column("password"), Required]

-        public string Password { get; set; } = default!;

-

-        [Column("roles"), Required]

-        public string Roles { get; set; } = default!;

-

-        [Column("version"), Required]

-        public long Version { get; set; }

-

-        [Column("nickname")]

-        public string? Nickname { get; set; }

-

-        [Column("create_time")]

-        public DateTime CreateTime { get; set; }

-

-        [Column("last_modified")]

-        public DateTime LastModified { get; set; }

-

-        public UserAvatarEntity? Avatar { get; set; }

-

-        public List<TimelineEntity> Timelines { get; set; } = default!;

-

-        public List<TimelinePostEntity> TimelinePosts { get; set; } = default!;

-

-        public List<TimelineMemberEntity> TimelinesJoined { get; set; } = default!;

-    }

-}

diff --git a/Timeline/Entities/UtcDateAnnotation.cs b/Timeline/Entities/UtcDateAnnotation.cs
deleted file mode 100644
index 6600e701..00000000
--- a/Timeline/Entities/UtcDateAnnotation.cs
+++ /dev/null
@@ -1,44 +0,0 @@
-using Microsoft.EntityFrameworkCore;

-using Microsoft.EntityFrameworkCore.Metadata;

-using Microsoft.EntityFrameworkCore.Metadata.Builders;

-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

-using System;

-

-namespace Timeline.Entities

-{

-    // Copied from https://github.com/dotnet/efcore/issues/4711#issuecomment-589842988

-    public static class UtcDateAnnotation

-    {

-        private const string IsUtcAnnotation = "IsUtc";

-        private static readonly ValueConverter<DateTime, DateTime> UtcConverter =

-            new ValueConverter<DateTime, DateTime>(v => v, v => DateTime.SpecifyKind(v, DateTimeKind.Utc));

-

-        public static PropertyBuilder<TProperty> IsUtc<TProperty>(this PropertyBuilder<TProperty> builder, bool isUtc = true) =>

-            builder.HasAnnotation(IsUtcAnnotation, isUtc);

-

-        public static bool IsUtc(this IMutableProperty property) =>

-            ((bool?)property.FindAnnotation(IsUtcAnnotation)?.Value) ?? true;

-

-        /// <summary>

-        /// Make sure this is called after configuring all your entities.

-        /// </summary>

-        public static void ApplyUtcDateTimeConverter(this ModelBuilder builder)

-        {

-            foreach (var entityType in builder.Model.GetEntityTypes())

-            {

-                foreach (var property in entityType.GetProperties())

-                {

-                    if (!property.IsUtc())

-                    {

-                        continue;

-                    }

-

-                    if (property.ClrType == typeof(DateTime))

-                    {

-                        property.SetValueConverter(UtcConverter);

-                    }

-                }

-            }

-        }

-    }

-}