| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452 |
- package main
- var pg = `<!DOCTYPE html>
- <html lang="zh-CN">
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>TsDB2 Analyzer v3</title>
- <style>
- *{box-sizing:border-box;margin:0;padding:0}
- body{font-family:'Segoe UI',system-ui,-apple-system,sans-serif;background:#0b0b14;color:#c8ccd4;min-height:100vh;overflow-x:hidden}
- ::-webkit-scrollbar{width:6px;height:6px}::-webkit-scrollbar-track{background:#12121f}::-webkit-scrollbar-thumb{background:#2a2a4a;border-radius:3px}
- a{color:#5b9bd5;text-decoration:none}
- .hdr{background:linear-gradient(90deg,#0d0d1a,#141428);border-bottom:1px solid #1e1e3a;padding:0 24px;height:52px;display:flex;align-items:center;justify-content:space-between;position:sticky;top:0;z-index:100}
- .hdr .logo{display:flex;align-items:center;gap:10px;font-size:16px;font-weight:700;color:#5b9bd5}
- .hdr .meta{display:flex;align-items:center;gap:16px;font-size:12px;color:#666}
- .hdr .meta .db-name{color:#8890a0;max-width:300px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}
- .hdr .btn{padding:5px 14px;background:#1a1a30;border:1px solid #2a2a4a;color:#8890a0;border-radius:4px;cursor:pointer;font-size:12px;transition:all .2s}
- .hdr .btn:hover{background:#222240;color:#aab;border-color:#3a3a5a}
- .main{display:flex;height:calc(100vh - 52px)}
- .sidebar{width:240px;min-width:240px;background:#0e0e1a;border-right:1px solid #1a1a2e;overflow-y:auto;display:flex;flex-direction:column}
- .sidebar .sec-title{padding:12px 16px 6px;font-size:10px;text-transform:uppercase;letter-spacing:1.5px;color:#444;font-weight:600}
- .sidebar .tbl-item{padding:9px 16px;cursor:pointer;display:flex;align-items:center;gap:8px;font-size:13px;color:#778;transition:all .15s;border-left:3px solid transparent}
- .sidebar .tbl-item:hover{background:#141428;color:#aab}
- .sidebar .tbl-item.active{background:#141428;color:#5b9bd5;border-left-color:#5b9bd5}
- .sidebar .tbl-item .ico{font-size:14px;opacity:.6}
- .sidebar .tbl-item .cnt{margin-left:auto;font-size:10px;color:#445;background:#1a1a2e;padding:1px 6px;border-radius:8px}
- .content{flex:1;overflow-y:auto;padding:20px 28px}
- .bc{display:flex;align-items:center;gap:6px;padding:0 0 16px;font-size:12px;color:#556}
- .bc .item{cursor:pointer;color:#5b9bd5;transition:color .15s}.bc .item:hover{color:#7bb}
- .bc .sep{color:#334}.bc .cur{color:#8890a0}
- .stats{display:grid;grid-template-columns:repeat(auto-fit,minmax(160px,1fr));gap:14px;margin-bottom:20px}
- .card{background:#111122;border:1px solid #1a1a2e;border-radius:8px;padding:16px 18px;position:relative;overflow:hidden}
- .card::before{content:'';position:absolute;top:0;left:0;right:0;height:2px}
- .card.c1::before{background:linear-gradient(90deg,#5b9bd5,#4a8bc4)}.card.c2::before{background:linear-gradient(90deg,#4ecdc4,#3dbdb5)}
- .card.c3::before{background:linear-gradient(90deg,#f7b731,#e6a620)}.card.c4::before{background:linear-gradient(90deg,#a78bfa,#8b5cf6)}
- .card.c5::before{background:linear-gradient(90deg,#e74c3c,#c0392b)}
- .card .lb{font-size:10px;text-transform:uppercase;letter-spacing:1px;color:#556;margin-bottom:6px}
- .card .val{font-size:28px;font-weight:700;color:#e0e4ec}.card .sub{font-size:11px;color:#556;margin-top:4px}
- .sec{background:#0f0f1e;border:1px solid #1a1a2e;border-radius:8px;margin-bottom:16px;overflow:hidden}
- .sec-hd{padding:12px 16px;border-bottom:1px solid #1a1a2e;display:flex;align-items:center;gap:8px;font-size:13px;font-weight:600;color:#aab}
- .sec-hd .dot{width:8px;height:8px;border-radius:50%;background:#5b9bd5}
- .sec-bd{padding:0}
- .dtbl{width:100%;border-collapse:collapse;font-size:12px}
- .dtbl th{background:#0d0d1a;color:#5b9bd5;font-weight:600;padding:8px 12px;text-align:left;border-bottom:1px solid #1a1a2e;position:sticky;top:0;font-size:11px;text-transform:uppercase;letter-spacing:.5px}
- .dtbl td{padding:7px 12px;border-bottom:1px solid #141428;color:#8890a0;vertical-align:middle}
- .dtbl tr:hover td{background:#111125}
- .dtbl .mono{font-family:'Cascadia Code','Fira Code',Consolas,monospace;font-size:11px}
- .dtbl .clickable{cursor:pointer;color:#5b9bd5;transition:color .15s}.dtbl .clickable:hover{color:#7bb;text-decoration:underline}
- .badge{display:inline-block;padding:2px 8px;border-radius:3px;font-size:10px;font-weight:600;letter-spacing:.5px}
- .badge.primary{background:rgba(91,155,213,.15);color:#5b9bd5}.badge.time{background:rgba(78,205,196,.15);color:#4ecdc4}
- .badge.string{background:rgba(247,183,49,.15);color:#f7b731}.badge.compose{background:rgba(167,139,250,.15);color:#a78bfa}
- .badge.btree{background:rgba(116,185,255,.15);color:#74b9ff}.badge.leaf{background:rgba(78,205,196,.15);color:#4ecdc4}
- .badge.internal{background:rgba(247,183,49,.15);color:#f7b731}.badge.data{background:rgba(91,155,213,.12);color:#5b9bd5}
- .badge.dropped{background:rgba(231,76,60,.15);color:#e74c3c}.badge.active{background:rgba(78,205,196,.15);color:#4ecdc4}
- .idx-list{padding:12px}
- .idx-card{background:#111122;border:1px solid #1a1a2e;border-radius:6px;padding:12px 16px;margin-bottom:8px;cursor:pointer;transition:all .2s;display:flex;align-items:center;gap:12px}
- .idx-card:hover{border-color:#2a2a4a;background:#141428}
- .idx-card .idx-ico{width:32px;height:32px;border-radius:6px;display:flex;align-items:center;justify-content:center;font-size:16px;background:#1a1a30}
- .idx-card .idx-info{flex:1}.idx-card .idx-name{font-size:13px;font-weight:600;color:#c8ccd4}
- .idx-card .idx-meta{font-size:11px;color:#556;margin-top:3px;display:flex;gap:12px}
- .idx-card .idx-arrow{color:#334;font-size:14px}
- .node-bar{display:flex;flex-wrap:wrap;gap:16px;padding:12px 16px;background:#0d0d1a;border-bottom:1px solid #1a1a2e;font-size:12px}
- .node-bar .ni{display:flex;align-items:center;gap:4px}.node-bar .ni-lb{color:#556}.node-bar .ni-val{color:#c8ccd4;font-weight:600}
- .nav-btns{display:flex;gap:8px;padding:12px 16px;justify-content:center}
- .nav-btn{padding:6px 16px;background:#1a1a30;border:1px solid #2a2a4a;color:#8890a0;border-radius:4px;cursor:pointer;font-size:12px;transition:all .2s}
- .nav-btn:hover{background:#222240;color:#aab;border-color:#3a3a5a}
- .empty{text-align:center;padding:40px 20px;color:#445}.empty .ico{font-size:36px;margin-bottom:10px;opacity:.4}.empty .msg{font-size:13px}
- .fb-overlay{position:fixed;inset:0;background:#0b0b14;z-index:200;display:flex;align-items:center;justify-content:center}
- .fb-box{width:560px;max-height:80vh;background:#111122;border:1px solid #1e1e3a;border-radius:10px;box-shadow:0 20px 60px rgba(0,0,0,.5);overflow:hidden;display:flex;flex-direction:column}
- .fb-hd{padding:16px 20px;border-bottom:1px solid #1a1a2e;font-size:15px;font-weight:700;color:#5b9bd5;display:flex;align-items:center;gap:8px}
- .fb-path{padding:8px 16px;background:#0d0d1a;font-size:11px;color:#556;border-bottom:1px solid #1a1a2e;font-family:monospace;word-break:break-all}
- .fb-list{flex:1;overflow-y:auto;max-height:400px}
- .fb-item{padding:8px 16px;cursor:pointer;display:flex;align-items:center;gap:10px;font-size:13px;transition:background .1s;border-bottom:1px solid #0d0d1a}
- .fb-item:hover{background:#141428}.fb-item.sel{background:#141428;border-left:3px solid #5b9bd5}
- .fb-item .fi-ico{width:20px;text-align:center;font-size:14px}.fb-item .fi-sz{margin-left:auto;font-size:10px;color:#445}
- .fb-ft{padding:12px 16px;border-top:1px solid #1a1a2e;display:flex;gap:8px}
- .fb-ft button{flex:1;padding:8px;border:none;border-radius:5px;cursor:pointer;font-size:12px;font-weight:600;transition:all .2s}
- .fb-ft .b-up{background:#1a1a30;color:#8890a0}.fb-ft .b-up:hover{background:#222240}
- .fb-ft .b-open{background:#5b9bd5;color:#fff}.fb-ft .b-open:hover{background:#4a8bc4}
- .fb-ft .b-open:disabled{background:#1a1a30;color:#445;cursor:not-allowed}
- .hex-data{font-family:'Cascadia Code','Fira Code',Consolas,monospace;font-size:10px;color:#667;word-break:break-all;max-width:400px;line-height:1.5}
- .ubar{width:60px;height:4px;background:#1a1a2e;border-radius:2px;overflow:hidden;display:inline-block;vertical-align:middle;margin-left:6px}
- .ubar .fill{height:100%;border-radius:2px;background:#4ecdc4}
- .ver-card{background:#0d0d18;border:1px solid #1a1a2e;border-radius:6px;padding:10px 14px;margin-bottom:8px}
- .ver-card .ver-hd{display:flex;align-items:center;gap:8px;margin-bottom:6px}
- .ver-card .ver-num{font-size:14px;font-weight:700;color:#5b9bd5}
- .ver-card .ver-fields{display:flex;flex-wrap:wrap;gap:4px}
- .ver-card .ver-field{padding:2px 8px;border-radius:3px;font-size:11px;font-family:monospace}
- .ver-card .ver-field.active{background:rgba(78,205,196,.1);color:#4ecdc4;border:1px solid rgba(78,205,196,.2)}
- .ver-card .ver-field.dropped{background:rgba(231,76,60,.08);color:#e74c3c;border:1px solid rgba(231,76,60,.15);text-decoration:line-through}
- .row-decoded{font-family:'Cascadia Code','Fira Code',Consolas,monospace;font-size:11px;color:#4ecdc4;line-height:1.6;max-width:600px}
- .row-decoded .fld-name{color:#5b9bd5}.row-decoded .fld-val{color:#c8ccd4}
- @media(max-width:900px){.sidebar{width:200px;min-width:200px}}
- </style>
- </head>
- <body>
- <div id="app"></div>
- <script>
- const $=id=>document.getElementById(id);
- const esc=s=>s?s.replace(/</g,'<').replace(/>/g,'>'):'';
- function fB(n){n=+n;if(n<1024)return n+' B';if(n<1048576)return(n/1024).toFixed(1)+' KB';if(n<1073741824)return(n/1048576).toFixed(2)+' MB';return(n/1073741824).toFixed(2)+' GB'}
- const ITYPE={1:'Time',2:'Primary',3:'String',4:'Compose',5:'BTree'};
- const ICOLOR={1:'time',2:'primary',3:'string',4:'compose',5:'btree'};
- let S={view:'fb',db:'',tables:[],cur:null,bc:[],idxType:0};
- let FB={path:'',sel:''};
- function renderFB(){
- document.getElementById('app').innerHTML=
- '<div class="fb-overlay"><div class="fb-box"><div class="fb-hd"><span style="font-size:20px">📊</span> TsDB2 Analyzer v3</div>'+
- '<div class="fb-path" id="fbp">Loading...</div><div class="fb-list" id="fbl"></div>'+
- '<div class="fb-ft"><button class="b-up" onclick="fbUp()">← Up</button>'+
- '<button class="b-open" id="fbOpen" onclick="fbOpen()" disabled>Open Database</button></div></div></div>';
- fbLoad('');
- }
- function fbLoad(p){
- fetch(p?'/api/list-dir?path='+encodeURIComponent(p):'/api/list-dir').then(r=>r.json()).then(d=>{
- if(d.err){alert(d.err);return}
- FB.path=d.p;FB.sel='';$('fbOpen').disabled=true;$('fbp').textContent=d.p;
- let h='';
- if(d.d)d.d.forEach(x=>{h+='<div class="fb-item" ondblclick="fbLoad(\''+esc(d.p+'/'+x.n).replace(/\\/g,'/')+'\')">'+
- '<span class="fi-ico">📁</span>'+esc(x.n)+'</div>'});
- if(d.f)d.f.forEach(x=>{const fp=d.p+'/'+x.n;
- h+='<div class="fb-item" onclick="fbSel(this,\''+esc(fp).replace(/\\/g,'/')+'\')">'+
- '<span class="fi-ico">📄</span>'+esc(x.n)+'<span class="fi-sz">'+fB(x.s)+'</span></div>'});
- $('fbl').innerHTML=h||'<div class="empty"><div class="ico">📭</div><div class="msg">Empty</div></div>';
- });
- }
- function fbSel(el,p){document.querySelectorAll('.fb-item').forEach(e=>e.classList.remove('sel'));el.classList.add('sel');FB.sel=p;$('fbOpen').disabled=false}
- function fbUp(){fetch('/api/list-dir?path='+encodeURIComponent(FB.path)).then(r=>r.json()).then(d=>{if(d.pp)fbLoad(d.pp)})}
- function fbOpen(){
- if(!FB.sel)return;
- fetch('/api/open-db',{method:'POST',headers:{'Content-Type':'application/json'},body:JSON.stringify({p:FB.sel})})
- .then(r=>r.json()).then(d=>{if(d.ok){S.db=d.s.f;S.view='dash';loadDash(d.s)}else alert('Error: '+d.e)});
- }
- function loadDash(s){
- let h='<div class="hdr"><div class="logo"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><rect x="3" y="3" width="18" height="18" rx="2"/><path d="M3 9h18M9 3v18"/></svg>TsDB2 Analyzer v3</div>'+
- '<div class="meta"><span class="db-name">'+esc(s.f)+'</span><span>'+s.fs+'</span><span>'+s.pg+' pages</span>'+
- '<button class="btn" onclick="S.view=\'fb\';renderFB()">Change DB</button></div></div>';
- h+='<div class="main"><div class="sidebar" id="sidebar"><div class="sec-title">Explorer</div>'+
- '<div class="tbl-item" onclick="showOverview()" style="color:#5b9bd5"><span class="ico">📊</span>Overview</div>'+
- '<div class="tbl-item" onclick="showHeader()"><span class="ico">📑</span>HeaderPage</div>'+
- '<div class="tbl-item" onclick="showFreePages()"><span class="ico">♻</span>Free Pages</div>'+
- '<div class="sec-title">Tables</div><div id="sideTabs"></div></div>';
- h+='<div class="content" id="content"></div></div>';
- document.getElementById('app').innerHTML=h;loadTables();showOverview(s);
- }
- function loadTables(){
- fetch('/api/tables').then(r=>r.json()).then(ts=>{
- S.tables=ts||[];let h='';
- S.tables.forEach(t=>{
- let mc=t.masterFields?t.masterFields.filter(f=>!f.dropped).length:0;
- h+='<div class="tbl-item" onclick="showTable(\''+esc(t.name)+'\')"><span class="ico">📋</span>'+esc(t.name)+
- '<span class="cnt">v'+(t.activeVer||1)+'</span></div>';
- });
- if($('sideTabs'))$('sideTabs').innerHTML=h;
- });
- }
- function showOverview(s){
- if(!s){fetch('/api/stats').then(r=>r.json()).then(d=>showOverview(d));return}
- document.querySelectorAll('.tbl-item').forEach(e=>e.classList.remove('active'));
- let h='<div class="bc"><span class="cur">Overview</span></div>';
- h+='<div class="stats">'+
- '<div class="card c1"><div class="lb">Database Size</div><div class="val">'+s.fs+'</div><div class="sub">'+s.pg+' pages</div></div>'+
- '<div class="card c2"><div class="lb">Tables</div><div class="val">'+s.tc+'</div></div>'+
- '<div class="card c3"><div class="lb">Page Size</div><div class="val">16 KB</div></div>'+
- '<div class="card c4"><div class="lb">Engine</div><div class="val">v3</div><div class="sub">Schema Aware</div></div></div>';
- h+='<div class="sec"><div class="sec-hd"><div class="dot"></div>All Tables</div><div class="sec-bd">';
- if(!S.tables||!S.tables.length)h+='<div class="empty"><div class="msg">No tables</div></div>';
- else{
- h+='<table class="dtbl"><thead><tr><th>Table</th><th>Rows</th><th>Active Ver</th><th>Master Fields</th><th>Versions</th><th>Indexes</th><th>Row Size</th></tr></thead><tbody>';
- S.tables.forEach(t=>{
- let mc=t.masterFields?t.masterFields.filter(f=>!f.dropped).length:0;
- let dc=t.masterFields?t.masterFields.filter(f=>f.dropped).length:0;
- h+='<tr style="cursor:pointer" onclick="showTable(\''+esc(t.name)+'\')">'+
- '<td style="color:#5b9bd5;font-weight:600">'+esc(t.name)+'</td><td>'+t.rowN+'</td>'+
- '<td><span class="badge active">v'+t.activeVer+'</span></td>'+
- '<td>'+mc+(dc>0?' <span class="badge dropped">'+dc+' dropped</span>':'')+'</td>'+
- '<td>'+(t.versions?t.versions.length:0)+'</td>'+
- '<td>'+(t.idxs?t.idxs.length:0)+'</td><td>'+t.fsz+' B</td></tr>';
- });
- h+='</tbody></table>';
- }
- h+='</div></div>';
- // Page visualization
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#74b9ff"></div>Page Map <span id="pgMapInfo" style="font-weight:400;font-size:11px;color:#556;margin-left:8px">Loading...</span></div><div class="sec-bd" style="padding:12px"><div id="pgMap" style="display:flex;flex-wrap:wrap;gap:2px"></div><div id="pgLegend" style="margin-top:10px;display:flex;gap:12px;flex-wrap:wrap;font-size:11px;color:#667"></div></div></div>';
- $('content').innerHTML=h;
- // Load page map
- fetch('/api/pages').then(r=>r.json()).then(d=>{
- if(!d.pages||!d.pages.length){$('pgMapInfo').textContent='No pages';return}
- const TC={0:'#1a1a2e',1:'#f7b731',2:'#5b9bd5',3:'#4ecdc4',4:'#a78bfa',5:'#74b9ff'};
- const TN={0:'Free',1:'Table',2:'Data',3:'Heap',4:'IdxMeta',5:'IdxData'};
- let g='';
- d.pages.forEach(p=>{
- let c=TC[p.t]||'#333';
- let br=p.us>50?1:p.us>20?.6:.3;
- g+='<div style="width:14px;height:14px;border-radius:2px;background:'+c+';opacity:'+br+';cursor:default" title="Page #'+p.id+'\nType: '+TN[p.t]+'\nUsage: '+p.us.toFixed(1)+'%\nSize: 16 KB"></div>';
- });
- $('pgMap').innerHTML=g;
- let lg='';
- for(let k in d.counts)if(d.counts[k]>0)lg+='<span><span style="display:inline-block;width:10px;height:10px;border-radius:2px;background:'+(TC[{free:0,table:1,data:2,heap:3,imeta:4,idata:5}[k]]||'#333')+';margin-right:3px;vertical-align:middle"></span>'+TN[{free:0,table:1,data:2,heap:3,imeta:4,idata:5}[k]]+': '+d.counts[k]+'</span>';
- $('pgLegend').innerHTML=lg;
- $('pgMapInfo').textContent=d.total+' pages \u00d7 16 KB';
- });
- }
- function showTable(nm){
- const t=S.tables.find(x=>x.name===nm);if(!t)return;
- S.cur=t;S.idxType=0;S.bc=[{l:nm,a:null}];
- document.querySelectorAll('.tbl-item').forEach(e=>{e.classList.remove('active');if(e.textContent.includes(nm))e.classList.add('active')});
- let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">›</span><span class="cur">'+esc(nm)+'</span></div>';
- let mc=t.masterFields?t.masterFields.filter(f=>!f.dropped).length:0;
- let dc=t.masterFields?t.masterFields.filter(f=>f.dropped).length:0;
- h+='<div class="stats">'+
- '<div class="card c1"><div class="lb">Total Rows</div><div class="val">'+t.rowN+'</div></div>'+
- '<div class="card c2"><div class="lb">Active Version</div><div class="val">v'+t.activeVer+'</div></div>'+
- '<div class="card c3"><div class="lb">Active Fields</div><div class="val">'+mc+'</div>'+(dc>0?'<div class="sub">'+dc+' dropped</div>':'')+'</div>'+
- '<div class="card c4"><div class="lb">Schema Versions</div><div class="val">'+(t.versions?t.versions.length:0)+'</div></div>'+
- '<div class="card c5"><div class="lb">Indexes</div><div class="val">'+(t.idxs?t.idxs.length:0)+'</div></div></div>';
- // Master Registry
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#f7b731"></div>Master Registry (Field History)</div><div class="sec-bd">'+
- '<table class="dtbl"><thead><tr><th>#</th><th>Name</th><th>Type</th><th>Size</th><th>Status</th></tr></thead><tbody>';
- if(t.masterFields)t.masterFields.forEach((f,i)=>{
- let st=f.dropped?'<span class="badge dropped">DROPPED</span>':'<span class="badge active">ACTIVE</span>';
- let nmStyle=f.dropped?'color:#e74c3c;text-decoration:line-through':'color:#5b9bd5;font-weight:600';
- h+='<tr><td class="mono">'+i+'</td><td style="'+nmStyle+'">'+esc(f.name)+'</td>'+
- '<td><span class="badge primary">'+f.typeName+'</span></td><td>'+f.sz+' bytes</td><td>'+st+'</td></tr>';
- });
- h+='</tbody></table></div></div>';
- // Schema Versions
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#a78bfa"></div>Schema Versions</div><div class="sec-bd" style="padding:12px">';
- if(t.versions)t.versions.forEach(v=>{
- let isAct=(v.ver===t.activeVer);
- h+='<div class="ver-card" style="'+(isAct?'border-color:#4ecdc4':'')+'">';
- h+='<div class="ver-hd"><span class="ver-num">Version '+v.ver+'</span>';
- if(isAct)h+='<span class="badge active">CURRENT</span>';
- h+='</div><div class="ver-fields">';
- if(v.fields)v.fields.forEach((fn,fi)=>{
- let isDrop=fn.includes('(dropped)');
- h+='<span class="ver-field '+(isDrop?'dropped':'active')+'">'+esc(fn)+'</span>';
- });
- h+='</div></div>';
- });
- h+='</div></div>';
- // Indexes
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#5b9bd5"></div>Indexes</div><div class="sec-bd"><div class="idx-list">';
- if(!t.idxs||!t.idxs.length)h+='<div class="empty"><div class="msg">No indexes</div></div>';
- else t.idxs.forEach(idx=>{
- let flds=(idx.flds||[]).map(fi=>t.masterFields&&t.masterFields[fi]?t.masterFields[fi].name:'?').join(', ');
- let ic=ICOLOR[idx.type]||'primary';
- h+='<div class="idx-card" onclick="showIndex(\''+esc(idx.name)+'\','+idx.ep+','+idx.type+')">'+
- '<div class="idx-ico" style="background:rgba(91,155,213,.15)">'+(idx.type===2?'🔑':idx.type===1?'⏰':idx.type===3?'🔤':idx.type===5?'🌳':'🔗')+'</div>'+
- '<div class="idx-info"><div class="idx-name">'+esc(idx.name)+'</div>'+
- '<div class="idx-meta"><span class="badge '+ic+'">'+idx.ts+'</span><span>Fields: '+esc(flds)+'</span><span>Root: '+idx.ep+'</span></div></div>'+
- '<div class="idx-arrow">›</div></div>';
- });
- h+='</div></div></div>';
- // Storage
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#4ecdc4"></div>Storage</div><div class="sec-bd">'+
- '<div class="idx-card" onclick="showHeapPages(\''+esc(nm)+'\')"><div class="idx-ico" style="background:rgba(78,205,196,.15)">📦</div>'+
- '<div class="idx-info"><div class="idx-name">Heap Pages (Field Overflow)</div><div class="idx-meta">First: '+t.hp0+'</div></div>'+
- '<div class="idx-arrow">›</div></div></div></div>';
- $('content').innerHTML=h;
- }
- function showIndex(nm,ep,it){
- S.idxType=it;S.bc=[{l:S.cur.name,a:()=>showTable(S.cur.name)},{l:nm,a:null}];
- let h='<div class="bc">';S.bc.forEach((b,i)=>{if(i>0)h+='<span class="sep">›</span>';
- if(b.a&&i<S.bc.length-1)h+='<span class="item" onclick="navBC('+i+')">'+esc(b.l)+'</span>';
- else h+='<span class="cur">'+esc(b.l)+'</span>'});
- h+='</div><div class="sec"><div class="sec-hd"><div class="dot" style="background:#'+(it===2?'5b9bd5':it===1?'4ecdc4':it===3?'f7b731':'a78bfa')+'"></div>'+
- (it===3||it===4?'Index':'B+ Tree')+' - '+esc(nm)+'</div><div id="idxContent" style="padding:16px;color:#5b9bd5">Loading...</div></div>';
- $('content').innerHTML=h;loadIdxPage(ep,it);
- }
- function loadIdxPage(pid,it){
- fetch('/api/btree?id='+pid+'&t='+it).then(r=>r.json()).then(d=>{
- if(d.e){$('idxContent').innerHTML='<div class="empty"><div class="msg">Error: '+d.e+'</div></div>';return}
- let isBtree=(it===1||it===2);
- let isSBtree=(it===5);
- let h='<div class="node-bar"><div class="ni"><span class="ni-lb">Page</span><span class="ni-val">'+d.id+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Type</span><span class="badge '+(d.lf?'leaf':'internal')+'">'+(d.lf?'Leaf':'Internal')+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Entries</span><span class="ni-val">'+d.cn+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Usage</span><span class="ni-val">'+d.us.toFixed(1)+'%</span>'+
- '<div class="ubar"><div class="fill" style="width:'+Math.min(d.us,100)+'%"></div></div></div></div>';
- if(!d.lf)h+='<div style="padding:8px 16px;font-size:11px;color:#556;background:#0a0a16;border-bottom:1px solid #1a1a2e">B+ Tree Internal Node</div>';
- if(d.lf&&isSBtree)h+='<div style="padding:8px 16px;font-size:11px;color:#f7b731;background:#0a0a16;border-bottom:1px solid #1a1a2e">Secondary B+ Tree Leaf (values are PKIDs, not DataPage IDs)</div>';
- h+='<table class="dtbl"><thead><tr><th style="width:40px">#</th><th>Key</th>';
- if(isBtree){
- h+='<th style="width:120px">'+(d.lf?'Data Page':'Child Page')+'</th>';
- }else if(isSBtree){
- h+='<th style="width:120px">'+(d.lf?'PKID':'Child Page')+'</th>';
- }else{
- h+='<th style="width:120px">PKID</th>';
- }
- h+='</tr></thead><tbody>';
- (d.ents||[]).forEach((e,i)=>{
- h+='<tr><td class="mono" style="color:#556">'+i+'</td><td class="mono" style="color:#c8ccd4">'+esc(e.k)+'</td>';
- if(isBtree){
- if(d.lf)h+='<td><span class="badge data clickable" onclick="showDP('+e.p+')">'+e.p+'</span></td>';
- else h+='<td><span class="badge primary clickable" onclick="loadIdxPage('+e.p+','+it+')">'+e.p+'</span></td>';
- }else if(isSBtree){
- if(d.lf)h+='<td class="mono" style="color:#5b9bd5;cursor:pointer" onclick="showPK('+e.dp+')" title="点击查看 DataPage">'+e.dp+'</td>';
- else h+='<td><span class="badge primary clickable" onclick="loadIdxPage('+e.p+','+it+')">'+e.p+'</span></td>';
- }else h+='<td class="mono" style="color:#667">'+e.dp+'</td>';
- h+='</tr>';
- });
- h+='</tbody></table>';
- let nav='';
- if(d.nx)nav+='<button class="nav-btn" onclick="loadIdxPage('+d.nx+','+it+')">Next → #'+d.nx+'</button>';
- if(d.pv)nav+='<button class="nav-btn" onclick="loadIdxPage('+d.pv+','+it+')">← Prev #'+d.pv+'</button>';
- if(nav)h+='<div class="nav-btns">'+nav+'</div>';
- $('idxContent').innerHTML=h;
- });
- }
- function showDP(pid){
- S.bc.push({l:'Data #'+pid,a:null});
- let h='<div class="bc">';S.bc.forEach((b,i)=>{if(i>0)h+='<span class="sep">›</span>';
- if(b.a&&i<S.bc.length-1)h+='<span class="item" onclick="navBC('+i+')">'+esc(b.l)+'</span>';
- else h+='<span class="cur">'+esc(b.l)+'</span>'});
- h+='</div><div class="sec"><div class="sec-hd"><div class="dot" style="background:#4ecdc4"></div>Data Page #'+pid+'</div>'+
- '<div id="dpContent" style="padding:16px;color:#5b9bd5">Loading...</div></div>';
- $('content').innerHTML=h;
- fetch('/api/data-page?id='+pid).then(r=>r.json()).then(d=>{
- if(d.e){$('dpContent').innerHTML='<div class="empty"><div class="msg">Error</div></div>';return}
- let info='<div class="node-bar"><div class="ni"><span class="ni-lb">Page</span><span class="ni-val">'+d.id+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Rows</span><span class="ni-val">'+d.cn+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Min</span><span class="ni-val" style="color:#4ecdc4">'+d.mn+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Max</span><span class="ni-val" style="color:#f7b731">'+d.mx+'</span></div>'+
- '<div class="ni"><span class="ni-lb">Usage</span><span class="ni-val">'+d.us.toFixed(1)+'%</span>'+
- '<div class="ubar"><div class="fill" style="width:'+Math.min(d.us,100)+'%"></div></div></div></div>';
- let rows='<table class="dtbl"><thead><tr><th style="width:30px">#</th><th style="width:60px">PK</th><th style="width:50px">Ver</th><th>Decoded Fields</th><th>Raw Hex</th></tr></thead><tbody>';
- (d.rs||[]).forEach(r=>{
- rows+='<tr><td class="mono" style="color:#556">'+r.i+'</td>'+
- '<td class="mono" style="color:#f7b731;font-size:12px">'+r.pk+'</td>'+
- '<td><span class="badge active">v'+r.sv+'</span></td>'+
- '<td class="row-decoded">'+esc(r.decoded)+'</td>'+
- '<td class="hex-data">'+esc(r.h)+'</td></tr>';
- });
- rows+='</tbody></table>';
- let nav='';
- if(d.pv)nav+='<button class="nav-btn" onclick="showDP('+d.pv+')">← Prev #'+d.pv+'</button>';
- if(d.nx)nav+='<button class="nav-btn" onclick="showDP('+d.nx+')">Next → #'+d.nx+'</button>';
- $('dpContent').innerHTML=info+rows+(nav?'<div class="nav-btns">'+nav+'</div>':'');
- });
- }
- function showPK(pkid){
- // 找到当前表的主键索引根页
- let pkRoot=0;
- if(S.cur&&S.cur.idxs){
- S.cur.idxs.forEach(idx=>{if(idx.type===2)pkRoot=idx.ep});
- }
- if(!pkRoot){alert('No primary index found');return}
- S.bc.push({l:'PK #'+pkid+' \u2192 DataPage',a:null});
- let h='<div class="bc">';S.bc.forEach((b,i)=>{if(i>0)h+='<span class="sep">›</span>';
- if(b.a&&i<S.bc.length-1)h+='<span class="item" onclick="navBC('+i+')">'+esc(b.l)+'</span>';
- else h+='<span class="cur">'+esc(b.l)+'</span>'});
- h+='</div><div class="sec"><div class="sec-hd"><div class="dot" style="background:#5b9bd5"></div>Locating PK #'+pkid+'...</div>';
- h+='<div id="dpContent" style="padding:16px;color:#5b9bd5">Searching primary B+ tree...</div></div>';
- $('content').innerHTML=h;
- fetch('/api/find-pk?pk='+pkid+'&root='+pkRoot).then(r=>r.json()).then(d=>{
- if(d.e){$('dpContent').innerHTML='<div class="empty"><div class="msg">'+d.e+'</div></div>';return}
- showDP(d.dp);
- });
- }
- function showHeader(){
- document.querySelectorAll('.tbl-item').forEach(e=>e.classList.remove('active'));
- S.bc=[{l:'HeaderPage',a:null}];
- let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">›</span><span class="cur">HeaderPage</span></div>';
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#4ecdc4"></div>Database Header</div>';
- h+='<div id="hdrContent" style="padding:16px;color:#5b9bd5">Loading...</div></div>';
- $('content').innerHTML=h;
- fetch('/api/header').then(r=>r.json()).then(d=>{
- if(d.e){$('hdrContent').innerHTML='<div class="empty"><div class="msg">Error</div></div>';return}
- let rows=[['Magic',d.magic],['Version','v'+d.ver],['Page Size',d.pgsz+' bytes ('+(d.pgsz/1024)+' KB)'],
- ['Next Free Page',d.nf],['Table Page (root)',d.tp],['Table Count',d.tc],
- ['Create Time',d.ct],['Modify Time',d.mt],['Free Chain Start',d.fs],['Free Count',d.fc],
- ['Global Flags',d.gf],['Comment',d.cm||'(empty)']];
- let t='<table class="dtbl"><thead><tr><th style="width:200px">Field</th><th>Value</th></tr></thead><tbody>';
- rows.forEach(r=>{t+='<tr><td style="color:#5b9bd5;font-weight:600">'+r[0]+'</td><td class="mono" style="color:#c8ccd4">'+r[1]+'</td></tr>'});
- t+='</tbody></table>';$('hdrContent').innerHTML=t;
- });
- }
- function showHeapPages(nm){
- const t=S.tables.find(x=>x.name===nm);if(!t)return;S.cur=t;
- S.bc=[{l:nm,a:()=>showTable(nm)},{l:'Heap Pages',a:null}];
- let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">›</span>'+
- '<span class="item" onclick="showTable(\''+esc(nm)+'\')">'+esc(nm)+'</span><span class="sep">›</span><span class="cur">Heap Pages</span></div>';
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#f7b731"></div>Heap Chain - '+esc(nm)+' <span id="heapInfo" style="font-weight:400;font-size:11px;color:#556;margin-left:8px">Loading...</span></div>';
- h+='<div id="heapContent" style="padding:12px">Loading...</div></div>';
- $('content').innerHTML=h;
- Promise.all([fetch('/api/heap-chain?id='+t.hp0).then(r=>r.json()),fetch('/api/pages').then(r=>r.json())]).then(([hd,pd])=>{
- if(!hd.pages||!hd.pages.length){$('heapContent').innerHTML='<div class="empty"><div class="ico">📦</div><div class="msg">No heap pages</div></div>';return}
- let heapSet=new Set(hd.pages.map(p=>p.id));
- $('heapInfo').textContent=hd.total+' heap pages \u00d7 16 KB';
- let h2='<div style="display:flex;flex-wrap:wrap;gap:2px">';
- (pd.pages||[]).forEach(p=>{
- let isHeap=heapSet.has(p.id);
- let c=isHeap?'#4ecdc4':'#1a1a2e';
- let br=isHeap?1:.2;
- h2+='<div style="width:14px;height:14px;border-radius:2px;background:'+c+';opacity:'+br+';cursor:default" title="Page #'+p.id+'\nType: '+p.ts+'\nUsage: '+p.us.toFixed(1)+'%\nSize: 16 KB'+(isHeap?'\n\u2605 Heap Page':'')+'"></div>';
- });
- h2+='</div>';
- h2+='<table class="dtbl" style="margin-top:12px"><thead><tr><th>Page ID</th><th>Next</th><th>Prev</th><th>Used</th><th>Usage</th></tr></thead><tbody>';
- hd.pages.forEach(p=>{
- let us=(p.use/16384*100).toFixed(1);
- h2+='<tr><td class="mono" style="color:#4ecdc4;font-weight:600">'+p.id+'</td><td class="mono">'+p.nx+'</td><td class="mono">'+p.pv+'</td><td class="mono">'+fB(p.use)+'</td><td>'+us+'%<div class="ubar"><div class="fill" style="width:'+Math.min(us,100)+'%"></div></div></td></tr>';
- });
- h2+='</tbody></table>';
- $('heapContent').innerHTML=h2;
- }).catch(e=>{$('heapContent').innerHTML='<div style="color:#e74c3c">Error: '+e.message+'</div>'});
- }
- function showFreePages(){
- document.querySelectorAll('.tbl-item').forEach(e=>e.classList.remove('active'));
- S.bc=[{l:'Free Pages',a:null}];
- let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">›</span><span class="cur">Free Pages</span></div>';
- h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#a78bfa"></div>Recycled Pages <span id="freeInfo" style="font-weight:400;font-size:11px;color:#556;margin-left:8px">Loading...</span></div>';
- h+='<div id="freeContent" style="padding:12px;color:#5b9bd5">Loading...</div></div>';
- $('content').innerHTML=h;
- Promise.all([fetch('/api/free-pages').then(r=>r.json()),fetch('/api/pages').then(r=>r.json())]).then(([fd,pd])=>{
- if(!fd.pages||!fd.pages.length){$('freeContent').innerHTML='<div class="empty"><div class="ico">♻</div><div class="msg">No recycled pages</div></div>';return}
- let freeSet=new Set(fd.pages);
- $('freeInfo').textContent=fd.total+' free pages \u00d7 16 KB = '+fB(fd.total*16384);
- let h2='<div style="display:flex;flex-wrap:wrap;gap:2px">';
- (pd.pages||[]).forEach(p=>{
- let isFree=freeSet.has(p.id);
- let c=isFree?'#a78bfa':'#1a1a2e';
- let br=isFree?1:.2;
- h2+='<div style="width:14px;height:14px;border-radius:2px;background:'+c+';opacity:'+br+';cursor:default" title="Page #'+p.id+'\nType: '+p.ts+'\nUsage: '+p.us.toFixed(1)+'%\nSize: 16 KB'+(isFree?'\n\u267B Free Page':'')+'"></div>';
- });
- h2+='</div>';
- h2+='<table class="dtbl" style="margin-top:12px"><thead><tr><th>#</th><th>Page ID</th><th>Next Free</th></tr></thead><tbody>';
- fd.pages.forEach((p,i)=>{
- h2+='<tr><td class="mono" style="color:#556">'+i+'</td><td class="mono" style="color:#a78bfa;font-weight:600">'+p+'</td><td class="mono">'+(i<fd.pages.length-1?fd.pages[i+1]:'0 (end)')+'</td></tr>';
- });
- h2+='</tbody></table>';
- $('freeContent').innerHTML=h2;
- }).catch(e=>{$('freeContent').innerHTML='<div style="color:#e74c3c">Error: '+e.message+'</div>'});
- }
- function navBC(i){S.bc=S.bc.slice(0,i+1);S.bc[i].a()}
- function fName(t){const m={1:'int8',2:'int16',3:'int32',4:'int64',5:'16byte',6:'32byte',7:'64byte',8:'128byte',9:'256byte'};return m[t]||'?'}
- renderFB();
- </script>
- </body>
- </html>`
|