On Tue, Jun 24, 2014 at 3:35 PM, Mike Bayer mike...@zzzcomputing.com
wrote:
On 6/23/14, 8:09 PM, Ken Lareau wrote:
if apptier:
subq = (
Session.query(
Package.pkg_name,
Package.version,
Package.revision,
Hi,
I'm wondering how I might get at postgresql's large object type (lob).
It's not to be confused with the TOASTED bytea, which are limited currently
to 1 GiB yet in practice is much lower (for me 400MiB) - it's a special
table + api designed to handle very large binary objects, like a few
Hello,
I am trying to use SQLAlchemy to map a database that was made available to
me, whose contents and schema cannot be altered. The database has a few
cases where a many-to-one relationship is treated as a many-to-many - that
is, instead of the child key being set directly onto the parent
On 6/25/14, 5:50 AM, Ofir Herzas wrote:
Sorry to barge in, but I'm having the exact same issue and I'm pretty
sure no one altered the sequence manually.
I'm using sqlalchemy 0.8, python 2.7.6, rhel 6.5, oracle 10g,
cx_oracle with the same connection string as above
This issue started just
On 6/25/14, 7:11 AM, Tara Andrews wrote:
Hello,
I am trying to use SQLAlchemy to map a database that was made
available to me, whose contents and schema cannot be altered. The
database has a few cases where a many-to-one relationship is treated
as a many-to-many - that is, instead of the
On 6/25/14, 2:26 AM, Ken Lareau wrote:
On Tue, Jun 24, 2014 at 3:35 PM, Mike Bayer mike...@zzzcomputing.com
mailto:mike...@zzzcomputing.com wrote:
On 6/23/14, 8:09 PM, Ken Lareau wrote:
if apptier:
subq = (
Session.query(
On Wednesday, June 25, 2014 3:27:48 PM UTC+2, Michael Bayer wrote:
yes you can apply the uselist=False option to the relationship.If
the relationship loads more than one row you'll get a warning.
That did it - thanks!
Best,
-tara
--
You received this message because you are
On 6/25/14, 2:35 AM, Jason Newton wrote:
Hi,
I'm wondering how I might get at postgresql's large object type
(lob). It's not to be confused with the TOASTED bytea, which are
limited currently to 1 GiB yet in practice is much lower (for me
400MiB) - it's a special table + api designed to
Didn't say it was your responsibility, just thought you should know there might
be an issue there.
I'll modify the sequence manually and get back to it should the problem persist.
From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On
Behalf Of Mike Bayer
Sent:
On Tuesday, June 24, 2014 9:40:02 PM UTC-4, Victor Olex wrote:
What I aiming for is to provide users a library of base class(es), which
are mapped using SQLAlchemy. The classes are then meant to be extended by
users with business logic. I am not hell bent on using inheritance for
this,
On Monday, June 2, 2014 6:18:42 PM UTC-4, Michael Bayer wrote:
there’s nothing on the Python library side that could do that, someone had
to have run an ALTER SEQUENCE on the database side in order for that to
happen.
I don't even think you could use ALTER SEQUENCE in this situation. I
Hi,
I've replied inline below.
On Wed, Jun 25, 2014 at 6:46 AM, Mike Bayer mike...@zzzcomputing.com
wrote:
well we just added the OID type in 0.9.5, so you at least have that.
I came across the entry on the issue tracker a little bit after
submitting. As usual for me, it's support wasn't
On 6/25/14, 2:53 PM, Jason Newton wrote:
Seems to fly in the face at the point of SQLA although integration
difficulties are appreciated. Most advanced postgresql drivers in any
language bindings have added support for this type although none of
them can hide that it's file like.
SQLA
Just in case this wasn't apparent, you certainly *can* use psycopg2's
bindings when you're in an otherwise SQLAlchemy app. Worst case you can
retrieve a raw psycopg2 connection using connection.raw_connection and do
whatever you need. If you truly have some use for LOBs, SQLAlchemy isn't
On 6/25/14, 5:35 PM, Jason Newton wrote:
Hand crafted inserts use server side lo_create(-1) (in sql) which
allocates a new large object and returning clause to get the oid
in one go back to the client side. Then I start using the
lobject api on the returned oid.
On 6/25/14, 6:36 PM, Neil Hooey wrote:
Is it possible to do a join query on two tables that have different
shard keys in SQLAlchemy?
For example, if you have two tables:
users: [userId, name] (sharded on userId)
messages: [messageId, userId, message] (sharded on messageId)
Could you
Do aggregate functions work across shards in SQLAlchemy?
Such as count, sum, etc?
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
On 6/25/14, 6:41 PM, Neil Hooey wrote:
Do aggregate functions work across shards in SQLAlchemy?
Such as count, sum, etc?
not across them, nope. you need to merge those yourself.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe
18 matches
Mail list logo