[wxPython] SQL table editor

hello all!

i have a module designed to edit data in an sql server table using
wxGrid-based window. it is still in alpha stage, but maybe someone is
interesed in unstable code?

the module was built and tested with Digital Creations DCOracle, but i
tried to avoid Oracle-specific extensions.

best wishes,
alex.

···

_______________________________________________
wxPython-users maillist - wxPython-users@starship.python.net
http://starship.python.net/mailman/listinfo/wxpython-users

alexander smishlajev wrote:

hello all!

i have a module designed to edit data in an sql server table using
wxGrid-based window. it is still in alpha stage, but maybe someone is
interesed in unstable code?

the module was built and tested with Digital Creations DCOracle, but i
tried to avoid Oracle-specific extensions.

I would be interested in trying it on PostgreSQL

···

------------
Hannu

_______________________________________________
wxPython-users maillist - wxPython-users@starship.python.net
http://starship.python.net/mailman/listinfo/wxpython-users

Hannu Krosing wrote:

> i have a module designed to edit data in an sql server table using
> wxGrid-based window. it is still in alpha stage, but maybe someone is
> interesed in unstable code?
>
> the module was built and tested with Digital Creations DCOracle, but i
> tried to avoid Oracle-specific extensions.

I would be interested in trying it on PostgreSQL

please let me know if you have any success. (probably we can use
wxPython and/or db-sig mailing list for that?)

cheers,
alex.

TableGrid.py (19.4 KB)

hello all!

oops! i did not intend to send large attachment to the mailing list.
please forgive me.

sorry,
alex.

···

_______________________________________________
wxPython-users maillist - wxPython-users@starship.python.net
http://starship.python.net/mailman/listinfo/wxpython-users

alexander smishlajev wrote:

Hannu Krosing wrote:
>
> > i have a module designed to edit data in an sql server table using
> > wxGrid-based window. it is still in alpha stage, but maybe someone is
> > interesed in unstable code?
> >
> > the module was built and tested with Digital Creations DCOracle, but i
> > tried to avoid Oracle-specific extensions.
>
> I would be interested in trying it on PostgreSQL

please let me know if you have any success. (probably we can use
wxPython and/or db-sig mailing list for that?)

your code uses a module called gettext, which i can't find anywhere ;(

Could you tell me where can I get it ?

···

---------------
Hannu

_______________________________________________
wxPython-users maillist - wxPython-users@starship.python.net
http://starship.python.net/mailman/listinfo/wxpython-users

Hannu Krosing wrote:

your code uses a module called gettext, which i can't find anywhere ;(

uhh... sorry. i told that it is alpha... <grin>

there is no such module, for a while. i saw recent discussions on that
topic, so i hope that it will appear sooner or later. if not, i will
have to create one myself because i am working with 3 different
languages. for now, my gettext.py is only a placeholder containing
single function. you can insert the following code into TableGrid.py:

try:
    from gettext import _
except:
    def _(string):
        return string

or just define empty _() function, as shown above.

the bigger problem is a debug module, which is used quite excessively.
it contains the following code:

=== begin cut ===
import string, traceback
from wxPython.wx import *

def trace(string, verbose=0):
  """when debugging, print a string"""
  if __debug__:
    if verbose: traceback.print_stack()
    print string

def show_error(msg):
  """show an error message"""
  dlg =wxMessageDialog(NULL, msg, 'Error', wxOK | wxICON_HAND)
  dlg.ShowModal()
  dlg.Destroy()

def show_exc():
  """show a message about exception occured"""
  (etype, value, tb) =sys.exc_info()
  tblist =traceback.extract_tb(tb)
  msg =string.join(traceback.format_exception_only(etype, value)
                  +traceback.format_list(tblist))
  print msg
  show_error(msg)
==== end cut ====

best wishes,
alex.

···

_______________________________________________
wxPython-users maillist - wxPython-users@starship.python.net
http://starship.python.net/mailman/listinfo/wxpython-users