From 2f8ffdb2db682b1c1407313816def20fde58d35f Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Sat, 13 Jun 2020 23:50:09 +0800
Subject: feat(back): Add database migration to add unique id for timeline.

---
 Timeline/Entities/DatabaseContext.cs | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'Timeline/Entities/DatabaseContext.cs')

diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs
index 8899308c..96e47cc8 100644
--- a/Timeline/Entities/DatabaseContext.cs
+++ b/Timeline/Entities/DatabaseContext.cs
@@ -1,4 +1,6 @@
+using Microsoft.Data.Sqlite;
 using Microsoft.EntityFrameworkCore;
+using System;
 
 namespace Timeline.Entities
 {
@@ -7,6 +9,15 @@ namespace Timeline.Entities
         public DatabaseContext(DbContextOptions<DatabaseContext> options)
             : base(options)
         {
+            if (Database.IsSqlite())
+            {
+                var connection = (SqliteConnection)Database.GetDbConnection();
+                connection.CreateFunction("timeline_create_guid", () => Guid.NewGuid().ToString());
+            }
+            else
+            {
+                throw new InvalidOperationException(Resources.Entities.ExceptionOnlySqliteSupported);
+            }
         }
 
         protected override void OnModelCreating(ModelBuilder modelBuilder)
@@ -14,6 +25,7 @@ namespace Timeline.Entities
             modelBuilder.Entity<UserEntity>().Property(e => e.Version).HasDefaultValue(0);
             modelBuilder.Entity<UserEntity>().HasIndex(e => e.Username).IsUnique();
             modelBuilder.Entity<DataEntity>().HasIndex(e => e.Tag).IsUnique();
+            modelBuilder.Entity<TimelineEntity>().Property(e => e.UniqueId).HasDefaultValueSql("timeline_create_guid()");
         }
 
         public DbSet<UserEntity> Users { get; set; } = default!;
-- 
cgit v1.2.3