[sqlalchemy] Re: list of strings/unicode strings

2007-02-08 Thread Robert Gravina
On Feb 7, 2007, at 9:43 PM, Sébastien LELONG wrote: Is there anyway I can specify the list of tags like this, instead? book.tags = [upython, uprogramming] Well you could use a PickleType column in your book table... Of course, you'll loose functionnalities you could have using a real

[sqlalchemy] Re: list of strings/unicode strings

2007-02-08 Thread Robert Gravina
On Feb 8, 2007, at 5:38 AM, Christopher Arndt wrote: Cliff Wells schrieb: You could use another table for maintaining the tags and a property for maintaining them, like Lee does here: http://www.splee.co.uk/2006/10/28/simpleblog-part-3-many-to-many- relationships/ Here's another

[sqlalchemy] FlushError: Can't change the identity of instance

2007-02-08 Thread jose
Hi, Could please, someone tell me what the following error means? FlushError: Can't change the identity of instance [EMAIL PROTECTED] in session (existing identity: (class 'sicer.model.fatturazione.Prestazione', (6,), None); new identity: (class 'sicer.model.fatturazione.Prestazione',

[sqlalchemy] Re: FlushError: Can't change the identity of instance

2007-02-08 Thread svilen
somehow u've managed to have 2 copies of same persistent-object - which should not happen; how did u get it? I don't know. can u prepare some short testcase ? and/or wait for those who know... one has unicode-string '6', another one has int 6 instead - some conversion failing? what is

[sqlalchemy] Re: py2exe sqlalchemy

2007-02-08 Thread Oleg Deribas
Hello, Something Special said the following on 08.02.2007 13:22: they should put this help somewhere on main page, or fix it:) Michael, would you accept such patch? -- Oleg --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[sqlalchemy] Re: SelectResults and GROUP_BY or DISTINCT?

2007-02-08 Thread isaac
Thanks, that looks like it will help. Hope the next release is soon. :) On Feb 8, 2007, at 3:09 AM, King Simon-NFHD78 wrote: I don't use postgres, so I don't know for certain, but that error message looks like the one described in this message:

[sqlalchemy] Re: Adding with (nolock) to all queries (mssql)

2007-02-08 Thread Rick Morrison
Pymssql, or adodbapi? Client-side cursors, or Server-side? We use pymssql here over FreeTDS with SQL Server 2005 here without issues. If your DBA suggests with (nolock), I'm assuming that you're seeing some sort of persistent table/page locks? Can you give a bit more info? On 2/8/07, Arnar

[sqlalchemy] Re: Adding with (nolock) to all queries (mssql)

2007-02-08 Thread Arnar Birgisson
Hi Rick, On 2/8/07, Rick Morrison [EMAIL PROTECTED] wrote: Pymssql, or adodbapi? Client-side cursors, or Server-side? Pymssql and client side cursors (I guess, I'm just issuing plain select statements, no stored procs or such). We use pymssql here over FreeTDS with SQL Server 2005 here

[sqlalchemy] automatically massaging string fields

2007-02-08 Thread metaperl
Hello, I want to take any string fields in my resultset and do the following to them before writing them out to CSV: unicodedata.normalize('NFKD', s).encode('ASCII', 'ignore') I dont really think my SA program is necessary, but may as well include it to be safe: #!/usr/bin/env python

[sqlalchemy] Re: Adding with (nolock) to all queries (mssql)

2007-02-08 Thread Rick Morrison
Pymssql runs on top of the ancient library DB-lib, which has real issues with not fully reading all query results -- make sure all your query results are fully consumed, i.e. read them into a list and the iterate that instead of partially iterating the cursor. On 2/8/07, Arnar Birgisson [EMAIL

[sqlalchemy] Re: Adding with (nolock) to all queries (mssql)

2007-02-08 Thread Arnar Birgisson
Ok. Should I rather be using adodbapi then? Arnar On 2/8/07, Rick Morrison [EMAIL PROTECTED] wrote: Pymssql runs on top of the ancient library DB-lib, which has real issues with not fully reading all query results -- make sure all your query results are fully consumed, i.e. read them into a

[sqlalchemy] Re: Adding with (nolock) to all queries (mssql)

2007-02-08 Thread Rick Morrison
If you're using FreeTDS, I assume you're on some kind of Unix. As far as I know, adodbapi is Windows-only (anyway, it has its own set of idiosyncrasies too). On 2/8/07, Arnar Birgisson [EMAIL PROTECTED] wrote: Ok. Should I rather be using adodbapi then? Arnar On 2/8/07, Rick Morrison

[sqlalchemy] Re: Adding with (nolock) to all queries (mssql)

2007-02-08 Thread Rick Morrison
Yeah sorry, I should have caught that. On the pymssql vs. adodbapi, the answer is not an easy question, and is quite a mixed bag. MS supports ADO (at least for now), and no longer supports DB-Lib, so from that standpoint adodbapi would be the way to go, at least as regards the toolchain from

[sqlalchemy] Re: new setuptools vs local SA copy

2007-02-08 Thread Kumar McMillan
put a file -pythonpath.pth into your site_packages folder: import os, sys; sys.__egginsert=len(os.environ.get('PYTHONPATH', '').split(os.pathsep)); duly noted for future usage _when_ i meet an egg. workingenv, as Simon King mentioned, is the way to go. At my company we share a dev

[sqlalchemy] Object-oriented engine?

2007-02-08 Thread chmod
Has anyone tried making an engine for an OODB? My company is heavily ties into Versant, and we'd love to use SQLAlchemy if possible. Is this even a valid thought? Versant doesn't support SQL, most of its calls are graph navigation. getchild(), getparent(), getattr() etc... Is this worth

[sqlalchemy] Re: Detecting an update/insert/delete in the current session

2007-02-08 Thread Paul K
Well...I thought that indicated data in the session has changed--even if session.save() hasn't been called. I was hoping that there was a way to tell if a flush *had* occurred (sometime in the past). I guess I could use a decorator on flush(), right? On Feb 8, 10:43 am, Jonathan Ellis [EMAIL