gitoriaLog in with ident

tracker

All repositories: gitoria

ReadmeCodePull requestsReleasesTicketsSettings
Main branchmain5cb85d75deploy.sh: a backup taken while a background job writes (tar exit 1) is a warning; archive checked with gzip -tmremain/lib/sync-helpers.hl

7.3 KB

  1. // lib/sync-helpers.hl — the small pieces of the sync (sync.hl) that need no table and no request: placeholder titles, day
  2. // numbers, TVmaze's HTML stripped, whether TVmaze numbers a show like we do, which seasons to ask, batches, changed texts,
  3. // migrated rows, and the totals of a run (mission 028: out of tmdbsync.hl).
  4. import { textOr } from './util.hl'
  5. // ---- TVmaze merge (tracker.worldapi.org#15) ------------------------------------------------------
  6. // a title that is none yet: empty, "TBA"/"TBD", or "Episode <n>" (what TMDB and TVmaze name an untitled episode; also
  7. // French/German/Spanish: real data has TVmaze "Épisode 1" where TMDB says "Episode 1")
  8. static placeholderWords = ['episode', 'épisode', 'Épisode', 'folge', 'episodio']
  9. static isPlaceholderTitle = (&v) => {
  10. t = textOr(v)
  11. if (t == null) { return true }
  12. l = t.trim().toLowerCase()
  13. if (l == 'tba' || l == 'tbd' || l == 'tba.' || l == 'to be announced') { return true }
  14. parts = l.split(' ')
  15. if (parts.length != 2 || !placeholderWords.includes(parts[0]) || parts[1].length == 0) { return false }
  16. let i = 0
  17. while (i < parts[1].length) {
  18. if (!'0123456789'.includes(parts[1][i])) { return false }
  19. i = i + 1
  20. }
  21. return true
  22. }
  23. // 'YYYY-MM-DD' → a day number (only differences matter), null when it is no such date
  24. static dayNumber = (&v) => {
  25. t = textOr(v)
  26. if (t == null || t.length < 10) { return null }
  27. y = toNumber(t.slice(0, 4))
  28. m = toNumber(t.slice(5, 7))
  29. d = toNumber(t.slice(8, 10))
  30. if (y == null || m == null || d == null || m < 1 || m > 12) { return null }
  31. before = [0, 31, 59, 90, 120, 151, 181, 212, 243, 273, 304, 334]
  32. py = m <= 2 ? y - 1 : y
  33. leaps = (py - py % 4) / 4 - (py - py % 100) / 100 + (py - py % 400) / 400
  34. return y * 365 + leaps + before[m - 1] + d
  35. }
  36. static daysApart = (&a, &b) => {
  37. x = dayNumber(a)
  38. y = dayNumber(b)
  39. if (x == null || y == null) { return null }
  40. return x > y ? x - y : y - x
  41. }
  42. // TVmaze's text without its HTML (tracker#18: `tvmazeSummary`): tags dropped — a block tag (p, br, div, li) becomes a space —
  43. // the common entities decoded, white space collapsed; null when nothing is left
  44. static blockTags = ['p', 'br', 'div', 'li', 'ul', 'ol', 'h1', 'h2', 'h3', 'h4', 'blockquote']
  45. static entities = [['&nbsp;', ' '], ['&quot;', '"'], ['&#39;', "'"], ['&apos;', "'"], ['&lt;', '<'], ['&gt;', '>'], ['&ndash;', '–'], ['&mdash;', '—'], ['&hellip;', '…'], ['&amp;', '&']]
  46. static stripHtml = (&v) => {
  47. t = textOr(v)
  48. if (t == null) { return null }
  49. let out = ''
  50. let i = 0
  51. while (i < t.length) {
  52. if (t[i] == '<') {
  53. let close = t.indexOf('>', i)
  54. if (close < 0) { close = t.length }
  55. let name = t.slice(i + 1, close).trim().toLowerCase()
  56. if (name.startsWith('/')) { name = name.slice(1) }
  57. let sp = name.indexOf(' ')
  58. if (sp >= 0) { name = name.slice(0, sp) }
  59. if (name.endsWith('/')) { name = name.slice(0, name.length - 1) }
  60. if (blockTags.includes(name)) { out = out + ' ' }
  61. i = close + 1
  62. } else {
  63. // a line break / tab (a control character) is a space too (strings have no escapes to name them)
  64. out = out + (t.charCodeAt(i) < 32 ? ' ' : t[i])
  65. i = i + 1
  66. }
  67. }
  68. for (e of entities) { out = out.replaceAll(e[0], e[1]) }
  69. words = []
  70. for (w of out.split(' ')) { if (w != '') { words.push(w) } }
  71. return words.length > 0 ? words.join(' ') : null
  72. }
  73. // do we and TVmaze number a show the same way? Of the episodes both know (same S/E), at least 80 % must air within a day
  74. // of each other OR carry the same title (a streaming show TVmaze dates all on its release day, TMDB week by week, still
  75. // agrees by title). A show we have episodes of but TVmaze numbers none of the same (e.g. seasons by year) never agrees.
  76. // Answers { known, compared, agree, ok }.
  77. static sameTitle = (&a, &b) => { return !isPlaceholderTitle(a) && !isPlaceholderTitle(b) && a.trim().toLowerCase() == b.trim().toLowerCase() }
  78. static numberingAgrees = (&epByNumber, &list) => {
  79. out = { known = 0 compared = 0 agree = 0 ok = true }
  80. localCount = epByNumber.keys().length
  81. for (te of list) {
  82. let e = epByNumber[te.season + 'x' + te.number]
  83. if (e != null) {
  84. out.known = out.known + 1
  85. let apart = daysApart(e.release, te.airdate)
  86. let titled = !isPlaceholderTitle(e.title) && !isPlaceholderTitle(te.name)
  87. if (apart != null || titled) {
  88. out.compared = out.compared + 1
  89. if ((apart != null && apart <= 1) || sameTitle(e.title, te.name)) { out.agree = out.agree + 1 }
  90. }
  91. }
  92. }
  93. out.ok = !((localCount > 0 && out.known == 0) || (out.compared > 0 && out.agree * 5 < out.compared * 4))
  94. return out
  95. }
  96. // which TMDB seasons to sync: every numbered one with episodes; 0 only when the show has a season 0 already
  97. static wantedSeasonNumbers = (&details, &localByNumber) => {
  98. out = []
  99. if (details.seasons == null) { return out }
  100. for (s of details.seasons) {
  101. let n = s.season_number
  102. if (n != null && (n > 0 || localByNumber['' + n] != null) && (s.episode_count == null || s.episode_count > 0 || localByNumber['' + n] != null)) { out.push(n) }
  103. }
  104. return out
  105. }
  106. // the seasons in batches of 20 (TMDB's append_to_response limit)
  107. static batchesOf = (&list, &size) => {
  108. out = []
  109. let cur = []
  110. for (x of list) {
  111. cur.push(x)
  112. if (cur.length == size) { out.push(cur) cur = [] }
  113. }
  114. if (cur.length > 0) { out.push(cur) }
  115. return out
  116. }
  117. // fields of an episode/season from TMDB that differ from the stored record (null/empty never overwrites)
  118. static changedText = (stored, &fresh) => { return fresh != null && fresh != stored }
  119. // mission 070 (conductor: no step destroys migrated data): a season / episode the old tracker's migration brought (its `oldId`
  120. // is neither `tmdb-…` nor `tvmaze-…`) keeps its FIRST title / summary in `migratedTitle` / `migratedSummary` before TMDB's text
  121. // replaces it (set once; shown nowhere) — the daily delta run now also refreshes seasons of titles nobody follows
  122. static isMigratedRow = (&r) => { return r.oldId != null && ('' + r.oldId).slice(0, 5) != 'tmdb-' && ('' + r.oldId).slice(0, 7) != 'tvmaze-' }
  123. // totals of a run: the per-show counts added up
  124. static emptyTotals = () => { return { shows = 0 requests = 0 tvmazeRequests = 0 newSeasons = 0 newEpisodes = 0 updatedEpisodes = 0 updatedSeasons = 0 posters = 0 ids = 0 tvmazeEpisodes = 0 tvmazeSeasons = 0 tvmazeFilled = 0 tvmazeSkipped = 0 errors = 0 } }
  125. static addTotals = (t, &r) => {
  126. o = t
  127. o.shows = o.shows + 1
  128. o.requests = o.requests + r.requests
  129. o.tvmazeRequests = o.tvmazeRequests + r.tvmazeRequests
  130. o.ids = o.ids + r.ids
  131. o.newSeasons = o.newSeasons + r.newSeasons
  132. o.newEpisodes = o.newEpisodes + r.newEpisodes
  133. o.updatedEpisodes = o.updatedEpisodes + r.updatedEpisodes
  134. o.updatedSeasons = o.updatedSeasons + r.updatedSeasons
  135. o.posters = o.posters + r.posters
  136. o.tvmazeEpisodes = o.tvmazeEpisodes + r.tvmazeEpisodes
  137. o.tvmazeSeasons = o.tvmazeSeasons + r.tvmazeSeasons
  138. o.tvmazeFilled = o.tvmazeFilled + r.tvmazeFilled
  139. o.tvmazeSkipped = o.tvmazeSkipped + r.tvmazeSkipped
  140. o.errors = o.errors + r.errors
  141. return o
  142. }
  143. static totalsLine = (&t) => {
  144. return 'shows=' + t.shows + ' newSeasons=' + t.newSeasons + ' newEpisodes=' + t.newEpisodes + ' updatedEpisodes=' + t.updatedEpisodes
  145. + ' updatedSeasons=' + t.updatedSeasons + ' posters=' + t.posters + ' ids=' + t.ids + ' requests=' + t.requests + ' tvmazeRequests=' + t.tvmazeRequests + ' errors=' + t.errors
  146. + ' tvmazeEpisodes=' + t.tvmazeEpisodes + ' tvmazeSeasons=' + t.tvmazeSeasons + ' tvmazeFilled=' + t.tvmazeFilled + ' tvmazeSkipped=' + t.tvmazeSkipped
  147. }

