Skip to content

CHANGELOG.md

Latest commit

 

History

History
123 lines (106 loc) · 10.6 KB

CHANGELOG.md

File metadata and controls

123 lines (106 loc) · 10.6 KB
Raw

Changelog

[2.0.1] - 2026-08-23

Fixed

  • Store-Paket registrierte keinen Datenbank-Handler. Das AppxManifest.xml deklarierte keine uap:FileTypeAssociation; eine aus dem Store installierte App erschien deshalb nicht unter „Öffnen mit" und ein Doppelklick auf eine .db startete sie nicht. Ergänzt: .db, .sqlite, .sqlite3 sowie der Ausführungsalias sqliteviewer.exe. Die Auswertung von sys.argv[1] war bereits vorhanden und wird jetzt durch Tests festgehalten.
  • Falsche Paket-Identität im Repository. store_package.json führte Geiger.SQLiteViewer, im Partner Center ist die App aber als Geiger.SQLiteViewerPro registriert (Produkt 9P6H501XB8JT). Ein aus diesem Stand gebautes Paket hätte nicht zur veröffentlichten App gepasst. Korrigiert, store_id ergänzt.
  • Versionsdrift behoben: APP_VERSION stand auf 2.0.0, pyproject.toml auf 2.0.1.

Added

  • tests/test_cli_db_argument.py — hält die Argument-Auswertung fest und prüft zusätzlich, dass die im Manifest deklarierten Endungen mit denen des Dateidialogs übereinstimmen. Bewusst ohne GUI-Instanziierung: SqlViewer() blockiert ohne Anzeige, statt zu scheitern.
  • Sprachen de-DE und en-US im Paket hinterlegt.

Changed

  • Paketversion 2.0.0.0 → 2.0.1.0; MaxVersionTested 10.0.19041.0 → 10.0.22621.0.
  • Manifest und Store-Icons werden aus store_package.json erzeugt (store-packager 2.2.0).

Store

  • Eingereicht am 2026-08-23, Submission 1152921505701721645, Status Certification.

[Unreleased]

Added

  • Standard PEP 621 pyproject.toml configuration with metadata, dependencies, and pytest settings.
  • Test suite status badge (30 passing tests) and LLM-Ready badge added to README.md and README_de.md.
  • GFM LLM note callouts (> [!NOTE]) added to README.md and README_de.md.

Changed

  • Updated llms.txt Last-checked header to 2026-07-27 and verified test suite assertions (30/30 passing pytest tests).

  • web_companion/library.js: sortRows(rows, columns, options) — clientseitige Spalten-Sortierung als pure-logic-Funktion (DOM-frei). Sortiert numerisch oder per localeCompare, null-Werte stets zuletzt, unbekannte Spalte gibt unveränderte Kopie zurück. Sieben neue Tests in web_companion/tests/library.test.mjs.

  • web_companion/app.js: Spaltensortierung per Klick auf Tabellenkopf — Event-Delegation auf <thead>, Sortierrichtung per Wiederholklick umkehren, Sort-Indikator (↑/↓) im aktiven Spaltenkopf, aria-sort-Attribut gesetzt, Tastatur-Bedienbarkeit (Enter/Leertaste) über tabIndex + keydown-Handler.

  • web_companion/style.css: Stile für klickbare Spaltenköpfe (cursor: pointer, Hover-Hintergrund, Focus-Ring, .sort-indicator in Akzentfarbe).

  • web_companion/library.js: exportToCsv(columns, rows) — erzeugt RFC-4180-konformes CSV für die aktuell sichtbaren Zeilen (CRLF-Trennung, Blob-Werte als lesbarer Text, Quoting bei Komma/Anführungszeichen/Zeilenumbrüchen, null → leeres Feld). Sechs neue Tests in web_companion/tests/library.test.mjs.

  • web_companion/: neuer Button „CSV exportieren" im Ergebniszeilen-Panel — lädt die gefilterten sichtbaren Zeilen als <datenbankname>.csv herunter; Button bleibt deaktiviert bis ein Export geladen ist.

  • German README_de.md with local-first usage, privacy context, comparison table, and SQLiteViewer search phrases.

  • web_companion/: static offline-first viewer for sqliteviewer-export-v1.json with local file import, demo mode, row filtering, metadata cards, LocalStorage restore, manifest, service worker, and Node smoke tests.

  • Three regression tests in tests/test_execute_sql.py covering sort-indicator propagation in search mode, redundant-binding double-sort prevention, and empty-table CSV export.

  • tests/source_platform_smoke.py: headless smoke tests for Linux and macOS source installs — covers module import, export serialization, _build_export_payload, SQL execution, and identifier escaping via fake infrastructure (no display required).

  • .github/workflows/source-platform-smoke.yml: CI matrix for ubuntu-latest and macos-latest running the smoke tests on every push/PR to main.

  • llms.txt with canonical repository, use cases, key files, discovery phrases, and boundaries for LLM/search crawlers.

  • Local release bundle workflow documented for the ignored releases/ workspace; public source files stay lightweight.

  • Application icon support in the Tk window.

  • Optional startup argument for opening a database file directly.

  • RELEASES.md documents the local release bundle layout.

  • SQLiteViewer.spec is tracked for reproducible PyInstaller builds.

  • Optional JSON companion export sqliteviewer-export-v1.json with source metadata, row limits, visible columns, and serialized result rows.

  • EXPORTFORMAT.md documents the JSON export contract for desktop-to-web/mobile companion workflows.

  • Reproducible Windows Store screenshot generation under _WARTUNG/generate_store_screenshots.py; generated screenshots stay in the ignored local releases/windowsstore/screenshots/ workspace while README/screenshots/main.png is refreshed for GitHub.

  • Local WACK notes remain in the ignored releases/windowsstore/ workspace; public root docs now describe only the source-controlled workflow.

