[Sqlalchemy-users] MS SQL engine?

Hi, Has anyone started working on an MS SQL engine that uses pymssql or .. whatever? If not, can anyone suggest which of the existing engines would be the closest match that I can use to write one for ms sql? And .. tips or suggestions for engine writers? -- Brad Clements

[Sqlalchemy-users] firebird connection - does autoload work?

I am using 3.2 Kinterbasdb with latest svn sqlalchemy. I've defined tables using autoload, but primary_key = False in all the tables loaded. Also it doesn't seem to create foreign keys either. Anyone know if this is supposed to work with firebird? -- Brad Clements,[EMAIL

Re: [Sqlalchemy-users] firebird connection - does autoload work?

).. -- 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

Re: [Sqlalchemy-users] firebird connection - does autoload work?

. Are the sqlalchemy unit tests all in working order and they're all supposed to work with any engine? Which tests are best to start with when developing an engine? Any other tips for engine authors other than .. just subclass the AnsiSQLEngine? -- Brad Clements,[EMAIL PROTECTED

Re: [Sqlalchemy-users] Transactions and Sessions, proposal #2

be a loonngg time coming. I do not think this is going to change in later versions of Jython. I believe I've read a number of times that relying on __del__ for resource release is not recommended. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com

[Sqlalchemy-users] Compound foreign keys

I have tables with compound primary keys, like this: # table task # Individual task for a service task = Table('task', Column('system_id', Integer, primary_key=True, nullable=False, ), Column('id', Integer,

[Sqlalchemy-users] Firebird compound key mapper get fails

