[sqlalchemy] COPY

2007-07-23 Thread Etienne Marache
Hello, Althought the following code works, I think it can be improved. Unfortunatly my mastering of SQLalchemy is not perfect. Thank you to all those who can help me. db = create_engine('postgres://@localhost/test') metadata = BoundMetaData(db) users = Table('users',metadata Column('user

[sqlalchemy] Re: Insert through ORM performance (was: Performance question)

2007-07-23 Thread michael
As has been noted in the thread, if you really want speed in bulk inserts, remove all the layers and go directly to the database. Sorry if this is repeated, I did not see it in the thread.. regardless of db engine; bulk inserts almost always go faster if you: drop indexes => insert bulk

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
which python reference (url?) are you speaking of? how does 'import_fullname' work? how would it be applied? On Jul 21, 11:35 am, [EMAIL PROTECTED] wrote: > > In other words, should I first attempt to > > __import__('vor.'+modname) in runJob() ? > > see the python reference about how to use __imp

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread svilen
On Monday 23 July 2007 16:45:15 Jesse James wrote: > which python reference (url?) are you speaking of? > how does 'import_fullname' work? how would it be applied? aaah, u are _that_ new... - use it instead of the __import__() func - original python library reference of the version u use; e.g.

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
> aaah, u are _that_ new... > - use it instead of the __import__() func > - original python library reference of the version u use; > e.g.http://docs.python.org/lib/built-in-funcs.html > > wow there's a level parameter now... somethin to try I'm not using 2.5 (2.4 still). I tried the 'my_import

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
Ok, I just tried something that actually worked. WOO HOO! First, I appended the sys.path var like this (relative, was absolute before): sys.path.append( 'vor') combined with this: ... module = my_import('vor.'+modname) ... I realize that this is not ideal. But I'

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread svilen
On Monday 23 July 2007 17:52:51 Jesse James wrote: > > aaah, u are _that_ new... > > - use it instead of the __import__() func > > - original python library reference of the version u use; > > e.g.http://docs.python.org/lib/built-in-funcs.html > > > > wow there's a level parameter now... somethi

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
> -3: 2.5 or 2.4 all the same (Except abs/rel imports which still dont > work in 2.5 anyway). > -2: u need my_import (or similar) because __import__( 'vor.model') > will not give u want u want. > -1: u need to give _same_ full absolute paths to __import__ (or > substitute) or else u'll get duplic

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread svilen
> 1: At least I'm in a working context...since I will be the user of > this jobs module 90% of the time for a while, I'll have a fighting > chance of refining it further to handle the other things you allude > to. have fun then. As for the $100... give them to someone in _need_ (the mall is not i

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread svilen
> First, I appended the sys.path var like this (relative, was > absolute before): > sys.path.append( 'vor') IMO u should not touch sys.path unless u really really have no other chance. Although this above is another wholesale solution to your initial problem (and no need of my_imports et

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
On Jul 23, 10:33 am, svilen <[EMAIL PROTECTED]> wrote: > > First, I appended the sys.path var like this (relative, was > > absolute before): > > sys.path.append( 'vor') > > IMO u should not touch sys.path unless u really really have no other > chance. Although this above is another whole

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
On Jul 23, 10:33 am, svilen <[EMAIL PROTECTED]> wrote: > > First, I appended the sys.path var like this (relative, was > > absolute before): > > sys.path.append( 'vor') > > IMO u should not touch sys.path unless u really really have no other > chance. Although this above is another whole

[sqlalchemy] SQLError

2007-07-23 Thread kwarg
SQLAlchemy has "wanderful" documentation in many perspectives ... Does anybody know what is the interface of sqlalchemy.exceptions.SQLError exception? I mean properties/attributes/methods. The following is totally useless: http://www.sqlalchemy.org/docs/sqlalchemy_exceptions.html#docstrings_sqlalc

[sqlalchemy] Re: SQLError

2007-07-23 Thread Michael Bayer
On Jul 23, 2007, at 4:35 PM, kwarg wrote: > > SQLAlchemy has "wanderful" documentation in many perspectives ... Does > anybody know what is the interface of sqlalchemy.exceptions.SQLError > exception? I mean properties/attributes/methods. > The following is totally useless: > http://www.sqlalche

[sqlalchemy] Model to Dictionary

2007-07-23 Thread HiTekElvis
Anybody know a way to change a model into a dictionary? For those to whom it means anything, I'm hoping to pass that dictionary into a formencode.Schema.from_python method. Any ideas? -Josh --~--~-~--~~~---~--~~ You received this message because you are subscri

[sqlalchemy] Re: Data types specific to engines

2007-07-23 Thread Jonas
Thank you very much! :) On 19 jul, 18:11, Michael Bayer <[EMAIL PROTECTED]> wrote: > i just put up a little bit of new docs to this effect. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To pos

[sqlalchemy] parley - library for distributed systems

2007-07-23 Thread Jonas
Parley [1] is a library for writing Python programs that implement the Actor model of distributed systems. I comment it here because perhaps could be usefull to SQLAlchemy to let a better access (more distributed) to several data bases. [1] http://www.python.org/pypi/parley/ --~--~-~--