Fixed

  • translator.py: TranslationSystem.t() lieferte bei leeren Übersetzungs-Strings in translations.json ("") den leeren String statt des deutschen Fallback-Texts.

Changed

  • Updated llms.txt Last-checked timestamp to 2026-07-22 and verified marketing, SEO, and discoverability context.
  • Internal platform plan now separates desktop database inspection from read-only Web/PWA review and keeps Android/iOS as export-first companion targets instead of native SQLiteViewer clones.
  • README now links the German guide and expands discovery phrases for file-bricks/SQLiteViewer, Python/Tkinter SQLite browser searches, and SQLite Viewer Pro.
  • llms.txt now records the 2026-06-12 marketing/discovery check and broader search/disambiguation notes.
  • Public docs now describe the export-first PWA path as the implemented mobile/browser companion strategy; raw .sqlite parsing stays a later optional evaluation step.
  • README is now English-first with a Start Here table, clearer local-first positioning, search/disambiguation context, and repaired German umlauts.
  • README now embeds the existing GUI screenshot from README/screenshots/main.png.
  • Repository URLs and community health files now point to file-bricks/SQLiteViewer.
  • START.bat now forwards command-line arguments and reports missing Python cleanly.
  • Store listings and Store metadata now reflect the current CSV/JSON export feature set and the active file-bricks/SQLiteViewer privacy/support links.
  • Store listing and screenshot workflow notes now avoid requiring ignored release artifacts in the public repo.
  • Community workflows now use actions/stale@v10 and actions/first-interaction@v3 with current input names.

Fixed

  • tests/source_platform_smoke.py bootstraps the project root into sys.path before the first import, so the documented direct smoke command python tests/source_platform_smoke.py now works outside pytest instead of failing with ModuleNotFoundError: SQLiteViewer.
  • Web Companion zeigt den vollständigen lokalen database_path nicht mehr in der sichtbaren Shell-Zusammenfassung; dort stehen jetzt Datenbankname und ein Hinweis, dass der volle Pfad im Export ausgeblendet wird.
  • Exportaktionen zeigen jetzt klarer ihren aktiven Kontext an: Tabellenansicht und SQL-Ergebnis bekommen eigene CSV-/JSON-Beschriftungen, und leere Exportzustände sind direkt deaktiviert statt erst in einen Warn-Dialog zu laufen. Regressionen ergänzt in tests/test_execute_sql.py.
  • SQL-Editor und Daten-Tab halten ihren Export-/View-State jetzt getrennt: execute_sql() schreibt Query-Ergebnisse nicht mehr in den Data-Tab-State, sondern in eigene sql_result_*-Felder; Exporte wählen abhängig vom aktiven Kontext den passenden Snapshot. Regressionen ergänzt in tests/test_execute_sql.py und tests/source_platform_smoke.py.
  • _search_data now fetches column names via PRAGMA table_info() instead of relying on self.current_columns. After running a SQL query in the SQL Editor, current_columns reflected the query result columns rather than the actual table columns, causing a silent Suchfehler: no such column: ... whenever the search box was used afterwards. Three regression tests added (tests/test_bugsweep_20260627.py).
  • Web companion metadata cards now render imported export metadata as inert text instead of interpolating it into innerHTML.
  • Sorting an active table search now keeps the filtered result set and export context intact instead of jumping back to the full unfiltered table.
  • Toolbar now uses a visible Suche: label instead of an icon-only search hint, and the refresh action is labeled consistently as Aktualisieren in the German UI.
  • SQL Editor now detects result-returning statements via cursor.description, so queries with leading comments are rendered correctly instead of being treated as DML.
  • SQL Editor now refreshes the currently selected table after data-changing statements instead of jumping back to the first table in the database.
  • Search now escapes %, _, and \ correctly so literal LIKE searches do not fail on wildcard-containing terms.
  • Opening a database now only closes the current session after the new read-only connection succeeds, so failed open attempts keep the existing database in place.
  • Sort indicator (↑/↓) was absent from column headings when viewing a search result — _search_data now adds the indicator to column headings when a sort column is active.
  • Double sort triggered by a redundant <Button-1> binding combined with the Treeview heading command — removed the explicit binding; heading command alone handles sorting.
  • export_csv blocked empty-table exports with a "no data" warning — now exports a header-only file consistently with export_json.

[2.0.0] - 2026-02-01

Added

  • SQL Editor with syntax highlighting and query execution
  • Schema view with CREATE TABLE inspection
  • Full-text search across all columns
  • CSV export functionality
  • Column sorting (click headers)
  • Keyboard shortcuts (Ctrl+O, Ctrl+F, Ctrl+E, F5, F9)
  • Dark theme for code editors
  • Table info display (row count, indexes, foreign keys)

Changed

  • Complete rewrite from basic viewer to full-featured browser
  • Upgraded UI with notebook tabs (Data, Schema, SQL)
  • Improved identifier escaping for safe SQL operations

[1.0.0] - 2024-12-01

Added

  • Initial release
  • Basic table browser with Treeview
  • Database open dialog
  • Row limit control
  • Refresh functionality