I am using svn update from today.. I am testing with Firebird engine, which I realize may be busted. However I just took a look at the MS-SQL engine and it does the same thing. I have a table with a compound key, like this: Tcontact = Table('contact', Column('system_id',

Re: [Sqlalchemy-users] Firebird compound key mapper get fails

Michael Bayer wrote: your last stack trace there is still using the firebird module. yes it is. Sorry my phrasing was poor. I should have said, gee, now I get this error in Firebird, so I will now switch to ms-sql. --- Using Tomcat but

[Sqlalchemy-users] rolling back or committing read-only transactions

clients to be blocked while they wait to see if I'm going to modify some data that has been read from some table. So, should I use engine.begin() , objectstore.commit() + engine.commit() and engine.rollback() in the middleware instead? -- Brad Clements,[EMAIL PROTECTED

Re: [Sqlalchemy-users] getting the global proxy engine for transaction management

=results, policy=self.policy) response = DataApp(response, content_type='text/xml') return response(environ, start_response) -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements

Re: [Sqlalchemy-users] Externally Maintained Thread pools and SA 0.2

can't see any benefit from renaming the close operation on execute() result sets. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements --- All

Re: [Sqlalchemy-users] Externally Maintained Thread pools and SA 0.2

for this functionality (obviously, it will be required by others as well). Awsome, thanks a ton! (I like the new website design. The font I think is easier to read too) -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE

[Sqlalchemy-users] Rough firebird.py diff for 0.21

I've only tested a very basic table.get() and table.select.. haven't tested updates. (attached) The following section of this message contains a file attachment prepared for transmission using the Internet MIME message format. If you are using Pegasus Mail, or any other MIME-compliant system,

Re: [Sqlalchemy-users] Rough firebird.py diff for 0.21

output? -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully

[Sqlalchemy-users] suggestion for threadlocal docs

that can specify the metadata object to use? -- Brad Clements, [EMAIL PROTECTED] (315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements

[Sqlalchemy-users] Class relationship diagram, howto write an Engine .. DB2

realize everyone is busy, so just tossing that out there as a wishlist item.. some notes / tips for engine writers so we could get more engines supported. Is anyone else working on DB2 support? -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com

Re: [Sqlalchemy-users] suggestion for threadlocal docs

need to import it. leaving out metadata didn't work. I got errors because something was looking for 'engine' attribute on the first column object. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements

[Sqlalchemy-users] getting extra engine params from url

it.. In fact, nothing does. looks like I need to submit a patch for url.py to allow extra args to get parsed out of a url. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements

[Sqlalchemy-users] possible bug in db.execute handling of positional args

InterfaceError: (0, 'Input parameter container must be a non-string sequence.') same problem in test_column_order_with_text_query -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements

[Sqlalchemy-users] test_column_accessor_shadow

mechanism (perhaps an arg passed to Column()) that can be used to declare a column as hidden.. This way other databases could use this feature as well (and pass the test). -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL

[Sqlalchemy-users] mapper / testcount

the engine needs a crack at changing count.. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements --- All the advantages of Linux Managed Hosting

[Sqlalchemy-users] Better Firebird patch and test patches

to do with the engine under test. It would be helpful to know which tests were in-progress in the trunk and which were are supposed to work.. thanks! -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE

Re: [Sqlalchemy-users] Better Firebird patch and test patches

, 30 May 2006 21:05:26 -0400 To: Brad Clements [EMAIL PROTECTED] ok what do you want here, dbengine://user:[EMAIL PROTECTED]:port/database? opt=valopt=val ? as long as its good with RFC1738. did you send me a patch ? i lost track today. also how do you want to approach

[Sqlalchemy-users] firebird patch for datetime

I think this patch got lost. it fixes Firebird so that Date columns are not treated like DateTime columns. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements The following section of this message

[Sqlalchemy-users] objectstore.flush leads to InvalidRequestError(This Connection is closed)

This code used to work, but I think a recent svn up busted it. Now using Rev 1577 I am using sqlalchemy.mods.threadlocal I execute the following code multiple times within a single process invocation. objectstore is sqlalchemy.objectstore. If I comment out the objecstore.flush() call, then

[Sqlalchemy-users] Firebird Patch supports type_conv and concurrency_level

This patch adds support for kinterbasdb.init() args specified in the dburi type_conv (defaults to 200) concurrency_level (defaults to 1) usage would be like dburi = firebird://sysdba:[EMAIL PROTECTED]:someport/path/database.gdb?type_conv=200concurrency_level=1 Index:

Re: [Sqlalchemy-users] Firebird Patch supports type_conv and concurrency_level

-- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements ___ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists

[Sqlalchemy-users] strange initialization problem with latest trunk

is performed. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make

Re: [Sqlalchemy-users] strange initialization problem with latest trunk

On 26 Jun 2006 at 15:30, Michael Bayer wrote: I made a change that should fix this in changeset 1660. It appears to be fixed, thanks -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements Using

[Sqlalchemy-users] mapper.options - attribute error

: 'PropertyLoader' object has no attribute 'argument' What am I doing wrong? -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements Using Tomcat but need to do more? Need to support web services

Re: [Sqlalchemy-users] mapper.options - attribute error

and hey, it does what I want. Probably works because I'm accessing the __dict__ directly rather than going through the object's __getitem__ or __getattr__ -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE

Re: [Sqlalchemy-users] SQLAlchemy 0.2.4 released - Firebird Patch missing?

I see my last Firebird patch still hasn't been applied. It's the one that adds support for type_conv I submitted it 2 or 3 times already. I've attached it again. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM

Re: [Sqlalchemy-users] SQLAlchemy 0.2.4 released - Firebird Patch missing?

there. No matter. (hm thought you were in the users file...i can set you up with that) I don't think that's necessary, I'm happy to have others vet my patches before applying them. ;-) -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com

[Sqlalchemy-users] mapper extension before_insert / before_update busted

update %r % instance update_contact_soundex_name(instance) inserting a new record or updating an existing record.. All I see for output is in contact extension init It seems before_insert and before_update are not being called. -- Brad Clements, [EMAIL PROTECTED] (315)268-1000 http

Re: [Sqlalchemy-users] mapper extension before_insert / before_update busted

and will look at this tomorrow. I wonder if there's some funkiness with module name checking at some point.. I just don't know I will send you some stuff directly. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM

[Sqlalchemy-users] table.drop docs off a bit

(engine=e) TypeError: drop() got an unexpected keyword argument 'engine' But this is taken directly from the online docs.. Apparently create and drop expect a positional argument, not a keyword. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com

[Sqlalchemy-users] using func.count with session

just session.query(Order).select([func.count(Order.c.id)]) gives the same error. I'll just use connection.execute() I guess.. But I'm curious if this is a docs issue, or I'm doing something wrong. -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com

Re: [Sqlalchemy-users] ID generator

this: TWarehouse = Table('Warehouse', metadata, Column('id', Integer, Sequence('w_id'), primary_key=True, nullable = False), Column('name', String(32), nullable = False), ) Sorry if this is not what you're talking about -- Brad Clements

[Sqlalchemy-users] calling create_engine multiple times with same connection string

to the engine) -- So back to the original question, did at one time create_engine return the same engine object for same connection string? -- Brad Clements,[EMAIL PROTECTED](315)268-1000 http://www.murkworks.com AOL-IM or SKYPE: BKClements