コミットを比較
1
コミット
| 作成者 | SHA1 | 日付 | |
|---|---|---|---|
|
|
4751b64416 |
@@ -0,0 +1,5 @@
|
||||
class AddIndexToTagsPostCount < ActiveRecord::Migration[8.0]
|
||||
def change
|
||||
add_index :tags, :post_count
|
||||
end
|
||||
end
|
||||
生成ファイル
+2
-1
@@ -10,7 +10,7 @@
|
||||
#
|
||||
# It's strongly recommended that you check this file into your version control system.
|
||||
|
||||
ActiveRecord::Schema[8.0].define(version: 2026_11_08_020000) do
|
||||
ActiveRecord::Schema[8.0].define(version: 2026_11_16_000000) do
|
||||
create_table "active_storage_attachments", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
|
||||
t.string "name", null: false
|
||||
t.string "record_type", null: false
|
||||
@@ -629,6 +629,7 @@ ActiveRecord::Schema[8.0].define(version: 2026_11_08_020000) do
|
||||
t.integer "post_count", default: 0, null: false
|
||||
t.integer "version_no", null: false
|
||||
t.index ["deprecated_at"], name: "index_tags_on_deprecated_at"
|
||||
t.index ["post_count"], name: "index_tags_on_post_count"
|
||||
t.check_constraint "(`deprecated_at` is null) or (`category` <> _utf8mb4'nico')", name: "chk_tags_deprecated_at_not_nico"
|
||||
t.check_constraint "`version_no` > 0", name: "chk_tags_version_no_positive"
|
||||
end
|
||||
|
||||
@@ -2,6 +2,17 @@ require 'rails_helper'
|
||||
|
||||
RSpec.describe Tag, type: :model do
|
||||
include WikiRecords
|
||||
|
||||
describe 'database indexes' do
|
||||
it 'has a non-unique index on post_count' do
|
||||
indexes = described_class.connection.indexes(described_class.table_name)
|
||||
index = indexes.find { |entry| entry.columns == ['post_count'] }
|
||||
|
||||
expect(index).to be_present
|
||||
expect(index.unique).to be(false)
|
||||
end
|
||||
end
|
||||
|
||||
describe '#has_description?' do
|
||||
let(:tag) { create(:tag) }
|
||||
|
||||
|
||||
+2
-2
@@ -6,8 +6,8 @@
|
||||
"scripts": {
|
||||
"dev": "vite",
|
||||
"build": "tsc -b && npm run build:client && npm run build:server",
|
||||
"build:client": "NODE_ENV=production vite build --outDir dist/client",
|
||||
"build:server": "NODE_ENV=production vite build --ssr src/entry-server.tsx --outDir dist/server",
|
||||
"build:client": "vite build --outDir dist/client",
|
||||
"build:server": "vite build --ssr src/entry-server.tsx --outDir dist/server",
|
||||
"start": "node server.mjs",
|
||||
"lint": "eslint .",
|
||||
"test": "vitest",
|
||||
|
||||
@@ -4,7 +4,7 @@ import { spawn } from 'node:child_process'
|
||||
import { after, before, test } from 'node:test'
|
||||
import { createServer as createViteServer } from 'vite'
|
||||
|
||||
import { render, renderSitemap } from './dist/server/entry-server.js'
|
||||
import { render } from './dist/server/entry-server.js'
|
||||
|
||||
const origin = 'https://ssr.example.invalid'
|
||||
const date = '2026-09-15T00:00:00+09:00'
|
||||
@@ -366,15 +366,6 @@ test ('counts SSR renders the shell without result requests or embedded results'
|
||||
}
|
||||
})
|
||||
|
||||
test ('noindex theatre routes are absent from sitemap', async () => {
|
||||
const start = requests.length
|
||||
const result = await renderSitemap ('/sitemap-ja-theatres-1.xml', origin, apiURL)
|
||||
const calls = requests.slice (start).map (request => new URL (request.url, origin))
|
||||
|
||||
assert.equal (result.status, 404)
|
||||
assert.equal (calls.some (url => url.pathname === '/sitemap_entries/theatres'), false)
|
||||
})
|
||||
|
||||
test ('every canonical screen route returns page HTML without JavaScript', async t => {
|
||||
const cookie = await authenticatedCookie ()
|
||||
for (const route of routes) {
|
||||
@@ -402,10 +393,7 @@ test ('every canonical screen route returns page HTML without JavaScript', async
|
||||
if (route.path === 'posts/:id')
|
||||
assert.match (result.head, new RegExp (`SSR post ${locale}`))
|
||||
if (route.path === 'theatres/:id')
|
||||
{
|
||||
assert.match (result.html.replace (/<[^>]*>/g, ''), /SSR[ ]theatre/)
|
||||
assert.equal (route.handle?.robots, 'noindex')
|
||||
}
|
||||
assert.match (result.html.replace (/<[^>]*>/g, ''), /SSR[ ]theatre/)
|
||||
if (route.path === 'wiki' || route.path === 'wiki/:title')
|
||||
assert.match (result.html, new RegExp (`SSR wiki body ${locale}|SSR`))
|
||||
assert.doesNotMatch (result.html, /Switched to client rendering|template id="B:/)
|
||||
|
||||
+1
-2
@@ -152,8 +152,7 @@ export const pageRoutes = (
|
||||
{ path: 'tags/changes', element: <TagHistoryPage/>,
|
||||
handle: { preload: TagHistoryPage.preload } },
|
||||
{ path: 'theatres/:id', element: <TheatreDetailPage user={user}/>,
|
||||
handle: { preload: TheatreDetailPage.preload, robots: 'noindex',
|
||||
sitemap: ['theatres'] } },
|
||||
handle: { preload: TheatreDetailPage.preload, sitemap: ['theatres'] } },
|
||||
{ path: 'materials', element: <MaterialBasePage/>,
|
||||
handle: { preload: MaterialBasePage.preload }, children: [
|
||||
{ index: true, element: <MaterialListPage/>,
|
||||
|
||||
新しいイシューから参照
ユーザーをブロックする