[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_184":185,"_186":187},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_38":-7,"_124":-5,"_19":125,"_126":127,"_128":129,"_130":131,"_132":133,"_21":134,"_135":-5,"_136":-5,"_137":24,"_138":139,"_140":84,"_141":-5,"_142":-5,"_143":144},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","kemilrajejarude","name","profcar-transcribe-260827","branchName","main","path","download.ts","project",{"_32":72,"_13":14,"_36":73,"_74":-5,"_75":24,"_76":77,"_78":77,"_79":80,"_81":-5,"_30":68,"_82":64,"_83":84,"_85":-5,"_86":-5,"_87":26,"_40":41,"_88":89,"_90":91,"_92":93,"_94":-5,"_95":96,"_97":96,"_98":99,"_100":99,"_101":99,"_102":96,"_103":96,"_53":104,"_105":106,"_107":108,"_109":24},"file",{"_63":64,"_13":18,"_65":66,"_67":24,"_71":-5},"isDirectory",false,"page",0,"history",[31],"hasNext","userId",{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":52,"_53":54,"_21":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":61},"id","bc173078-8ec8-4c01-8dc9-69b5b1571625","branchId","57cd85ed-a07d-476c-96fe-0a3b3306ff39","createdAt",["D",1787881215529],"version",3,"orgId","019ff3cf-16f4-709a-8fe4-60961d815d88","parentId","98de0445-0582-4ae6-b4a2-03e4b7fcd43d","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","ChatGPT","user",{"_32":68,"_40":41,"_11":12,"_69":70},{"_63":64,"_13":18,"_65":66,"_67":24},"pull","merge","revert","multiple","commits",[62],{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":50,"_51":52,"_53":54,"_21":55,"_56":-5,"_57":-5,"_58":-5},"fileId","6b087c30-a281-11f1-8673-1607ee4eb77e","fileType","http","deleted","6af5a0e5-948b-4312-a6df-879952225a73","avatar","https://lh3.googleusercontent.com/a/ACg8ocJKihjBDLgGZqsR10b1qEdYjfcapUof9nyXNF0WLzSTs5E2qCOu=s96-c","deletedAtVersion","a1cb98b9-eaba-43f6-a00c-b248e3918a1a",["D",1787871554907],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","PROFCAR transcription 260827","imageUrl","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","a1cb98b9eaba43f6a00cb248e3918a1a","tursoHostname","a1cb98b9eaba43f6a00cb248e3918a1a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_123":70},"org",{"_11":12,"_118":119,"_69":70,"_30":68,"_120":121,"_122":24},"branch",{"_38":39,"_13":16,"_32":35,"_110":72,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":14,"_117":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Kemil Raje Jarude","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_32":72,"_13":14,"_36":179,"_74":-5,"_75":24,"_76":77,"_78":77,"_79":80,"_81":-5,"_30":68,"_82":64,"_83":84,"_85":-5,"_86":-5,"_87":26,"_40":41,"_88":89,"_90":91,"_92":180,"_94":-5,"_95":96,"_97":96,"_98":99,"_100":99,"_101":99,"_102":96,"_103":96,"_53":181,"_105":182,"_107":183,"_109":24},"tree",[163,164],"files",[163,164],"counts",{"_152":26,"_153":154,"_155":26,"_156":157,"_158":159},"contents",[],{"_32":145,"_34":35,"_63":64,"_13":18,"_146":147,"_65":66,"_38":26,"_42":-5,"_36":148,"_149":39,"_150":-5,"_17":151},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"0d1010ab-cadb-4073-b052-a924c59581c2","content","export default async function handler(_req: Request) {\n const url = \"https://a4af93de-8439-4a25-b77d-3369556baa8c.sandbox.floot.app/_cdn/static/transcricao_completa_26082709080910452.txt\";\n const r = await fetch(url);\n if (!r.ok) return new Response(`upstream ${r.status}`, { status: 502 });\n const body = await r.arrayBuffer();\n return new Response(body, { headers: {\n \"content-type\": \"text/plain; charset=utf-8\",\n \"content-disposition\": \"attachment; filename=transcricao_completa_26082709080910452.txt\",\n \"cache-control\": \"no-store\"\n }});\n}",["D",1787881215529],"branchVersion","label",[18],"pulls","branches",1,"forks","envVars",{"_160":26,"_162":26},"connections",{"_160":26,"_161":26},"count","unfilledCount","emptyCount",{"_32":145,"_13":18,"_63":64,"_42":-5,"_34":35,"_149":39,"_169":84,"_36":176,"_38":26,"_65":66,"_146":147,"_67":24,"_150":-5,"_173":177,"_17":178},{"_32":165,"_13":166,"_63":167,"_42":-5,"_34":35,"_149":168,"_169":84,"_36":170,"_38":154,"_65":171,"_146":172,"_67":24,"_150":-5,"_173":174,"_17":175},"fb07e82c-96d2-437b-a52b-3b3e5e050398","transcribe.ts","ecdf74e6-a26a-11f1-8246-1607ee4eb77e",2,"latest",["D",1787871591208],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst AUDIO = \"https://a4af93de-8439-4a25-b77d-3369556baa8c.sandbox.floot.app/_cdn/static/5206286e-4321-4b33-aea5-4284dc21c990-26082709080910452_compactado_8k_full.ogg\";\nconst STT = \"https://notetakers.vipresearch.ca/stt/v1/transcribe\";\nconst SEG_SEC = 1200;\nconst SEGMENTS = 9;\n\nfunction u32(d: Uint8Array,o:number){return (d[o]|d[o+1]<<8|d[o+2]<<16|d[o+3]<<24)>>>0}\nfunction u64(d:Uint8Array,o:number){return Number(BigInt(u32(d,o))+(BigInt(u32(d,o+4))<<32n))}\nfunction w32(d:Uint8Array,o:number,v:number){d[o]=v&255;d[o+1]=(v>>>8)&255;d[o+2]=(v>>>16)&255;d[o+3]=(v>>>24)&255}\nfunction w64(d:Uint8Array,o:number,v:number){const b=BigInt(Math.floor(v));w32(d,o,Number(b&0xffffffffn));w32(d,o+4,Number((b>>32n)&0xffffffffn))}\nfunction crc(d:Uint8Array){let c=0>>>0;for(const b of d){c=(c^(b<<24))>>>0;for(let i=0;i<8;i++)c=(c&0x80000000)?(((c<<1)>>>0)^0x04C11DB7)>>>0:(c<<1)>>>0}return c>>>0}\nfunction patch(raw:Uint8Array,serial:number,seq:number,gran:number,ht:number){const x=new Uint8Array(raw);x[5]=ht;w64(x,6,gran);w32(x,14,serial);w32(x,18,seq);w32(x,22,0);w32(x,22,crc(x));return x}\ntype Pg={p:number,size:number,g:number,type:number};\nfunction parse(d:Uint8Array){let p=0,a:Pg[]=[];while(p0){const b=audio.findIndex(x=>x.g>=startThr);start=b<0?audio.length:b+1}if(start>=audio.length)return null;let end=audio.findIndex((x,i)=>i>=start&&x.g>=endThr);if(end<0)end=audio.length-1;const base=start===0?0:audio[start-1].g;const serial=(0x7c270000+index*7919)>>>0;const parts=[patch(d.slice(head.p,head.p+head.size),serial,0,0,2),patch(d.slice(tags.p,tags.p+tags.size),serial,1,0,0)];let seq=2;for(let i=start;i<=end;i++){const x=audio[i];let ht=x.type&1;if(i===end)ht|=4;parts.push(patch(d.slice(x.p,x.p+x.size),serial,seq++,(x.g-base)+preskip,ht))}return {bytes:join(parts),startSec:index*SEG_SEC,endSec:Math.min((index+1)*SEG_SEC,(audio[audio.length-1].g-preskip)/48000)} }\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS segments (idx INTEGER PRIMARY KEY, ok INTEGER NOT NULL, text TEXT, error TEXT, start_sec REAL, end_sec REAL, audio_bytes INTEGER, status INTEGER, processing_ms INTEGER, created_at TEXT DEFAULT CURRENT_TIMESTAMP)`);\nconst existing=await sqlite.execute(\"SELECT idx FROM segments WHERE ok=1 ORDER BY idx\");\nconst done=new Set(existing.rows.map((r:any)=>Number(r.idx)));\nlet index=-1; for(let i=0;i

History · download.ts