That would be me. It's currently misbehaving on binary / unicode data with pymssql, but I was considering posting it anyway for experimental work, as I'm getting tired of resolving conflicts on each "svn up".

Mike, on my working copy I've currently setup SqlServer IDENTITY columns to use a new class in schema.py like so:

class Identity(DefaultGenerator):
    """ represents an identity property, a sort of implicit sequence object, used by Microsoft SQL Server """
    def __init__(self, start = 1, increment = 1):
        super(Identity, self).__init__()
        self.start = start
        self.increment = increment

    def __repr__(self):
        return "IDENTITY(%s,%s)" % (self.start, self.increment)

    def _set_parent(self, column):
        super(Identity, self)._set_parent(column)
        column.identity = self

    def accept_schema_visitor(self, visitor):
        """calls the visit_sequence method on the given visitor."""
        return visitor.visit_identity(self)


....I was on the fence for a bit about creating a new explicit Identity() class, or shoehorning it into the Sequence() class, which already does have the needed start and increment attributes.......any thoughts on that?

Rick


On 3/28/06, Brad Clements <[EMAIL PROTECTED]> wrote:
On 26 Mar 2006 at 16:52, Michael Bayer wrote:

> firebird doesnt work at all right now AFAIK...if it actually did some
> things correctly, thats great news.   the creator/maintainer of the
> module has been on vacation until this week, and has not yet gotten
> around to the initial testing of the module which I committed into
> SVN for him a few weeks ago.

Who is working on the firebird module?

I suppose in the meantime I could switch to MS Sql server for a bit.. I forgot now
who was working on that as well..





--
Brad Clements,                [EMAIL PROTECTED]    (315)268-1000
http://www.murkworks.com
AOL-IM or SKYPE: BKClements




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to