Path: csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: cl@isbd.net
Newsgroups: comp.lang.python
Subject: Any sqledit/sqlkit users here?
Date: Wed, 16 Mar 2016 16:48:21 +0000
Lines: 36
Message-ID: <lbforc-p94.ln1@esprimo.zbmc.eu>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net iQrP/kGswWtVKx/B+2I5egQejGtKA79rTq91osbBBLe/7XiKk=
X-Orig-Path: not-for-mail
Cancel-Lock: sha1:E6C5jw/S+PbrRmjMpDEFhKqLnNQ=
User-Agent: tin/2.3.1-20141224 ("Tallant") (UNIX) (Linux/4.2.0-34-generic (x86_64))
Xref: csiph.com comp.lang.python:105052

Does anyone here use sqledit/sqlkit?  It's a sqlite database
browser/editor which does most of its work by introspection (at least
I think that's the right name for it).

Thus it's trivially simple to write a gui program to edit data in a
database:-

    #!/usr/bin/python

    from sqlkit.widgets import SqlTable
    from sqlkit.db import proxy

    import gtk

    db = proxy.DbProxy(bind="sqlite:////home/chris/tmp/odinlog.db")

    t = SqlTable('tripLog',    dbproxy=db, order_by='Date' )
    t.reload()

    gtk.main()


(Yes, I know exit/close is missing)

Just run the above (against an existing database) and you get a very
neat looking, editable, grid view.

I was wondering if there are any active users with whom I could share
ideas, the mailing list is quite quiet though there is activity to
move the code to bitbucket and allow more contributions.

I'm just a bit overwhelmed by it at the moment and need some feedback.

-- 
Chris Green
·