Hi,
VulnResDesc.mapper.add_property('rawvulns', sao.relation(VulnRes.mapper,
primaryjoin = sa.and_(VulnRes.targetid == VulnResDesc.targetid,
VulnMap.vulndescid == VulnResDesc.id,
VulnMap.tool == VulnRes.tool,
Hi,
I still don't quite understand this I'm afraid, I though there were more
columns involved - VulnResDesc.id, VulnRes.tool, VulnRes.toolvulnid.
So you know, this isn't urgent now. I've rewritten the mapper property as a
property on my class, and that works straight off, without any voodoo.
Only for the record: I just noticed that another simple workaround is
ordering by something like start_date is not null, start_date,
end_date is null, end_date. SA could also implement nullsfirst()/
nullslast() that way if the database engine does not support nulls
first/nulls last.
Lukasz Szybalski wrote:
I have mysqldb installed in the system wide install how do I tell
virtualenv to use it?
I don't see a need to install it in virtualenv again so I guess I just
have to givea right path? How, and in which file?
Thanks,
Lucas
File
Hi!
I have following situation: I have 3 tables which stand as a base for
other stuff:
table_virtual_categories = Table(virtual_categories, meta,
Column(id, Integer, primary_key = True),
Column(id_parent, Integer, ForeignKey(virtual_categories.id)),
Column(visible, Boolean,
and you mappers look like?
why u need to inherit articles at all then? just use the base..
On Tuesday 10 June 2008 15:34:21 ml wrote:
Hi!
I have following situation: I have 3 tables which stand as a base
for other stuff:
table_virtual_categories = Table(virtual_categories, meta,
g'day.
i stepped on strange behavour (0.4 latest):
class AB is an assoc proxy, .myb pointing to B;
the clause
AB.myb == B.dbid
fails with NotImplementedError:
File sqlalchemy/sql/expression.py, line 1191, in __eq__
return self.operate(operators.eq, other)
File
On Jun 10, 2008, at 4:29 AM, Paul Johnston wrote:
Hi,
VulnResDesc.mapper.add_property('rawvulns',
sao.relation(VulnRes.mapper,
primaryjoin = sa.and_(VulnRes.targetid == VulnResDesc.targetid,
VulnMap.vulndescid == VulnResDesc.id,
manytoone should be fine. try making a simplified test case (just any
old many to one).
On Jun 10, 2008, at 9:39 AM, [EMAIL PROTECTED] wrote:
g'day.
i stepped on strange behavour (0.4 latest):
class AB is an assoc proxy, .myb pointing to B;
the clause
AB.myb == B.dbid
fails with
On Jun 10, 2008, at 8:34 AM, ml wrote:
So as you can see the table articles is quite redundant because it
has
only the primary key column but I didn't find any other way to select
articles directly from the table virtual_items according to the
column
kind without joining to another
that's it! great, thanks!
Michael Bayer napsal(a):
On Jun 10, 2008, at 8:34 AM, ml wrote:
So as you can see the table articles is quite redundant because it
has
only the primary key column but I didn't find any other way to select
articles directly from the table virtual_items
On Tue, Jun 10, 2008 at 6:12 AM, King Simon-NFHD78
[EMAIL PROTECTED] wrote:
Lukasz Szybalski wrote:
I have mysqldb installed in the system wide install how do I tell
virtualenv to use it?
I don't see a need to install it in virtualenv again so I guess I just
have to givea right path? How,
On Jun 10, 10:34 am, Malthe Borch [EMAIL PROTECTED] wrote:
I have an issue with SQLAlchemy planning to execute insertion tasks in
the wrong order.
Basically, I have a utility table Relations which is used to maintain
ordered list relations:
table = rdb.Table(
'relation',
Michael Bayer wrote:
A self-referential relationship, when configured as many-to-one,
requires the remote_side argument to indicate this, as described in
http://www.sqlalchemy.org/docs/04/mappers.html#advdatamapping_relation_selfreferential
. Otherwise it defaults to one-to-many.
That
this should be straightforward, I think...
I'm trying to do
select email_address from user where is_verified is not true
( or is not null or is not false )
This part is simple :
Session.execute( sqlalchemy.select( [ User.c.email ] ) )
This part is not:
Session.execute(
funny... just a plain relation, i've removed all the assoc stuff...
what i am missing???
here the case, attached.
no matter what, i doesnot work; older sa versions give different
error...
On Tuesday 10 June 2008 16:59:01 Michael Bayer wrote:
manytoone should be fine. try making a simplified
Hi Binglmar
I have replied to your post on IBM_DB Forum. Please Check out if you
have missed it on
http://groups.google.com/group/ibm_db/browse_thread/thread/4095e6ecfde7e63/535519afa04bf5db?hl=en#535519afa04bf5db
Kindly let us know your thoughts.
Thanks and Regards
Tarun Pasrija
On Jun 8,
Hi.
I'm using Python 2.5.1 + SQLAlchemy + Psyco 1.6 for accelerating
Python computations. Everything works ok for SQLAchemy 0.4.4 (50%
performance boost), but for SQLAlchemy 0.4.5, 0.4.6 and latest SVN
version (0_4 branch) there is a huge slowdown and profiling shows that
SA's code takes much
would need to see mappings.
On Jun 10, 2008, at 11:06 AM, Malthe Borch wrote:
Michael Bayer wrote:
A self-referential relationship, when configured as many-to-one,
requires the remote_side argument to indicate this, as described in
Hi,
My development team and me are working in a application to migrate Oracle
databases to PostgreSQL databases, and we need this information to do this.
I've done successful migrations using autocode,
http://code.google.com/p/sqlautocode/
The procedure, roughly is:
1) Use autocode to
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of lilo
Sent: 10 June 2008 17:23
To: sqlalchemy
Subject: [sqlalchemy] select db engine with create_session
can someone tell me how session chooses the right db engine to insert
records in
On Tuesday 10 June 2008 20:22:08 Paul Johnston wrote:
Hi,
My development team and me are working in a application to migrate
Oracle databases to PostgreSQL databases, and we need this
information to do this.
I've done successful migrations using autocode,
what DB backend ? often you can just compare to 1 or 0.
On Jun 10, 2008, at 12:03 PM, Jonathan Vanasco wrote:
this should be straightforward, I think...
I'm trying to do
select email_address from user where is_verified is not true
( or is not null or is not false )
This part is
these two stack traces appear to show completely different operations
proceeding (in one its a flush with a delete occuring, the other its
performing an INSERT or UPDATE).
my vague understanding of psyco is that it can be quite arbitrary as
to what kind of code it can improve and what
these are the valid comparisons:
print AB.this == A()
print AB.this_id == A.name
On Jun 10, 2008, at 8:32 AM, [EMAIL PROTECTED] wrote:
funny... just a plain relation, i've removed all the assoc stuff...
what i am missing???
here the case, attached.
no matter what, i doesnot work; older
On Jun 10, 8:11 pm, Michael Bayer [EMAIL PROTECTED] wrote:
I would first take a look at the SQL
being issued as the first source of speed differences; if in 0.4.5
there's suddenly a whole series of deletes occuring which do not
within 0.4.4, then that's the source of the difference.
these are the valid comparisons:
print AB.this == A()
mmh. i want these to be clauses, not plain comparisons
i.e. AB.this==A.dbid --- same as tableAB.c.this==tableA.c.dbid
instead it produces something like
:param_1 = AB.this_id
print AB.this_id == A.name
and.. why this way works and the
On Tuesday 10 June 2008 22:13:04 Artur Siekielski wrote:
On Jun 10, 8:11 pm, Michael Bayer [EMAIL PROTECTED] wrote:
I would first take a look at the SQL
being issued as the first source of speed differences; if in
0.4.5 there's suddenly a whole series of deletes occuring which
do
Michael Bayer wrote:
would need to see mappings.
First, let me mention that this issue only occurs on Postgres; I can't
replicate it on SQLite.
This is the many-to-many relation table (posted previously):
table = rdb.Table(
'relation',
metadata,
rdb.Column('id',
Find the latest updates in SQL server 2008 tools and techniques. A
site for all your IT related needs such as data management, software
testing and many more
http://www.sqlserversoftware.blogspot.com
--~--~-~--~~~---~--~~
You received this message because you are
sorry, bad mod.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For
ok, so as i get it, descriptors of PropertyLoaders cannot be used in
clauses.
any idea then how to map something like this then without going down
to tables:
(pseudocode)
Doc.ver == ver
and (
Doc.dbid == Doc2Place.nazn and
Doc2Place.rabmesto ==
32 matches
Mail list logo