AI: address issue #150

backend/db/migrate/20261112000000_add_foreign_key_on_deerjikists_tag_id.rb

@@ -1,5 +0,0 @@
-class AddForeignKeyOnDeerjikistsTagId < ActiveRecord::Migration[8.0]
-  def change
-    add_foreign_key :deerjikists, :tags, column: :tag_id
-  end
-end

frontend/src/components/PostEmbed.tsx

@@ -196,6 +196,39 @@ const PostEmbed: FC<Props> = (
       return <TwitterEmbed userId={userId} statusId={statusId}/>
     }
 
+  case 'bilibili.com':
+    {
+      const videoId = url.pathname.match (
+	  /^\/video\/(BV[a-zA-Z0-9]{10}|av[1-9]\d*)\/?$/)?.[1]
+      if (!(videoId))
+	break
+
+      if (embedAutoLoadMode === 'off')
+	return externalLink
+      if (shouldLoadEmbed === false)
+	return manualLoadControl
+
+      const playerUrl = new URL ('https://player.bilibili.com/player.html')
+      const parameter = videoId.startsWith ('BV') ? 'bvid' : 'aid'
+      const identifier = parameter === 'bvid' ? videoId : videoId.slice (2)
+      playerUrl.searchParams.set (parameter, identifier)
+      playerUrl.searchParams.set ('autoplay', '1')
+
+      const page = url.searchParams.get ('p')
+      if (page != null && /^[1-9]\d*$/.test (page))
+	playerUrl.searchParams.set ('p', page)
+
+      return (
+	  <iframe
+	      src={playerUrl.toString ()}
+	      title={post.title || post.url}
+	      width={640}
+	      height={360}
+	      className="aspect-video h-auto max-w-full"
+	      allow="autoplay; fullscreen"
+	      allowFullScreen/>)
+    }
+
   case 'youtube.com':
     {
       const videoId = url.searchParams.get ('v')