Howdy,

I have a slightly modified firebirdconnect.py module that uses gvib (I need transaction support).

Anyway, just starting with a simple test.py module like this:

__connection__ = FirebirdConnection(host='nowhere.com',
                                     db='/usr/database/strader.gdb',
                                     user='xxxx',
                                     passwd='x13233',
                                     autoCommit=False)


class    Org(SQLObject):
    class sqlmeta:
        fromDatabase = True


Then, using sql-admin, like so:

sql-admin sql -m testgvib

I've fixed up a bunch of errors with col types, etc.

Now, what's odd is the sql that gets output, I get this:

CREATE TABLE org (
    id INT NOT NULL PRIMARY KEY,
    iscaimporte_r CHAR(1),
    isconsigne_e CHAR(1),
    isusimporte_r CHAR(1),
    isshippe_r CHAR(1),

(snip)

Debugging the fields actually extracted from the database, I get:

FIELD ISCAIMPORTER type 'TEXT' null None length 1 scale 0
name  ISCAIMPORTER
FIELD ISCONSIGNEE type 'TEXT' null None length 1 scale 0
name  ISCONSIGNEE
FIELD ISUSIMPORTER type 'TEXT' null None length 1 scale 0
name  ISUSIMPORTER
FIELD ISSHIPPER type 'TEXT' null None length 1 scale 0
name  ISSHIPPER

(where name is the kw['name'] value passed to colClass)

So, it looks like the name mangling is happening in the "to sql" process.

I'm using the default style, and latest trunk checkout from today.



--
Brad Clements,                bkc@murkworks.com    (315)268-1000
http://www.murkworks.com                         
AOL-IM or SKYPE: BKClements