A possible workaround is switch to firebird 2.0 now, is very close to
final release, largely backward compatible and accepts "AS" in table
aliasing
Ezio
Roger Demetrescu wrote:
Yes... I don't have SA here now, but probably the example from [1]
won't work either.
I'll try it tomorrow mornin
Hello,
Michael Bayer said the following on 05.10.2006 1:11:
> soon. im waiting for SF to fix this one, its taken them awhile to
> realize theres a problem. two things i dont like about google
> groups is that i cant have an archive of the existing SA mail
> imported into it,
Yes, but i
On 9/27/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
> this needed an adjustment to the EagerLoader's determination of what
> table it should attach its outerjoin onto, which you can see in
> changeset 1907 (and some more in 1909). I converted the test program
> into a new unittest suite for eager
Yes... I don't have SA here now, but probably the example from [1]
won't work either.
I'll try it tomorrow morning and let you know
Cheers,
Roger
[1] - http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_alias
On 10/5/06, Lele Gaifax <[EMAIL PROTECTED]> wrote:
> Ezio Vernacotola wrot
Hi Ezio,
I have the following code:
8<
duplicata_table = Table('DUPLICATA', metadata,
Column('dpl_loja', String(2), primary_key=True),
Column('dpl_id', Integer, Sequence('GEN_DPL_ID'), primary_key=True),
Column('dpl_ticket', Integer),
Column('dp
Ezio Vernacotola wrote:
> I don't understand what you are trying do to with column and table aliasing.
> Can you give some code example to better explain your problem?
>
I think it is not relevant: effectively Firebird does not like the table
alias introduced by "AS", so most probably the FB bac
test received
On 10/2/06, mike bayer <[EMAIL PROTECTED]> wrote:
> this is a test.
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opi
I don't understand what you are trying do to with column and table aliasing.
Can you give some code example to better explain your problem?
Ezio
Roger Demetrescu wrote:
> Hi,
>
> Firebird 1.5 allows the following sentences:
>
> select myfield from mytable;
> select myfield FOO from my table;
Hi,
I'd really like to use the version_id_col argument to mapper, via the
ActiveMapper extension.
>From what I can see, lines 268 and 271 of activemapper.py need to be
modified to pass through user specified keywords.
I'm not familiar with metaclass programming, and I'm not sure about
the best a
I have a scenario where one column in a table is involved in two foreign
keys. Getting some erronous results, pondering whether it is currently
supported. The code below explains the point.
from sqlalchemy import *
from sqlalchemy.ext.assignmapper import assign_mapper
from sqlalchemy.ext.session
Dear SQLAlchemists,
I'm using SA 0.2.8 with MySQL and experiencing problems with connections
timeout ("MySQL server has gone away"). As of 0.2.8, there is a pool_recycle
option which ensures connections are beeing recycled when a given amount of
time has passed. The problem is not all connecti
soon. im waiting for SF to fix this one, its taken them awhile to
realize theres a problem. two things i dont like about google
groups is that i cant have an archive of the existing SA mail
imported into it, and also im not sure if it has much of a method to
get an export of everything i
Time to move to Google Groups? :)
On 10/3/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
> test
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to shar
Hello,I'm having some issues when I try to put an identically named bind parameter into two selects, and then union them.from sqlalchemy import *meta = DynamicMetaData()# I have these two tables:
users = Table('users', meta, Column('id', Integer, primary_key = True), Column('user_name', S
hey list -
there is a known issue on sourceforge regarding mail from gmail.com
getting to the list. but are other email addresses failing as
well ? if so, please email me directly at mike_mp (at)
zzzcomputing.com so i have some idea of what the status is.
- mike
This is probably standard SQL but I can't figure it out.
I have a simple arrangement in SQLAlchemy.
There are 4 tables:
item_table --> mapped to Item
section_table --> "" Section
keyword_table --> "" Keyword
itemkeyword_table
There is a many-to-many relationship between item and keyword
contain
I'm using the mapper and Table classes from SQLAlchemy 0.2.8 to build
a simple user registration table and mapping. Im using Postgresql 8.1
as the RDBMS and am using TurboGears 1.0b1 to work with SQLalchemy.
I'm getting an exception when I try to update a row, even though my
code is very similar t
In my program I got this error message:
Error: (ProgrammingError) ERROR: could not serialize access due to
concurrent update
I know why the message appears (found the reason in the postgresql
docs), but is there any solution in sqlalchemy for this problem?
By the way: I'm using mapped objects a
Hi, I'm developing a web app. using SA in my DB layer.
I can't find any definitive documentation for using cross database
sequence types within SA. Is there any best practice for implementing
a custom solution for this in SA?
On a different note, after a bit of research I found that SA has built
That's very nice Mike. I think that will definitely help with the confusion
over threadlocal and friends. Just one nitpick--the first paragraph under
SessionContext could say
"This plugin is used to instantiate and manage Session objects. As of
SQLAlchemy 0.2 it is the preferred way to provide
this is a test.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://w
In my program I got this error message:
Error: (ProgrammingError) ERROR: could not serialize access due to
concurrent update
I know why the message appears (found the reason in the postgresql
docs), but is there any solution in sqlalchemy for this problem?
By the way: I'm using mapped objects
When I tried to download/install I first used easy_install,
this put a .egg file in site-packages/ no source .py files. So I tried to get
the .gz file and unzipped it, ran setup.py install and that built the product
in place but didn’t copy the tree with examples, docs sources etc to
site-
Hi,
Firebird 1.5 allows the following sentences:
select myfield from mytable;
select myfield FOO from my table;
select myfield AS FOO from mytable;
(the last 2 sentences change the name of the final column, right ?)
The same rules don't apply when we create tables aliases:
select myfield from
On Mon, 2 Oct 2006, Dennis wrote:
> The "IN" comparison functionality only works if I pass the data in
> without a list.
>
> Examples:
> (broken)
> >>> sel=select([categories.c.id],categories.c.parent_id.in_ ( [1,34] ))
> >>> str(sel)
> 'SELECT categories.id \nFROM categories \nWHERE categories.pa
25 matches
Mail list logo
