MSSQL uses the same type of row_number() technique, so an update that works
with both would be great, if possible.
Just so I'm clear on this, the plan is to leave the row_number() usage, but
to auto-wrap queries using DISTINCT, is that right?
Thx,
Rick
Also be aware that the API to populate_instance() has changed (ironically,
the very thing that I was worrying about in the thread)
Update this:
def populate_instance(self, mapper, selectcontext, row, instance,
identitykey, isnew):
if isnew:
On Mar 26, 2008, at 1:34 PM, pyplexed wrote:
Hi all,
I'm a complete newcomer to SA, and I've tried to adapt an example I
found on-line to look a bit more like the problem I'm trying to solve.
If I save an object to my session, and then flush it, I'm getting an
error which Google can't
If we want to do it across the board for MS-SQL, we can. But I'm not
as confident in its usage as using a LIMIT keyword supplied by the
database. It would take a lot of testing to ensure it works in all
cases.
Agreed, but there's no version of MSSQL that supports either the LIMIT or
can you try my test script with an MS-SQL database and see what you
get ?
Works with no errors, column names quoted with square brackets.
Here's the echo output:
2008-03-26 15:11:41,342 INFO sqlalchemy.engine.base.Engine.0x..d4
CREATE TABLE [some table] (
[primary col] INTEGER NOT
hello friends,
is there a way to query a table object of all the relationships it's involved
with?
both onoe2many, many2one, many2many etc.
thanks in advance,
alex
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
On Mar 26, 11:46 pm, Crispin Wellington [EMAIL PROTECTED]
wrote:
select * from countries left join country_synonyms;
Here are my attempts and their results:
Session.query(Country).join(CountrySynonym).all()
InvalidRequestError: Mapper 'Mapper|Country|countries' has no property
'class