Does anybody know of a plug-and-play window for defining a database query? I'm thinking of something where you pick a column name, pick an operator (equal to, contains, less than, etc.), and then type in a value (ideally, in a field whose type or validation changes depending on the data type of the column chosen). Then there would be a "+" button that lets you add another constraint, and you could repeat this for as many constraints as you wish.
Probably not a huge deal to write this ourselves, but it strikes me as the sort of thing that may be already available somewhere in the wxPython community.
Does anybody know of a plug-and-play window for defining a database query? I'm thinking of something where you pick a column name, pick an operator (equal to, contains, less than, etc.), and then type in a value (ideally, in a field whose type or validation changes depending on the data type of the column chosen). Then there would be a "+" button that lets you add another constraint, and you could repeat this for as many constraints as you wish.
Probably not a huge deal to write this ourselves, but it strikes me as the sort of thing that may be already available somewhere in the wxPython community.
Thanks,
- Joe
You might look at Dabo...I'm not sure if they have a widget per se, but they're wxPython set of tools is supposed to be "ready-made" for database stuff:
Does anybody know of a plug-and-play window for defining a database
query? I'm thinking of something where you pick a column name, pick
an operator (equal to, contains, less than, etc.), and then type in a
value (ideally, in a field whose type or validation changes depending
on the data type of the column chosen). Then there would be a "+"
button that lets you add another constraint, and you could repeat this
for as many constraints as you wish.
I did a quick Google search for "sql query builder gui open source" and
one of the first results was this:
Does anybody know of a plug-and-play window for defining a database query? I'm thinking of something where you pick a column name, pick an operator (equal to, contains, less than, etc.), and then type in a value (ideally, in a field whose type or validation changes depending on the data type of the column chosen). Then there would be a "+" button that lets you add another constraint, and you could repeat this for as many constraints as you wish.
Probably not a huge deal to write this ourselves, but it strikes me as the sort of thing that may be already available somewhere in the wxPython community.
You might give Navicat a try. Not open source, but the non-commercial/lite version works very well.
Does anybody know of a plug-and-play window for defining a database query? I'm thinking of something where you pick a column name, pick an operator (equal to, contains, less than, etc.), and then type in a value (ideally, in a field whose type or validation changes depending on the data type of the column chosen). Then there would be a "+" button that lets you add another constraint, and you could repeat this for as many constraints as you wish.
Probably not a huge deal to write this ourselves, but it strikes me as the sort of thing that may be already available somewhere in the wxPython community.
Yes it wonders me too, apparently guys who already know SQL don't need such a thing,
and guys who don't understand SQL very well can't make it.
And as an exception, I'm (not very well with SQL) am working on something like this in wxPython, http://mientki.ruhosting.nl/data_www/pylab_works/pw_sqllite.html
But as others already pointed, there are a lot non-Python programs free available.
Yes, but that's Java. I probably should have specified it, but I'm looking for something in wxPython. (Thought that was implied by the list I was posting to, but of course it's always better to be clear.)
Thanks,
- Joe
···
On Dec 15, 2008, at 2:44 PM, Wayne Koorts wrote:
Does anybody know of a plug-and-play window for defining a database
query? ...
I did a quick Google search for "sql query builder gui open source" and
one of the first results was this:
Does anybody know of a plug-and-play window for defining a
database query? I'm thinking of something where you pick a
column name, pick an operator (equal to, contains, less than,
etc.), and then type in a value (ideally, in a field whose
type or validation changes depending on the data type of the
column chosen). Then there would be a "+"
button that lets you add another constraint, and you could
repeat this for as many constraints as you wish.
Probably not a huge deal to write this ourselves, but it
strikes me as the sort of thing that may be already available
somewhere in the wxPython community.
Someone called Jerry LeVan posted some stuff here about a year ago. Here is
a link -
Does anybody know of a plug-and-play window for defining a database query? I'm thinking of something where you pick a column name, pick an operator (equal to, contains, less than, etc.), and then type in a value (ideally, in a field whose type or validation changes depending on the data type of the column chosen). Then there would be a "+" button that lets you add another constraint, and you could repeat this for as many constraints as you wish.
I would approach this a little differently. I'd use a StyledTextCtrl that used the SQL lexer for syntax coloring and AutoComplete popups for providing help to select the table names, field names, etc. That way you'll end up with something that can be used by SQL newbies without too much hassle, and also by pros without getting in their way. The FlameRobin project has done something like this in wx (C++).
···
--
Robin Dunn
Software Craftsman http://wxPython.org Java give you jitters? Relax with wxPython!
This sounds like something that would be perfect for Dabo
(http://dabodev.com). This is a framework that wraps wxPython and adds
a lot of database connectivity stuff that is normally very difficult
to do.
I'm not much of a database guy, but you might want to ask on the
dabo-users list if this is something that's already been done. It's a
real helpful group of people on that list, so I'm sure that your
question will be answered. http://leafe.com/mailman/listinfo/dabo-users
···
On Mon, Dec 15, 2008 at 12:46 PM, Joe Strout <joe@strout.net> wrote:
Does anybody know of a plug-and-play window for defining a database query?
I'm thinking of something where you pick a column name, pick an operator
(equal to, contains, less than, etc.), and then type in a value (ideally, in
a field whose type or validation changes depending on the data type of the
column chosen). Then there would be a "+" button that lets you add another
constraint, and you could repeat this for as many constraints as you wish.