コミットを比較
1
コミット
| 作成者 | SHA1 | 日付 | |
|---|---|---|---|
|
|
4751b64416 |
@@ -46,8 +46,8 @@ class PostsController < ApplicationController
|
|||||||
:tag_names, :tag_descriptions] }])
|
:tag_names, :tag_descriptions] }])
|
||||||
.with_attached_thumbnail
|
.with_attached_thumbnail
|
||||||
|
|
||||||
q = q.where('posts.url LIKE ?', "%#{ Post.sanitize_sql_like(url).tr('*?', '%_') }%") if url
|
q = q.where('posts.url LIKE ?', "%#{ url }%") if url
|
||||||
q = q.where('posts.title LIKE ?', "%#{ Post.sanitize_sql_like(title).tr('*?', '%_') }%") if title
|
q = q.where('posts.title LIKE ?', "%#{ title }%") if title
|
||||||
if original_created_from
|
if original_created_from
|
||||||
q = q.where('posts.original_created_before > ?', original_created_from)
|
q = q.where('posts.original_created_before > ?', original_created_from)
|
||||||
end
|
end
|
||||||
|
|||||||
@@ -9,8 +9,8 @@ class TagsController < ApplicationController
|
|||||||
|
|
||||||
post_id = params[:post]
|
post_id = params[:post]
|
||||||
|
|
||||||
name = params[:name].to_s.strip.presence
|
name = params[:name].presence
|
||||||
category = params[:category].to_s.strip.presence
|
category = params[:category].presence
|
||||||
post_count_between = (params[:post_count_gte].presence || -1).to_i,
|
post_count_between = (params[:post_count_gte].presence || -1).to_i,
|
||||||
(params[:post_count_lte].presence || -1).to_i
|
(params[:post_count_lte].presence || -1).to_i
|
||||||
post_count_between[0] = nil if post_count_between[0] < 0
|
post_count_between[0] = nil if post_count_between[0] < 0
|
||||||
|
|||||||
@@ -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.
|
# 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|
|
create_table "active_storage_attachments", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
|
||||||
t.string "name", null: false
|
t.string "name", null: false
|
||||||
t.string "record_type", 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 "post_count", default: 0, null: false
|
||||||
t.integer "version_no", null: false
|
t.integer "version_no", null: false
|
||||||
t.index ["deprecated_at"], name: "index_tags_on_deprecated_at"
|
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 "(`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"
|
t.check_constraint "`version_no` > 0", name: "chk_tags_version_no_positive"
|
||||||
end
|
end
|
||||||
|
|||||||
@@ -2,6 +2,17 @@ require 'rails_helper'
|
|||||||
|
|
||||||
RSpec.describe Tag, type: :model do
|
RSpec.describe Tag, type: :model do
|
||||||
include WikiRecords
|
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
|
describe '#has_description?' do
|
||||||
let(:tag) { create(:tag) }
|
let(:tag) { create(:tag) }
|
||||||
|
|
||||||
|
|||||||
@@ -516,39 +516,6 @@ RSpec.describe 'Posts API', type: :request do
|
|||||||
end
|
end
|
||||||
end
|
end
|
||||||
|
|
||||||
[:title, :url].each do |field|
|
|
||||||
context "when #{field} contains wildcards" do
|
|
||||||
let!(:search_posts) do
|
|
||||||
['needle%25end', 'needleX25end', 'needle_end', 'needleXend', 'needleABend', 'needle%25_end'].map.with_index do |value, index|
|
|
||||||
Post.create!(uploaded_user: user,
|
|
||||||
title: field == :title ? "prefix #{value} suffix" : 'url search post',
|
|
||||||
url: field == :url ? "https://example.com/prefix-#{value}-suffix" :
|
|
||||||
"https://example.com/title-search-#{index}")
|
|
||||||
end
|
|
||||||
end
|
|
||||||
|
|
||||||
{
|
|
||||||
'needle%25end' => [0],
|
|
||||||
'needle_end' => [2],
|
|
||||||
'needle*end' => [0, 1, 2, 3, 4, 5],
|
|
||||||
'needle?end' => [2, 3],
|
|
||||||
'needle%*end' => [0, 5],
|
|
||||||
'needle_?nd' => [2],
|
|
||||||
'needle%25_end' => [5],
|
|
||||||
'needle%25_*end' => [5]
|
|
||||||
}.each do |query, expected_indices|
|
|
||||||
it "matches #{query.inspect} using only * and ? as wildcards" do
|
|
||||||
get '/posts', params: { field => query }
|
|
||||||
|
|
||||||
expect(response).to have_http_status(:ok)
|
|
||||||
expected_ids = expected_indices.map { |i| search_posts[i].id }
|
|
||||||
expect(json.fetch('posts').map { |p| p['id'] }).to match_array(expected_ids)
|
|
||||||
expect(json.fetch('count')).to eq(expected_ids.size)
|
|
||||||
end
|
|
||||||
end
|
|
||||||
end
|
|
||||||
end
|
|
||||||
|
|
||||||
context 'when created_from/created_to are provided' do
|
context 'when created_from/created_to are provided' do
|
||||||
let(:t_created_hit) { Time.zone.local(2010, 1, 5, 12, 0, 0) }
|
let(:t_created_hit) { Time.zone.local(2010, 1, 5, 12, 0, 0) }
|
||||||
let(:t_created_miss) { Time.zone.local(2012, 1, 5, 12, 0, 0) }
|
let(:t_created_miss) { Time.zone.local(2012, 1, 5, 12, 0, 0) }
|
||||||
|
|||||||
新しいイシューから参照
ユーザーをブロックする