import streamlit as st

st.markdown(
    """
# Databases Documentation

## 1. Objective
Generate telecom databases and KML outputs from a dump file (`.xlsb`) using the `Database processing` page.

## 2. When to use this tool
Use this page when you need one or several outputs from the same dump:
- 2G / 3G / LTE databases
- NEI database
- INVUNIT database
- ADJL / ATL / Nice datasets (when full dump is available)
- 2G / 3G / LTE KML files

## 3. Input files and accepted formats
- Required: one dump file in `.xlsb`
- Optional behavior toggle: `Exclude decommissioned 2G BSCs` (enabled by default)

## 4. Required sheets
Depending on selected outputs, the dump should contain:
- 2G: `BTS`, `BCF`, `TRX`, `MAL`
- 3G: `WCEL`, `WBTS`, `WNCEL`
- LTE: `LNBTS`, `LNCEL`, `LNCEL_FDD`, `LNCEL_TDD`
- Neighbors: `ADCE`, `ADJS`, `ADJI`, `ADJG`, `ADJW`, `BTS`, `WCEL`
- INVUNIT: `INVUNIT`
- Full dump extras: `MRBTS` and related full-dump dependencies

## 5. Step-by-step usage
1. Open `Apps > Generate Databases`.
2. Upload your `.xlsb` dump.
3. Review available buttons (enabled according to detected sheets).
4. Click the needed generation button (`Generate 2G DB`, `Generate All DBs`, etc.).
5. Wait for completion message and download the generated file.

## 6. Outputs generated
The page can generate downloadable files such as:
- `2G database_<timestamp>.xlsx`
- `3G database_<timestamp>.xlsx`
- `LTE database_<timestamp>.xlsx`
- `All databases_<timestamp>.xlsx`
- `Neighbors databases_<timestamp>.xlsx`
- `INVUNIT database_<timestamp>.xlsx`
- KML files for 2G/3G/LTE

## 7. Frequent errors and fixes
- Error: required sheets missing.
  - Fix: verify the dump contains the required tabs listed above.
- Error: unsupported file type.
  - Fix: upload only `.xlsb`.
- Long processing or timeout feeling.
  - Fix: generate one dataset at a time for very large dumps.

## 8. Minimal reproducible example
- Input: one valid full dump `.xlsb` containing 2G/3G/LTE sheets.
- Action: click `Generate All DBs`.
- Expected result: download button appears for `All databases_<timestamp>.xlsx`.

## 9. Known limitations
- Processing time increases with dump size.
- Behavior depends on source dump consistency.
- Some outputs are only available when full dump requirements are met.

## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)