page.go 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452
  1. package main
  2. var pg = `<!DOCTYPE html>
  3. <html lang="zh-CN">
  4. <head>
  5. <meta charset="UTF-8">
  6. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7. <title>TsDB2 Analyzer v3</title>
  8. <style>
  9. *{box-sizing:border-box;margin:0;padding:0}
  10. body{font-family:'Segoe UI',system-ui,-apple-system,sans-serif;background:#0b0b14;color:#c8ccd4;min-height:100vh;overflow-x:hidden}
  11. ::-webkit-scrollbar{width:6px;height:6px}::-webkit-scrollbar-track{background:#12121f}::-webkit-scrollbar-thumb{background:#2a2a4a;border-radius:3px}
  12. a{color:#5b9bd5;text-decoration:none}
  13. .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}
  14. .hdr .logo{display:flex;align-items:center;gap:10px;font-size:16px;font-weight:700;color:#5b9bd5}
  15. .hdr .meta{display:flex;align-items:center;gap:16px;font-size:12px;color:#666}
  16. .hdr .meta .db-name{color:#8890a0;max-width:300px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}
  17. .hdr .btn{padding:5px 14px;background:#1a1a30;border:1px solid #2a2a4a;color:#8890a0;border-radius:4px;cursor:pointer;font-size:12px;transition:all .2s}
  18. .hdr .btn:hover{background:#222240;color:#aab;border-color:#3a3a5a}
  19. .main{display:flex;height:calc(100vh - 52px)}
  20. .sidebar{width:240px;min-width:240px;background:#0e0e1a;border-right:1px solid #1a1a2e;overflow-y:auto;display:flex;flex-direction:column}
  21. .sidebar .sec-title{padding:12px 16px 6px;font-size:10px;text-transform:uppercase;letter-spacing:1.5px;color:#444;font-weight:600}
  22. .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}
  23. .sidebar .tbl-item:hover{background:#141428;color:#aab}
  24. .sidebar .tbl-item.active{background:#141428;color:#5b9bd5;border-left-color:#5b9bd5}
  25. .sidebar .tbl-item .ico{font-size:14px;opacity:.6}
  26. .sidebar .tbl-item .cnt{margin-left:auto;font-size:10px;color:#445;background:#1a1a2e;padding:1px 6px;border-radius:8px}
  27. .content{flex:1;overflow-y:auto;padding:20px 28px}
  28. .bc{display:flex;align-items:center;gap:6px;padding:0 0 16px;font-size:12px;color:#556}
  29. .bc .item{cursor:pointer;color:#5b9bd5;transition:color .15s}.bc .item:hover{color:#7bb}
  30. .bc .sep{color:#334}.bc .cur{color:#8890a0}
  31. .stats{display:grid;grid-template-columns:repeat(auto-fit,minmax(160px,1fr));gap:14px;margin-bottom:20px}
  32. .card{background:#111122;border:1px solid #1a1a2e;border-radius:8px;padding:16px 18px;position:relative;overflow:hidden}
  33. .card::before{content:'';position:absolute;top:0;left:0;right:0;height:2px}
  34. .card.c1::before{background:linear-gradient(90deg,#5b9bd5,#4a8bc4)}.card.c2::before{background:linear-gradient(90deg,#4ecdc4,#3dbdb5)}
  35. .card.c3::before{background:linear-gradient(90deg,#f7b731,#e6a620)}.card.c4::before{background:linear-gradient(90deg,#a78bfa,#8b5cf6)}
  36. .card.c5::before{background:linear-gradient(90deg,#e74c3c,#c0392b)}
  37. .card .lb{font-size:10px;text-transform:uppercase;letter-spacing:1px;color:#556;margin-bottom:6px}
  38. .card .val{font-size:28px;font-weight:700;color:#e0e4ec}.card .sub{font-size:11px;color:#556;margin-top:4px}
  39. .sec{background:#0f0f1e;border:1px solid #1a1a2e;border-radius:8px;margin-bottom:16px;overflow:hidden}
  40. .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}
  41. .sec-hd .dot{width:8px;height:8px;border-radius:50%;background:#5b9bd5}
  42. .sec-bd{padding:0}
  43. .dtbl{width:100%;border-collapse:collapse;font-size:12px}
  44. .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}
  45. .dtbl td{padding:7px 12px;border-bottom:1px solid #141428;color:#8890a0;vertical-align:middle}
  46. .dtbl tr:hover td{background:#111125}
  47. .dtbl .mono{font-family:'Cascadia Code','Fira Code',Consolas,monospace;font-size:11px}
  48. .dtbl .clickable{cursor:pointer;color:#5b9bd5;transition:color .15s}.dtbl .clickable:hover{color:#7bb;text-decoration:underline}
  49. .badge{display:inline-block;padding:2px 8px;border-radius:3px;font-size:10px;font-weight:600;letter-spacing:.5px}
  50. .badge.primary{background:rgba(91,155,213,.15);color:#5b9bd5}.badge.time{background:rgba(78,205,196,.15);color:#4ecdc4}
  51. .badge.string{background:rgba(247,183,49,.15);color:#f7b731}.badge.compose{background:rgba(167,139,250,.15);color:#a78bfa}
  52. .badge.btree{background:rgba(116,185,255,.15);color:#74b9ff}.badge.leaf{background:rgba(78,205,196,.15);color:#4ecdc4}
  53. .badge.internal{background:rgba(247,183,49,.15);color:#f7b731}.badge.data{background:rgba(91,155,213,.12);color:#5b9bd5}
  54. .badge.dropped{background:rgba(231,76,60,.15);color:#e74c3c}.badge.active{background:rgba(78,205,196,.15);color:#4ecdc4}
  55. .idx-list{padding:12px}
  56. .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}
  57. .idx-card:hover{border-color:#2a2a4a;background:#141428}
  58. .idx-card .idx-ico{width:32px;height:32px;border-radius:6px;display:flex;align-items:center;justify-content:center;font-size:16px;background:#1a1a30}
  59. .idx-card .idx-info{flex:1}.idx-card .idx-name{font-size:13px;font-weight:600;color:#c8ccd4}
  60. .idx-card .idx-meta{font-size:11px;color:#556;margin-top:3px;display:flex;gap:12px}
  61. .idx-card .idx-arrow{color:#334;font-size:14px}
  62. .node-bar{display:flex;flex-wrap:wrap;gap:16px;padding:12px 16px;background:#0d0d1a;border-bottom:1px solid #1a1a2e;font-size:12px}
  63. .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}
  64. .nav-btns{display:flex;gap:8px;padding:12px 16px;justify-content:center}
  65. .nav-btn{padding:6px 16px;background:#1a1a30;border:1px solid #2a2a4a;color:#8890a0;border-radius:4px;cursor:pointer;font-size:12px;transition:all .2s}
  66. .nav-btn:hover{background:#222240;color:#aab;border-color:#3a3a5a}
  67. .empty{text-align:center;padding:40px 20px;color:#445}.empty .ico{font-size:36px;margin-bottom:10px;opacity:.4}.empty .msg{font-size:13px}
  68. .fb-overlay{position:fixed;inset:0;background:#0b0b14;z-index:200;display:flex;align-items:center;justify-content:center}
  69. .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}
  70. .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}
  71. .fb-path{padding:8px 16px;background:#0d0d1a;font-size:11px;color:#556;border-bottom:1px solid #1a1a2e;font-family:monospace;word-break:break-all}
  72. .fb-list{flex:1;overflow-y:auto;max-height:400px}
  73. .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}
  74. .fb-item:hover{background:#141428}.fb-item.sel{background:#141428;border-left:3px solid #5b9bd5}
  75. .fb-item .fi-ico{width:20px;text-align:center;font-size:14px}.fb-item .fi-sz{margin-left:auto;font-size:10px;color:#445}
  76. .fb-ft{padding:12px 16px;border-top:1px solid #1a1a2e;display:flex;gap:8px}
  77. .fb-ft button{flex:1;padding:8px;border:none;border-radius:5px;cursor:pointer;font-size:12px;font-weight:600;transition:all .2s}
  78. .fb-ft .b-up{background:#1a1a30;color:#8890a0}.fb-ft .b-up:hover{background:#222240}
  79. .fb-ft .b-open{background:#5b9bd5;color:#fff}.fb-ft .b-open:hover{background:#4a8bc4}
  80. .fb-ft .b-open:disabled{background:#1a1a30;color:#445;cursor:not-allowed}
  81. .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}
  82. .ubar{width:60px;height:4px;background:#1a1a2e;border-radius:2px;overflow:hidden;display:inline-block;vertical-align:middle;margin-left:6px}
  83. .ubar .fill{height:100%;border-radius:2px;background:#4ecdc4}
  84. .ver-card{background:#0d0d18;border:1px solid #1a1a2e;border-radius:6px;padding:10px 14px;margin-bottom:8px}
  85. .ver-card .ver-hd{display:flex;align-items:center;gap:8px;margin-bottom:6px}
  86. .ver-card .ver-num{font-size:14px;font-weight:700;color:#5b9bd5}
  87. .ver-card .ver-fields{display:flex;flex-wrap:wrap;gap:4px}
  88. .ver-card .ver-field{padding:2px 8px;border-radius:3px;font-size:11px;font-family:monospace}
  89. .ver-card .ver-field.active{background:rgba(78,205,196,.1);color:#4ecdc4;border:1px solid rgba(78,205,196,.2)}
  90. .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}
  91. .row-decoded{font-family:'Cascadia Code','Fira Code',Consolas,monospace;font-size:11px;color:#4ecdc4;line-height:1.6;max-width:600px}
  92. .row-decoded .fld-name{color:#5b9bd5}.row-decoded .fld-val{color:#c8ccd4}
  93. @media(max-width:900px){.sidebar{width:200px;min-width:200px}}
  94. </style>
  95. </head>
  96. <body>
  97. <div id="app"></div>
  98. <script>
  99. const $=id=>document.getElementById(id);
  100. const esc=s=>s?s.replace(/</g,'&lt;').replace(/>/g,'&gt;'):'';
  101. 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'}
  102. const ITYPE={1:'Time',2:'Primary',3:'String',4:'Compose',5:'BTree'};
  103. const ICOLOR={1:'time',2:'primary',3:'string',4:'compose',5:'btree'};
  104. let S={view:'fb',db:'',tables:[],cur:null,bc:[],idxType:0};
  105. let FB={path:'',sel:''};
  106. function renderFB(){
  107. document.getElementById('app').innerHTML=
  108. '<div class="fb-overlay"><div class="fb-box"><div class="fb-hd"><span style="font-size:20px">&#x1F4CA;</span> TsDB2 Analyzer v3</div>'+
  109. '<div class="fb-path" id="fbp">Loading...</div><div class="fb-list" id="fbl"></div>'+
  110. '<div class="fb-ft"><button class="b-up" onclick="fbUp()">&#x2190; Up</button>'+
  111. '<button class="b-open" id="fbOpen" onclick="fbOpen()" disabled>Open Database</button></div></div></div>';
  112. fbLoad('');
  113. }
  114. function fbLoad(p){
  115. fetch(p?'/api/list-dir?path='+encodeURIComponent(p):'/api/list-dir').then(r=>r.json()).then(d=>{
  116. if(d.err){alert(d.err);return}
  117. FB.path=d.p;FB.sel='';$('fbOpen').disabled=true;$('fbp').textContent=d.p;
  118. let h='';
  119. if(d.d)d.d.forEach(x=>{h+='<div class="fb-item" ondblclick="fbLoad(\''+esc(d.p+'/'+x.n).replace(/\\/g,'/')+'\')">'+
  120. '<span class="fi-ico">&#x1F4C1;</span>'+esc(x.n)+'</div>'});
  121. if(d.f)d.f.forEach(x=>{const fp=d.p+'/'+x.n;
  122. h+='<div class="fb-item" onclick="fbSel(this,\''+esc(fp).replace(/\\/g,'/')+'\')">'+
  123. '<span class="fi-ico">&#x1F4C4;</span>'+esc(x.n)+'<span class="fi-sz">'+fB(x.s)+'</span></div>'});
  124. $('fbl').innerHTML=h||'<div class="empty"><div class="ico">&#x1F4ED;</div><div class="msg">Empty</div></div>';
  125. });
  126. }
  127. function fbSel(el,p){document.querySelectorAll('.fb-item').forEach(e=>e.classList.remove('sel'));el.classList.add('sel');FB.sel=p;$('fbOpen').disabled=false}
  128. function fbUp(){fetch('/api/list-dir?path='+encodeURIComponent(FB.path)).then(r=>r.json()).then(d=>{if(d.pp)fbLoad(d.pp)})}
  129. function fbOpen(){
  130. if(!FB.sel)return;
  131. fetch('/api/open-db',{method:'POST',headers:{'Content-Type':'application/json'},body:JSON.stringify({p:FB.sel})})
  132. .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)});
  133. }
  134. function loadDash(s){
  135. 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>'+
  136. '<div class="meta"><span class="db-name">'+esc(s.f)+'</span><span>'+s.fs+'</span><span>'+s.pg+' pages</span>'+
  137. '<button class="btn" onclick="S.view=\'fb\';renderFB()">Change DB</button></div></div>';
  138. h+='<div class="main"><div class="sidebar" id="sidebar"><div class="sec-title">Explorer</div>'+
  139. '<div class="tbl-item" onclick="showOverview()" style="color:#5b9bd5"><span class="ico">&#x1F4CA;</span>Overview</div>'+
  140. '<div class="tbl-item" onclick="showHeader()"><span class="ico">&#x1F4D1;</span>HeaderPage</div>'+
  141. '<div class="tbl-item" onclick="showFreePages()"><span class="ico">&#x267B;</span>Free Pages</div>'+
  142. '<div class="sec-title">Tables</div><div id="sideTabs"></div></div>';
  143. h+='<div class="content" id="content"></div></div>';
  144. document.getElementById('app').innerHTML=h;loadTables();showOverview(s);
  145. }
  146. function loadTables(){
  147. fetch('/api/tables').then(r=>r.json()).then(ts=>{
  148. S.tables=ts||[];let h='';
  149. S.tables.forEach(t=>{
  150. let mc=t.masterFields?t.masterFields.filter(f=>!f.dropped).length:0;
  151. h+='<div class="tbl-item" onclick="showTable(\''+esc(t.name)+'\')"><span class="ico">&#x1F4CB;</span>'+esc(t.name)+
  152. '<span class="cnt">v'+(t.activeVer||1)+'</span></div>';
  153. });
  154. if($('sideTabs'))$('sideTabs').innerHTML=h;
  155. });
  156. }
  157. function showOverview(s){
  158. if(!s){fetch('/api/stats').then(r=>r.json()).then(d=>showOverview(d));return}
  159. document.querySelectorAll('.tbl-item').forEach(e=>e.classList.remove('active'));
  160. let h='<div class="bc"><span class="cur">Overview</span></div>';
  161. h+='<div class="stats">'+
  162. '<div class="card c1"><div class="lb">Database Size</div><div class="val">'+s.fs+'</div><div class="sub">'+s.pg+' pages</div></div>'+
  163. '<div class="card c2"><div class="lb">Tables</div><div class="val">'+s.tc+'</div></div>'+
  164. '<div class="card c3"><div class="lb">Page Size</div><div class="val">16 KB</div></div>'+
  165. '<div class="card c4"><div class="lb">Engine</div><div class="val">v3</div><div class="sub">Schema Aware</div></div></div>';
  166. h+='<div class="sec"><div class="sec-hd"><div class="dot"></div>All Tables</div><div class="sec-bd">';
  167. if(!S.tables||!S.tables.length)h+='<div class="empty"><div class="msg">No tables</div></div>';
  168. else{
  169. 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>';
  170. S.tables.forEach(t=>{
  171. let mc=t.masterFields?t.masterFields.filter(f=>!f.dropped).length:0;
  172. let dc=t.masterFields?t.masterFields.filter(f=>f.dropped).length:0;
  173. h+='<tr style="cursor:pointer" onclick="showTable(\''+esc(t.name)+'\')">'+
  174. '<td style="color:#5b9bd5;font-weight:600">'+esc(t.name)+'</td><td>'+t.rowN+'</td>'+
  175. '<td><span class="badge active">v'+t.activeVer+'</span></td>'+
  176. '<td>'+mc+(dc>0?' <span class="badge dropped">'+dc+' dropped</span>':'')+'</td>'+
  177. '<td>'+(t.versions?t.versions.length:0)+'</td>'+
  178. '<td>'+(t.idxs?t.idxs.length:0)+'</td><td>'+t.fsz+' B</td></tr>';
  179. });
  180. h+='</tbody></table>';
  181. }
  182. h+='</div></div>';
  183. // Page visualization
  184. 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>';
  185. $('content').innerHTML=h;
  186. // Load page map
  187. fetch('/api/pages').then(r=>r.json()).then(d=>{
  188. if(!d.pages||!d.pages.length){$('pgMapInfo').textContent='No pages';return}
  189. const TC={0:'#1a1a2e',1:'#f7b731',2:'#5b9bd5',3:'#4ecdc4',4:'#a78bfa',5:'#74b9ff'};
  190. const TN={0:'Free',1:'Table',2:'Data',3:'Heap',4:'IdxMeta',5:'IdxData'};
  191. let g='';
  192. d.pages.forEach(p=>{
  193. let c=TC[p.t]||'#333';
  194. let br=p.us>50?1:p.us>20?.6:.3;
  195. 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>';
  196. });
  197. $('pgMap').innerHTML=g;
  198. let lg='';
  199. 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>';
  200. $('pgLegend').innerHTML=lg;
  201. $('pgMapInfo').textContent=d.total+' pages \u00d7 16 KB';
  202. });
  203. }
  204. function showTable(nm){
  205. const t=S.tables.find(x=>x.name===nm);if(!t)return;
  206. S.cur=t;S.idxType=0;S.bc=[{l:nm,a:null}];
  207. document.querySelectorAll('.tbl-item').forEach(e=>{e.classList.remove('active');if(e.textContent.includes(nm))e.classList.add('active')});
  208. let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">&#x203A;</span><span class="cur">'+esc(nm)+'</span></div>';
  209. let mc=t.masterFields?t.masterFields.filter(f=>!f.dropped).length:0;
  210. let dc=t.masterFields?t.masterFields.filter(f=>f.dropped).length:0;
  211. h+='<div class="stats">'+
  212. '<div class="card c1"><div class="lb">Total Rows</div><div class="val">'+t.rowN+'</div></div>'+
  213. '<div class="card c2"><div class="lb">Active Version</div><div class="val">v'+t.activeVer+'</div></div>'+
  214. '<div class="card c3"><div class="lb">Active Fields</div><div class="val">'+mc+'</div>'+(dc>0?'<div class="sub">'+dc+' dropped</div>':'')+'</div>'+
  215. '<div class="card c4"><div class="lb">Schema Versions</div><div class="val">'+(t.versions?t.versions.length:0)+'</div></div>'+
  216. '<div class="card c5"><div class="lb">Indexes</div><div class="val">'+(t.idxs?t.idxs.length:0)+'</div></div></div>';
  217. // Master Registry
  218. h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#f7b731"></div>Master Registry (Field History)</div><div class="sec-bd">'+
  219. '<table class="dtbl"><thead><tr><th>#</th><th>Name</th><th>Type</th><th>Size</th><th>Status</th></tr></thead><tbody>';
  220. if(t.masterFields)t.masterFields.forEach((f,i)=>{
  221. let st=f.dropped?'<span class="badge dropped">DROPPED</span>':'<span class="badge active">ACTIVE</span>';
  222. let nmStyle=f.dropped?'color:#e74c3c;text-decoration:line-through':'color:#5b9bd5;font-weight:600';
  223. h+='<tr><td class="mono">'+i+'</td><td style="'+nmStyle+'">'+esc(f.name)+'</td>'+
  224. '<td><span class="badge primary">'+f.typeName+'</span></td><td>'+f.sz+' bytes</td><td>'+st+'</td></tr>';
  225. });
  226. h+='</tbody></table></div></div>';
  227. // Schema Versions
  228. 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">';
  229. if(t.versions)t.versions.forEach(v=>{
  230. let isAct=(v.ver===t.activeVer);
  231. h+='<div class="ver-card" style="'+(isAct?'border-color:#4ecdc4':'')+'">';
  232. h+='<div class="ver-hd"><span class="ver-num">Version '+v.ver+'</span>';
  233. if(isAct)h+='<span class="badge active">CURRENT</span>';
  234. h+='</div><div class="ver-fields">';
  235. if(v.fields)v.fields.forEach((fn,fi)=>{
  236. let isDrop=fn.includes('(dropped)');
  237. h+='<span class="ver-field '+(isDrop?'dropped':'active')+'">'+esc(fn)+'</span>';
  238. });
  239. h+='</div></div>';
  240. });
  241. h+='</div></div>';
  242. // Indexes
  243. 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">';
  244. if(!t.idxs||!t.idxs.length)h+='<div class="empty"><div class="msg">No indexes</div></div>';
  245. else t.idxs.forEach(idx=>{
  246. let flds=(idx.flds||[]).map(fi=>t.masterFields&&t.masterFields[fi]?t.masterFields[fi].name:'?').join(', ');
  247. let ic=ICOLOR[idx.type]||'primary';
  248. h+='<div class="idx-card" onclick="showIndex(\''+esc(idx.name)+'\','+idx.ep+','+idx.type+')">'+
  249. '<div class="idx-ico" style="background:rgba(91,155,213,.15)">'+(idx.type===2?'&#x1F511;':idx.type===1?'&#x23F0;':idx.type===3?'&#x1F524;':idx.type===5?'&#x1F333;':'&#x1F517;')+'</div>'+
  250. '<div class="idx-info"><div class="idx-name">'+esc(idx.name)+'</div>'+
  251. '<div class="idx-meta"><span class="badge '+ic+'">'+idx.ts+'</span><span>Fields: '+esc(flds)+'</span><span>Root: '+idx.ep+'</span></div></div>'+
  252. '<div class="idx-arrow">&#x203A;</div></div>';
  253. });
  254. h+='</div></div></div>';
  255. // Storage
  256. h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#4ecdc4"></div>Storage</div><div class="sec-bd">'+
  257. '<div class="idx-card" onclick="showHeapPages(\''+esc(nm)+'\')"><div class="idx-ico" style="background:rgba(78,205,196,.15)">&#x1F4E6;</div>'+
  258. '<div class="idx-info"><div class="idx-name">Heap Pages (Field Overflow)</div><div class="idx-meta">First: '+t.hp0+'</div></div>'+
  259. '<div class="idx-arrow">&#x203A;</div></div></div></div>';
  260. $('content').innerHTML=h;
  261. }
  262. function showIndex(nm,ep,it){
  263. S.idxType=it;S.bc=[{l:S.cur.name,a:()=>showTable(S.cur.name)},{l:nm,a:null}];
  264. let h='<div class="bc">';S.bc.forEach((b,i)=>{if(i>0)h+='<span class="sep">&#x203A;</span>';
  265. if(b.a&&i<S.bc.length-1)h+='<span class="item" onclick="navBC('+i+')">'+esc(b.l)+'</span>';
  266. else h+='<span class="cur">'+esc(b.l)+'</span>'});
  267. 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>'+
  268. (it===3||it===4?'Index':'B+ Tree')+' - '+esc(nm)+'</div><div id="idxContent" style="padding:16px;color:#5b9bd5">Loading...</div></div>';
  269. $('content').innerHTML=h;loadIdxPage(ep,it);
  270. }
  271. function loadIdxPage(pid,it){
  272. fetch('/api/btree?id='+pid+'&t='+it).then(r=>r.json()).then(d=>{
  273. if(d.e){$('idxContent').innerHTML='<div class="empty"><div class="msg">Error: '+d.e+'</div></div>';return}
  274. let isBtree=(it===1||it===2);
  275. let isSBtree=(it===5);
  276. let h='<div class="node-bar"><div class="ni"><span class="ni-lb">Page</span><span class="ni-val">'+d.id+'</span></div>'+
  277. '<div class="ni"><span class="ni-lb">Type</span><span class="badge '+(d.lf?'leaf':'internal')+'">'+(d.lf?'Leaf':'Internal')+'</span></div>'+
  278. '<div class="ni"><span class="ni-lb">Entries</span><span class="ni-val">'+d.cn+'</span></div>'+
  279. '<div class="ni"><span class="ni-lb">Usage</span><span class="ni-val">'+d.us.toFixed(1)+'%</span>'+
  280. '<div class="ubar"><div class="fill" style="width:'+Math.min(d.us,100)+'%"></div></div></div></div>';
  281. 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>';
  282. 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>';
  283. h+='<table class="dtbl"><thead><tr><th style="width:40px">#</th><th>Key</th>';
  284. if(isBtree){
  285. h+='<th style="width:120px">'+(d.lf?'Data Page':'Child Page')+'</th>';
  286. }else if(isSBtree){
  287. h+='<th style="width:120px">'+(d.lf?'PKID':'Child Page')+'</th>';
  288. }else{
  289. h+='<th style="width:120px">PKID</th>';
  290. }
  291. h+='</tr></thead><tbody>';
  292. (d.ents||[]).forEach((e,i)=>{
  293. h+='<tr><td class="mono" style="color:#556">'+i+'</td><td class="mono" style="color:#c8ccd4">'+esc(e.k)+'</td>';
  294. if(isBtree){
  295. if(d.lf)h+='<td><span class="badge data clickable" onclick="showDP('+e.p+')">'+e.p+'</span></td>';
  296. else h+='<td><span class="badge primary clickable" onclick="loadIdxPage('+e.p+','+it+')">'+e.p+'</span></td>';
  297. }else if(isSBtree){
  298. if(d.lf)h+='<td class="mono" style="color:#5b9bd5;cursor:pointer" onclick="showPK('+e.dp+')" title="点击查看 DataPage">'+e.dp+'</td>';
  299. else h+='<td><span class="badge primary clickable" onclick="loadIdxPage('+e.p+','+it+')">'+e.p+'</span></td>';
  300. }else h+='<td class="mono" style="color:#667">'+e.dp+'</td>';
  301. h+='</tr>';
  302. });
  303. h+='</tbody></table>';
  304. let nav='';
  305. if(d.nx)nav+='<button class="nav-btn" onclick="loadIdxPage('+d.nx+','+it+')">Next &#x2192; #'+d.nx+'</button>';
  306. if(d.pv)nav+='<button class="nav-btn" onclick="loadIdxPage('+d.pv+','+it+')">&#x2190; Prev #'+d.pv+'</button>';
  307. if(nav)h+='<div class="nav-btns">'+nav+'</div>';
  308. $('idxContent').innerHTML=h;
  309. });
  310. }
  311. function showDP(pid){
  312. S.bc.push({l:'Data #'+pid,a:null});
  313. let h='<div class="bc">';S.bc.forEach((b,i)=>{if(i>0)h+='<span class="sep">&#x203A;</span>';
  314. if(b.a&&i<S.bc.length-1)h+='<span class="item" onclick="navBC('+i+')">'+esc(b.l)+'</span>';
  315. else h+='<span class="cur">'+esc(b.l)+'</span>'});
  316. h+='</div><div class="sec"><div class="sec-hd"><div class="dot" style="background:#4ecdc4"></div>Data Page #'+pid+'</div>'+
  317. '<div id="dpContent" style="padding:16px;color:#5b9bd5">Loading...</div></div>';
  318. $('content').innerHTML=h;
  319. fetch('/api/data-page?id='+pid).then(r=>r.json()).then(d=>{
  320. if(d.e){$('dpContent').innerHTML='<div class="empty"><div class="msg">Error</div></div>';return}
  321. let info='<div class="node-bar"><div class="ni"><span class="ni-lb">Page</span><span class="ni-val">'+d.id+'</span></div>'+
  322. '<div class="ni"><span class="ni-lb">Rows</span><span class="ni-val">'+d.cn+'</span></div>'+
  323. '<div class="ni"><span class="ni-lb">Min</span><span class="ni-val" style="color:#4ecdc4">'+d.mn+'</span></div>'+
  324. '<div class="ni"><span class="ni-lb">Max</span><span class="ni-val" style="color:#f7b731">'+d.mx+'</span></div>'+
  325. '<div class="ni"><span class="ni-lb">Usage</span><span class="ni-val">'+d.us.toFixed(1)+'%</span>'+
  326. '<div class="ubar"><div class="fill" style="width:'+Math.min(d.us,100)+'%"></div></div></div></div>';
  327. 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>';
  328. (d.rs||[]).forEach(r=>{
  329. rows+='<tr><td class="mono" style="color:#556">'+r.i+'</td>'+
  330. '<td class="mono" style="color:#f7b731;font-size:12px">'+r.pk+'</td>'+
  331. '<td><span class="badge active">v'+r.sv+'</span></td>'+
  332. '<td class="row-decoded">'+esc(r.decoded)+'</td>'+
  333. '<td class="hex-data">'+esc(r.h)+'</td></tr>';
  334. });
  335. rows+='</tbody></table>';
  336. let nav='';
  337. if(d.pv)nav+='<button class="nav-btn" onclick="showDP('+d.pv+')">&#x2190; Prev #'+d.pv+'</button>';
  338. if(d.nx)nav+='<button class="nav-btn" onclick="showDP('+d.nx+')">Next &#x2192; #'+d.nx+'</button>';
  339. $('dpContent').innerHTML=info+rows+(nav?'<div class="nav-btns">'+nav+'</div>':'');
  340. });
  341. }
  342. function showPK(pkid){
  343. // 找到当前表的主键索引根页
  344. let pkRoot=0;
  345. if(S.cur&&S.cur.idxs){
  346. S.cur.idxs.forEach(idx=>{if(idx.type===2)pkRoot=idx.ep});
  347. }
  348. if(!pkRoot){alert('No primary index found');return}
  349. S.bc.push({l:'PK #'+pkid+' \u2192 DataPage',a:null});
  350. let h='<div class="bc">';S.bc.forEach((b,i)=>{if(i>0)h+='<span class="sep">&#x203A;</span>';
  351. if(b.a&&i<S.bc.length-1)h+='<span class="item" onclick="navBC('+i+')">'+esc(b.l)+'</span>';
  352. else h+='<span class="cur">'+esc(b.l)+'</span>'});
  353. h+='</div><div class="sec"><div class="sec-hd"><div class="dot" style="background:#5b9bd5"></div>Locating PK #'+pkid+'...</div>';
  354. h+='<div id="dpContent" style="padding:16px;color:#5b9bd5">Searching primary B+ tree...</div></div>';
  355. $('content').innerHTML=h;
  356. fetch('/api/find-pk?pk='+pkid+'&root='+pkRoot).then(r=>r.json()).then(d=>{
  357. if(d.e){$('dpContent').innerHTML='<div class="empty"><div class="msg">'+d.e+'</div></div>';return}
  358. showDP(d.dp);
  359. });
  360. }
  361. function showHeader(){
  362. document.querySelectorAll('.tbl-item').forEach(e=>e.classList.remove('active'));
  363. S.bc=[{l:'HeaderPage',a:null}];
  364. let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">&#x203A;</span><span class="cur">HeaderPage</span></div>';
  365. h+='<div class="sec"><div class="sec-hd"><div class="dot" style="background:#4ecdc4"></div>Database Header</div>';
  366. h+='<div id="hdrContent" style="padding:16px;color:#5b9bd5">Loading...</div></div>';
  367. $('content').innerHTML=h;
  368. fetch('/api/header').then(r=>r.json()).then(d=>{
  369. if(d.e){$('hdrContent').innerHTML='<div class="empty"><div class="msg">Error</div></div>';return}
  370. let rows=[['Magic',d.magic],['Version','v'+d.ver],['Page Size',d.pgsz+' bytes ('+(d.pgsz/1024)+' KB)'],
  371. ['Next Free Page',d.nf],['Table Page (root)',d.tp],['Table Count',d.tc],
  372. ['Create Time',d.ct],['Modify Time',d.mt],['Free Chain Start',d.fs],['Free Count',d.fc],
  373. ['Global Flags',d.gf],['Comment',d.cm||'(empty)']];
  374. let t='<table class="dtbl"><thead><tr><th style="width:200px">Field</th><th>Value</th></tr></thead><tbody>';
  375. 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>'});
  376. t+='</tbody></table>';$('hdrContent').innerHTML=t;
  377. });
  378. }
  379. function showHeapPages(nm){
  380. const t=S.tables.find(x=>x.name===nm);if(!t)return;S.cur=t;
  381. S.bc=[{l:nm,a:()=>showTable(nm)},{l:'Heap Pages',a:null}];
  382. let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">&#x203A;</span>'+
  383. '<span class="item" onclick="showTable(\''+esc(nm)+'\')">'+esc(nm)+'</span><span class="sep">&#x203A;</span><span class="cur">Heap Pages</span></div>';
  384. 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>';
  385. h+='<div id="heapContent" style="padding:12px">Loading...</div></div>';
  386. $('content').innerHTML=h;
  387. Promise.all([fetch('/api/heap-chain?id='+t.hp0).then(r=>r.json()),fetch('/api/pages').then(r=>r.json())]).then(([hd,pd])=>{
  388. if(!hd.pages||!hd.pages.length){$('heapContent').innerHTML='<div class="empty"><div class="ico">&#x1F4E6;</div><div class="msg">No heap pages</div></div>';return}
  389. let heapSet=new Set(hd.pages.map(p=>p.id));
  390. $('heapInfo').textContent=hd.total+' heap pages \u00d7 16 KB';
  391. let h2='<div style="display:flex;flex-wrap:wrap;gap:2px">';
  392. (pd.pages||[]).forEach(p=>{
  393. let isHeap=heapSet.has(p.id);
  394. let c=isHeap?'#4ecdc4':'#1a1a2e';
  395. let br=isHeap?1:.2;
  396. 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>';
  397. });
  398. h2+='</div>';
  399. 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>';
  400. hd.pages.forEach(p=>{
  401. let us=(p.use/16384*100).toFixed(1);
  402. 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>';
  403. });
  404. h2+='</tbody></table>';
  405. $('heapContent').innerHTML=h2;
  406. }).catch(e=>{$('heapContent').innerHTML='<div style="color:#e74c3c">Error: '+e.message+'</div>'});
  407. }
  408. function showFreePages(){
  409. document.querySelectorAll('.tbl-item').forEach(e=>e.classList.remove('active'));
  410. S.bc=[{l:'Free Pages',a:null}];
  411. let h='<div class="bc"><span class="item" onclick="showOverview()">Overview</span><span class="sep">&#x203A;</span><span class="cur">Free Pages</span></div>';
  412. 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>';
  413. h+='<div id="freeContent" style="padding:12px;color:#5b9bd5">Loading...</div></div>';
  414. $('content').innerHTML=h;
  415. Promise.all([fetch('/api/free-pages').then(r=>r.json()),fetch('/api/pages').then(r=>r.json())]).then(([fd,pd])=>{
  416. if(!fd.pages||!fd.pages.length){$('freeContent').innerHTML='<div class="empty"><div class="ico">&#x267B;</div><div class="msg">No recycled pages</div></div>';return}
  417. let freeSet=new Set(fd.pages);
  418. $('freeInfo').textContent=fd.total+' free pages \u00d7 16 KB = '+fB(fd.total*16384);
  419. let h2='<div style="display:flex;flex-wrap:wrap;gap:2px">';
  420. (pd.pages||[]).forEach(p=>{
  421. let isFree=freeSet.has(p.id);
  422. let c=isFree?'#a78bfa':'#1a1a2e';
  423. let br=isFree?1:.2;
  424. 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>';
  425. });
  426. h2+='</div>';
  427. h2+='<table class="dtbl" style="margin-top:12px"><thead><tr><th>#</th><th>Page ID</th><th>Next Free</th></tr></thead><tbody>';
  428. fd.pages.forEach((p,i)=>{
  429. 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>';
  430. });
  431. h2+='</tbody></table>';
  432. $('freeContent').innerHTML=h2;
  433. }).catch(e=>{$('freeContent').innerHTML='<div style="color:#e74c3c">Error: '+e.message+'</div>'});
  434. }
  435. function navBC(i){S.bc=S.bc.slice(0,i+1);S.bc[i].a()}
  436. 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]||'?'}
  437. renderFB();
  438. </script>
  439. </body>
  440. </html>`