Limadata: Profile Signal

Loading signal data…

\n\n\n\n",[228],"4c19816a-d9dc-458a-9ea4-4f0120112117","backfill-lima-slugs.ts","befb4802-a715-11f1-a8ab-1607ee4eb77e",133,["D",1788384726534],"// One-off backfill: limadata people.public_identifier from the vanity slug in the\n// raw payloads' after/before.profile_url (data.url is urn-based for many profiles).\n// Matches the extraction now in processor.ts normLimadata(). Idempotent.\nimport postgres from \"npm:postgres\";\n\nconst sql = postgres(Deno.env.get(\"DATABASE_URL\")!, { max: 1, idle_timeout: 5, connect_timeout: 10 });\n\nconst res = await sql`\n update thenetwork.people p\n set public_identifier = s.slug\n from (\n select distinct on (coalesce(payload->'data'->>'url', payload->'data'->>'external_id'))\n coalesce(payload->'data'->>'url', payload->'data'->>'external_id') as url,\n substring(coalesce(payload->'data'->'after'->>'profile_url',\n payload->'data'->'before'->>'profile_url') from '/in/([^/?#]+)') as slug\n from thenetwork.raw_payloads\n where vendor = 'limadata'\n and coalesce(payload->'data'->'after'->>'profile_url',\n payload->'data'->'before'->>'profile_url') ~ '/in/'\n order by 1, id desc\n ) s\n where p.vendor = 'limadata' and p.public_identifier is null\n and p.linkedin_url = s.url\n and s.slug is not null and s.slug !~ '^AC[ow]'`;\nconsole.log(\"people updated:\", res.count);\n\nconst [left] = await sql`\n select count(*)::int as n from thenetwork.people\n where vendor = 'limadata' and public_identifier is null`;\nconsole.log(\"limadata people still without a slug:\", left.n);\nawait sql.end();\n",[236],"pulls","forks","envVars",{"_248":250,"_251":54},"connections",{"_248":54,"_249":54},"count","unfilledCount",4,"emptyCount",{"_20":235,"_13":236,"_128":237,"_130":-5,"_131":21,"_132":238,"_134":50,"_22":306,"_29":54,"_137":138,"_139":240,"_141":38,"_142":-5,"_267":307,"_90":308},{"_20":227,"_13":228,"_128":229,"_130":-5,"_131":21,"_132":230,"_134":50,"_22":303,"_29":232,"_137":101,"_139":233,"_141":38,"_142":-5,"_267":304,"_90":305},{"_20":219,"_13":220,"_128":221,"_130":-5,"_131":21,"_132":222,"_134":50,"_22":300,"_29":224,"_137":201,"_139":225,"_141":38,"_142":-5,"_267":301,"_90":302},{"_20":212,"_13":213,"_128":214,"_130":-5,"_131":21,"_132":30,"_134":50,"_22":297,"_29":216,"_137":101,"_139":217,"_141":38,"_142":-5,"_267":298,"_90":299},{"_20":204,"_13":205,"_128":206,"_130":-5,"_131":21,"_132":207,"_134":50,"_22":294,"_29":209,"_137":201,"_139":210,"_141":38,"_142":-5,"_267":295,"_90":296},{"_20":196,"_13":197,"_128":48,"_130":-5,"_131":21,"_132":198,"_134":50,"_22":291,"_29":200,"_137":201,"_139":202,"_141":38,"_142":-5,"_267":292,"_90":293},{"_20":187,"_13":188,"_128":189,"_130":-5,"_131":21,"_132":190,"_134":50,"_22":288,"_29":192,"_137":193,"_139":194,"_141":38,"_142":-5,"_267":289,"_90":290},{"_20":180,"_13":181,"_128":182,"_130":-5,"_131":21,"_132":183,"_134":50,"_22":285,"_29":54,"_137":138,"_139":185,"_141":38,"_142":-5,"_267":286,"_90":287},{"_20":173,"_13":174,"_128":175,"_130":-5,"_131":21,"_132":176,"_134":50,"_22":282,"_29":54,"_137":138,"_139":178,"_141":38,"_142":-5,"_267":283,"_90":284},{"_20":166,"_13":167,"_128":168,"_130":-5,"_131":21,"_132":169,"_134":50,"_22":279,"_29":54,"_137":138,"_139":171,"_141":38,"_142":-5,"_267":280,"_90":281},{"_20":158,"_13":159,"_128":160,"_130":-5,"_131":21,"_132":161,"_134":50,"_22":276,"_29":163,"_137":138,"_139":164,"_141":38,"_142":-5,"_267":277,"_90":278},{"_20":151,"_13":152,"_128":153,"_130":-5,"_131":21,"_132":154,"_134":50,"_22":273,"_29":54,"_137":138,"_139":156,"_141":38,"_142":-5,"_267":274,"_90":275},{"_20":144,"_13":145,"_128":146,"_130":-5,"_131":21,"_132":147,"_134":50,"_22":270,"_29":54,"_137":138,"_139":149,"_141":38,"_142":-5,"_267":271,"_90":272},{"_20":126,"_13":127,"_128":129,"_130":-5,"_131":21,"_132":133,"_134":50,"_22":266,"_29":136,"_137":138,"_139":140,"_141":38,"_142":-5,"_267":268,"_90":269},["D",1788378557981],"children",[],[127],["D",1788378137760],[],[145],["D",1788296086727],[],[152],["D",1788556685208],[],[159],["D",1788384447548],[],[167],["D",1788381362561],[],[174],["D",1788381861334],[],[181],["D",1788556715953],[],[188],["D",1788275057394],[],[197],["D",1789413254393],[],[205],["D",1789413270118],[],[213],["D",1788384415311],[],[220],["D",1788379333604],[],[228],["D",1788384726534],[],[236],["D",1788273667302],{"_11":12,"_88":83},{"_11":12,"_82":83,"_84":83,"_45":46,"_85":86,"_87":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_109":346,"_347":348,"_349":350,"_351":38,"_352":38,"_353":38,"_354":50,"_355":-5,"_356":-7,"_357":-7,"_358":54,"_359":38,"_360":38,"_361":-5,"_362":38,"_363":38,"_364":38,"_365":-5},"ENV",{"_317":318,"_319":320,"_321":26,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Branches1

Branches
1