Hi Guys!
I am working on a project where I need to display data from mysql onto my app, i.e into a wxGrid
Also, the user can dynamically change that data and it gets updated in the database…
Any idea how I can perform both tasks?
PS:the grid is used under wxNotebook…i.e many similar grids…
~Udgam~
Udgam:
I built an application that does just this. I ended up using a Virtual wxGrid since my data was large; see the wxPython Examples. You have to consider Editors and Validators for each col so the data doesn't get rejected by MySQL (dates and long blob binary fields were the trickiest for me). Also, I used a separate thread to do the calls to the database so they would not freeze up the user interface (see the DelayedResult in the wxPython Examples). Also, I assume you know about the python MySQLdb package.
Other than those items, it is just bells and whistles that you may need.
Ben
On 9/20/2012 9:12 AM, Udgam Mehetre wrote:
Hi Guys!
I am working on a project where I need to display data from mysql onto my
app, i.e into a wxGrid
Also, the user can dynamically change that data and it gets updated in the
database...
Any idea how I can perform both tasks?
PS:the grid is used under wxNotebook..i.e many similar grids..~Udgam~
Do some more googling -- there has GOT to be sample code for this, or
somethign similar (i.e SQLite).
Also, check out Dabo:
They have certainly solved thiw problem already.
-Chris
On Thu, Sep 20, 2012 at 6:12 AM, Udgam Mehetre <uvmgr8@gmail.com> wrote:
Hi Guys!
I am working on a project where I need to display data from mysql onto my
app, i.e into a wxGrid
Also, the user can dynamically change that data and it gets updated in the
database...
Any idea how I can perform both tasks?
--
Christopher Barker, Ph.D.
Oceanographer
Emergency Response Division
NOAA/NOS/OR&R (206) 526-6959 voice
7600 Sand Point Way NE (206) 526-6329 fax
Seattle, WA 98115 (206) 526-6317 main reception
Chris.Barker@noaa.gov
Hi,
On Thursday, September 20, 2012 8:12:24 AM UTC-5, Udgam Mehetre wrote:
Hi Guys!
I am working on a project where I need to display data from mysql onto my app, i.e into a wxGrid
Also, the user can dynamically change that data and it gets updated in the database…
Any idea how I can perform both tasks?
PS:the grid is used under wxNotebook…i.e many similar grids…~Udgam~
I did something with SQLite and SQLAlchemy in a simple wxPython application that can load most SQLite databases and view them using ObjectListView, a wrapper for the ListCtrl. I know it’s not a grid widget, but it might help you get started. Here’s the article: http://www.blog.pythonlibrary.org/2012/06/04/wxpython-and-sqlalchemy-loading-random-sqlite-databases-for-viewing/