#!/usr/bin/env python3
"""
IEEE 802.1 Index Generator
Creates searchable HTML index from processed documents
"""
import sqlite3
import json
from datetime import datetime
def load_config():
config = {}
if os.path.exists('.env'):
with open('.env', 'r') as f:
for line in f:
line = line.strip()
if line and not line.startswith('#') and '=' in line:
key, value = line.split('=', 1)
config[key.strip()] = value.strip()
return config
config = load_config()
BASE_PATH = config.get('BASE_PATH', '/home/mark/files.serialport.org/ieee802')
def get_documents():
"""Retrieve all processed documents from database"""
conn = sqlite3.connect('ieee_docs.db')
c = conn.cursor()
c.execute('''SELECT filepath, filename, year, extension, filesize,
summary, subgroup, doc_number
FROM documents
WHERE processed = 1
ORDER BY year, filename''')
documents = []
for row in c.fetchall():
# Convert filepath to relative web path
filepath = row[0].replace(BASE_PATH, '')
web_path = filepath.replace('/docs', 'docs')
documents.append({
'filepath': web_path,
'filename': row[1],
'year': row[2],
'extension': row[3],
'filesize': row[4],
'summary': row[5] or 'No summary available',
'subgroup': row[6] or 'Unknown',
'doc_number': row[7] or 'N/A'
})
conn.close()
return documents
def generate_html(documents):
"""Generate static HTML index"""
# Get unique subgroups for filter
subgroups = sorted(set(doc['subgroup'] for doc in documents))
html = f"""
IEEE 802.1 Document Index (1994-1998)
IEEE 802.1 Document Index
Early VLAN Development (1994-1998)
Total Documents: {len(documents)} |
Generated: {datetime.now().strftime('%Y-%m-%d %H:%M')}
Year
Filename
Subgroup
Doc Number
Summary
Type
"""
# Add table rows
for doc in documents:
filename_link = f'{doc["filename"]}'
subgroup_badge = f'{doc["subgroup"]}'
html += f"""
{doc['year']}
{filename_link}
{subgroup_badge}
{doc['doc_number']}
{doc['summary']}
{doc['extension']}
"""
html += """
"""
return html
def main():
print("IEEE 802.1 Index Generator")
print("=" * 50)
# Get documents
documents = get_documents()
if not documents:
print("No processed documents found!")
print("Run processor.py first to process documents.")
return
print(f"Found {len(documents)} processed documents")
# Generate HTML
html = generate_html(documents)
# Write to file
output_file = 'output/ieee802_index.html'
with open(output_file, 'w', encoding='utf-8') as f:
f.write(html)
print(f"\nIndex generated successfully!")
print(f"Output file: {output_file}")
print(f"\nOpen in browser: file://{os.path.abspath(output_file)}")
print(f"Or copy to web directory and access via: https://files.serialport.org/ieee802/")
if __name__ == '__main__':
import os
main()