On May 16, 2013, at 9:17 PM, Bobby Impollonia wrote:
> That makes sense. I am seeing one problem with this approach and it causes
> the asserts in original gist to still fail. The problem is that the identity
> map remembers that I constructed my objects as instances of the parent class
> eve
That makes sense. I am seeing one problem with this approach and it causes
the asserts in original gist to still fail. The problem is that the
identity map remembers that I constructed my objects as instances of the
parent class even across commit and expire boundaries. So the following
assert
I have a User model, and a Group model, and a m2m relation between them.
I also have a proxy on the user that routes directly to the Group
instances. The creator function, however, only takes one param (group), so
when I pass in a group, I have no way to look it up to see if the (user_id,
group
On May 16, 2013, at 6:22 PM, Bobby Impollonia wrote:
> Sounds like a useful feature.
>
> Regarding case sensitivity, perhaps it would better if each of these methods
> (even like() and contains()) took a keyword argument along the lines of
> col.endswith('foo', case_sensitive=False) rather th
On Thu, May 16, 2013 at 7:16 PM, Simon King wrote:
> I don't think this would be a good match for HSTORE - I assume that
> retrieving values from HSTORE won't be as efficient as retrieving them from
> their own rows.
It depends on the number of attributes per test. It won't ever be as
efficient
Sounds like a useful feature.
Regarding case sensitivity, perhaps it would better if each of these
methods (even like() and contains()) took a keyword argument along the
lines of col.endswith('foo', case_sensitive=False) rather than adding extra
methods with weird names like iendswith.
On Mond
On 16 May 2013, at 21:21, Michael Bayer wrote:
>
> On May 16, 2013, at 4:07 PM, Julien Cigar wrote:
>
>> On 05/14/2013 16:58, Michael Bayer wrote:
>>> When you are storing data with key/values, where the set of keys is part of
>>> the data. Storing configurational data is the main use case
I think this value is coming from the underlying database driver rather
than SQLAlchemy. If you execute the stored proc directly using the driver
(I guess this is pymssql), do you see the same behavior?
On Thursday, May 16, 2013 12:37:56 PM UTC-7, John Anderson wrote:
>
> I have a SQLServer DB
On May 16, 2013, at 4:07 PM, Julien Cigar wrote:
> On 05/14/2013 16:58, Michael Bayer wrote:
>> When you are storing data with key/values, where the set of keys is part of
>> the data. Storing configurational data is the main use case.HSTORE not
>> an option because it is postgresql-spec
On 05/14/2013 16:58, Michael Bayer wrote:
When you are storing data with key/values, where the set of keys is part of the
data. Storing configurational data is the main use case.HSTORE not an
option because it is postgresql-specific.
Yes it may be acceptable to store configurational dat
oh, yeah I don't have that code, that was Ori talking about a particular client
integration they had, where they went bananas with EAV. The point there was
to show how Akiban does a much better job querying structures like that, but I
had no involvement in that gig.
The EAV stuff I have, you
On May 16, 2013, at 3:02 PM, Bobby Impollonia wrote:
>
> I hoped to end up with something like:
> SELECT email_addresses.id AS email_addresses_id, email_addresses.address AS
> email_addresses_address
> FROM email_addresses, affiliations
> WHERE affiliations.address_type = 'email' AND affiliat
I believe it was for some work you did for Akiban. If I remember correctly
(ha!) I believe you detailed with some slides an updated join strategy that
they are using (or that you hacked) into a custom version of SA used by
them. I noted the demo as I am planning on using EAV for a personal
pr
I have a SQLServer DB with a table that has a column as datetime and its
default value is `getutcdate()` (on the server).
We are using stored procedures and are running DBSession.execute('sproc')
and to do a select on the table and the rows that are returned have weird
datetime values:
datetime.d
I am trying to create a relationship to work with a legacy schema and am
having trouble configuring it to behave as I want. As a disclaimer, I
understand why the schema here is not the schema one would use if starting
from scratch.
Anyway, I have simplied the situation down to the following exa
I am and that's awesome. Thank you!
On Thursday, May 16, 2013 2:47:47 PM UTC-4, Michael Bayer wrote:
>
> if you're on 0.8 this is all available via the various getters on mapper:
> http://docs.sqlalchemy.org/en/rel_0_8/orm/mapper_config.html#sqlalchemy.orm.mapper.Mapper.attrs
>
>
> On May 16, 20
if you're on 0.8 this is all available via the various getters on mapper:
http://docs.sqlalchemy.org/en/rel_0_8/orm/mapper_config.html#sqlalchemy.orm.mapper.Mapper.attrs
On May 16, 2013, at 1:37 PM, Jonathan Vanasco wrote:
> I've been using a utility method 'columns_as_dict' to help store my d
I've been using a utility method 'columns_as_dict' to help store my data in
a cache. It works well.
A problem I've encountered... i need to access the related data that i've
eagerloaded.
My current function looks like this
def columns_as_dict(self):
as_dict = dict(
a little bit of a slip in metadata.reflect(), there's a patch which potentially
fixes this in http://www.sqlalchemy.org/trac/ticket/2728.
On May 16, 2013, at 3:35 AM, rdunklau wrote:
> My bad, I didn't notice those notes in the documentation, thank you for
> pointing that out.
>
> I understa
My bad, I didn't notice those notes in the documentation, thank you for
pointing that out.
I understand the reason for the table test1 showing twice, but why doesn't
it when I reflect the public schema (explicitly, not via the "None" default
schema) after the test2 table ?
If I understand corre
20 matches
Mail list logo