Python

Python RSS

Data View

•

Join Date: Dec 2006

Posts: 25

Reputation: wandie is an unknown quantity at this point

Solved Threads: 0

wandie

Offline

Light Poster

Data View

Jul 17th, 2007

I got this error when i was running a tuturial on how to view data using a grid in wx. I downloaded the modules for wx. I wandering if anyone can help me. this is the error i got

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
Traceback (most recent call last):
  File "C:\Update\data.py", line 7, in <module>
    class MyFrame(wx.Frame):
  File "C:\Update\data.py", line 27, in MyFrame
    self.grid_1.SetColLabelValue(index, item[0])
NameError: name 'self' is not defined
Traceback (most recent call last):
  File "C:\Update\data.py", line 7, in <module>
    class MyFrame(wx.Frame):
  File "C:\Update\data.py", line 27, in MyFrame
    self.grid_1.SetColLabelValue(index, item[0])
NameError: name 'self' is not defined

This is the code i put in.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
import wx   
import wx.grid   
import getdata
db = getdata.Eb_db()
class MyFrame(wx.Frame):
 
    def __init__(self, *args, **kwds):
        # begin wxGlade: MyFrame.__init__
        kwds["style"] = wx.DEFAULT_FRAME_STYLE
        wx.Frame.__init__(self, *args, **kwds)
        self.grid_1 = wx.grid.Grid(self, -1, size=(1, 1))
        self.__do_layout()
        # end wxGlade   
    def __set_properties(self):   
       # begin wxGlade: MyFrame.__set_properties   
       self.SetTitle("frame_1")   
       self.SetSize((400, 400))   
      # end wxGlade
       self.grid_1.CreateGrid(len(db.data),len(db.fields))
 
    for item in db.fields:
        index = 0 
        self.grid_1.SetColLabelValue(index, item[0])
        index += 1
    for row in range(len(db.data)):
        for col in range(len(db.data[row])):
            values = db.data[row][col]
            self.grid_1.SetCellValue(row,col,str(values))
    def __do_layout(self):
        # begin wxGlade: MyFrame.__do_layout
        sizer_1 =wx.BoxSizer(wx.VERTICAL)
        sizer_1.Add(self.grid_1, 1, wx.EXPAND, 0)
        self.SetAutoLayout(True)
        self.SetSizer(sizer_1)
        self.Layout()
        # end wxGlade
        # end of class MyFrame
if __name__ == "__main__":
    app = wx.PySimpleApp(0)
    wx.InitAllImageHandlers()
    frame_1 = MyFrame(None, -1, "")
    app.SetTopWindow(frame_1)
    frame_1.Show()
    app.MainLoop()
import wx   
import wx.grid   
import getdata
db = getdata.Eb_db()
class MyFrame(wx.Frame):
 
    def __init__(self, *args, **kwds):
        # begin wxGlade: MyFrame.__init__
        kwds["style"] = wx.DEFAULT_FRAME_STYLE
        wx.Frame.__init__(self, *args, **kwds)
        self.grid_1 = wx.grid.Grid(self, -1, size=(1, 1))
        self.__do_layout()
        # end wxGlade   
    def __set_properties(self):   
       # begin wxGlade: MyFrame.__set_properties   
       self.SetTitle("frame_1")   
       self.SetSize((400, 400))   
      # end wxGlade
       self.grid_1.CreateGrid(len(db.data),len(db.fields))
 
    for item in db.fields:
        index = 0 
        self.grid_1.SetColLabelValue(index, item[0])
        index += 1
    for row in range(len(db.data)):
        for col in range(len(db.data[row])):
            values = db.data[row][col]
            self.grid_1.SetCellValue(row,col,str(values))
    def __do_layout(self):
        # begin wxGlade: MyFrame.__do_layout
        sizer_1 =wx.BoxSizer(wx.VERTICAL)
        sizer_1.Add(self.grid_1, 1, wx.EXPAND, 0)
        self.SetAutoLayout(True)
        self.SetSizer(sizer_1)
        self.Layout()
        # end wxGlade
        # end of class MyFrame
if __name__ == "__main__":
    app = wx.PySimpleApp(0)
    wx.InitAllImageHandlers()
    frame_1 = MyFrame(None, -1, "")
    app.SetTopWindow(frame_1)
    frame_1.Show()
    app.MainLoop()

got the example on this site: http://www.serpia.org/mysql. If you know any other tutorials i can try to view data from mysql database.

•

Join Date: Oct 2004

Posts: 4,009

Reputation: vegaseat is just really nice

Solved Threads: 928

vegaseat

Offline

DaniWeb's Hypocrite

Re: Data View

Jul 17th, 2007

Don't wedge your for loops detween two function defines! Rewrite your code like this ...

 Help with Code Tags 
 python Syntax (Toggle Plain Text) 
import wx
import wx.grid
import getdata
 
db = getdata.Eb_db()
 
