Closed mlbrgl closed 10 months ago
Update query:
UPDATE charts SET is_indexable = 1 WHERE charts.id IN (2111,2113,3246,3863,4089,4520,4544,4545,4549,5234,5359,5406,5586,5653,6905,6951,7016,185,225,379,449,517,518,1009,1540,1566,1567,1671,1886,2903,3149,3150,3231,3233,3234,3243,3244,3248,3250,3251,3311,3359,3456,3796,3941,4009,4059,4327,4408,4410,4433,4462,4478,4479,4487,4522,4523,4539,4654,4669,4696,4699,4704,4792,4798,4901,5042,5057,5076,5165,5180,5203,5227,5231,5233,5247,5297,5385,5392,5395,5400,5401,5402,5403,5405,5408,5409,5410,5411,5413,5500,5574,5894,6045,6046,6049,6153,6199,6221,6226,6301,6356,6360,6475,6499,6501,6502,6503,6504,6505,6506,6507,6512,6643,6663,6664,6665,6666,6667,6952,3230,5152,5306,6362,7129,6426,6427,6763,5579,5580,6538,6618,3724,3731,4806,5201,5211,5244,5621,5624,6644,413,417,5952,5997,6260,6261,236,328,383,392,418,419,424,437,446,448,4700,4701,4707,4863,4876,5111,5113,5139,5169,5181,5925,6047,6048,6050,6051,6052,2631,4596,579,3768,3860,5839,6418,3305,4683,3861,5876,6419,6609,3927,4634,3507,3779,3781,4599,4620,4621)
@spoonerf it occurred to me after running the update query that one of these charts could be unlisted, in which case they should have been excluded from the update.
Checking for charts that are both unlisted and is_indexable against the live DB returns nothing after the update, so we're good:
SELECT DISTINCT charts.id FROM charts LEFT JOIN chart_tags ON charts.id = chart_tags.chartId LEFT JOIN tags ON tags.id = chart_tags.tagId WHERE charts.is_indexable = 1 AND tags.
name="Unlisted"
Ah good thinking @mlbrgl! Thanks for the fix. So after the indexing runs in a few hours these charts should reappear in Search?
Yes! (they did)
Charts that should be indexable: datasette query
From live db to avoid stale results from datasette query: