ArchiveViewer.exe
av.zip (10.6 KB)
···
===================
Prerequistes:
Python 2.6+
wxPython (latest version)
HTML.py (from http://www.decalage.info/python/html) - download, unzip, install
sqlite3 (installed with python)
any database (*.db)
Running:
$ python archiveviewer.py
You will find 3 panels: two at the top, one on the bottom.
top left: tree of databases, tables, and queries
top right: sql query editor (just a text box)
bottom: a notebook with 2 tabs
a “results” tab (when double clicking on a specific query in the tree)
a sql field selector
sequence would be:
-
click open database and choose a sqlite database (*.db)
-
click on a table in the tree: you will set the database and table fields
-
click new query button
-
select some field to display
-
click “generate sql” -> to get query into top right text box
-
edit the query if you want (or not)
-
when ready click the “save” button, and it will show up in the tree in the correct place
-
double click on the query (in the tree), and the results will show
My trouble:
-
Everything works fine in both Windows (with py2exe), and in linux (in a VM under my mac)
-
in native OSx it does NOT work.
In OSx, The top two panels work fine. The Notebook panel (the bottom) is dead to any and all clicking events.
So why would it work just fine in those two, and not OSx? My first guess would be it would have worked in linux and osx and not windows.
–
Licensed Amateur Radio Operator: K7AZJ
Registered Linux User: 275424
Recursion: (noun):
see: Recursion