FWIW, it is perfectly possible to package the thing separately as
Glyph seem to suggest, even if the feature is enabled through an
option. For example, Debian does it:
http://packages.debian.org/experimental/python-sqlalchemy-ext
On Fri, May 7, 2010 at 19:56, Kent Bower wrote:
> Just because ther
On Fri, Apr 2, 2010 at 21:08, Bo Shi wrote:
> Hrm, some different errors pop up. I'll move the dialog to the ticket
> in question.
>
> http://www.sqlalchemy.org/trac/ticket/1757
Should be fixed now (hopefully). Could you test once more?
Thanks,
--
Gaëtan de Menten
--
You received this messag
On Tue, Mar 30, 2010 at 19:32, Michael Bayer wrote:
> Bo Shi wrote:
>>> pep 249 specifies "list of tuples" for fetchmany() and fetchall()
>>
>> Hrm, pep-249 seems to only specify "sequence" and "sequence of
>> sequences" for the fetch*() functions, specifying list of tuples only
>> as one possible
On Sun, Mar 21, 2010 at 17:13, drakkan wrote:
> On 21 Mar, 14:31, Antoine Pitrou wrote:
>> Le dimanche 21 mars 2010 à 02:10 -0700, drakkan a écrit :
>>
>> > a really interesting feature in sa 0.6 are the c extensions, however I
>> > think they should be implemented using ctypes so if python ctype
On Wed, Feb 10, 2010 at 09:04, Gaetan de Menten wrote:
> On Wed, Feb 10, 2010 at 08:48, Chris wrote:
>> Hi All
>>
>> Have just upgraded to this version and am having the following issue.
>>
>> I use a the execute method on a ScopedSession to run generic SQL
>&
On Wed, Feb 10, 2010 at 08:48, Chris wrote:
> Hi All
>
> Have just upgraded to this version and am having the following issue.
>
> I use a the execute method on a ScopedSession to run generic SQL
> Statements in a TextClause, in the resulting BufferedRowResultProxy
> object their used to list fie
On Thu, Feb 4, 2010 at 17:25, Andrew wrote:
> I have a table of "tasks" which contain references to multiple
> children and parents (tasks can have multiple children and multiple
> parents in this example). These are defined as ManyToMany and so I get
> an extra table containing the links.
>
> If
On Wed, Jan 13, 2010 at 10:16, 诚子 wrote:
> detial please see
>
> http://my.unix-center.net/~WeiZhicheng/2010/01/13/sqlalchemy-0-6-unicodedecodeerror-bug-patch/
Well, if I understand correctly, you would like a workaround for a bad
truncate algorithm in mysql (which apparently truncates in the mid
I am very pleased to announce that version 0.7.1 of Elixir
(http://elixir.ematia.de) is now
available. As always, feedback is very welcome, preferably on Elixir
mailing list.
This release packs a few interesting new features (abstract classes
and a new collection
type providing explicit relative
On Mon, Nov 16, 2009 at 06:57, BruceC wrote:
> I'm trying to implement a character counter on all textarea fields in
> my Elixir-SQLA-Pylons app, & need to find a way to determine the
> maximum number of characters a given column can hold, so I can supply
> the character counter with a "Maximum
On Mon, Oct 19, 2009 at 16:04, Michael Bayer wrote:
>> I see in r6413, that you use an ordered dictionary instead of a
>> standard one for properties, in an attempt to "fix some jython
>> ordering annoyingness". Is this really necessary to be compliant with
>> Jython? Would you care to explain?
Hi Mike,
I see in r6413, that you use an ordered dictionary instead of a
standard one for properties, in an attempt to "fix some jython
ordering annoyingness". Is this really necessary to be compliant with
Jython? Would you care to explain? I'm quite puzzled as to how that
change could have any e
On Wed, Oct 14, 2009 at 17:09, Gaetan de Menten wrote:
> Btw: Iwan, did you try:
>
> factory = elixir.session.session_factory
> elixir.session.registry = sqlalchemy.util.ScopedRegistry(maker,
> scope_func=your_scope_func)
Of course, that should read :
factory = elixir.session.
On Tue, Oct 13, 2009 at 16:49, Michael Bayer wrote:
>> We have a situation where we have an existing ScopedSession, but want
>> to change its scopefunc. This sounds like a strange requirement, it
>> is because we use elixir - the issue is discusses here:
>> http://groups.google.com/group/sqlelix
On Wed, Oct 14, 2009 at 08:34, robert rottermann wrote:
> I am using a one to many relation, and would like the result to be ordered by
> a
> field of the child table. however no order by statement is executed when I
> access the related property of the parent object.
>
> this is my declaration
I am very pleased to announce that version 0.7.0 of Elixir
(http://elixir.ematia.de) is now available. As always, feedback is
very welcome, preferably on Elixir mailing list.
This release incorporates many small improvements and bug fixes across
the board. Please look at
http://elixir.ematia.de/t
On Wed, Sep 30, 2009 at 16:57, Michael Bayer wrote:
>
> Gaetan de Menten wrote:
>> I've been trying to work around the Session.mapper deprecation warning
>> in Elixir by providing the same functionality within Elixir. The
>> question is whether _ScopedExt is consid
Hi all,
I've been trying to work around the Session.mapper deprecation warning
in Elixir by providing the same functionality within Elixir. The
question is whether _ScopedExt is considered deprecated too ? I guess
it is but want to make sure to not duplicate code needlessly...
--
Gaëtan de Mente
On Wed, Aug 5, 2009 at 08:13, kportertx wrote:
> UGGG! I have been fighting with this for a while. I never thought to
> just use an actual file for my db instead of using memory. I was
> using memory because I was only wanting to test things and didn't want
> to keep the data. Seems that perh
On Wed, Aug 5, 2009 at 08:16, kportertx wrote:
> O on a side note would you recommend elixir over declarative_base?
The biggest difference between the two is that Elixir can generate
some columns and tables for you (using common "patterns"). Michael
Bayer probably won't recommend Elixir since he
On Sun, May 31, 2009 at 16:50, Michael Bayer wrote:
>
>
> On May 30, 2009, at 1:56 AM, ericthompso...@gmail.com wrote:
>
>> Upon reaching the instantiation of Foo, my code blows up with the
>> error message in the subject. Now I realize this is often caused by
>> threading issues - multiple thre
On Tue, Feb 17, 2009 at 03:14, Michael Bayer wrote:
> it says to me:
>
> Congratulations!
>
> [Valid RSS] This is a valid RSS feed.
>
> im not able to reproduce any issue in the straight FF reader.
Seems like somebody else fixed it, because it works today.
--
Gaëtan de Menten
http://openh
It seems like there is some bad character in one of the ticket details
as it's been a few days since I could access the Trac feed. My feed
reader (liferea) complains of:
XML Parsing Error: reference to invalid character number
Location: file:///
Line Number 20, Column 14:
Hi all,
For those who might be interested, I wrote an article for Python
Magazine titled "Creating a collection manager with Elixir". It has
just been published in the January issue
(http://www.pythonmagazine.com/c/issue/view/90). Within the article, I
detail the creation of a simple collection m
On Mon, Dec 22, 2008 at 17:06, Eoghan Murray wrote:
> The following example uses an elixir class:
>
> class MyE(Entity):
>id = Field(Integer, primary_key=True)
>f_1 = ManyToOne('OtherE')
>f_2 = ManyToOne('OtherE')
>date = Field(Date)
>
> MyE.query.select_from(union(MyE.table.sele
On Mon, Dec 8, 2008 at 10:31, Kless <[EMAIL PROTECTED]> wrote:
>
> Thanks! Anyway I've seen that it's better add extensions in Elixir,
> into a declarative layer, just as has been made in DataMapper.
As I just said on the Elixir mailing list: not really. The ability to
add new types is an SQLAlch
Here are the suggestions that come to mind:
- You should either get rid of, or (preferably) expand/replace the
current top-level "table of contents". As it is currently, there is
only one useful link in there (API reference) and the table of
contents block waste way too much space for just one li
On Wed, Dec 3, 2008 at 16:04, Michael Bayer <[EMAIL PROTECTED]> wrote:
> this ones big, i can handle it. the attached patch makes your case
> work, but the problem represented here still makes itself apparent in
> other ways and I havent strength tested this patch. you might want
> to see if
On Wed, Dec 3, 2008 at 15:03, Michael Bayer <[EMAIL PROTECTED]> wrote:
> um yeah, actually this behavior is affecting all multi-level usage of
> "polymorphic_union". So, while polymorphic_union is quite obviously
> (since nobody has noticed this pretty glaring issue) on the decline in
> the 0.5
Hello all,
I've been playing a bit with polymorphic concrete inheritance, and
noticed that when you have several levels of "polymorphic" loading (ie
my child class is also a parent class which I want to load
polymorphically), the query for the top-level class includes the child
polymorphic join wh
On Mon, Sep 29, 2008 at 4:46 PM, Itamar Ravid <[EMAIL PROTECTED]> wrote:
> Thanks for the answer, Mike. I was used to Oracle's behavior while writing
> raw SQL, in which the case of unquoted column identifiers doesn't matter.
> This behavior seems reasonable enough, although the inconsistency betw
On Mon, Sep 29, 2008 at 5:01 PM, Joril <[EMAIL PROTECTED]> wrote:
>
> Hi everyone!
> I'm new to SQLAlchemy and I'm using version 0.5rc1..
> I need every entity class to have a few common fields, so I tried
> writing an "abstract" base class, declarative-style, that every other
> entity class would
On Fri, Sep 12, 2008 at 4:37 AM, Sam <[EMAIL PROTECTED]> wrote:
>
> One of the things I really liked about sqlobject was its versioning
> plug-in. ( http://www.sqlobject.org/Versioning.html )
>
> Is there anything similar for sqlalchemy? A google search turned up
> versioned ( http://elixir.emat
On Wed, Aug 27, 2008 at 3:21 AM, Randy Syring <[EMAIL PROTECTED]> wrote:
>
> Ok, so I was going to try and implement a solution using the method
> discussed here, but ran into a problem b/c I am using Elixir objects
> and not declaring the tables directly. Can I still use this method?
> How do I
On Thu, Aug 21, 2008 at 2:06 PM, Jim Jones <[EMAIL PROTECTED]> wrote:
>
> On Tue, 2008-08-19 at 16:16 -0400, Michael Bayer wrote:
>>
>> On Aug 19, 2008, at 4:07 PM, Gaetan de Menten wrote:
>>
>> > Simpler than Elixir? How so? If you are speaking about the
On Tue, Aug 19, 2008 at 8:54 PM, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Aug 19, 2008, at 2:43 PM, Jose Galvez wrote:
>
>>
>> What is the proposed stability of declarative functions which I guess
>> are pretty new. From what I've read so far I really like it and was
>> thinking of using
I am very pleased to announce that version 0.6.1 of Elixir
(http://elixir.ematia.de) is now available. As always, feedback is
very welcome, preferably on Elixir mailing list.
This is a minor release featuring some bug fixes (one of them to
handle a late rename in SQLAlchemy's 0.5 beta cycle), a n
I am very pleased to announce that version 0.6.0 of Elixir
(http://elixir.ematia.de) is now
available. As always, feedback is very welcome, preferably on Elixir
mailing list.
Please look at: http://elixir.ematia.de/trac/wiki/Migrate05to06 for
detailed upgrade notes.
Here are the highlights for t
GenericAssoc's from the second Session usage present.
Jeeez. I hate myself for thinking it was some complex thing related to
the pattern used and not even looking further...
> ahh yes i had this same a week ago but i forgot.
> so is u2=session.merge(u2) a cure?
> i used it on some
Hi list,
Could anybody tell me what's wrong with the following code? It's only
the code in the poly_assoc example directory (the generic version)
where I'm trying to set the polymorphic part of the relationship. It
gets me the traceback below and I don't really understand why:
Traceback (most rec
On Fri, Jun 27, 2008 at 2:44 PM, MuTPu4 <[EMAIL PROTECTED]> wrote:
> I have table wordforms and WordformMapping associated with it. Bi-
> directional self-relation is expressed by using association table with
> attributes named "infinitives" and "forms". I am using Elixir for
> mapping definition
Hi list,
Is there really no easier/nicer way to get a count of items alongside
object results than the one described at:
http://www.sqlalchemy.org/docs/05/ormtutorial.html#datamapping_joins_subqueries
?
>>> from sqlalchemy.sql import func
>>> stmt = session.query(Address.user_id,
>>> func.count
On Thu, Jun 12, 2008 at 4:58 PM, bollwyvl <[EMAIL PROTECTED]> wrote:
>
> I am running into similar problems, adding to the complexity the
> threadpool module.
>
> Here's a post that might help:
> http://blog.uxpython.com/blog/web/view/116
>
> I am still running into problems, however, based on par
On Fri, May 16, 2008 at 9:23 PM, Jim R. Wilson <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> SQLAlchemy is a great project and a growing niche. As it becomes even
> more popular, there will be increasing demand for experts in the
> field.
>
> I am compiling a contact list of SQLAlchemy experts who m
On Tue, Apr 29, 2008 at 12:11 PM, Gaetan de Menten <[EMAIL PROTECTED]> wrote:
> On Mon, Apr 28, 2008 at 10:33 PM, Michael Bayer
> <[EMAIL PROTECTED]> wrote:
> > In any case the unit tests which you were working from (im guessing
> > test/orm/inheritance/con
On Mon, Apr 28, 2008 at 10:33 PM, Michael Bayer
<[EMAIL PROTECTED]> wrote:
> pjoin = polymorphic_union(...)
> pjoin2 = polymorphic_union(...)
>
> employee_mapper = mapper(Employee, pjoin, polymorphic_on=pjoin.c.type)
> manager_mapper = mapper(Manager, managers_table,
> inherits=employee_mapp
Hi there,
I've been playing with concrete inheritance a bit these days (trying
to implement it into Elixir). I've run into several problems, which
might be known limitations, but I'd like to know for sure or be shown
what I've done wrong...
The two problems I get involve a chain of classes inheri
I am very pleased to announce that version 0.5.2 of Elixir
(http://elixir.ematia.de) is now
available. As always, feedback is very welcome, preferably on Elixir
mailing list.
This is a minor bug fixes release (mostly restoring python 2.3 compatibility).
The full list of changes can be seen at:
h
Hi guys,
Lately, I've upgraded some of my applications to the latest SQLAlchemy
version and have some minor complaints about the String with no length
to Text move:
- if you used the Unicode type with no length, you're still told in
the warning to use "Text" instead, which makes it a bit confusin
Hello all,
I'm puzzled as I cannot seem to do a pretty simple query: I have a
many to many relationship (say from Vendor to Item) and want to get a
list of all vendors which have no item.
The obvious:
Vendor.query.filter(Vendor.items == []).all()
does not work (it produce a query without any whe
I am very pleased to announce that version 0.5.1 of Elixir
(http://elixir.ematia.de) is now available. As always, feedback is
very welcome, preferably on Elixir mailing list.
This is mostly a bug fixes release (especially for people using
inheritance), but we have also a few minor new features, i
On Feb 4, 2008 12:08 PM, Felix Schwarz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm chasing a very nasty bug in my TurboGears-Application
> (using SQLAlchemy r4116, Elixir 0.5): I create a new object
> and flush that session (ScopedSession) but there is no COMMIT
> issued and therefore the data is n
On Jan 25, 2008 9:18 PM, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Jan 25, 2008, at 2:02 PM, Kumar McMillan wrote:
>
> >
> > On Jan 25, 2008 11:58 AM, Michael Bayer <[EMAIL PROTECTED]>
> > wrote:
> >>
> >> The Session.mapper function is not worth it, in my opinion, it exists
> >> due to t
On Jan 23, 2008 10:24 PM, Monty Taylor <[EMAIL PROTECTED]> wrote:
>
> This may or may not be elixir specific...
>
> If I have an auto-generated mapping table for a many-to-many
> relationship, is there a sensible way to add another column to it that's
> also has a foreign key relationship to a thi
On Dec 20, 2007 8:50 AM, iain duncan <[EMAIL PROTECTED]> wrote:
>
> Sorry if this seems a stupid question, but I thought that Mike had said
> that in sa0.4, if you used session_context that this
>
> User.query.get_by(name='john')
>
> was the replacement for the old assign mapper convenience call.
Since this is not specific to Elixir and I don't know what could be
the problem, I'm forwarding this to the SQLAlchemy list. You can watch
that list for the answer (which will hopefully be given) or wait until
I forward that answer to the Elixir list.
-- Forwarded message --
From:
I am very pleased to announce that version 0.5.0 of Elixir
(http://elixir.ematia.de)
is now available. As always, feedback is very welcome, preferably on Elixir
mailing list.
This is mostly a bug fixes release, but we have also had some pretty
important changes to the default values for options.
Anybody knows about this?
-- Forwarded message --
From: Mitch <[EMAIL PROTECTED]>
Date: Dec 5, 2007 1:06 AM
Subject: [elixir] sqlite3.OperationalError: Could not decode to UTF-8 column
To: SQLElixir <[EMAIL PROTECTED]>
Apologies in advance if this should be sent to the SQLAlchemy
On Nov 20, 2007 5:23 PM, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Nov 20, 2007, at 4:37 AM, Gaetan de Menten wrote:
> > I have some classes with "standard python" properties which target
> > another python object and also uses several columns in the da
On Nov 20, 2007 11:51 AM, svilen <[EMAIL PROTECTED]> wrote:
>
>
> On Tuesday 20 November 2007 11:37:29 Gaetan de Menten wrote:
> > Hi people,
> >
> > I have some classes with "standard python" properties which target
> > another python object and
in my "example", i
speak about filter and filter_by.
> you'll have to have whatever your property returns support
> __eq__)
Of course.
>
> On Nov 20, 4:37 am, "Gaetan de Menten" <[EMAIL PROTECTED]> wrote:
> > Hi people,
> >
> > I have som
Hi people,
I have some classes with "standard python" properties which target
another python object and also uses several columns in the database. I
also got a global factory function to create an instance of that
target object out of the value of the columns (the class of that
target object can
On 10/30/07, Paul Johnston <[EMAIL PROTECTED]> wrote:
> Mike,
>
>
> > use mapper.get_property(name) and mapper.iterate_properties (). I've
> > considered removing "properties" as a public accessor since it serves
> > no useful purpose.
> >
>
> This doesn't work for me - the following code output
I am very pleased to announce that version 0.4.0 of Elixir is now
available. As always, feedback is very welcome, preferably on Elixir
mailing list.
Highlights for this release
-
- Implemented a new attribute-based syntax to declare fields and relationships,
On 10/12/07, Simon Pamies <[EMAIL PROTECTED]> wrote:
>
> On Oct 12, 10:09 am, "Gaetan de Menten" <[EMAIL PROTECTED]> wrote:
> > I couldn't agree more. I mean: shouldn't the "autoload" part be
> > integrated into SQLAlchemy reflection ca
I couldn't agree more. I mean: shouldn't the "autoload" part be
integrated into SQLAlchemy reflection capability if it can do more
than SQLAlchemy 0.4 currently support (or simply removed if it doesn't
do more)?
And I fact, I think the formatting part could also be integrated into
SQLALchemy prop
On 9/20/07, Christine <[EMAIL PROTECTED]> wrote:
> Any elixir fans? Any idea on when it will finally be made an
> extension? Let me know.
Not sure. I'd like to answer: "When it's ready". But ven when it'll be
ready, this might not happen. There would be some positive points to
that, but also som
On 9/5/07, Paul Johnston <[EMAIL PROTECTED]> wrote:
> >data. I did some benchmarks a while back to see how everything
> >stacked up as I was wondering if I was doing everything the hard way
> >(in C++) instead of using SqlAlchemy, etc. TurboEntity is the same as
> >
> >
> Great work Eric.
>
> I
On 9/4/07, Acm <[EMAIL PROTECTED]> wrote:
>
> I am trying out Elixir 0.3.0 over SQLAlchemy 0.3.10 in a Python 2.5
> environment.
>
> Are there any known performance issues with Elixir for CRUD (Create
> Select Update Delete) commands?
Not that I know of. There shouldn't be any overhead (over raw
You might be interested by: http://techspot.zzzeek.org/?p=13
(also in the examples directory of SQLAlchemy)
On 8/24/07, praddy <[EMAIL PROTECTED]> wrote:
>
> ##
> from sqlalchemy import *
> meta = BoundMetaData('sqlite://', echo=False)
>
>
On 8/1/07, Alexandre CONRAD <[EMAIL PROTECTED]> wrote:
> I'm realizing that I've been using .list() to query objects. But all the
> examples in the docs talk about .all().
>
> What's the difference ? Should I switch to .all() rather than .list() ?
> Will list be deprecated in 0.4 ?
Exactly. lis
On 7/28/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
> those are fine with me. if someone could add a ticket and/or
> implement that would be helpful.
http://www.sqlalchemy.org/trac/ticket/696
--
Gaëtan de Menten
http://openhex.org
--~--~-~--~~~---~--~~
You re
On 7/27/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Jul 27, 2007, at 4:03 PM, Gaetan de Menten wrote:
>
> >> so do you just want "explicit_columns=True" so that no auto-grabbing
> >> of columns occurs ?
> >
> > I don'
On 7/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> On Friday 27 July 2007 21:26:51 jason kirtland wrote:
> > svilen wrote:
> > > Anyway it may depend which audience are u targeting with these
> > > names - those who never seen an API or those for which names are
> > > important only to
On 7/27/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Jul 27, 2007, at 8:34 AM, Gaetan de Menten wrote:
>
> > First, it complained there was no alias, while I *think* aliases
> > should only be necessary when the query is used in a subquery, but
> > a
Hi all,
The way single table inheritance works seem a bit "unclean" to me: all
columns are available as properties in all classes. Even if they map
to the same table, ideally each object should only have a subset of
columns available, right? SQLAlchemy can't guess which object has
which columns, s
On 7/27/07, svilen <[EMAIL PROTECTED]> wrote:
> On Friday 27 July 2007 02:45:12 jason kirtland wrote:
> - Catalog:
> what is a sqlalchemy's metadata?
> >jason> "a catalog of tables available in the database."
> to me it holds everything about the "subset of database structure",
> used in the app
On 7/24/07, svilen <[EMAIL PROTECTED]> wrote:
>
> > >> assert t.compare(t2)
> > >
> > > yes i was hoping for such method (:-)
> > > And the best will be if it can produce a list/ hierarchy of
> > > differences, which then programaticaly can be iterated - and
> > > checked and resolved or raised hi
On 7/25/07, svilen <[EMAIL PROTECTED]> wrote:
>
> > i just saw there is some usagerecipe ModelUpdate in the wiki, may
> > be a good start point:
> > http://www.sqlalchemy.org/trac/wiki/UsageRecipes/ModelUpdate
> >
> and this one:
> http://www.sqlalchemy.org/trac/wiki/UsageRecipes/AutoCode
As I sa
[in response to a batch-insert-is-slow complaint on the Elixir list]
On 7/19/07, AndCycle <[EMAIL PROTECTED]> wrote:
>
> I don't think db define is the major problem,
> it could be sqlalchemy's problem,
> because currently it haven't implement real transaction command in
> most db implementation,
On 6/13/07, Roger Demetrescu <[EMAIL PROTECTED]> wrote:
>
> Hi Michael,
>
> On 6/13/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
> >
> >
> > On Jun 13, 2007, at 8:48 AM, Roger Demetrescu wrote:
> > > But the use of this function is to ugly to my taste (I know, the
> > > "give_me_pk_values_in_corre
Hi,
Anybody knows how I could emulate the behavior of Query.get (ie get
the result from the session if possible instead of always fetching
from the db) if I have the values for the different columns of the
primary as keyword arguments (ie not in the order of the columns of
the initial table)? I n
On 6/12/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> we have, in fact, made a tip of the hat to SAT analogy questions
> ("selecting everything is to all() as selecting just the first row is
> to: a. scalar() b. first() c. list()[0]").
I've already said it earlier but since you didn't comment
On 6/4/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Jun 3, 2007, at 10:33 PM, Michael Bayer wrote:
>
> > one() raises an exception when theres not exactly one result, scalar
> > () does not. currently we have selectfirst() and selectone(), people
> > seem to like the dichotomy. [0] spec
On 6/3/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
> - the methods select(), selectfirst(), selectone(), select_by(),
> selectfirst_by(), selectone_by() and get_by() would be deprecated.
> this means they will remain present on the Query object but the
> documentation would be reorganized to tal
On 6/2/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Jun 2, 2007, at 6:02 AM, Gaetan de Menten wrote:
>
> > Hmmm, after some more thoughts there is one little aspect of that
> > which bothers me: once you joined to something, you can't add
> > filt
On 6/2/07, Gaetan de Menten <[EMAIL PROTECTED]> wrote:
> IMHO, this solves my use case nicely. It's slightly longer than what I
> proposed but doesn't reach my internal "this_is_too_long_to_type"
> threshold and it's more explicit...
>
> So
IMHO, this solves my use case nicely. It's slightly longer than what I
proposed but doesn't reach my internal "this_is_too_long_to_type"
threshold and it's more explicit...
So for me it's a +1 for that solution (along with documenting the
joinpoint behavior ;-)).
On 6/2/07, Michael Bayer <[EMAIL
On 6/1/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
>
> On Jun 1, 11:37 am, Christoph Haas <[EMAIL PROTECTED]> wrote:
> > sooner or later. Am I right that we are just talking of
> >
> > john = session.query(User).get_by(name="john")
> >
> > versus
> >
> > john = User.get_by(name="john"
For what it's worth I personally vote to get rid of all those query
methods (except query() itself, of course).
On 6/1/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> as it turns out, assign_mapper's monkeypatched methods (and they are
> all monkeypatched, not sure why you singled out query()) d
And btw, in case I didn't understand what you wanted and you really
wanted to map one class to several tables, you'll find information
about that there:
http://www.sqlalchemy.org/docs/adv_datamapping.html#advdatamapping_joins
On 5/7/07, Gaetan de Menten <[EMAIL PROTECTED]> wr
On 5/7/07, Spider <[EMAIL PROTECTED]> wrote:
>
> I'm fairly new to this, and trying to understand the ORM relationship
> between a class and a table row. In most of the examples in the
> documentation, there is a one-to-one relationship; a class instance
> corresponds to a row of a table.
>
> In m
On 4/30/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
> turns out scalar columns already worksince they are
> just...columns ! which ColumnProperty already handles.
That's what I tried to get at... that it was supposed to "just work"...
> any old SA
> version will allow the test script to wo
Just use
print your_statement_variable
Or, if you need it in a variable: str(your_statement_variable) should
do the trick.
On 4/30/07, vinjvinj <[EMAIL PROTECTED]> wrote:
>
> Is there any way to have sqlalchemy return the sql that it is going to
> execute without actually executing it? I'm u
On 4/26/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Apr 26, 2007, at 4:40 AM, Gaetan de Menten wrote:
> >
> >> - the biggest picture not here - its read only !
> >
> > It's obviously meant to be that way... So I don't see a problem he
On 4/26/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Apr 26, 2007, at 4:40 AM, Gaetan de Menten wrote:
>
> >> - you have an aggregate function there. wheres the GROUP
> >> BY ? not
> >> just of the main table's columns but any other colu
On 4/26/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Apr 25, 2007, at 3:52 PM, Gaetan de Menten wrote:
>
> > It's better with the attachments (the actual patch and a small
> > demonstration/test file)...
> >
> > On 4/25/07, Gaetan de Menten
It's better with the attachments (the actual patch and a small
demonstration/test file)...
On 4/25/07, Gaetan de Menten <[EMAIL PROTECTED]> wrote:
> Ok, I'm quite a bit stubborn at times, so I implemented this the way I
> thought because I think it makes much more sense thi
k it
should be quite easily fixable.
- As always, I'm not attached to the names I've given.
On 4/24/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Apr 24, 2007, at 4:44 AM, Gaetan de Menten wrote:
>
> >
> >> the next way is to do it almost th
On 4/24/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Apr 24, 2007, at 5:42 AM, Gaetan de Menten wrote:
>
> > Here is an experimental patch to add generative aggregate methods on
> > query objects.
> >
> > My use case is that I have a class w
1 - 100 of 136 matches
Mail list logo
