14th February, 2010

Gerald release 0.3.6

Filed under: database,python — admin @ 2:06 pm

I have just released version 0.3.6 of Gerald. Gerald is a general purpose database schema toolkit written in Python.

This release was at the request of the sqlpython project and contains only one change. A new convenience method connect has been added to the Schema class. This enables a schema to be initiated and then later have a database connection associated with it. Because this changes the public API of gerald I’ve released this under a new version number.

Development, bug and issue tracking and the project wiki are available on the project Trac site. Source code and distribution files are available at the sourceforge page.

The next release will be 0.4. Exactly what will make up that release is still evolving, although it is likely to feature SQL Server support as I have just started a new job and all of the systems there use it. To see what else is in the release and to track progress take a look at the version 0.4 roadmap.

2 Comments

  1. Hey Andy,

    Sorry if this is not in context but I thought that since you are the dev for gerald I thought this would be the best place to ask ;). Anyway, I am using Sqlpython and gerald 0.3.6 but it seems to be having trouble with getting the metadata. I followed you advice from the sqlpython google group to apply that patch to gerald which does seem to have gotten it further but but it still fails on the same thing which is “_DEFAULT_AUDITING_OPTIONS_”.

    I would really appreciate some help because atm I cannot really do anything with it as i cannot even do desc table because of the metadata problem. Could this have something to do with the perms that the user has connecting to the db??? Because as a dev in corporate sector I will never have full dba assess to the oracle db’s??

    Anyway, here is my error in full detail:

    [me@lcs ~]$ sqlpython user/pass@dbalias
    /bin/sh: xclip: command not found
    /usr/bin/vim
    0:user@dbalias> Exception in thread Thread-1:
    Traceback (most recent call last):
    File “/System/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/threading.py”, line 522, in __bootstrap_inner
    self.run()
    File “/Library/Python/2.6/site-packages/sqlpython-1.7.1-py2.6.egg/sqlpython/connections.py”, line 277, in run
    newgerald = gerald_classes[self.db_instance.rdbms](self.db_instance.username, self.db_instance.conn_data.gerald_uri())
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/schema.py”, line 97, in __init__
    self.schema = self._get_schema(self._cursor)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/oracle_schema.py”, line 168, in _get_schema
    self._set_unless_fail(schema, table_key, table_name, Table, cursor, owner)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/schema.py”, line 232, in _set_unless_fail
    schema[key] = object_type(object_name, *args)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/schema.py”, line 324, in __init__
    self._get_table(cursor)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/oracle_schema.py”, line 287, in _get_table
    raise AttributeError, “Can’t get DDL for table %s” % uc_table_name
    AttributeError: Can’t get DDL for table _DEFAULT_AUDITING_OPTIONS_

    Comment by David Binney — 06/05/2010 @ 6:02 pm

  2. Hey Andy,

    Sorry if this is not in context but I thought that since you are the dev for gerald I thought this would be the best place to ask ;). Anyway, I am using Sqlpython and gerald 0.3.6 but it seems to be having trouble with getting the metadata. I followed you advice from the sqlpython google group to apply that patch to gerald which does seem to have gotten it further but but it still fails on the same thing which is “_DEFAULT_AUDITING_OPTIONS_”.

    I would really appreciate some help because atm I cannot really do anything with it as i cannot even do desc table because of the metadata problem. Could this have something to do with the perms that the user has connecting to the db??? Because as a dev in corporate sector I will never have full dba assess to the oracle db’s??

    Anyway, here is my error in full detail:

    [me@lcs ~]$ sqlpython user/pass@dbalias
    /bin/sh: xclip: command not found
    /usr/bin/vim
    0:user@dbalias> Exception in thread Thread-1:
    Traceback (most recent call last):
    File “/System/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/threading.py”, line 522, in __bootstrap_inner
    self.run()
    File “/Library/Python/2.6/site-packages/sqlpython-1.7.1-py2.6.egg/sqlpython/connections.py”, line 277, in run
    newgerald = gerald_classes[self.db_instance.rdbms](self.db_instance.username, self.db_instance.conn_data.gerald_uri())
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/schema.py”, line 97, in __init__
    self.schema = self._get_schema(self._cursor)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/oracle_schema.py”, line 168, in _get_schema
    self._set_unless_fail(schema, table_key, table_name, Table, cursor, owner)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/schema.py”, line 232, in _set_unless_fail
    schema[key] = object_type(object_name, *args)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/schema.py”, line 324, in __init__
    self._get_table(cursor)
    File “/Library/Python/2.6/site-packages/gerald-0.3.6-py2.6.egg/gerald/oracle_schema.py”, line 287, in _get_table
    raise AttributeError, “Can’t get DDL for table %s” % uc_table_name
    AttributeError: Can’t get DDL for table _DEFAULT_AUDITING_OPTIONS_

    Comment by David Binney — 06/05/2010 @ 6:02 pm

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress