Re: [Sqlalchemy-users] Converting columns definition to formencode schema.

2006-08-09 Thread Tzahi Fadida
, at 6:28 AM, Tzahi Fadida wrote: > > Hi, > > I am trying to convert automatically a list of columns definition > > to a formencode schema. String,Integer,Float,Numeric,Binary > > were easy to convert, i.e. just the String(40), not empty, > > precision, length >

[Sqlalchemy-users] Converting columns definition to formencode schema.

2006-08-09 Thread Tzahi Fadida
it is the automatic side of things. For specifics i create custom validators, i.e., i am looking for one, to know if a DateTime is indeed a DateTime format that the database will accept, etc... 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.w

Re: [Sqlalchemy-users] Namespace possible bug.

2006-08-06 Thread Tzahi Fadida
t SA will never support CREATE SCHEMA, but its lower priority > since not every DB even supports CREATE SCHEMA and also SA is not > trying to be a replacement for DDLs. > > On Aug 5, 2006, at 6:11 PM, Tzahi Fadida wrote: > > I am using postgresql. > > When i use the schema ke

[Sqlalchemy-users] Namespace possible bug.

2006-08-05 Thread Tzahi Fadida
e/base.py", line 319, in _execute_raw File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 338, in _execute sqlalchemy.exceptions.SQLError: (ProgrammingError) schema "nis2" does not exist '\nCREATE TABLE nis2.users (\n\tuser_id SERIAL NOT NULL, \

Re: [Sqlalchemy-users] Pool bug?

2006-08-05 Thread Tzahi Fadida
def do_get(self): while True: try: return QueuePool.do_get(self) except TimeoutError: gc.collect() -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNI

Re: [Sqlalchemy-users] Pool bug?

2006-08-05 Thread Tzahi Fadida
t, i guess i can subclass the Queuepool but i am averse to using other lib internals. 10x. > > On Aug 5, 2006, at 10:30 AM, Tzahi Fadida wrote: > > OK, if i use gc.collect() it is released. > > Though i was very surprised that collect() takes so much time. > > I wonder if it

Re: [Sqlalchemy-users] Pool bug?

2006-08-05 Thread Tzahi Fadida
wrote: > On Aug 4, 2006, at 10:06 PM, Tzahi Fadida wrote: > > Anyway, if i believe there is a bug i am reporting it in case other > > bugs follows. > > > > I have tried what you described with and without threadlocal, and with > > explicitly deleting every object

Re: [Sqlalchemy-users] Pool bug?

2006-08-04 Thread Tzahi Fadida
egin a transaction and then > just let it fall away without managing its closure; it seems to > defeat the purpose of a transaction, which is, demarcation of a set > of operations. -- Regards, Tzahi. -- Tzahi Fadida Blog: http

Re: [Sqlalchemy-users] Pool bug?

2006-08-04 Thread Tzahi Fadida
On Saturday 05 August 2006 01:47, you wrote: > On Aug 4, 2006, at 7:24 AM, Tzahi Fadida wrote: > >> you can always make your own subclass of Session / SessionTransaction > >> that checks some kind of timeout value upon the next operation. > >> SessionTransaction is

Re: [Sqlalchemy-users] Pool bug?

2006-08-04 Thread Tzahi Fadida
On Friday 04 August 2006 08:29, Michael Bayer wrote: > On Aug 3, 2006, at 1:22 PM, Tzahi Fadida wrote: > > I am pretty convinced this is a bug. > > The normal way it should have worked is that all the new sessions > > should > > have got the timeouts exception. The rea

Re: [Sqlalchemy-users] Pool bug?

2006-08-03 Thread Tzahi Fadida
On Thursday 03 August 2006 17:47, Jonathan Ellis wrote: > On 8/3/06, Tzahi Fadida <[EMAIL PROTECTED]> wrote: > > I am trying to use sessions on a certain connection pool like so: > > > > from sqlalchemy import * > > import sqlalchemy.pool as pool > >

[Sqlalchemy-users] Pool bug?

2006-08-03 Thread Tzahi Fadida
ociate a session to a pool (for example, i assign a pool for operations that are expected to be very long like reports etc... that can occupy a connection for minutes or even hrs. and a pool for regular requests). 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.o

[Sqlalchemy-users] Blocking for connection + long transactions

2006-08-02 Thread Tzahi Fadida
replay the transaction with the new queries. How do i do that? -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS:  see at http://members.lycos.co.uk/my2nis/spamwarning.html

Re: [Sqlalchemy-users] help with data types (LONGVARCHAR)

2006-07-21 Thread Tzahi Fadida
ould look? > > Brian > > ----- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to sha

Re: [Sqlalchemy-users] Keeping two databases in sync

2006-07-12 Thread Tzahi Fadida
p;bid=263057&dat=121642 > ___ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users -- Regards, Tzahi. -- Tzahi Fadida Blog: http

Re: [Sqlalchemy-users] Keeping two databases in sync

2006-07-12 Thread Tzahi Fadida
ation? > Replication should really be handled at a lower level than SA. Most modern > DBs have a replication solution available. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS:  see at http://members.ly

[Sqlalchemy-users] Plans for beta release?

2006-07-12 Thread Tzahi Fadida
Is there a planned date/estimate for a beta release? For example, a feature freeze for a release version. I see that there is an effort to find all the bugs now instead of concentrating on features. P.s. is there a published roadmap on the web? 10x. -- Regards, Tzahi. -- Tzahi Fadida

Re: [Sqlalchemy-users] session objects and threads + savepoints + serializable

2006-07-03 Thread Tzahi Fadida
zero tolerance > for failures, something like Hibernate is much more mature; as SA is > hardly even beta, i cant say very much is "guaranteed" about it right > now. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop

Re: [Sqlalchemy-users] session objects and threads + savepoints + serializable

2006-07-02 Thread Tzahi Fadida
On Sunday 02 July 2006 18:11, you wrote: > On Jul 2, 2006, at 4:05 AM, Tzahi Fadida wrote: > > Finally, when operations are done on a session. when i do > > session.flush() are > > they guaranteed to be performed in order? at least when i use > > transactions. > &g

Re: [Sqlalchemy-users] Questions about metadata + validation + namespaces + serializing ORM

2006-07-02 Thread Tzahi Fadida
On Sunday 02 July 2006 18:21, Michael Bayer wrote: > On Jul 2, 2006, at 5:32 AM, Tzahi Fadida wrote: > > Hi, > > Sorry for the mass questions, i tried to concentrate these so as > > not to flood > > the mailing list :) : > > *How do i add a column to an existing

[Sqlalchemy-users] Questions about metadata + validation + namespaces + serializing ORM

2006-07-02 Thread Tzahi Fadida
ble *Using ORM, are there any security problems in serializing (pickling) a User() object (of users_table) and sending it to a client from the server? 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS:  see at h

[Sqlalchemy-users] session objects and threads + savepoints + serializable

2006-07-02 Thread Tzahi Fadida
i do session.flush() are they guaranteed to be performed in order? at least when i use transactions. 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS:  see at http://members.lycos.co.uk/my2nis/spamwarning.html Us

[Sqlalchemy-users] SQLAlchemy ready for production?

2006-07-01 Thread Tzahi Fadida
features for stability. 10x. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS:  see at http://members.lycos.co.uk/my2nis/spamwarning.html Using Tomcat but need to do more? Need to support web services, security? Get