Limadata: Profile Signal

Loading signal data…

\n\n\n\n",[222],"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",[230],"pulls","branches","forks","envVars",{"_243":245,"_246":42},"connections",{"_243":42,"_244":42},"count","unfilledCount",4,"emptyCount",{"_18":229,"_20":230,"_122":231,"_124":-5,"_125":68,"_126":232,"_128":38,"_22":301,"_65":42,"_131":132,"_133":234,"_135":26,"_136":-5,"_262":302,"_85":303},{"_18":221,"_20":222,"_122":223,"_124":-5,"_125":68,"_126":224,"_128":38,"_22":298,"_65":226,"_131":95,"_133":227,"_135":26,"_136":-5,"_262":299,"_85":300},{"_18":213,"_20":214,"_122":215,"_124":-5,"_125":68,"_126":216,"_128":38,"_22":295,"_65":218,"_131":195,"_133":219,"_135":26,"_136":-5,"_262":296,"_85":297},{"_18":206,"_20":207,"_122":208,"_124":-5,"_125":68,"_126":66,"_128":38,"_22":292,"_65":210,"_131":95,"_133":211,"_135":26,"_136":-5,"_262":293,"_85":294},{"_18":198,"_20":199,"_122":200,"_124":-5,"_125":68,"_126":201,"_128":38,"_22":289,"_65":203,"_131":195,"_133":204,"_135":26,"_136":-5,"_262":290,"_85":291},{"_18":190,"_20":191,"_122":36,"_124":-5,"_125":68,"_126":192,"_128":38,"_22":286,"_65":194,"_131":195,"_133":196,"_135":26,"_136":-5,"_262":287,"_85":288},{"_18":181,"_20":182,"_122":183,"_124":-5,"_125":68,"_126":184,"_128":38,"_22":283,"_65":186,"_131":187,"_133":188,"_135":26,"_136":-5,"_262":284,"_85":285},{"_18":174,"_20":175,"_122":176,"_124":-5,"_125":68,"_126":177,"_128":38,"_22":280,"_65":42,"_131":132,"_133":179,"_135":26,"_136":-5,"_262":281,"_85":282},{"_18":167,"_20":168,"_122":169,"_124":-5,"_125":68,"_126":170,"_128":38,"_22":277,"_65":42,"_131":132,"_133":172,"_135":26,"_136":-5,"_262":278,"_85":279},{"_18":160,"_20":161,"_122":162,"_124":-5,"_125":68,"_126":163,"_128":38,"_22":274,"_65":42,"_131":132,"_133":165,"_135":26,"_136":-5,"_262":275,"_85":276},{"_18":152,"_20":153,"_122":154,"_124":-5,"_125":68,"_126":155,"_128":38,"_22":271,"_65":157,"_131":132,"_133":158,"_135":26,"_136":-5,"_262":272,"_85":273},{"_18":145,"_20":146,"_122":147,"_124":-5,"_125":68,"_126":148,"_128":38,"_22":268,"_65":42,"_131":132,"_133":150,"_135":26,"_136":-5,"_262":269,"_85":270},{"_18":138,"_20":139,"_122":140,"_124":-5,"_125":68,"_126":141,"_128":38,"_22":265,"_65":42,"_131":132,"_133":143,"_135":26,"_136":-5,"_262":266,"_85":267},{"_18":120,"_20":121,"_122":123,"_124":-5,"_125":68,"_126":127,"_128":38,"_22":261,"_65":130,"_131":132,"_133":134,"_135":26,"_136":-5,"_262":263,"_85":264},["D",1788378557981],"children",[],[121],["D",1788378137760],[],[139],["D",1788296086727],[],[146],["D",1788556685208],[],[153],["D",1788384447548],[],[161],["D",1788381362561],[],[168],["D",1788381861334],[],[175],["D",1788556715953],[],[182],["D",1788275057394],[],[191],["D",1789413254393],[],[199],["D",1789413270118],[],[207],["D",1788384415311],[],[214],["D",1788379333604],[],[222],["D",1788384726534],[],[230],["D",1788273667302],{"_16":17,"_83":78},{"_16":17,"_77":78,"_79":78,"_33":34,"_80":81,"_82":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_103":341,"_342":343,"_344":345,"_346":26,"_347":26,"_348":26,"_349":38,"_350":-5,"_351":-7,"_352":-7,"_353":42,"_354":26,"_355":26,"_356":-5,"_357":26,"_358":26,"_359":26,"_360":-5},"ENV",{"_312":313,"_314":315,"_316":67,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340},"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"]

Search