Branches

Latest commits

  • 5cb85d75deploy.sh: a backup taken while a background job writes (tar exit 1) is a warning; archive checked with gzip -tmre
  • 9abda75dtracker: report 035mre
  • 12595e47mission 035: theme re-vendored from layouts.worldapi.org 0222f67 (two corner radii: radiusSmall 5px, radiusLarge 10px); the tracker's 18 own radii -> radiusSmall/radiusLarge (--layout-radius is gone); check-theme 0; gates 379/0, 32/0, 53/0, 229/0, 26/0; real copy: every computed radius in {0, 5px, 10px, 50%}mre
  • e7305014tracker: report 032 (art + photos)mre
  • fbb903cctracker#33/#37 (mission 032): a title without a TMDB poster gets its backdrop (w780, posterFromBackdrop, shown 2:3 centre-cropped); movies store runtime, the page shows release date + runtime; art backfill (public titles without poster file / movies without runtime) and person photo backfill (tmdbProfile / photoCheck) as the last start jobs (TRACKER_ART, TRACKER_PHOTOS; off in every gate start); gates 379/0, 32/0, 53/0, 229/0, 26/0, check-theme 0; live copy: art 4977 titles in 42 min (115 posters, 15 backdrops, 4609 runtimes), The Remaining shows its backdrop + 7 minmre
  • 4ecc67b2tracker: STATUS/LOG for the t38 + t40 merge (gates 374/0, 32/0, 53/0, 229/0, 26/0, check-theme 0; live copy checks)mre
  • e5945d2fMerge t40 (tracker#40 curated franchises, Franchises menu, superseded collections) into main: deploy.sh lists all six gates (browser, kinds, franchises, pager, franchiseseed, check-theme); search.hl keeps #37's personPhotoOf + #40's importWithCredits; pager gate runs with TRACKER_FRANCHISE_SEED=0; gates 374/0, 32/0, 53/0, 229/0, 26/0, check-theme 0mre
  • b638e99dMerge t38 (tracker#38 pagination, #35 Returning/Airing label) into main: LOG/STATUS keep both sides; pager gate follows #37's /people (everyone, last updated first: seed updatedAt); gates pager 229/0, browser 374/0mre
  • f8ffa4dbtracker: report 032 + The Remaining + #39mre
  • 7565a863tracker: LOG timemre
  • b10f00c8tracker#39: double episodes — migrated episodes whose TMDB id TMDB replaced are adopted by their number in the sync (old id -> migratedTmdbId); merge.hl step 3 merges each season's doubles at start (keeper: most watches > synced > first; watches moved/parked; tombstones into mergedEpisodes, nothing deleted); tools/count-duplicate-episodes.hl; gate fixture + paths-m039; live copy 850 -> 0 in 64 s; gates 373/0, 32/0, 52/0mre
  • 8f1d4542tracker#40: superseded collections — a TMDB collection timeline whose titles are all in one curated timeline is hidden (supersededBy; kept: own page + editor finder), set by the collection seed when it makes one and by the curated build (lifted when the cover is gone); partly covered ones join that franchise; no second widget (First Contact: only Star Trek — Prime); gate franchiseseed 26/0, browser 365/0, kinds 32/0, franchises 53/0, check-theme 0; real copy 24 supersededmre
  • 9448d643tracker#35 follow-up (mission 033): TVmaze 'Running' is labelled 'Returning', or 'Airing' while a non-special episode of the two newest seasons is released within today +-7 days (data unchanged); gate fixtures Running/Airing/Aired + a special; browser 366/0, kinds 32/0, franchises 52/0, pager 229/0, check-theme 0mre
  • 7d4b293dtracker#40: "Franchises" in the main menu (desktop header after People, phone sidebar) → /franchises, marked on franchise and timeline pages; gates 365/0, 32/0, 53/0, 24/0, check-theme 0mre
  • 8751adb8tracker: report 032mre
  • 9bce1f65tracker mission 032: STATUS gate files + the hour-boundary flakemre
  • 718bfb89tracker#37 (mission 032): /people = everyone, last updated first (updatedAt stamped by the person fill; view built at boot, touched people first at once), photo + name tiles (person colour) with the /movies pagination, /people/<letter> removed; photo = our file, tmdbProfile, a cast/crew entry's profile (in-memory map at boot), else the new 'no photo' placeholder; new cast/crew/created_by people keep tmdbProfile; search people rows with the photo; /settings = the heading only; util.hl sortDesc starts from sorted runs (same result, 105k: 1.6 s -> 0.15 s); gates 369/0, 32/0, 52/0, check-theme 0; README/STATUS/LOGmre
  • 93dfb0batracker#40 (mission 034): the curated franchises — data/franchises.json (17 franchises, 31 timelines, 285 TMDB titles, movies + series, in-universe/release order, 12 TMDB collections attached); lib/franchiseseed.hl + jobs.hl franchiseSeedTick (last start job, imports missing titles via details.hl importWithCredits = the search's Add, one per step paced, then one build; franchiseseed.db: editor changes win, the creator's same-name franchise adopted / timeline left alone, 404 remembered, resumable, idempotent); timeline heads 'N titles · in-universe order' (orderKind) and wrap on a phone; series pages show the widget; new gate tests/franchiseseed.mjs (5th in deploy.sh), the others run with TRACKER_FRANCHISE_SEED=0; gates 365/0, 32/0, 52/0, 24/0, check-theme 0; real copy 196 imported, 0 failed, 7 min, restart unchanged=31mre
  • 03ec792ftracker#38 (mission 033): pagination goes exactly to the clicked page — tilelist read the clicked button's text after pagination.hl's own handler had rebuilt the buttons (real clicks only); now li.current, else the button's own text; new gate tests/pager.mjs (5 lists x 11 pages, 390/1280, real + script clicks, Back/Forward) 229/0; browser 365/0, kinds 32/0, franchises 52/0, check-theme 0mre
  • 96ba683adeploy.sh: a gate without a 'passed,' line (check-theme) no longer ends the scriptmre