The work of those who have been making the case for the article has
paid off: I see that the article is no longer marked as non-notable.
Well done!
Hamish
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy
Michael Bayer ha scritto:
hey list -
I continue to be troubled by the slightly fragmented nature of SA's
Query object (and the cousin SelectResults). When I work with
Hibernate, I can see that their querying interface is a little more
consistent than ours. We have flags that are used for
Hi,
How do I access an extra column of a many_to_many table without
accessing the table directly?
My code is as follows:
query_expert_table = Table(query_expert, metadata,
Column(query_id, Integer,
ForeignKey(query.query_id), primary_key=True),
Greetings everyone,
does SQLAlchemy somehow support SQLites' ATTACH DATABASE statement? I
have a in-memory SQLite database that I want to dump to file, so I was
thinking of using ATTACH to do it. Any other ideas welcome ;).
Thanks in advance,
Karlo.
attach database ...wow i never knew it had that ! if its a matter of
issuing the string attach database, just use literal text() or
engine.execute().
attach databasevery handy !
On Mar 9, 9:43 am, Karlo Lozovina [EMAIL PROTECTED] wrote:
Greetings everyone,
does SQLAlchemy somehow
its not always a list. the underlying storage could be a Set, or a
dict.
there is also a ticket to enhance the typing behavior in this regard,
its #213. although even if we make subtypes that are specific to a
collection type, actually subclassing list is somewhat inconvenient
since its a
youre looking for the mappers to express the relational concepts as
fully as Tables. but thats what Tables are for, why not just use
them ? SA's philosophy is very much about dont pretend theres no
database.
On Mar 9, 5:16 am, Glauco [EMAIL PROTECTED] wrote:
Michael Bayer ha scritto:
hey
my only concern is that you now have more than one way to do it. i
need to deal with things in the identity map. do i go look at the
session.identity_map ? (which is documented, its part of the public
API) oh no, i dont have the exact kind of key to use, now i have to
go use a method called
why not copy the source of PickleType and add the zlib steps to its
pickling logic ? then it would just be transparent.
On Mar 8, 8:12 pm, Andrea Gavana [EMAIL PROTECTED] wrote:
Hi All,
I was wondering if it is possible to use zlib.compress() to
compress a cPickled object and store it
Hi,
are there any plans to support the BIT type of Postgres?
Andreas
pgp5Z1roj65VK.pgp
Description: PGP signature
Hmmm, seems the set nocount on trick now causes problems on deletes:
ConcurrentModificationError is thrown because Updated rowcount -1
does not match number of objects updated 1.
Which seems strange because I thought rowcount -1 simply meant that
the count cannot be determined, not that there is
feel free to send a patch (its like 5 lines)
for example, heres the INET patch:
http://www.sqlalchemy.org/trac/ticket/444
On Mar 9, 11:12 am, Andreas Jung [EMAIL PROTECTED] wrote:
Hi,
are there any plans to support the BIT type of Postgres?
Andreas
application_pgp-signature_part
Great that's working. And Yuck! Having to do that directly on the
cursor really makes me enjoy SA's capabilities. Can't wait until
that's a supported feature. Keep up the good work guys!
Greg
On Mar 9, 10:42 am, Michael Bayer [EMAIL PROTECTED] wrote:
you can pull raw_connection() off of
On Mar 9, 4:33 pm, Michael Bayer [EMAIL PROTECTED] wrote:
attach database ...wow i never knew it had that ! if its a matter of
issuing the string attach database, just use literal text() or
engine.execute().
Me neither ;), until the other day I started looking for an efficient
way to dump
I have a class that has a lazy loaded option.
This class is a parent of another table that I'd like to select from.
a-lazy_b
c-lazy_a
I want to eagerload both a b like this:
c-a-b
Is there a way to specify that?
query(c).options(eagerload('a'),eagerload('a.b'))
seams logical.
OK, just read over ATTACH, you issue the ATTACH DATABASE command
textually. from that point on, the tables in that database are
accessible using a schemaname syntax (i.e. schemaname.tablename).
if you really want to just copy tables wholesale, yeah youd have to
issue INSERT ... SELECT
This is still with pyodbc? The MSSQL module should already set
sane_rowcount to False for that dialect, as per the pyodbc site, they don't
implement rowcount.
Rick
On 3/9/07, polaar [EMAIL PROTECTED] wrote:
Hmmm, seems the set nocount on trick now causes problems on deletes:
in theory youd say options(eagerload(a.b)).
the separate eagerload(a) isnt needed since its sort of impossible
to eagerload b without eager loading a.
On Mar 9, 2007, at 3:01 PM, Dennis wrote:
I have a class that has a lazy loaded option.
This class is a parent of another table that I'd
On Mar 9, 2:20 pm, Michael Bayer [EMAIL PROTECTED] wrote:
in theory youd say options(eagerload(a.b)).
the separate eagerload(a) isnt needed since its sort of impossible
to eagerload b without eager loading a.
But I'm assuming there isn't a way to do it currently.
I guess I could create a
except im totally wrong, at the moment you have to have the separate
eagerload for each path, the way you have it.
On Mar 9, 2007, at 3:01 PM, Dennis wrote:
I have a class that has a lazy loaded option.
This class is a parent of another table that I'd like to select from.
a-lazy_b
Hi,
I guess I could create a mapper for a that doesn't lazyload b and use
that mapper instead.
I'm doing just that and it works fine for me.
Paul
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy
21 matches
Mail list logo