class MyFrame(wx.Frame):
    def __init__(self, *args, **kwds):
        # begin wxGlade: MyFrame.__init__
        kwds["style"] = wx.DEFAULT_FRAME_STYLE
        wx.Frame.__init__(self, *args, **kwds)
        self.grid_1 = wx.grid.Grid(self, -1, size=(1, 1))
        self.__do_layout()
        # end wxGlade
 
        for item in db.fields:
            index = 0
            self.grid_1.SetColLabelValue(index, item[0])
            index += 1
        for row in range(len(db.data)):
            for col in range(len(db.data[row])):
                values = db.data[row][col]
                self.grid_1.SetCellValue(row,col,str(values))
 
    def __set_properties(self):
       # begin wxGlade: MyFrame.__set_properties
       self.SetTitle("frame_1")
       self.SetSize((400, 400))
      # end wxGlade
       self.grid_1.CreateGrid(len(db.data),len(db.fields))
 
    def __do_layout(self):
        # begin wxGlade: MyFrame.__do_layout
        sizer_1 =wx.BoxSizer(wx.VERTICAL)
        sizer_1.Add(self.grid_1, 1, wx.EXPAND, 0)
        self.SetAutoLayout(True)
        self.SetSizer(sizer_1)
        self.Layout()
        # end wxGlade
        # end of class MyFrame
 
if __name__ == "__main__":
    app = wx.PySimpleApp(0)
    wx.InitAllImageHandlers()
    frame_1 = MyFrame(None, -1, "")
    app.SetTopWindow(frame_1)
    frame_1.Show()
    app.MainLoop()
import wx
import wx.grid
import getdata
 
db = getdata.Eb_db()
 
class MyFrame(wx.Frame):
    def __init__(self, *args, **kwds):
        # begin wxGlade: MyFrame.__init__
        kwds["style"] = wx.DEFAULT_FRAME_STYLE
        wx.Frame.__init__(self, *args, **kwds)
        self.grid_1 = wx.grid.Grid(self, -1, size=(1, 1))
        self.__do_layout()
        # end wxGlade
 
        for item in db.fields:
            index = 0
            self.grid_1.SetColLabelValue(index, item[0])
            index += 1
        for row in range(len(db.data)):
            for col in range(len(db.data[row])):
                values = db.data[row][col]
                self.grid_1.SetCellValue(row,col,str(values))
 
    def __set_properties(self):
       # begin wxGlade: MyFrame.__set_properties
       self.SetTitle("frame_1")
       self.SetSize((400, 400))
      # end wxGlade
       self.grid_1.CreateGrid(len(db.data),len(db.fields))
 
    def __do_layout(self):
        # begin wxGlade: MyFrame.__do_layout
        sizer_1 =wx.BoxSizer(wx.VERTICAL)
        sizer_1.Add(self.grid_1, 1, wx.EXPAND, 0)
        self.SetAutoLayout(True)
        self.SetSizer(sizer_1)
        self.Layout()
        # end wxGlade
        # end of class MyFrame
 
if __name__ == "__main__":
    app = wx.PySimpleApp(0)
    wx.InitAllImageHandlers()
    frame_1 = MyFrame(None, -1, "")
    app.SetTopWindow(frame_1)
    frame_1.Show()
    app.MainLoop()

The way you had it, Python looks at them as global to the class and self hasn't been declared yet. I don't have getdata, so I can't test it!

Last edited by vegaseat; Jul 17th, 2007 at 5:00 pm.

May 'the Google' be with you!

•

Join Date: Dec 2006

Posts: 25

Reputation: wandie is an unknown quantity at this point

Solved Threads: 0

wandie

Offline

Light Poster

Re: Data View

Jul 18th, 2007

Thank you for the code it works. Well it displays the window but Its not getting the data from the getdata.py here is the code.For the getdata

 Help with Code Tags 
 python Syntax (Toggle Plain Text) 
import MySQLdb
 
class Eb_db:
    def __init__(self):
        try:
            connection = MySQLdb.connect(host="localhost",
            user="root", passwd="scott", db="phonebook" )
            cursor = connection.cursor()
            cursor.execute( "SELECT * FROM details " )
        except MySQLdb.OperationalError, message:
            errorMessage = "Error %d:\n%s" % (message[ 0 ], message[ 1 ] )
            return
        else:
            self.data = cursor.fetchall() 
            self.fields = cursor.description 
            cursor.close() 
            connection.close()
import MySQLdb
 
class Eb_db:
    def __init__(self):
        try:
            connection = MySQLdb.connect(host="localhost",
            user="root", passwd="scott", db="phonebook" )
            cursor = connection.cursor()
            cursor.execute( "SELECT * FROM details " )
        except MySQLdb.OperationalError, message:
            errorMessage = "Error %d:\n%s" % (message[ 0 ], message[ 1 ] )
            return
        else:
            self.data = cursor.fetchall() 
            self.fields = cursor.description 
            cursor.close() 
            connection.close()