wxPython - ListCrtl and SQLite3

Posted by Dunwitch on Stack Overflow See other posts from Stack Overflow or by Dunwitch
Published on 2010-03-29T09:01:56Z Indexed on 2010/03/29 9:03 UTC
Read the original article Hit count: 269

Filed under:

I'm trying to get a SQLite3 DB to populate a wx.ListCrtl. I can get it to print to stdout/stderr without any problem. I just can't seem to figure out how to display the data in the DataWindow/DataList? I'm sure I've made some code mistakes, so any help is appreciated.

Main.py

import wx
import wx.lib.mixins.listctrl  as  listmix
from database import *
import sys

class DataWindow(wx.Frame):
    def __init__(self, parent = None):
        wx.Frame.__init__(self, parent, -1, 'DataList', size=(640,480))
        self.win = DataList(self)
        self.Center()
        self.Show(True)

class DataList(wx.ListCtrl, listmix.ListCtrlAutoWidthMixin, listmix.ColumnSorterMixin):
    def __init__(self, parent = DataWindow):
        wx.ListCtrl.__init__( self, parent, -1, style=wx.LC_REPORT|wx.LC_VIRTUAL|wx.LC_HRULES|wx.LC_VRULES)

        #building the columns
        self.InsertColumn(0, "Location")
        self.InsertColumn(1, "Address")
        self.InsertColumn(2, "Subnet")
        self.InsertColumn(3, "Gateway")
        self.SetColumnWidth(0, 100)
        self.SetColumnWidth(1, 150)
        self.SetColumnWidth(2, 150)
        self.SetColumnWidth(3, 150)

class MainWindow(wx.Frame):
    def __init__(self, parent = None, id = -1, title = "MainWindow"):
        wx.Frame.__init__(self, parent, id, title, size = (800,600),
                          style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER))

        # StatusBar
        self.CreateStatusBar()

        # Filemenu
        filemenu = wx.Menu()

        # Filemenu - About
        menuitem = filemenu.Append(-1, "&About", "Information about this application")
        self.Bind(wx.EVT_MENU, self.onAbout, menuitem)

        #Filemenu - Data
        menuitem = filemenu.Append(-1, "&Data", "Get data")
        self.Bind(wx.EVT_MENU, self.onData, menuitem)
        # Filemenu - Seperator
        filemenu.AppendSeparator()

        #Filemenu - Exit
        menuitem = filemenu.Append(-1, "&Exit", "Exit the application")
        self.Bind(wx.EVT_MENU, self.onExit, menuitem)

        # Menubar
        menubar = wx.MenuBar()
        menubar.Append(filemenu, "&File")
        self.SetMenuBar(menubar)

        # Show
        self.Show(True)
        self.Center()

    def onAbout(self, event):
        pass

    def onData(self, event):
        DataWindow(self)
        callDb = Database()
        sql = "SELECT rowid, address, subnet, gateway FROM pod1"
        records = callDb.select(sql)
        for v in records:
            print "How do I get the records on the DataList?"
            #print "%s%s%s" % (v[1],v[2],v[3])
            #for v in records:
            #DataList.InsertStringItem("%s") % (v[0], v[1], v[2])

    def onExit(self, event):
        self.Close()
        self.Destroy()

    def onSave(self, event):
        pass

if __name__ == '__main__':
    app = wx.App()
    frame = MainWindow(None, -1)
    frame.Show()
    app.MainLoop()

database.py

import os
import sqlite3

class Database(object):

    def __init__(self, db_file="data/data.sqlite"):
        database_allready_exists = os.path.exists(db_file)
        self.db = sqlite3.connect(db_file)
        if not database_allready_exists:
            self.setupDefaultData()

    def select(self,sql):
        cursor = self.db.cursor()
        cursor.execute(sql)
        records = cursor.fetchall()
        cursor.close
        return records

    def insert(self,sql):
        newID = 0
        cursor = self.db.cursor()
        cursor.execute(sql)
        newID = cursor.lastrowid
        self.db.commit()
        cursor.close()
        return newID

    def save(self,sql):
        cursor = self.db.cursor()
        cursor.execute(sql)
        self.db.commit()
        cursor.close()

    def setupDefaultData(self):
        pass

© Stack Overflow or respective owner

Related posts about wxpython